SQL Tutorial - Full Database Course for Beginners

Channel:
United States freeCodeCamp.org
Subscribers:
10,700,000
Published on ● Video Link: https://www.youtube.com/watch?v=HXV3zeQKqGY


Duration: 4:20:39
16,622,272 views
316,889

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/databases/sql/creating-company-database/

⭐️ 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. Check out his YouTube channel for more great programming courses: https://www.youtube.com/channel/UCvmINlrza7JHB1zkIOuXEbw

🐦Follow Mike on Twitter: http://twitter.com/mike_dane

🔗The Giraffe Academy website: http://www.giraffeacademy.com/

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org



Other Videos By freeCodeCamp.org


2018-07-09Amazon Alexa Skill Development Live Stream - Day 1
2018-07-06WordPress Plugin Editing Part 2 (P5D83) - Live Coding with Jesse
2018-07-06Testing Node.js with Mocha
2018-07-05WordPress Plugin Editing (P5D82) - Live Coding with Jesse
2018-07-05Intro to Cloud Computing and AWS
2018-07-05Logging in JavaScript Best Practices
2018-07-04The human nature of failure & resiliency
2018-07-03Learn to Code: 5 Secret Weapons
2018-07-03Elm crash course - Building unbreakable webapps fast
2018-07-02React Live Search (P5D81) - Live Coding with Jesse
2018-07-02SQL Tutorial - Full Database Course for Beginners
2018-07-02Overcoming obstacles when learning to code
2018-06-29Statistics and Probability: Your first steps on the road to data science
2018-06-28React Native Tutorial - Augmented Reality Mobile App
2018-06-27Learn React with Kent C. Dodds
2018-06-27Learn Python by Immersion
2018-06-26Build your first Rails app - blog with comments (tutorial)
2018-06-26Web Workers —  Outsource your JavaScript
2018-06-25Build a blazing fast website with GatsbyJS and Contentful
2018-06-25How to achieve reusability with React components
2018-06-22Code Asteroids in JavaScript (1979 Atari game) - tutorial


Tags:
sql
sql tutorial
sql course
sql for beginners
Structured Query Language
sql course for beginners
learn sql
free sql course
web development
mysql
mysql tutorial
mysql course
rdbms