Dive into a comprehensive MySQL tutorial series spanning 3 hours and 30 minutes, covering essential topics from installation to advanced concepts. Learn to create and manage databases, execute SQL queries, implement constraints, utilize indexing, work with views, master various join types, and create stored procedures. Gain practical insights through interview preparation segments and solve real-world MySQL queries to enhance your database management skills for data science and Python integration.
Overview
Syllabus
Tutorial 1- MySQL With Python And Data Science- MySQL Installation Steps.
Tutorial 2-Create and Drop Database and Table-Complete MySQL Tutorial-.
Tutorial 3-MYSQL NULL Values, UPDATE,DELETE,ALTER Query-Complete MySQL Tutorial.
Tutorial 4- SQL Constraints Part1 - My SQL Complete Playlist.
Tutorial 5- Primary Key, Foreign Key, Check And Default Constraints-MySQL Complete Playlist.
Tutorial 6- Indexing In MySQL-MySQL Complete Playlist.
Tutorial 7- Interview Preparation MySql Views-MySQL Complete Playlist.
Tutorial 8- Discussing All Types Of Joins -MySQL Complete Playlist.
Tutorial 9- MYSQL Stored Procedures -MySQL Complete Playlist.
Interview 1-MySQL Interview Question With Solutions- Part 1.
Interview 1-MySQL Interview Question With Solutions- Solving Queries- Part 2.
Taught by
Krish Naik
