Data Analysis
Collect, clean and analyse data with spreadsheets and Python so you can answer business questions.
SQL training
Write SQL queries to retrieve, filter, join and summarise data stored in relational databases.
Course overview
Learn to speak to databases. You will write queries to find, filter, combine and summarise data, then move on to designing tables and keeping data accurate.
Requirements
- A computer
- Basic computer skills
- No prior database experience needed
What you will learn
- Write SELECT queries with filters and sorting
- Join data across tables
- Summarise data with aggregate functions
- Create and modify tables
Practical projects
- Query a sales database
- Design a small student or inventory database
Skills you will gain
- SQL queries
- Joins
- Aggregation
- Database design basics
- Data manipulation
Career and application opportunities
- Data analyst
- Database support
- Backend developer (with programming)
- Reporting roles
Curriculum
1Introduction to databases
- What databases are
- Tables, rows and columns
- Relational concepts
- Setting up MySQL
2Querying data
- SELECT and FROM
- Filtering with WHERE
- Sorting and limiting
- Working with text, numbers and dates
3Combining and summarising
- Joins
- Aggregate functions
- GROUP BY and HAVING
- Subqueries
4Changing data
- INSERT, UPDATE and DELETE
- Creating tables
- Keys and constraints
- Indexes basics
5Designing and using databases
- Database design
- Normalisation basics
- Views
- Capstone project
Related courses
Data Science
Combine programming, statistics and visualisation to turn raw data into insight and predictions.
Database Management
Learn to design, build, secure and maintain databases that applications depend on.