MySQL Full Course For Beginners in 3 hours
MySQL Full Course For Beginners in 3 hours
Please find all the queries in my github repository: https://github.com/DataScienceRoadMap...
MySQL Full course
Learn SQL
SQL full course
MySQL tutorial
SQL tutorial
SQL for beginners
MySQL for beginners
SQL full course for beginners
SQL in 3 hours
Content:
00:00:00 Introduction
00:00:19 How to install MySQL
00:04:32 Part 1:
What is SQL
What is an RDBMS
What is a Database and what is a Relational Database
Famous RDBMS used in the real world
Tables
ER diagram
Keys
Constraints
SQL indexes
MySQL data types
SQL command types
Hands-on all the defined concepts above using MySQL
00:27:52 Part 2:
DROP DATABASES
DDL commands (INSERT single row without column names)
INSERT single row with column names
INSERT multiple rows
DELETE command
Change preferences to force updates in a table
Why do we use SELECT and WHERE commands?
UPDATE command
DROP vs TRUNCATE table
CREATE and DROP VIEW
00:42:36 Part 3:
CREATE Table
ALTER command (ADD, RENAME, DROP columns)
ALTER command( Modify data type of a column)
SHOW command (To display the table details)
ADD and DROP Constraints( NOT NULL, DEFAULT and CHECK)
SELECT and SELECT DISTINCT
Aliases
Comparaison Operators
00:55:36 Part 4:
Logical Operators
IN Operator
BETWEEN Operator
Aggregation Functions
GROUP BY Operator
ORDER BY Operator
Operator
HAVING Operator
CASE STATEMENT
LIKE Operator
01:21:42 Part 5:
UNION & UNION ALL
01:27:35 Part 6:
Inner Joins
Outer Joins (RIGHT, LEFT and FULL)
Natural Joins
Cross Joins
01:43:56 Part 7:
Subqueries(6 types)
02:03:18 Part 8:
NULL SAFE JOIN & SAFE JOIN
02:10:57 Part 9:
MySQL Built in functions
String functions
Numeric functions
Date and Time functions
02:27:55 Part 10:
TCL commands (COMMIT, ROLLBACK and SAVEPOINT)
02:35:35 Part 11:
Aggregation functions as window functions
ROW_NUMBER()
FIRST_VALUE()
LAST_VALUE()
NTH_VALUE()
LEAD()
LAG()
NTILE()
RANK()
DENSE_RANK()
PERCENT_RANK()
CUME_DIST()
Coursera plus - with Coursera plus, you will have unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs—all included in your subscription including popular Professional Certificates from Google and Meta : https://imp.i384100.net/Or95Yn
Data Science Path:
1. Data Science Math skills - Duke University: https://imp.i384100.net/3e9Okd
2. Inferential Statistics - Duke University: https://imp.i384100.net/4PrKao
3. IBM Data Analyst: https://imp.i384100.net/NkQPG2
4. Python for Everybody: https://imp.i384100.net/y2eLZW
5. Data Science Specialization - Johns Hopkins University: https://imp.i384100.net/9gM2D0
6. IBM Data Science: https://imp.i384100.net/LXxgBL
7. Machine Learning Specialization: https://imp.i384100.net/NkQPJv
8. Deep Learning Specialization: https://imp.i384100.net/Kjq9GA
9. MLOps Specialization: https://imp.i384100.net/q4ENvj
10. DeepLearning.AI TensorFlow Developer: https://imp.i384100.net/9gMQZ0
11. TensorFlow Advanced Techniques: https://imp.i384100.net/rQzby5
13. TensorFlow Data & Deployment Specialization: https://imp.i384100.net/PyrkgX
14. Natural Language Processing Specialization: https://imp.i384100.net/k0abvn
15. AWS Fundamentals: https://imp.i384100.net/eKrB2D
16. Practical Data Science on AWS: https://imp.i384100.net/q4ENv5
Get certified from Google:
1. Google Data Analytics: https://imp.i384100.net/xk2bvA
2. Google Business Intelligence: https://imp.i384100.net/QyNedP
3. Google Advanced Data Analytics: https://imp.i384100.net/rQzbNQ
Get certified from Meta:
Meta Database Engineer: https://imp.i384100.net/jrn26e
Disclosure:
I may receive a commission if you click on and purchase from one of the links above.
