SQL Tutorial for Beginners (and Technical Interview Questions Solved)
Welcome to this comprehensive SQL tutorial course. This course covers the basics of relational databases and SQL, including setting up MySQL, inserting data, and working with aggregation, grouping, and pagination in SQL queries. It also covers advanced topics such as combining tables using joins, executing SQL queries using Python and SQL Alchemy, and solving technical interview questions. By the end of this course, you'll have the knowledge and confidence to excel in SQL.
✏️ Course created by@jovianhq
Important Links
🔗 Relational Databases notebook - https://jovian.com/aakashns/relational-databases-and-sql
🔗 Advanced SQL Aggregation & Joins notebook - https://jovian.com/aakashns/advanced-sql-aggregation-and-joins
🔗 SQL data file: https://raw.githubusercontent.com/harsha547/ClassicModels-Database-Queries/master/database.sql
A database is an organized collection of structured information, typically stored in the form of tables (rows & columns). Relational databases allow storing and retrieving different kinds of related information e.g. products, customers, and orders for an online shopping site. Structured Query Language or SQL (pronounced "sequel") is the most widely used language for interacting with relational databases, and is an essential skill for Data Science professionals.
⭐️ Contents ⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:01:28) Relational Databases & SQL
⌨️ (0:03:05) Setting up MySQL
⌨️ (0:29:23) Inserting Data into the Table
⌨️ (0:56:32) Practice Exercises
⌨️ (1:22:12) Aggregation, grouping & pagination in SQL queries
⌨️ (2:23:17) Mapping and Arithmetic Functions
⌨️ (2:54:53) Working with Dates
⌨️ (3:12:16) Combining Tables using Joins
⌨️ (3:30:14) Executing SQL queries using Python and SQL Alchemy
⌨️ (4:11:06) 3 step approach to Interview Questions
⌨️ (4:36:58) Interview Q - Apple
⌨️ (4:38:59) Interview Q - Linkedin
⌨️ (4:43:09) Interview Q - Meta
⌨️ (4:50:41) Interview Q - Uber
⌨️ (4:59:18) Interview Q - Amazon
⌨️ (5:07:27) Interview Q - Google
🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
Видео SQL Tutorial for Beginners (and Technical Interview Questions Solved) канала freeCodeCamp.org
✏️ Course created by@jovianhq
Important Links
🔗 Relational Databases notebook - https://jovian.com/aakashns/relational-databases-and-sql
🔗 Advanced SQL Aggregation & Joins notebook - https://jovian.com/aakashns/advanced-sql-aggregation-and-joins
🔗 SQL data file: https://raw.githubusercontent.com/harsha547/ClassicModels-Database-Queries/master/database.sql
A database is an organized collection of structured information, typically stored in the form of tables (rows & columns). Relational databases allow storing and retrieving different kinds of related information e.g. products, customers, and orders for an online shopping site. Structured Query Language or SQL (pronounced "sequel") is the most widely used language for interacting with relational databases, and is an essential skill for Data Science professionals.
⭐️ Contents ⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:01:28) Relational Databases & SQL
⌨️ (0:03:05) Setting up MySQL
⌨️ (0:29:23) Inserting Data into the Table
⌨️ (0:56:32) Practice Exercises
⌨️ (1:22:12) Aggregation, grouping & pagination in SQL queries
⌨️ (2:23:17) Mapping and Arithmetic Functions
⌨️ (2:54:53) Working with Dates
⌨️ (3:12:16) Combining Tables using Joins
⌨️ (3:30:14) Executing SQL queries using Python and SQL Alchemy
⌨️ (4:11:06) 3 step approach to Interview Questions
⌨️ (4:36:58) Interview Q - Apple
⌨️ (4:38:59) Interview Q - Linkedin
⌨️ (4:43:09) Interview Q - Meta
⌨️ (4:50:41) Interview Q - Uber
⌨️ (4:59:18) Interview Q - Amazon
⌨️ (5:07:27) Interview Q - Google
🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan
--
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
Видео SQL Tutorial for Beginners (and Technical Interview Questions Solved) канала freeCodeCamp.org
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MLOps Course – Build Machine Learning Production Grade ProjectsBuild and Deploy an Instagram Clone with React and Firebase – TutorialAPI Documentation Best Practices – Full CourseAdvanced Music Production with FL Studio – TutorialAWS Cloud Complete Bootcamp CourseArduino Course for EverybodyNext.js Authentication - AuthJS / NextAuth for Role-Based SecurityCreate a Large Language Model from Scratch with Python – TutorialCalming Web Development – Colored MarkersAdvanced C# Programming CoursePointers in C for Absolute Beginners – Full CourseLearn Rust Programming - Complete Course 🦀Deep Learning for Computer Vision with Python and TensorFlow – Complete CourseNeo4j Course for BeginnersBuild AI Apps with ChatGPT, DALL-E, and GPT-4 – Full Course for BeginnersDjango ChatGPT Clone TutorialFull-Stack Next.js, TypeScript, and AWS Course – Code a Quote GeneratorUse ChatGPT to Code a Full Stack App – Full CourseJavaScript Security Vulnerabilities Tutorial – With Code ExamplesGo Programming – Golang Course with Bonus Projects