4.65 out of 5
4.65
29 reviews on Udemy

Mastering SQL (Using MySQL, Java, and Go)

A practical course to master SQL advanced queries using MySQL, and to connect Java & Golang to MySQL & PostgreSQL
Instructor:
Kam Hojati
1,124 students enrolled
English [Auto-generated]
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)

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)

Introduction & Installation

1
Welcome to The Mastering SQL (Using MySQL, Java, and Go)
2
Sample Course Lectures (Only For Prospective Students)
3
A Brief History of SQL and MySQL
4
Database Concepts - Part 1 (Data and Tables)
5
Database Concepts - Part 2 (Columns, Rows, Tables, and Databases)
6
Database Concepts - Part 3 (DBMS, RDBMS, CRUD, and an Example) - Exercise
7
MySQL Installation on Windows

Your First Database

1
Section Introduction
2
First Data Types (INT and VARCHAR)
3
Creating & Managing Your First Database
4
Creating & Managing Your First Tables
5
Inserting Data into Tables
6
Querying Data using the SELECT Statement
7
Exercise - Working with Databases and Tables

Retrieving Data - Part 1 (Basics)

1
Section Introduction
2
NULL Values, Testing for NULL Values, Columns Alias, and Equality Operators
3
Primary Key, WHERE Clause, and AUTO_INCREMENT
4
The DEFAULT Keyword, Logical Operators, and Exercises
5
Creating Primary Keys (2nd approach), Simple & Composite Primary Keys - Exercise
6
Data Types (DECIMAL, DATE, and ENUM) - Mathematical Operators
7
Exercise [DECIMAL, DATE, and ENUM, Mathematical Operators, CONCAT() and LEFT() ]
8
Managing Duplicate Rows - DISTINCT and ALL Keywords - Comparison Operators
9
Writing Subqueries Using the IN Keyword - The BETWEEN Keyword
10
The ORDER BY Clause, and the LIMIT Keyword - Exercise
11
Pattern Matching using the LIKE Operator
12
Complex Pattern Matching using the REGEXP Operator

Retrieving Data - Part 2 (Joins)

1
Section Introduction
2
Table Joins, Concepts (Inner and Outer Joins)
3
Table Joins, Examples
4
Inner Joins, Exercise 1,2
5
Implicit Inner Joins
6
Left Outer Joins, Exercise 4,5
7
Right Outer Joins, Exercise 6,7
8
Implicit and Explicit Self Joins - Equijoins - The USING Keyword - Exercise
9
Cross Joins, UNION, and Full Outer Joins - Exercise 1,2
10
Joining Multiple Tables - Exercise 1-3

Tables & Databases - Part 1 (CRUD Operations)

1
Section Introduction
2
Creating and Dropping Databases and Tables - CRUD Operations - Exercise 1
3
Creating Tables using the 'SELECT AS' and 'LIKE' keywords - Exercise 1,2
4
Modifying Structure of Tables using the 'Alter Table' Command - Exercise
5
Updating Data using the UPDATE statement - Exercise 1,2
6
Removing Data using the DELETE statement - Exercise

Retrieving Data - Part 3 (More Advanced Queries)

1
Section Introduction
2
Summary Queries / Aggregate Functions, Part 1 - AVG, MIN, MAX, SUM, COUNT
3
Summary Queries / Aggregate Functions, Part 2 - Exercise 1,2
4
Summary Queries / Aggregate Functions, Part 3 - Exercise 3,4
5
The Group By Clause, Part 1 - Exercise 1-3
6
Running MySQL Scripts
7
The Group By Clause, Part 2 - Exercise 1,2
8
The Group By Clause, Part 3-1 - Exercise 1,2
9
The Group By Clause, Part 3-2 - The HAVING Clause - Exercise 3-5
10
The Group By Clause, Part 3-3 - Exercise 6
11
The Group By Clause, Part 3-4 - Exercise 7,8
12
Replacing Inner Joins with Implicit Joins - Exercise 1-5
13
Using Subqueries in Different Parts of Queries - Exercise 1-4
14
Subqueries - ALL, ANY, and SOME Operators

Data Types

1
Section Introduction
2
Data Types - CHAR, and VARCHAR
3
Data Types - Texts, Binary Large Objects, ENUM, and SET
4
Data Types-INT, BIGINT, …, BOOLEAN, DECIMAL, FLOAT, DOUBLE, DATE, TIME, DATETIME
5
Implicit and Explicit Data Conversion - CAST(), CONVERT(), FORMAT(), CHAR()

String & Numeric Functions

1
Section Introduction
2
String Functions - Part 1 (Lower, Upper, Lcase, Ucase)
3
String Functions - Part 2 (Concat, Concat_WS, LTrim, RTrim, Trim)
4
String Functions - Part 3 (Length, Char_Length, Lpad, Rpad)
5
String Functions - Part 4 (Left, Right, Reverse, Repeat, Space)
6
String Functions - Part 5 (Replace, Locate, Insert)
7
String Functions - Part 6 (Strcmp, Substring)
8
String Functions - Exercise 1,2
9
Numeric Functions - Part 1 (Mod, Sign, Abs, Ceiling, Floor)
10
Numeric Functions - Part 2 (Power, Sqrt, Truncate, Rand) - Exercise

Date-Time & Miscellaneous Functions

1
Section Introduction
2
Datetime Functions - Part 1 (Now, Sysdate, Curdate, Curtime, UTC_Date, …)
3
Datetime Functions - Part 2 (Year, Quarter, Month, MonthName, Week)
4
Datetime Functions - Part 3 (Day, Hour, Minute, Second, DayOfWeek, ...)
5
Datetime Functions - Part 4 (Extract)
6
Datetime Functions - Part 5 (Date_Format, Time_Format, Get_Format)
7
Datetime Functions - Part 6 (Format Specifiers)
8
Datetime Functions - Part 7 (Date_add, Date_Sub, DateDiff, TimeDiff, ...)
9
Datetime Functions - Part 8 - Searching for date/time values - Exercise 1,2
10
The Case() Function - Exercise
11
The IF() Function
12
The IfNull() and Coalesce() Functions

Tables & Databases - Part 2 (Relationships & Constraints)

1
Section Introduction
2
One-to-One Relationships / Primary and Foreign Keys
3
One-to-Many Relationships
4
Many-to-Many Relationships
5
One-to-One Relationships - Practice
6
One-to-Many Relationships - Practice
7
Many-to-Many Relationships - Practice (Including an ERD)
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7
4.7 out of 5
29 Ratings

Detailed Rating

Stars 5
22
Stars 4
5
Stars 3
1
Stars 2
0
Stars 1
1
d8a66c0ce07d8ef17ad1f93036136106
30-Day Money-Back Guarantee

Includes

21 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion