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?!
0.5) Welcome to the Complete MySQL Course!
1 Introductin to Intro
2 How to Use MySQL
3 Tooling and isntalling mysql
4 Tooling and Hello world
DATABASES AND QUERIES
1 Creating Database
1 Creating Databases
2 Dropping Databases
2 Dropping Databases
3 Data Types
3 Data Types
4 Creating Table
5 Dropping Table
5 Dropping Table
6 Alter Table
6 Alter Table
7 Inserting Data into Database
7 Inserting Data into Database
8 Inserting Multiple Records
8 Inserting Multiple Data
9 Deleting A Row
9 Deleting A Row
10 Deleting Multiple Rows
10 Deleting Multiple Rows
11 Truncate
11 Truncate
12 Inserting Fake Data
SQL Statements Fundamentals
1 Statements Basics
1 Generate Fake Data
2 The Select Statement
2 SELECT Statement
3 SELECT DISTINTC
3 SELECT DISTINCT
4 WHERE
4 WHERE
5 Alises AS
5 Alias AS
6 LIMIT and Offset
6 LIMIT and Offset
7 SELECT COUNT
7 SELECT COUNT
8 Between
8 Between
9 IN
9 IN
10 Order By
10 Order By
11 Aggregate Function
11 Aggregate Functions
12 Group By
12 Group by
13 HAVING
13 HAVING
Create, Read, Update, Delete (CRUD)
1 Intro
1 intro
2 Create
2 Create
3 Read
3 Read
4 Update
4 Update
5 Delete
5 Delete
Data Types and Operators
1 Intro
2 CHAR
2 CHAR
3 Decimal
3 Date and Time
3 Decimal
4 Date and Time
4 Date and Time
5 Current Time and Date
5 Current Time and Date
6 Date and Time Functions
6 Date and Time Funcations
7 DATEDIFF
8 DATEADD
8 DateADD
9 TIMEstamps and CURRENTTIME STAMP
9 Timestamps and CURRENT TIME STAMP
10 SDate Format
10 Date Format
Links
String and Mathematical Functions
1 Intro
1 Substr
2 Substr
3 Concat
3 Concat
4 ASCII
4 ASCII
5 BIN
5 BIN
6 TRIM
6 TRIM
7 String Length
7 String Length
8 Upper and Lower Case
8 Upper and Lower Case
9 Reverse
9 Reverse
10 String Replace
10 String Replace
11 String Compare
11 String Compare
12 Intro to Maths Functions
13 Rand
13 Rand
14 Round
14 Rand
Joins and Relationships
1 Introduction to Relationships
1 Inner Join
2 Types Of Relation
2 Cross Join
3 One to Many Relation - Free Preview
3 Left Join
4 Querying Table
5 Cross Join
5 Querying Table
6 Inner Join
7 Left Join
8 Right Join
PROJECT I : Twitter Clone Design & Development
1 Intro
2 Our Entities Basics
3 Working with Users Schema
4 Tweets Schema
5 Inserting Tweets
6 Tweet Replies
7 Relation Between Users and Replies
8 Tweet Has Reply
9 Likes and Its relation
Porject Codes
Project II : Contact Diary Web Application
1 Intro
2 Building UI
3 Table Schema
4 Connecting to Database
5 Adding Contacts to Database
6 Contact Lists
7 Deleting From Table
8 Details of Contact
9 Update Contacts
10 Checks
contacts
edit
DB_SCHEMA
contacts
index
update
conn
details
delete
BONUS: Git and Github
1 Intro
2 Git Installation
3 Cloning From Github
4 Repositories
5 Pushing on github
6 Pull from Github
7 Branches Basics
Course Summary, and Conclusion
MYSQL CONCLUSION
5 Cross Join
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock