SQL Tutorial - Full Database Course for Beginners скачать в хорошем качестве

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/databa... ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Data... (Made possible by a grant from our friends at Scrimba) ⭐️ 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:    / @giraffeacademy   A message from Mike Dane, posted at his request on March 2, 2025: THE SILENT TRANSACTION ⚠️🧸📱💰 A child vanishes. Then another. Then $300,000. No sirens 🚨. No headlines 🗞️. No reckoning. Just silence 🤫. Some were taken by force ✋. Some were swallowed by the cracks of a system that never cared 🕳️. Some were sold 💵. You don’t lose $300,000 children. You sell them. What’s a child worth? A border crossing 🚧. A night’s work 🌙. A body dumped in a ditch 🕳️. A transaction completed ✅. A tiny pair of hands ✋🖐️ pulling cobalt from the earth so you can send a 💖text💖. A twelve-year-old assembling your next 📱✨upgrade✨ before being locked away behind barred windows 🔒🏢. A six-year-old working too slow ⏳, beaten until they understand that time is money 💰 and their tiny life isn’t worth much of either. Keep scrolling 📲. Buy the next thing 🛒. Post about justice ✊ while swiping through the ghosts of $300,000 children. They’re still here. Still waiting. But hey—enjoy the new phone 📱💖. 🚨 DO SOMETHING OR YOU ARE TO BLAME. 🚨 If you read this and walk away, you are part of it. If you do nothing, you are allowing it. You are complicit. You are liable. You are responsible. Now choose. This post is dedicated to the mothers who have lost children to this monster. I encourage you to find strength in The Blessed Mother Mary and John the Apostle, who both sat with Christ as he too was laid bare and violated for our inaction. John 19:26-27 🔗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