Home
Category
Search
Cart
Menu

Find your desired course

Select Your Favourite
Category And Start Learning.

Course Content
01. Introduction and Set Up
0/12
01. Course Overview
02:49
02. Udemy Basics
02:37
03. Relational Databases
04:57
04. What is MySQL
02:07
05. What is SQL
02:13
06. Objects in MySQL
01:16
07. MySQL Installation Overview
01:32
08. MySQL Installation on Windows OS
08:42
09. MySQL Installation on Mac OS
09:14
10. MySQL Workbench UI Overview
08:54
11. Adding the Countries Data
04:28
12. Course Resources PDF + Lecture Downloads!
02:17
02. Data Query Language
0/13
01. Section Overview
01:05
02. The SELECT Statement
07:15
03. USE SCHEMA
02:18
04. Statements vs Queries
00:47
05. SELECT STAR ()
03:04
06. Aliasing Column Names
05:47
07. Aliasing Table Names (and Qualifying Columns)
05:31
08. Adding Comments to SQL Code
02:03
09. Selecting Distinct Rows
03:26
10. Ordering Rows
04:28
11. Limiting Rows
02:20
12. Order of Execution (So Far)
02:15
13. Syntax Differences Across Databases
01:56
03. Challenge Section 1
0/1
Attachments
04. Data Types
0/6
01. Section Overview
00:55
02. Numeric Data Types
03:37
03. String Data Types
03:06
04. Date and Time Data Types
00:55
05. The Describe Statement
01:59
06. Data Type Differences Across Databases
02:08
05. Data Definition and Manipulation Language
0/16
01. Section Overview
01:09
02. Creating and Dropping Tables
05:13
03. Creating and Dropping Schemas
03:14
04. Inserting Rows
11:31
05. Inserting Multiple Rows
08:03
06. Create Table As (CTAS)
03:19
07. Truncating Tables
01:14
08. Alter Table
08:54
09. Updating and Deleting Rows
11:24
10. Constraints in SQL
01:35
11. Not Null Constraint
05:41
12. Unique Constraint
03:55
13. Default Constraint
03:40
14. Check Constraint
03:17
15. Dropping the Not Null and Default Constraints
02:49
16. Dropping the Unique and Check Constraints
03:32
06. Relational Database Design
0/8
01. Section Overview
00:28
02. Normalization
11:48
03. Types of Relationships
05:17
04. Primary and Foreign Keys
06:11
05. Primary and Foreign Keys (Demo)
10:55
06. Entity Relationship Diagrams (ERD)
08:23
07. Tidying Up Our Schemas
00:28
08. Syntax Differences Across Databases
01:10
The Comprehensive SQL Course
Previous
Next
0% Complete

As Featured In