SQL Tutorial - Full Database Course for Beginners
In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. 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
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Видео SQL Tutorial - Full Database Course for Beginners канала freeCodeCamp.org
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
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
Видео SQL Tutorial - Full Database Course for Beginners канала freeCodeCamp.org
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MySQL Tutorial for Beginners [Full Course]Fastest way to become a software developerWhat is SQL? [in 4 minutes for beginners]The first 20 hours -- how to learn anything | Josh Kaufman | TEDxCSUDay in the Life of a Japanese Game ProgrammerIQ15: 6 SQL Query Interview QuestionsLearn Python - Full Course for Beginners [Tutorial]Google Coding Interview With A High School StudentPython for Everybody - Full University Python CourseWhat is Database & SQL?Learn SQL in 1 Hour - SQL Basics for BeginnersHTML Full Course - Build a Website TutorialSQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | EdurekaHow To Install MySQL on Windows 10How to Become an SQL Developer in 2020Learn SQL In 60 MinutesExcel VBA Beginner TutorialSQL Joins Tutorial for Beginners - Inner Join, Left Join, Right Join, Full Outer JoinAPIs for Beginners - How to use an API (Full Course / Tutorial)