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
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX