SQL Tutorial - Full Database Course for Beginners
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS.
Want more from Mike? He's starting a coding RPG/Bootcamp - https://simulator.dev/
The course is designed for beginners to SQL and database management systems, and will introduce common database management topics.
Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more.
You can get PopSQL to follow along here: http://popsql.com/freecodecamp
🔗Company Database Code: https://www.giraffeacademy.com/databa...
⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables & Keys
⌨️ (43:31) SQL Basics
⌨️ (52:26) MySQL Windows Installation
⌨️ (1:01:59) MySQL Mac Installation
⌨️ (1:15:49) Creating Tables
⌨️ (1:31:05) Inserting Data
⌨️ (1:38:17) Constraints
⌨️ (1:48:11) Update & Delete
⌨️ (1:56:11) Basic Queries
⌨️ (2:08:37) Company Database Intro
⌨️ (2:14:05) Creating Company Database
⌨️ (2:30:27 ) More Basic Queries
⌨️ (2:26:24) Functions
⌨️ (2:45:13) Wildcards
⌨️ (2:53:53) Union
⌨️ (3:01:36) Joins
⌨️ (3:11:49) Nested Queries
⌨️ (3:21:52) On Delete
⌨️ (3:30:05) Triggers
⌨️ (3:42:12) ER Diagrams Intro
⌨️ (3:55:53) Designing an ER Diagram
⌨️ (4:08:34) Converting ER Diagrams to Schemas
Course developed by Mike Dane.
-
38:35
Standpoint with Gabe Groisman
2 hours agoEp. 22. Knesset Speaker on The Challenging Times in Israel. Amir Ohana
7.65K13 -
17:05
TENET Media
1 hour agoRepeal The 19th Amendment? | Tim Pool
4.1K17 -
2:42:14
Russell Brand
5 hours agoPower-Grabbing WHO Pandemic Treaty Is BACK - And It’s Worse Than You Thought- Stay Free #357
128K320 -
27:50
Stephen Gardner
2 hours ago🔴Biden makes EPIC MISTAKE Against Trump as TRUTH Leaks out of Court!
10.7K21 -
4:18:06
Cryptic Hybrid
5 hours agoBreeding Cute Bees & Helping Gnomes. Let's Play Indie Games Time Is Honey & EcoGnomix
12.6K -
1:26:00
vivafrei
2 hours agoTrump Judge Contemplates MORE Contempt! TERRIBLE Bill out of New York; Daily Wire DRAMA & More!
26.1K20 -
1:11:49
TheAlecLaceShow
3 hours agoGuests: Senator Rick Scott | Congressman Andrew Clyde | Clay Clark | The Alec Lace Show
12.3K1 -
57:31
The Dan Bongino Show
5 hours agoThe Professionals Behind The Protests (Ep. 2242) - 05/02/2024
410K1.28K -
LIVE
Drunk3PO
3 hours agoPP Pants, Stay at the X-Men Mansion, & MORE | High-T Thursday w/ Fear the Beardo & Drunk3po Live
269 watching -
DVR
OFFICIAL Jovan Hutton Pulitzer Rumble
4 hours agoARTIFICIAL INTELLEGENCE - Voting Data/Info - You Have Already Been Corralled!
14K9