Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete MySQL Bootcamp: Become an Expert in SQL & MySQL
INTRODUCTION TO MYSQL
Would You Like To Learn MySQL From Scratch?! (2:10)
0.5) Welcome to the Complete MySQL Course! (2:33)
1 Introductin to Intro (3:29)
2 How to Use MySQL (3:40)
3 Tooling and isntalling mysql (2:44)
4 Tooling and Hello world (4:38)
DATABASES AND QUERIES
1 Creating Database (4:38)
1 Creating Databases
2 Dropping Databases
2 Dropping Databases (3:19)
3 Data Types (3:52)
3 Data Types
4 Creating Table (7:57)
5 Dropping Table (4:09)
5 Dropping Table
6 Alter Table
6 Alter Table (8:10)
7 Inserting Data into Database (8:05)
7 Inserting Data into Database
8 Inserting Multiple Records (3:22)
8 Inserting Multiple Data
9 Deleting A Row (3:01)
9 Deleting A Row
10 Deleting Multiple Rows (2:18)
10 Deleting Multiple Rows
11 Truncate (2:03)
11 Truncate
12 Inserting Fake Data (5:50)
SQL Statements Fundamentals
1 Statements Basics (0:47)
1 Generate Fake Data
2 The Select Statement (9:00)
2 SELECT Statement
3 SELECT DISTINTC (4:14)
3 SELECT DISTINCT
4 WHERE (9:52)
4 WHERE
5 Alises AS
5 Alias AS (2:56)
6 LIMIT and Offset (2:58)
6 LIMIT and Offset
7 SELECT COUNT (4:09)
7 SELECT COUNT
8 Between (2:07)
8 Between
9 IN (2:49)
9 IN
10 Order By (5:44)
10 Order By
11 Aggregate Function (4:27)
11 Aggregate Functions
12 Group By (14:42)
12 Group by
13 HAVING (5:44)
13 HAVING
Create, Read, Update, Delete (CRUD)
1 Intro (2:33)
1 intro
2 Create (3:20)
2 Create
3 Read (2:39)
3 Read
4 Update
4 Update (5:35)
5 Delete
5 Delete (5:43)
Data Types and Operators
1 Intro (0:42)
2 CHAR (11:09)
2 CHAR
3 Decimal (7:29)
3 Date and Time
3 Decimal
4 Date and Time (8:26)
4 Date and Time
5 Current Time and Date
5 Current Time and Date (4:12)
6 Date and Time Functions
6 Date and Time Funcations (7:48)
7 DATEDIFF (6:41)
8 DATEADD (4:35)
8 DateADD
9 TIMEstamps and CURRENTTIME STAMP (10:43)
9 Timestamps and CURRENT TIME STAMP
10 SDate Format (4:02)
10 Date Format
Links
String and Mathematical Functions
1 Intro (2:16)
1 Substr
2 Substr (2:25)
3 Concat (3:05)
3 Concat
4 ASCII (2:27)
4 ASCII
5 BIN (2:05)
5 BIN
6 TRIM
6 TRIM (2:22)
7 String Length
7 String Length (2:21)
8 Upper and Lower Case (3:09)
8 Upper and Lower Case
9 Reverse (2:13)
9 Reverse
10 String Replace (4:47)
10 String Replace
11 String Compare (2:59)
11 String Compare
12 Intro to Maths Functions (0:44)
13 Rand (1:28)
13 Rand
14 Round (1:54)
14 Rand
Joins and Relationships
1 Introduction to Relationships (4:58)
1 Inner Join
2 Types Of Relation (6:17)
2 Cross Join
3 One to Many Relation - Free Preview (7:30)
3 Left Join
4 Querying Table (5:58)
5 Cross Join (2:14)
5 Querying Table
6 Inner Join (15:54)
7 Left Join (9:00)
8 Right Join (4:26)
PROJECT I : Twitter Clone Design & Development
1 Intro (0:49)
2 Our Entities Basics (3:27)
3 Working with Users Schema (8:43)
4 Tweets Schema (10:15)
5 Inserting Tweets (6:56)
6 Tweet Replies (14:39)
7 Relation Between Users and Replies (4:42)
8 Tweet Has Reply (6:10)
9 Likes and Its relation (20:43)
Porject Codes
Project II : Contact Diary Web Application
1 Intro (3:44)
2 Building UI (8:10)
3 Table Schema (3:45)
4 Connecting to Database (6:24)
5 Adding Contacts to Database (7:27)
6 Contact Lists (4:42)
7 Deleting From Table (6:03)
8 Details of Contact (7:40)
9 Update Contacts (8:15)
10 Checks (3:40)
contacts
edit
DB_SCHEMA
contacts
index
update
conn
details
delete
BONUS: Git and Github
1 Intro (2:02)
2 Git Installation (3:41)
3 Cloning From Github (5:46)
4 Repositories (5:35)
5 Pushing on github (7:41)
6 Pull from Github (3:13)
7 Branches Basics (7:22)
Course Summary, and Conclusion
MYSQL CONCLUSION (1:37)
3 One to Many Relation - Free Preview
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock