Mastering SQL (Using MySQL, Java, and Go) - Udemy

Learning SQL (Structured Query Language), as  the most commonly used database language, can be one of the greatest career decisions you make.

SQL is one of the most sought-after skills by hiring employers.

SQL that is the primary language responsible for managing data within a relational database management system (RDBMS) can be easily connected to any programming language.

SQL is a natural language for data analysis that is the center of every decision making process.

SQL is a productive language for writing queries and for performing CRUD  (Create, Read, Update, Delete) operations on data.

SQL can be used by data scientists, data analysts, front- and back-end developers, business and systems analysts and in short anyone who's willing to analyze data.

In this practical course, you will:

• Learn CRUD (Create, Read, Update, Delete) operations

• Create complex queries across multiple tables

• Analyze data and create reports accordingly

• Write complex joins (inner, outer, full)

• Write summary queries using aggregate functions

• Write sub-queries

• Utilize String/Numeric/Datetime functions

• Analyze data, group the related data into separate entities (tables), establish relationships (1-1, 1-m, m-m) between tables, and apply referential integrity on tables

• Write views, triggers, stored procedures, cursors, and stored functions

• Four Comprehensive Assignments: Create four sample databases from scratch, as well as to write advanced queries for each assignment

• Assignments: Learn how  views, triggers, stored procedures, cursors, and stored functions can interact

• Connect MySQL and PostgreSQL to Java

• Connect MySQL and PostgreSQL to Go (Google Golang)