Master the standard language for relational database management systems. Explore core concepts, terminologies, and powerful commands for data manipulation and definition.
Get started with SQL. Understand databases, the ecosystem, terminologies, and different types of databases (Relational vs NoSQL).
Deep dive into Data Query Language (SELECT, Filtering, Sorting) and Data Definition Language (Create, Alter, Drop, Truncate).
Master the art of joining tables (Inner, Left, Right, Full) and combining result sets with UNION and INTERSECT.
Perform operations on individual data items. String manipulation, Date/Time calculations, and Mathematical operations.
Summarize data with Aggregate functions (SUM, AVG, COUNT) and perform advanced analysis with Window functions.