Learn MySQL from installation to advanced concepts in this comprehensive 9-hour course. Master database management, data manipulation, and extraction through hands-on projects. Explore SQL fundamentals including CRUD operations, joins, pattern matching, and various SQL functions. Dive into normalization techniques, ER diagrams, operators, and case statements. Practice with real-world examples like HR and broadband database management systems. Gain practical skills in integrating SQL with Python for data analysis and manipulation. Perfect for beginners and intermediate learners looking to enhance their database management skills and accelerate their careers in data-driven fields.
Overview
Syllabus
MySQL Workbench Installation | How To Download And Install MYSQL Workbench | Great Learning.
Introduction to Database Management System | DBMS tutorial for beginners | Great Learning.
Getting started with RDBMS | DBMS tutorial for beginners | Great Learning.
Normalization techniques in MySQL | Normalization 1nf 2nf 3nf With Example | Great Learning.
ER Diagram | ER diagram in DBMS | Great Learning.
MySQL Tutorial for Beginners | Introduction to MySQL | Great Learning.
Operators in Mysql | Mysql Tutorial For beginners | Great Learning.
Pattern matching and null value concept in MySQL | MySQL Tutorial For beginners | Great Learning.
Group By and Having Concept in MySQL | MySQL Tutorial For beginners | Great Learning.
Join in SQL | MySQL Tutorial for Beginners | Great Learning.
Subquery in SQL | MySQL Tutorial For Beginner | Great Learning.
Case statement in MySQL | MySQL Tutorial For beginners | Great Learning.
HR Database Management System | DBMS | DBMS Tutorial For Beginners | Great Learning.
Broadband database management system | DBMS | DBMS Tutorial For Beginners | Great Learning.
SQL with Python | MySQL Tutorial For Beginners | Great Learning.
Taught by
Great Learning
