This course covers MySQL installation, creating and dropping databases and tables, working with NULL values, UPDATE, DELETE, and ALTER queries, SQL constraints, indexing, views, different types of joins, and stored procedures. The course aims to teach MySQL skills for data science and Python, with a focus on interview preparation. The intended audience for this course is individuals interested in learning MySQL for data science and Python applications.
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
