In this module you will be introduced to the concept of a relational database, the SELECT statement and showcase the types of data you will encounter in a database:

• Understanding the language databases use
• How a relational database functions
• Data types
• Relational database management systems (RDBMSs)
• SQLite 

In this module you will become familiar with the resources intended to be used in conjunction with this course, as well as the many exercises and self-assessment questions that will help you test your SQL knowledge:

• Setting up our SQL environment
• The sTunes database
• DB Browser for SQLite
• Self-assessments
• SQL learning strategies 

In this module, we will familiarize ourselves with the interface of our chosen SQL browser for SQLite: DB Browser:

• Launching the SQL software
• Opening a database file
• The Database Structure tab
• The Browse Data tab
• The Execute SQL tab

In this module you will cover the basics of writing a good query and formatting the results. By the end of this module you will be able to select individual fields from a specific database and display those fields in alphabetical order:

• Query notation techniques
• SQL query basics
• Using an alias
• Sorting results alphabetically
• Limiting query results 

Learn how SQL provides some tools that not only allow you to narrow down your result set (that is, the results of your query) to very specific data, but also to order and filter your data by user-specified conditions:

• Operators in SQL
• The WHERE clause
• Searching for text using wildcard values
• The DATE()

In this module you will learn to access data from multiple tables simultaneously. You become comfortable obtaining data from two or more tables with a single query by using powerful tools called joins: 

• Introducing joins
• Joins and relational database structure
• Joins and aliases
• Inner join, left outer join, and right outer

In this module you will learn how to simplify your calculations by using functions:

• Adding calculations to your queries
• Types of functions in SQL
• String functions
• Date functions
• Aggregate functions

In this chapter you'll learn about Subqueries and how to use them as an alternate method of simultaneously accessing data from more than one table: 

• Subqueries and aggregate functions
• SELECT statement subqueries
• WHERE clause subqueries
• Subqueries without aggregate functions
• Returning multiple values

A fun gamified group project where you use what you've learned in the course to solve a crime with your data analytics skills.