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 -
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 operations, aggregation, nested queries, joins, keys and much more.
You can get PopSQL to follow along here:
🔗Company Database Code:
⭐️ 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:
🐦Follow Mike on Twitter:
🔗The Giraffe Academy website:
--
Learn to code for free and get a developer job:
Read hundreds of articles on programming:
1 view
101
24
7 months ago 01:28:06 1
#002 Django СТРИМ 🔴 Рабочее окружение Backend разработчика + необходимые знания
7 months ago 02:37:26 1
Linux сервер для Django проекта (Nginx, gunicorn, PostgreSQL) + простой CI/CD 🔴 #008 Django СТРИМ
7 months ago 04:19:34 40
Learn PostgreSQL Tutorial - Full Course for Beginners
7 months ago 04:52:51 1
Artificial Intelligence Full Course | Artificial Intelligence Tutorial for Beginners | Edureka
7 months ago 00:59:12 24
face-to-many comfyui pinokio (PS2 Graphics) tutorial + more
8 months ago 03:10:25 1
СУБД для начинающих - Windows-приложение на C# c базой данных в MySQL - туториал на русском
8 months ago 00:09:34 1
C# MongoDB Beginner’s Guide: How To Update Documents