MySQL Tutorial - Comprehensive Guide for Beginners to Advanced Users
Offered By: Derek Banas via YouTube
Course Description
Overview
Learn MySQL fundamentals in this comprehensive 41-minute tutorial. Master database creation, table design, data types, primary and foreign keys, SQL queries, and advanced concepts like joins and aggregate functions. Explore practical examples and best practices for efficient database management, covering 95-98% of essential MySQL knowledge in a single video.
Syllabus
Introduction
MySQL Workbench
MySQL Terminal
Creating a Database
Creating a Table
Primary Keys
Atomic Tables
Additional Rules
Numeric Types
String Types
Set Types
Class
Foreign Keys
Test Data
Insert Data
Rename Tables
Limit Data
Order Data
Distinct
Count
Group By
Allow
Numeric Functions
Absences
Between
In
Join
Join 3 Tables
Left Join
Inner Join
Taught by
Derek Banas
Related Courses
Datenmanagement mit SQLopenHPI Programming Cloud Services for Android Handheld Systems
Vanderbilt University via Coursera Getting and Cleaning Data
Johns Hopkins University via Coursera Ruby مدخل إلى برمجة مواقع الإنترنت باستخدام لغة
Rwaq (رواق) MongoDB for .NET Developers
MongoDB University