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

⭐️ Contents ⭐
⌨️ (0:00) Introduction
⌨️ (2:36) What is a Database?
⌨️ (23:10) Tables \u0026 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 \u0026 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
freeCodeCamp.org : Click the "JOIN" button below the video to support freeCodeCamp.org!
Sahil Pawar : who are these 1k people who disliked this video. The guy is teaching an entire language in 4hrs for free what the heck do you want?????
AMAL P B : (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) FR Diagrams Intro
(3:55:53) Designing an ER Diagram
(4:08:34) Converting ER Diagrams to Schemas
Lil Nas D : Two weeks ago I started doing this course thinking that it would be useful for my placements and today I'm here to let you know that because of your teaching I actually learnt DBMS and got placed in an MNC .The recruiter asked me about DBMS functions and in particular he asked me about group by function which I otherwise wouldn't have answered . I'm really grateful for you and thank you very much Sir for taking your time to explain DBMS to us.
Sriram Srinivasan : you teach the entire databases course in 4 hours, that is way better and more efficient than my prof who rambles on and i don't get much out of his course for the entire 16 weeks. thanks dude! you're our lifesaver and a silent unsung hero!

Database Tutorial for Beginners

This database tutorial will help beginners understand the basics of database management systems. We use helpful analogies to explain a high-level overview of spreadsheets, tables, and database management systems. The logic and concepts in this tutorial will make it easier to understand the more technical aspects of database architecture and Entity Relationship Diagrams (ERD).

When it comes to organizing data, we often start by compiling everything into a single spreadsheet (or table). But that approach isn't scalable. As more data floods the system, a single table will result in misleading information, duplicate data, and errors.

A better method is to split your data up into smaller tables that have a narrower focus. These tables organize your data in a more efficient way and come together via relationships to form a database. And a database management system is the software that handles the storage, retrieval, and updating of that database.

Database Management Systems are closely related to Entity Relationship Diagrams. If you've spent any time in a database management system, you know that they typically don’t give you the best options for visualizing your database. It’s all in the programming language and it’s hard to see where the connections are. That’s where Entity Relationship Diagrams come in. It’s a visual way of looking at your database structure. Each table translates into an entity. And your columns in each table are listed as attributes in their respective entity. Finally, the programmed connections between your tables are visualized through relationship lines.

Lucidchart is a visual productivity platform that can help you visualize your Database Management System. Our ERD import and export tool make it easy to translate your database into a diagram that helps you spot database errors, find potential improvements, and onboard others to your database.

——

Photos Requiring Attribution:
Cat Leash - by K B - http://bit.ly/2tDSE9a

Learn more and sign up:
http://www.lucidchart.com

Follow us:
Facebook: https://www.facebook.com/lucidchart
Twitter: https://twitter.com/lucidchart
Instagram: https://www.instagram.com/lucidchart
LinkedIn: https://www.linkedin.com/company/lucidsoftware
Lil_ZcrazyG : i didnt even realize that this was an add for lucid chart....... WOW, well played.
tadabae : when an ad is so good that your databases professor requires all the students to watch it
Cherisy Konstanz : Did a commercial just go truly helpful on my ass?
Corne Myburgh : I must say, this is probably the best Database explanation video I've seen out there.
edilgin : best ad i've seen in a while. nicely done

Intro to Databases

See this entire course on the Intro to Databases playlist. https://cbt.gg/2wh3UuW

Ready for the Databases quiz? Take it here. https://cbt.gg/30EOJcV

More and more data is being collected and used. As a result, databases are more important than ever. CBT Nuggets trainer Garth Schulte covers databases and their many benefits.

What are Intro to IT courses?

We all have to start somewhere. Intro to IT courses allow aspiring and seasoned IT pros alike to explore the different corners of the IT career field. These free, open courses are taught at a level anyone can understand by the same great CBT Nuggets trainers.

Here's how it works.

Step 1: Watch this entire course. If you watch the course, then the Intro to Databases quiz will be a breeze.

Step 2: Test your knowledge with the 11-question Intro to Databases quiz. Good luck! https://cbt.gg/30EOJcV

Step 3: Earn the Intro to Databases Certificate of Completion.

Step 4: Continue learning database technologies with CBT Nuggets. https://cbt.gg/2VNxaUt
ReadBeard ! : I really appreciate the "i will assume you know nothing of this"- bc i hate "beginners" course and you have to already know 80% of what they talk about. So, thank you kind sir.
Ummi : I'm just learning about databases to track some statistics for a team in a game I'm playing. Thanks for explaining this so clearly and so simply that even I got it! Now I'm dying to find the link to the Star Wars database tutorial XD Luckily until I find it, I have lots and lots of other content to watch through :D
gamer7234 : Great video!! Right to the point
Don-Dadda : Really needed this!! Thanks Garth!!
Gerhard de Wit : Found this helpful and shared it with co workers. Thanks.

...