This course aims to teach the basics of relational databases and SQL, covering topics such as setting up MySQL, data insertion, aggregation, grouping, pagination, joins, executing SQL queries using Python and SQL Alchemy, and solving technical interview questions. The course is designed for beginners looking to gain proficiency in SQL and excel in technical interviews.
Overview
Syllabus
⌨️ Introduction
⌨️ Relational Databases & SQL
⌨️ Setting up MySQL
⌨️ Inserting Data into the Table
⌨️ Practice Exercises
⌨️ Aggregation, grouping & pagination in SQL queries
⌨️ Mapping and Arithmetic Functions
⌨️ Working with Dates
⌨️ Combining Tables using Joins
⌨️ Executing SQL queries using Python and SQL Alchemy
⌨️ 3 step approach to Interview Questions
⌨️ Interview Q - Apple
⌨️ Interview Q - Linkedin
⌨️ Interview Q - Meta
⌨️ Interview Q - Uber
⌨️ Interview Q - Amazon
⌨️ Interview Q - Google
Taught by
freeCodeCamp.org
