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
Managing Big Data with MySQLDuke University via Coursera Database Management Essentials
University of Colorado System via Coursera Business Metrics for Data-Driven Companies
Duke University via Coursera Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique Базы данных (Databases)
Saint Petersburg State University via Coursera