Mastering SQL (Using MySQL, Java, and Go)

About this course

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) operationsCreate complex queries across multiple tablesAnalyze data and create reports accordinglyWrite complex joins (inner, outer, full)Write summary queries using aggregate functionsWrite sub-queriesUtilize String/Numeric/Datetime functionsAnalyze data, group the related data into separate entities (tables), establish relationships (1-1, 1-m, m-m) between tables, and apply referential integrity on tablesWrite views, triggers, stored procedures, cursors, and stored functionsFour Comprehensive Assignments: Create four sample databases from scratch, as well as to write advanced queries for each assignmentAssignments: Learn how  views, triggers, stored procedures, cursors, and stored functions can interactConnect MySQL and Postg