SQL for Data Analysis Bootcamp

£500
or £42 / month over 12 months with an interest free loan from Knoma

LEARN NOW, PAY LATER!

No interest

Spread the cost of the course, and pay no interest

Up to 12 months

Choose a flexible repayment schedule that works best for you, up to 12 months.

Apply in minutes

Most people can find out if they will be approved within minutes, though it could take up to 48 hours.

Am I eligible?

  • Must be a UK resident
  • Must be 18+ years old
  • Must have a UK bank account

How it works?

  1. Click the Pay with Knoma button to apply for finance.
  2. View the training dates on this page and Enrol if you've not enrolled yet.
  3. Contact us with proof of your finance approval and the invoice number.
SQL for Data Analysis Bootcamp
Total Duration: 20 Hours
Course level: Beginner
Delivery Method: Instructor led online training
Certification: Certificate of Completion will be provided after completing the course

Course Overview

Learning to query databases with SQL is a substantial part of Data Analyst. In this Bootcamp, you’ll learn to use Structured Query Language (SQL) to extract and analyse data stored in databases. You’ll first learn to extract data, join tables together, and perform aggregations. Then you’ll learn to do more complex analysis and manipulations using subqueries, temp tables, and window functions. By the end of the course, you’ll be able to write efficient SQL queries to successfully handle a variety of data analysis tasks.

Skills Required

No prior experience is required. We will start from the very basics.

Course Dates, Prices & Enrolment

There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later.

Full Course Outline

  1. Understanding Databases and DBMS
    • Database and DBMS
    • Introduction to MS SQL Server
  2. Retrieving Data
    • Introduction to the SELECT Statement
    • Retrieving Columns
    • Using DISTINCT to find unique values
    • Concatenating Columns
    • Creating Calculated Field
    • Limiting Results by using TOP Clause
  3. Filtering Data
    • Using WHERE for filtering
    • Using the NOT operator
    • Using the LIKE operator
    • Using IS NULL and IS NOT NULL
  4. Sorting Data Using ORDER BY
    • Sorting Data
    • Sorting by Multiple Columns
    • Specifying Sort Direction
  5. Using Functions
    • LEFT and Right
    • MONTH
    • YEAR
    • DAY
  6. Combining multiple SELECT Results
    • UNION
    • UNION ALL
  7. Creating and Using Views
    • Introduction of Views
    • Creating Views using SQL
  8. Built-In Functions
    • Introduction to Built-In Functions
    • Using System Functions
    • Conversion Functions - CAST and CONVERT
    • Using Mathematical functions
    • Using String Functions
  9. Date and Time Functions
    • GETDATE
    • DATEADD
    • DATEDIFF
    • DATENAME
    • DATEPART
    • DAY, MONTH and YEAR
    • Using CONVERT to format a date/time
  10. Subqueries
    • Introduction of Subqueries
    • Subqueries vs Joining Tables
    • Subqueries with Comparison Operators
    • Subqueries with IN and NOT IN Operators
  11. Multi-Table Queries
    • Joining Tables
    • INNER JOIN
    • INNER JOIN with more than two Tables
    • OUTER JOIN
  12. Aggregate Functions and Group by Extensions
    • COUNT, SUM, AVG, MIN, MAX
    • Grouping by fields
    • Using HAVING to filter results
    • Using CASE with aggregate functions
  13. Windowing
    • Ranking Functions
    • ROW_NUMBER
    • RANK and DENSE_RANK
  14. Common Table Expressions (CTE)
    • Introduction to CTE
    • Non-Recursive CTE
    • Recursive CTE
    • When to use CTEs, and When not to
  15. Temporary Tables and Table Variables
    • Using temporary tables
    • Creating table variables
  16. User-Defined Functions - UDFs
    • Introduction to UDFs
    • Creating a Scalar-Valued Function
  17. Stored Procedures
    • Introduction to Stored Procedures
    • Creating User Stored Procedures
    • Stored Procedure with Parameters
  18. Creating reports using SSRS
    • Introduction to SSRS
    • Create a new SSRS Project
    • Create a report
    • Grouping data in report
    • Exporting report

Newsletter Sign-up

Have a Question?