9 Sections
47 Lessons
10 Weeks
Expand all sections
Collapse all sections
Introduction to MySQL and SQL Basics
3
1.1
Introduction to MySQL and SQL Basics
1.2
Installing MySQL Server and MySQL Workbench
1.3
Executing the first SQL query in MySQL – Practical
MySQL Fundamentals
5
2.1
MySQL Fundamentals- MySQL Basics : Understanding MySQL statements
2.2
MySQL Fundamentals MySQL Basics – Practical
2.3
Data Filtering – Part-1
2.4
Data Filtering – Part-2
2.5
Assignment Solution
Advanced MySQL Concepts
9
3.1
Advanced MySQL Concepts
3.2
Joints in MySQL – Practical
3.3
Joints in MySQL – Practical Part-2
3.4
Logical Operators and Advance Filtering
3.5
Timestamps and Extract in MySQL
3.6
Using String Functions in MySQL
3.7
Using mathematical functions in MySQL
3.8
Assignment
3.9
Assignment Solution
Database Management and Constraints in MySQL
4
4.1
Data Types and Constraints in MySQL
4.2
Constraints in MySQL – Practical
4.3
Creating and Altering Tables in MySQL
4.4
Table Data Manipulation in MySQL
Database Design and Normalisation
2
5.1
Database Design Principles and Normalization
5.2
Database Design and Normalization (Practical)
Performance Optimization
4
6.1
Performance Optimization- Indexing, Query Optimization, Database Maintenance
6.2
Performance Optimization- Practical
6.3
Performance Analysis of Database
6.4
Database Security Best Practices
Advanced MySQL Features
9
7.1
Advanced MySQL Features
7.2
Advanced MySQL Features – Practical
7.3
Management of User Defined Functions
7.4
Creating and managing triggers
7.5
Views and Data Import-Export in MySQL
7.6
Creating & Managing views in MySQL
7.7
Windows Function
7.8
Windows Function- Rank
7.9
Connecting Python with MySQL
Practical Applications and Projects
3
8.1
Conditional Logic, NULL Values, Real-World Database & Case Studies
8.2
Using CASE statements for conditional logic- practical
8.3
Handling NULL Values in MySQL
Final Projects and Certifications
8
9.1
Capstone Project Intro
9.2
Capstone Project Solution Part- 1
9.3
Capstone Project Solution Part- 2
9.4
Capstone Project Solution Part- 3
9.5
Capstone Project Solution Part- 4
9.6
Capstone Project Solution Part- 5
9.7
Capstone Project Solution Part- 6
9.8
Final Assessment and Conclusion
MySQL & SQL Mastery: Basics to Advanced Management
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
Lost your password?
Remember Me
Modal title
Main Content