SQL basics for data science

Introduction to SQL and data science

Introduces SQL, relational databases and the role of SQL in data science and data analytics.

Database fundamentals

Provides a foundation in database concepts and structures used when working with SQL.

SQL data types and database structure

Introduces common SQL data types and how data is structured within relational databases.

Basic SQL queries

Teaches learners how to retrieve information from databases using fundamental SQL queries.

Filtering and sorting data

Develops skills for finding specific information and organising query results.

SQL functions and data transformation

Introduces built-in SQL functions used to transform and analyse data.

Aggregation and data summarisation

Teaches learners how to summarise large datasets and generate useful analytical information.

SQL joins and relational data analysis

Develops practical skills for combining information from multiple related tables.

Subqueries and advanced querying

Introduces techniques for writing more powerful queries and solving complex data analysis problems.

Teaches learners how to identify and correct common data quality problems using SQL.

Common table expressions and views

Introduces reusable SQL structures that simplify complex analysis and data workflows.

Data modification and database management

Introduces basic SQL commands for adding, modifying and removing data.

SQL for exploratory data analysis

Applies SQL techniques to explore datasets and identify patterns, trends and relationships.

SQL for business and data analytics

Demonstrates how SQL can be used to solve practical business and analytical problems.

SQL with Python and data science tools

Introduces the integration of SQL with Python and other data science workflows.

SQL performance and best practices

Introduces techniques for writing efficient, readable and maintainable SQL queries.

Data security and responsible database use

Covers essential security and ethical practices when accessing and analysing data.

Final SQL data science project

Allows learners to apply their SQL skills to a complete practical data analysis project