•        No prior SQL experience required — this course starts from zero

•        A Windows, Mac, or Linux computer with internet access

•        SQL Server Management Studio (SSMS) or Azure Data Studio - both free to download

•        Access to the CareerSwerve practice databases (provided upon purchase)

•        Willingness to complete hands-on labs and professional challenges in each chapter

SQL Core: Foundations for Data Careers is the first module in the CareerSwerve SQL Series™, a structured, enterprise-aligned pathway designed for professionals who want practical SQL capability, not just theoretical knowledge.

This course gives you immediate access to the complete SQL Core training material, structured for self-paced study. Written by Emmanuel Edegbo (Lead Data Engineer & Architect), the material is built around two real-world practice datasets - SalesLT (a product and customer database) and ComplianceLT (a financial compliance environment), so you learn SQL in context, not in isolation.

Every chapter follows a consistent format: Learning Objectives, concept explanation, syntax reference, worked examples with expected outputs, hands-on labs, professional challenges, and a readiness check. A full cheat sheet is included for ongoing reference.

SQL Core is the industry entry point. Before dashboards are built, models are trained, or reports are signed off, data must be queried correctly. This course builds that foundation.

SQL Core is designed for professionals who want structured, enterprise-ready SQL capability. Whether you are new to SQL or strengthening foundational skills, this pathway guides you from the basics to confident professional application.

•       Aspiring data analysts and business analysts

•       Project managers, product owners, and scrum masters working on data-driven projects

•       Software testers validating backend logic and values displayed on reports

•       Compliance and risk professionals querying structured records

•       Career switchers entering data engineering, data science, or other data roles

•       Cybersecurity analysts and SOC professionals querying log data and reviewing database-level access patterns

•       Software and backend engineers seeking to design, validate, and optimise database interactions

•       Passive learners looking to skim content without practice

•       Individuals seeking shortcuts or instant mastery without repetition

•       Those unwilling to write queries manually

In a world powered by data, SQL remains the universal language used to access, analyse, and validate information across nearly every organisation. From banking systems and retail platforms to healthcare records and cloud analytics environments, SQL sits at the core of how data is retrieved, structured, and interpreted.

Despite the rise of artificial intelligence and new programming tools, SQL remains foundational because before insights are generated or models are built, data must first be queried correctly.

SQL powers enterprise databases, cloud data warehouses, lakehouse platforms, business intelligence tools, reporting systems, and compliance and audit environments. It is not limited to any single platform — it is the common layer beneath them all.

SQL has remained dominant for decades because it is platform-agnostic, widely adopted, transferable across industries, and foundational to analytics and AI. While technologies evolve, SQL persists.

CareerSwerve SQL is not a generic tutorial. It is a structured, career-aligned learning pathway built from real enterprise experience.

Each chapter follows a structured learning sequence. Every concept is introduced in plain language, shown in a formal Syntax box, demonstrated through a worked Example, followed by the Expected Outcome, and then applied in a Hands-On Lab.

•       Read the concept explanation fully before looking at the Syntax box

•       Study the Syntax — understand the structure before the example

•       Work through the Example carefully — trace what each line does

•       Read the Expected Outcome — confirm what the result means in business terms

•       Review the Query Pattern — this is what you will adapt in real work

•       Attempt every lab independently before reviewing model answers

By completing SQL Core, you will:

•       Write clear and effective SELECT queries

•       Filter and sort data using conditional logic

•       Summarise datasets using aggregation and grouping

•       Handle NULL values correctly in filters and calculations

•       Apply scalar functions to format and transform query results

•       Use CASE expressions to categorise and classify data

•       Combine result sets using UNION and UNION ALL

•       Interpret query output in business terms

To complete the exercises in this book, you will need a SQL client tool to connect to the CareerSwerve SQL database hosted on Microsoft Azure SQL Server.

SSMS is Microsoft's official tool for interacting with SQL Server databases. It is available for Windows users only.

Step 1 — Download SSMS

1.      Visit: https://learn.microsoft.com/en-us/ssms/install/install

2.      Click the download button to download the installer

Step 2 — Install

3.      Run the downloaded installer and click Install

4.      Accept the defaults and wait for installation to complete

5.      Restart your machine if prompted

Step 3 — Connect to CareerSwerve Database

6.      Search for 'SSMS' and launch SQL Server Management Studio

7.      Enter the login credentials provided by CareerSwerve and tick 'Remember password'

8.      Click Options and enter the database name provided by CareerSwerve

9.      Click Connect — you should see the database tree appear on the left

Step 4 — Execute Your First Query

10.   Expand Databases > [your database] > Tables

11.   Right-click any table (e.g. SalesLT.Customer) and select 'Select Top 1000 Rows'

12.   SSMS generates the query automatically — in this course you will learn to write this from scratch

DBeaver is a cross-platform database tool supporting Windows, macOS, and Linux. It also supports multiple database systems beyond SQL Server.

Step 1 — Download DBeaver

13.   Visit: https://dbeaver.io/download/

14.   Choose the Community Edition for your operating system

Step 2 — Install DBeaver

15.   Run the installer and click Next

16.   Agree to the Licence Agreement

17.   Accept the defaults and complete the installation

Step 3 — Connect to CareerSwerve Database

18.   Launch DBeaver and click the Connect icon

19.   Select 'Azure SQL Server' as the database type

20.   Enter the connection details provided by CareerSwerve and click 'Test Connection'

21.   Click OK and Finish to save the connection

Step 4 — Execute Your First Query

22.   Expand the server node > Databases > [database] > Schemas > SalesLT > Tables

23.   Right-click any table and select 'View Data' — the data appears on the right

24.   You are ready to start learning SQL

This material is provided strictly for educational and professional development purposes. While every effort has been made to ensure technical accuracy, CareerSwerve and the author assume no responsibility for technical inaccuracies, misinterpretation of content, or outcomes resulting from the application of SQL examples.

SQL examples provided in this material are intended for controlled practice environments only.

Readers are responsible for validating all SQL logic, testing performance implications, ensuring security compliance, confirming data governance standards, and obtaining proper authorisation before running database operations.

This material introduces foundational SQL skills for structured data querying and professional entry into data careers. CareerSwerve materials are designed to build applied SQL competence, strengthen business-aligned data thinking, and support structured career progression.

Certification is awarded based on demonstrated capability, not attendance.

Upon completing this course, you will be able to:

•        Write clear, professional SELECT queries with column aliases and DISTINCT logic

•        Filter datasets using WHERE clauses, comparison operators, IN, BETWEEN, LIKE, and NULL handling

•        Sort and limit results using ORDER BY and SELECT TOP

•        Summarise data using GROUP BY, COUNT, SUM, AVG, MIN, MAX, and HAVING

•        Apply scalar functions including UPPER, LOWER, CONCAT, LEN, ROUND, GETDATE, and CAST

•        Use CASE expressions to classify data and apply conditional logic

•        Combine result sets using UNION and UNION ALL correctly

•        Interpret query output in business terms across real-world scenarios

•        Earn your SQL Core certification upon completion