In this course we will cover the basics of database administration and SQL using the MySQL RDBMS.
Want more from Mike? He's starting a coding RPG/bootcamp – https://simulator.dev/

The course is aimed at beginners in the area of SQL and database management systems and introduces common topics in database management.

During the course, we will cover various topics including schema design, basic CRUD operations, aggregation, nested queries, joins, keys, and much more.

You can download PopSQL here to join: http://popsql.com/freecodecamp

Company database code: https://www.giraffeacademy.com/databases/sql/creating-company-database/

️ Content
️ (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) Create tables
️ (1:31:05) Insert data
️ (1:38:17) Restrictions
️ (1:48:11) Update and delete
️ (1:56:11) Basic queries
️ (2:08:37) Introduction to the company database
️ (2:14:05) Create company database
️ (2:30:27) More basic queries
️ (2:26:24) Features
️ (2:45:13) Placeholder
️ (2:53:53) Union
️ (3:01:36) Join
️ (3:11:49) Nested queries
️ (3:21:52) When deleting
️ (3:30:05) Trigger
️ (3:42:12) Introduction to ER diagrams
️ (3:55:53) Designing an ER diagram
️ (4:08:34) Converting ER diagrams to schemas

Course developed by Mike Dane. For more great programming courses, check out his YouTube channel: 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 program for free and get a developer job: https://www.freecodecamp.org

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

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.