Mastering SQL (Using MySQL, Java, and Go)
4.7 (70 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,422 students enrolled

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
4.7 (70 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,422 students enrolled
Created by Kam Hojati
Last updated 2/2019
English
English [Auto]
Current price: $128.99 Original price: $184.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 21 hours on-demand video
  • 87 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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)
Course content
Expand all 188 lectures 20:50:13
+ Introduction & Installation
7 lectures 41:18
A Brief History of SQL and MySQL
02:17
Database Concepts - Part 1 (Data and Tables)
02:31
Database Concepts - Part 2 (Columns, Rows, Tables, and Databases)
03:20
Database Concepts - Part 3 (DBMS, RDBMS, CRUD, and an Example) - Exercise
05:51
MySQL Installation on Windows
08:05
+ Your First Database
7 lectures 43:14
Section Introduction
00:26
First Data Types (INT and VARCHAR)
01:37
Creating & Managing Your First Database
06:57
Creating & Managing Your First Tables
09:02
Inserting Data into Tables
12:35
Querying Data using the SELECT Statement
04:02
Exercise - Working with Databases and Tables
08:35
+ Retrieving Data - Part 1 (Basics)
12 lectures 01:49:57
Section Introduction
01:02
NULL Values, Testing for NULL Values, Columns Alias, and Equality Operators
06:10
Primary Key, WHERE Clause, and AUTO_INCREMENT
17:26
The DEFAULT Keyword, Logical Operators, and Exercises
11:52
Creating Primary Keys (2nd approach), Simple & Composite Primary Keys - Exercise
14:09
Data Types (DECIMAL, DATE, and ENUM) - Mathematical Operators
05:05
Exercise [DECIMAL, DATE, and ENUM, Mathematical Operators, CONCAT() and LEFT() ]
16:54
Managing Duplicate Rows - DISTINCT and ALL Keywords - Comparison Operators
05:47
Writing Subqueries Using the IN Keyword - The BETWEEN Keyword
07:02
The ORDER BY Clause, and the LIMIT Keyword - Exercise
08:58
Pattern Matching using the LIKE Operator
08:00
Complex Pattern Matching using the REGEXP Operator
07:32
+ Retrieving Data - Part 2 (Joins)
10 lectures 01:25:47
Section Introduction
00:34
Table Joins, Concepts (Inner and Outer Joins)
06:50
Table Joins, Examples
16:31
Inner Joins, Exercise 1,2
14:24
Implicit Inner Joins
01:56
Left Outer Joins, Exercise 4,5
04:30
Right Outer Joins, Exercise 6,7
03:52
Implicit and Explicit Self Joins - Equijoins - The USING Keyword - Exercise
09:05
Cross Joins, UNION, and Full Outer Joins - Exercise 1,2
14:35
Joining Multiple Tables - Exercise 1-3
13:30
+ Tables & Databases - Part 1 (CRUD Operations)
6 lectures 01:01:42
Section Introduction
00:34
Creating and Dropping Databases and Tables - CRUD Operations - Exercise 1
06:35
Creating Tables using the 'SELECT AS' and 'LIKE' keywords - Exercise 1,2
09:34
Modifying Structure of Tables using the 'Alter Table' Command - Exercise
15:28
Updating Data using the UPDATE statement - Exercise 1,2
16:24
Removing Data using the DELETE statement - Exercise
13:07
+ Retrieving Data - Part 3 (More Advanced Queries)
14 lectures 01:39:41
Section Introduction
00:40
Summary Queries / Aggregate Functions, Part 1 - AVG, MIN, MAX, SUM, COUNT
09:21
Summary Queries / Aggregate Functions, Part 2 - Exercise 1,2
09:37
Summary Queries / Aggregate Functions, Part 3 - Exercise 3,4
04:52
The Group By Clause, Part 1 - Exercise 1-3
09:16
Running MySQL Scripts
04:50
The Group By Clause, Part 2 - Exercise 1,2
06:03
The Group By Clause, Part 3-1 - Exercise 1,2
06:09
The Group By Clause, Part 3-2 - The HAVING Clause - Exercise 3-5
05:29
The Group By Clause, Part 3-3 - Exercise 6
10:33
The Group By Clause, Part 3-4 - Exercise 7,8
03:05
Replacing Inner Joins with Implicit Joins - Exercise 1-5
05:50
Using Subqueries in Different Parts of Queries - Exercise 1-4
12:09
Subqueries - ALL, ANY, and SOME Operators
11:47
+ Data Types
5 lectures 41:42
Section Introduction
00:40
Data Types - CHAR, and VARCHAR
08:33
Data Types - Texts, Binary Large Objects, ENUM, and SET
09:06
Data Types-INT, BIGINT, …, BOOLEAN, DECIMAL, FLOAT, DOUBLE, DATE, TIME, DATETIME
09:03
Implicit and Explicit Data Conversion - CAST(), CONVERT(), FORMAT(), CHAR()
14:20
+ String & Numeric Functions
10 lectures 56:08
Section Introduction
00:53
String Functions - Part 1 (Lower, Upper, Lcase, Ucase)
01:50
String Functions - Part 2 (Concat, Concat_WS, LTrim, RTrim, Trim)
04:30
String Functions - Part 3 (Length, Char_Length, Lpad, Rpad)
05:57
String Functions - Part 4 (Left, Right, Reverse, Repeat, Space)
05:01
String Functions - Part 5 (Replace, Locate, Insert)
09:05
String Functions - Part 6 (Strcmp, Substring)
04:50
String Functions - Exercise 1,2
13:25
Numeric Functions - Part 1 (Mod, Sign, Abs, Ceiling, Floor)
04:45
Numeric Functions - Part 2 (Power, Sqrt, Truncate, Rand) - Exercise
05:52
+ Date-Time & Miscellaneous Functions
12 lectures 54:20
Section Introduction
01:05
Datetime Functions - Part 1 (Now, Sysdate, Curdate, Curtime, UTC_Date, …)
04:29
Datetime Functions - Part 2 (Year, Quarter, Month, MonthName, Week)
02:22
Datetime Functions - Part 3 (Day, Hour, Minute, Second, DayOfWeek, ...)
04:13
Datetime Functions - Part 4 (Extract)
04:37
Datetime Functions - Part 5 (Date_Format, Time_Format, Get_Format)
08:04
Datetime Functions - Part 6 (Format Specifiers)
07:41
Datetime Functions - Part 7 (Date_add, Date_Sub, DateDiff, TimeDiff, ...)
06:54
Datetime Functions - Part 8 - Searching for date/time values - Exercise 1,2
04:25
The Case() Function - Exercise
04:21
The IF() Function
02:22
The IfNull() and Coalesce() Functions
03:47
+ Tables & Databases - Part 2 (Relationships & Constraints)
12 lectures 01:19:59
Section Introduction
00:53
One-to-One Relationships / Primary and Foreign Keys
05:47
One-to-Many Relationships
02:42
Many-to-Many Relationships
05:04
One-to-One Relationships - Practice
09:05
One-to-Many Relationships - Practice
03:52
Many-to-Many Relationships - Practice (Including an ERD)
10:11
Attributes & Constraints (NOT NULL, UNIQUE, DEFAULT, AUTO_INCREMENT, ...)
07:31
Referential Integrity & Foreign Key Constraint - Exercise
17:25
Altering Table Constraints (Add/Drop/Change Column) - Exercise 1-3
05:50
Altering Table Constraints (Add/Drop Primary or Foreign Key, ...) - Exercise 4-8
09:09
Renaming, Truncating and Dropping Tables
02:30
Requirements
  • To learn SQL, all you need is some general computer knowledge, and time and patience to learn the topics and to work on exercises and assignments
  • To connect MySQL and PostgreSQL to Java, you'll need prior Java experience, but code will be explained in detail
  • To connect MySQL and PostgreSQL to Go (Google Golang), you'll need prior Go experience, but code will be explained in detail
Description

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)




Who this course is for:
  • Developers, systems analysts, business analysts, or anyone willing to comfortably write SQL queries to analyze data and to address business needs
  • Anyone willing to create databases, tables, views, triggers, and stored programs
  • Anyone who wants to learn how use SQL (mainly MySQL and partially PostgreSQL) in Java and Go (Google Golang)