In this course, you will explore Structured Query Language (SQL), mastering its core concepts through hands-on projects.
You’ll start with fundamental SQL queries like SELECT query, SQL WHERE, etc. and gradually progress to using SQL DISTINCT, SQL GROUP BY, SQL ORDER BY, and SQL aggregate functions. You'll learn how to create and manage tables, compute new fields, and optimize data relationships using foreign keys.
By the end, you will be adept at using SQL joins, SQL subqueries, and merging techniques to generate comprehensive reports.
In this course, you will explore Structured Query Language (SQL), mastering its core concepts through hands-on projects.
You’l...Show More
WHAT YOU'LL LEARN
An understanding of the declarative nature of SQL and its core principles
The ability to formulate SQL queries using SELECT query, SQL WHERE, and SQL DISTINCT
Hands-on experience building queries with SQL GROUP BY, SQL ORDER BY, and SQL aggregate functions to uncover crucial information
The ability to create, update, and delete data within tables
The ability to extract and manipulate data across multiple tables using SQL joins and SQL subqueries
An understanding of the declarative nature of SQL and its core principles
Show more
TAKEAWAY SKILLS
Content
1.
Introduction to SQL
2 Lessons
In this chapter, you’ll learn SQL queries and the SELECT query in an introduction to SQL, and how to interact with a relational database.
2.
SQL SELECT
2 Lessons
In this chapter, you’ll master SQL SELECT and SQL DISTINCT to eliminate duplicates, ensuring you retrieve accurate and unique data from your database.
3.
SQL Queries: SELECT, WHERE, AND, OR, NOT, and Strings
3 Lessons
In this chapter, learn to filter data using SQL SELECT WHERE, handle SQL Strings, and combine conditions with SQL AND, SQL OR, SQL NOT for query results.
4.
SQL ORDER BY, Aggregate functions, and GROUP BY
3 Lessons
In this chapter, learn data sorting with SQL ORDER BY, perform calculations using SQL aggregate functions, and organize query results with SQL GROUP BY.
5.
SQL CREATE, DESCRIBE, INSERT INTO, UPDATE and DELETE Tables
3 Lessons
In this chapter, create tables with SQL CREATE TABLE, add data using SQL INSERT INTO, modify records with SQL UPDATE, and remove them using SQL DELETE.
6.
SQL Alter Table and Aliases
5 Lessons
In this chapter, modify database structures using SQL ALTER TABLE and simplify query readability with SQL aliases for table and column names.
7.
Data Redundancy
4 Lessons
In this chapter, minimize data redundancy by using SQL foreign keys to establish relationships between tables to ensure data integrity and management.
8.
SQL Joins and Subqueries
5 Lessons
In this chapter, learn SQL joins and subqueries to retrieve related data, while understanding the implications of the SQL cartesian product in queries.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Developed by MAANG Engineers
Trusted by 2.8 million developers working at companies
"These are high-quality courses. Trust me the price is worth it for the content quality. Educative came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"
Anthony Walker
@_webarchitect_
"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"
Evan Dunbar
ML Engineer
"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."
Software Developer
Carlos Matias La Borde
"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"
Souvik Kundu
Front-end Developer
"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."
Vinay Krishnaiah
Software Developer
Hands-on Learning Powered by AI
See how Educative uses AI to make your learning more immersive than ever before.
AI Prompt
Code Feedback
Explain with AI
AI Code Mentor
Free Resources
