SQL Crash Course - Beginner to Intermediate
Offered By: Traversy Media via YouTube
Course Description
Overview
Learn the fundamentals of SQL (Structured Query Language) in this comprehensive video tutorial. Cover essential topics from beginner to intermediate level, including database and table creation, data manipulation, querying with various operators, data types, and record management. Explore advanced concepts such as table joins, aliases, constraints (primary and foreign keys), and indexes. Gain hands-on experience with practical examples using popular database systems and tools like MySQL and phpMyAdmin. Master SQL skills to effectively manage and analyze data, preparing you for real-world database management scenarios.
Syllabus
Introduction
What Youll Learn
What is SQL
Popular Databases
SQL Tools
Installing SQL
Setting up PHP MyAdmin
Creating a Database
Creating a Table
Inserting Data
Updating Data
Deleting Customers
Alter Table
Select
Operators
Indexes
Insert Data
Inner Join
aliases
aggregate functions
group by
you case
Taught by
Traversy Media
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