YoVDO

MySQL Tutorial - Comprehensive Guide for Beginners to Advanced Users

Offered By: Derek Banas via YouTube

Tags

MySQL Courses Database Design Courses Database Management Courses MySQL Workbench Courses Foreign Keys Courses Aggregate Functions Courses

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 SQL
openHPI
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