Messing with MySQL - A Quick Tutorial on SQL Basics
Offered By: Satish C J via YouTube
Course Description
Overview
Learn essential MySQL database operations in this 42-minute tutorial. Explore DDL commands like Create, Alter, and Drop, as well as DML commands including Insert, Update, and Select. Master various constraints such as Primary Key, Check, Unique Key, Not Null, Default, and Foreign Key using Alter Table commands. Dive into different types of joins in MySQL, including Equi join, Left Join, Right Join, and Cross Join. Gain proficiency in using aggregate functions, the Between operator, and clauses like Group By, Having, and Order By to effectively manipulate and retrieve data from your MySQL database.
Syllabus
Messing with MySQL !!! - A quick tutorial on SQL basics using MySQL
Taught by
Satish C J
Related Courses
Mastering SQL JoinsCoursera Project Network via Coursera Intermediate SQL Queries
DataCamp Introduction to SQL Server
DataCamp PostgreSQL Summary Stats and Window Functions
DataCamp Functions for Manipulating Data in SQL Server
DataCamp