Course Content
Course Introduction
Course Introduction.
0/7
Welcome to the course
Course Introduction
05:22
Downloading MySQL
02:13
Installing MySQL in our Computer
09:22
What is a Database?
10:07
Course Resources
Student Review Request
Creating Databases and Tables
Creating Databases and Tables
0/9
Creating New Database
04:41
Introducing Command line interface
02:08
Dropping Database using command Line Interface (CLI)
02:05
Understanding Tables
05:59
SQL Data Types
07:29
Creating tables in our database
05:33
Creating tables in our database Continue
02:36
Dropping Tables
01:52
MySQL comments
05:54
Inserting data into our tables
0/6
Introducing insert command
06:24
Multi-Insert
03:51
working with null and NOT-NULL
05:59
Working with Default values
06:22
Auto-increments
04:19
Understanding PRIMRY KEYS
06:52
Basics of CRUD operations
Basics of CRUD operations
0/8
Section Introduction CRUD
04:16
Types of SQL Commands
06:13
Create Command
04:14
Inserting data into our table
01:52
Select Command
04:09
SQL Aliases
03:07
UPDATE COMMAND
07:53
DELETE Command
03:38
SQL String Functions
SQL String Functions
0/7
MySQL string functions
03:34
Loading data and creating new Table
05:21
Concat
06:25
Substring
06:35
Replace
03:10
Upper and Lower
03:32
Reverse, TRIM, LTRIM, RTRIM, RIGHT, LEFT Commands
06:10
Deep Dive into Select Statement
Deep Dive into Select Statement
0/5
Section 6 introduction
01:05
Loading Database and Tables
08:49
Order by and Distinct command
07:36
LIMIT AND OFFSET
06:09
LIKE AND WILCARDS
14:07
Aggregate Functions
Aggregate Functions
0/7
COUNT
05:36
COUNT WITH GRUP BY
04:45
MIN and MAX
01:53
Min and Max with Group By
05:41
Subqueries with Aggregate functions
08:42
SUM and AVG Functions
04:55
Grouping multiple Columns
03:40
Logical Operators and Comparisons
Logical Operators and Comparisons
0/8
NOT EQUAL
05:52
NOT LIKE
03:16
Greater than and less than
06:18
48 Logical and logical or
07:58
Between
04:07
The in Operator
05:56
The Is NULL operator
02:38
Case Operator
08:16
Constraints and Alter Table
Constraints and Alter Table
0/7
Unique Constraint
05:34
Check Constraint
04:32
Named Constraints
04:10
Alter table Adding Columns
03:55
Alter Table Dropping Columns
01:09
Alter table name, and Modifying Columns
04:06
Alter Table Constraints
04:58
Relationships, joins and Views
Relationships, joins and Views
0/8
Introduction to Relationships
07:38
One to one Relationship
12:03
One to Many Relationship
12:01
Many to Many Relationship
12:54
Introduction to joins
03:42
Joins in detail
11:27
Joining Multiple Tables
11:41
Views in detail
05:47
Course Roundup
Course Roundup
0/2
Course Roundup.
02:14
Final words
The Complete SQL Database Course from ZERO to HERO using MySQL.
Previous
Next
0% Complete