MySQL and MariaDB Masterclass [Full Course]
#MySQL #SQL #RDBMS
Welcome to the Introduction to RDBMS, SQL, MySQL, and MariaDB with a little bit of Python Programming.
You can find the code demonstrated and the other resources in this Episode at the following repository,
https://github.com/ashwin-pajankar/Da...
Contents:
00:00:00 - Introduction and Installation of MySQL
01:38:50 - Getting Started with Basic SQL queries
02:08:05 - The WHERE Clause
02:44:50 - Single Row Functions
03:33:26 - Group Functions
03:54:48 - Joins
04:22:30 - Views
04:34:25 - Subquery
04:46:45 - Constraints
05:34:20 - Referential Integrity and Foreign Key
06:07:00 - Working with Python
06:47:50 - Install MariaDB on Windows and Raspberry Pi
07:15:25 - Useful Tips and Tools