ThoughtSpot acquires Mode to define the next generation of collaborative BI >>Learn More
Learn to answer questions with data using SQL. No coding experience necessary.
Basic SQL
- IntroductionThe SQL Tutorial for Data AnalysisLearn to answer questions with data to solve challenging problems.Start Now
- Lesson 1Using SQL in ModeLearn to use Mode's Query Editor to run SQL queries against data in a relational database.Start Now
- Lesson 2SQL SELECTThe SQL SELECT statement is used to retrieve data from a database based on criteria specified in the query.Start Now
- Lesson 3SQL LIMITUse the SQL LIMIT command to restrict how many rows a SQL query returns.Start Now
- Lesson 4SQL WHEREUse the SQL WHERE clause to filter data.Start Now
- Lesson 5SQL Comparison OperatorsUse SQL comparison operators like =, <, and, > to filter numerical and non-numerical data.Start Now
- Lesson 6SQL Logical OperatorsSQL logical operators allow you to filter results using several conditions at once.Start Now
- Lesson 7SQL LIKEAn introduction to the LIKE operator, which matches similar values.Start Now
- Lesson 8SQL INUse the SQL IN operator in the WHERE clause to filter data by a list of values.Start Now
- Lesson 9SQL BETWEENUse the SQL BETWEEN operator to select values from a specific range.Start Now
- Lesson 10SQL IS NULLUse SQL's IS NULL operator to select rows that have no data in a given column.Start Now
- Lesson 11SQL ANDUse the SQL AND operator to select rows that satisfy two or more conditions.Start Now
- Lesson 12SQL ORUse the SQL OR operator to select rows that satisfy either of two conditions.Start Now
- Lesson 13SQL NOTUse the SQL NOT operator to select rows for which a certain conditional statement is false.Start Now
- Lesson 14SQL ORDER BYSee code and examples of using SQL ORDER BY to sort data.Start Now
Intermediate SQL
- IntroductionPutting it togetherAggregate data and join tables for more meaningful analysis across broader data sets.Start Now
- Lesson 1SQL Aggregate FunctionsAggregate data across entire columns using the COUNT, SUM, MIN, MAX, and AVG functions.Start Now
- Lesson 2SQL COUNTUsing SQL COUNT to count the number of rows in a particular column.Start Now
- Lesson 3SQL SUMUse the SQL SUM function to total the numerical values in a particular column.Start Now
- Lesson 4SQL MIN/MAXSee examples using the SQL MIN and MAX functions to select the highest and lowest values in a particular column.Start Now
- Lesson 5SQL AVGUsing the SQL AVG function to select the average of a selected group of values.Start Now
- Lesson 6SQL GROUP BYUse the GROUP BY clause to separate data into groupsStart Now
- Lesson 7SQL HAVINGUse the SQL HAVING clause to filter an aggregated query.Start Now
- Lesson 8SQL CASEUsing if/then logic with the SQL CASE statement.Start Now
- Lesson 9SQL DISTINCTUsing SQL DISTINCT to view and aggregate unique values in a given column.Start Now
- Lesson 10SQL JoinsAn introduction to SQL joins and the relational logic behind them.Start Now
- Lesson 11SQL INNER JOINUse a SQL INNER JOIN to select rows that satisfy a join statement and eliminate rows that don't.Start Now
- Lesson 12SQL Outer JoinsThis lesson of the SQL tutorial for data analysis introduces the concept of outer joins.Start Now
- Lesson 13SQL LEFT JOINSee code and examples for LEFT JOIN.Start Now
- Lesson 14SQL RIGHT JOINSee code and examples for RIGHT JOIN.Start Now
- Lesson 15SQL Joins Using WHERE or ONLearn the differences between filtering joined data using WHERE or ONStart Now
- Lesson 16SQL FULL OUTER JOINLearn about SQL FULL OUTER JOIN, which returns unmatched rows from both tables being joined.Start Now
- Lesson 17SQL UNIONUNION allows you to stack one dataset on top of another dataset.Start Now
- Lesson 18SQL Joins with Comparison OperatorsUse comparison operators with SQL joins, which is especially helpful for defining date ranges.Start Now
- Lesson 19SQL Joins on Multiple KeysLearn to join tables on multiple keys to boost performance and make SQL queries run faster.Start Now
- Lesson 20SQL Self JoinsLearn the situations where you might want to join a table to itself, and how to do so.Start Now
Advanced SQL
- IntroductionLeveling upLearn advanced SQL to take your analysis to the next levelStart Now
- Lesson 1SQL Data TypesLearn about SQL data types and how to change a column's data type using CONVERT and CAST.Start Now
- Lesson 2SQL Date FormatLearn how dates and times are formatted in SQL, and best practices for interacting with them.Start Now
- Lesson 3Data Wrangling with SQLProgrammatically transform data into a format that makes it easier to work with.Start Now
- Lesson 4Using SQL String Functions to Clean DataUse SQL string functions to clean data strings and fix date formats.Start Now
- Lesson 5Writing Subqueries in SQLUse subqueries in SQL with aggregate functions, conditional logic, and joins.Start Now
- Lesson 6SQL Window FunctionsLearn about SQL windowing functions such as ROW_NUMBER(), NTILE, LAG, and LEAD.Start Now
- Lesson 7Performance Tuning SQL QueriesLearn how to conduct SQL performance tuning by reducing table size, simplifying joins, and the EXPLAIN command.Start Now
- Lesson 8Pivoting Data in SQLLearn to pivot rows to columns and columns to rows in SQL.Start Now
SQL Analytics Training
- IntroductionAbout Analytics TrainingHone your analytical skills by solving real-world cases from analytics teams at data-driven companies.Start Now
- Lesson 1Investigating a Drop in User EngagementInvestigating a drop in user engagement with your product.Start Now
- Lesson 2Investigating a Drop in User Engagement: AnswersThe answer to the problem of investigating a drop in user engagement with your product.Start Now
- Lesson 3Understanding Search FunctionalityHow to understand in-product search functionality.Start Now
- Lesson 4Understanding Search Functionality: AnswersAnswers how to understand in-product search functionality and if it's worth investing in.Start Now
- Lesson 5Validating A/B Test ResultsHow to validate A/B testing results.Start Now
- Lesson 6Validating A/B Test Results: AnswersAnswers how to validate A/B testing results.Start Now
- Lesson 7SQL Tutorial ConclusionYou're more than ready to apply your skills to real analytical problems. On to the next step.Start Now
LIVE WEEKLY GROUP DEMO
Get to know Mode
Get a firsthand look at how Mode helps data teams deliver high-impact ad hoc analysis and self-service reporting in one platform.
Get more from your data
Your team can be up and running in 30 minutes or less.
