Mastering SQL (Using MySQL, Java, and Go)


Updated on

Course overview

Course type
Paid course
All Levels
21 hours
188 lessons
Available on completion
Course author
Kam Hojati
  • Write complex queries to address organizations business queries
  • Perform data analysis using SQL
  • Design and implement your own database (mainly using MySQL and partially using PostgreSQL)
  • Create tables, views, triggers, stored programs, and cursors
  • Design and implement four sample databases
  • Connect MySQL / PostgreSQL to Java and Go (Google Golang)


A practical course to master SQL advanced queries using MySQL, and to connect Java & Golang to MySQL & PostgreSQL

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)

Similar courses

Learn Database Design with MySQL
  • 7 hours
  • 32 lessons
  • Certificate
Mastering SQL (Using MySQL, Java, and Go)
  • English language

  • Recommended provider

  • Certificate available