Database Basics with SQL

Description

This toolkit teaches SQL with business questions in mind. Its 14 PDF lessons start with databases and SQL fundamentals and show how to create your first tables.

You learn to retrieve data with SELECT, filter and sort with WHERE, join tables and summarise with GROUP BY. Further lessons cover INSERT, UPDATE and DELETE, constraints, subqueries and views, then transactions, security and indexes for performance. The last lessons work through business scenarios and a first business intelligence report. Exercises appear in most lessons, so the PDFs also work as a reminder when you write queries later.

Who it is for: business professionals and analysts who want to work with company data directly rather than wait for a report.

What’s included
14 PDF lessons · 109 pages · about 29,500 words
One ZIP download that is yours to keep — read on any device, no subscription or app needed.

Course programme

1. Understanding Databases and SQL Fundamentals
2. Creating Your First Database Tables
3. Mastering Data Retrieval with SELECT Statements
4. Filtering and Sorting Data with WHERE
5. Working with Multiple Tables Using JOINs
6. Aggregating Data with GROUP BY and Aggregate Functions
7. Modifying Data with INSERT, UPDATE, and DELETE
8. Ensuring Data Integrity with Constraints
9. Building Complex Queries with Subqueries
10. Creating Views for Reusable Queries
11. Managing Transactions and Database Security
12. Optimizing Performance with Indexes
13. Real-World Business Scenarios and Case Studies
14. Building Your First Business Intelligence Report