SQL


Analyzing: Common Metrics You can use this category to discuss the SQL: Analyzing Business Metrics - Common Metrics exercises. Fake Apps In this project you will write queries with aggregate functions to retrieve information from the fake_apps table. SQL: Manipulation Get up and running with SQL by learning commands to manipulate data stored in relational databases. Querying Tables In this project you will practice querying multiple tables using joins. Table Transformation: Set Operations You can use this category to discuss the SQL: Table Transformation - Set Operations exercises. Table Transformation: Date, Number & String You can use this category to discuss the SQL: Table Transformation - Date, Number and String Functions exercises. SQL: Queries Learn the most commonly used SQL commands to query a table in a database. Writing Queries In this project you will write queries to retrieve information from the movies table. Analyzing: Advanced Aggregates You can use this category to discuss the SQL: Analyzing Business Metrics - Advanced Aggregates exercises. SQL: Aggregate Functions Learn how to use SQL to perform calculations during a query. Create Table In this project you will create your own friends table and add and delete data from it. SQL: Multiple Tables Learn how to query multiple tables using joins. Table Transformation: Subqueries You can use this category to discuss the SQL: Table Transformation - Subqueries exercises. Table Transformation: Conditional Aggregates You can use this category to discuss the SQL: Table Transformation - Conditional Aggregates exercises.
About the Learn SQL category [SQL] (2)
Non-Correlated Subqueries III - Why do we need to GROUP BY 1,2,3 instead of just GROUP BY 3? [Table Transformation: Subqueries] (2)
SQL Non-correlated Subqueries III [Table Transformation: Subqueries] (1)
Print all the records having 'The' but not 'The ' [Querying Tables] (3)
Non-Correlated Subqueries II [Querying Tables] (2)
Need some explanation on the significance of 'a' [Table Transformation: Subqueries] (4)
SQL: TABLE Transformation [Table Transformation: Date, Number & String] (5)
How does SQL handle letters like ä,ö,ü [Create Table] (1)
Beginner Problems with SQL [Table Transformation: Subqueries] (8)
Inner Join Issue [Writing Queries] (5)
Explain it's working as well as meaning of `GROUP BY 1,2,3` and `GROUP BY 1,2` and `ORDER BY 1,2` [Table Transformation: Subqueries] (5)
SGL manipulation [Create Table] (6)
Project for sql [SQL: Manipulation] (4)
SQL: Table Transformation 2/7 [Table Transformation: Subqueries] (10)
Help Me Understand Why SELECT(*) Decides Whether and Answer is Right or Wrong [SQL: Aggregate Functions] (3)
Multiple Table- Ledt Join [Querying Tables] (1)
Correlated Subqueries II [Table Transformation: Subqueries] (2)
SQL: Joining Tables [SQL: Multiple Tables] (2)
BEWARE: Concealed Logic in Non-Correlated Subqueries I & II (2-3/7) [Table Transformation: Subqueries] (2)
7/8 Why Not SUM(CASE WHEN....) [Table Transformation: Conditional Aggregates] (3)
Learn sql multiple tables 7 / 10 - cross join [SQL: Multiple Tables] (5)
SQL DEFAULT CONSTRAINT not working [SQL: Manipulation] (2)
9/10: too simple of an execution to learn from [SQL: Multiple Tables] (2)
How do Inner Joins 4/10 [Create Table] (3)
9. ARPU.2 Help? ( 2 ) [Analyzing: Common Metrics] (21)
Need help with "Combining Tables Manually" exercise [SQL: Multiple Tables] (4)
SQL IN Operator [SQL: Queries] (3)
Group By [SQL: Aggregate Functions] (3)
Learn SQL - Aggregate Functions doesn't work [SQL: Aggregate Functions] (4)
About review of completed cource [SQL] (2)