SQL for Data Analysis Bootcamp

Batch Price From £500 (approx. $670 USD) View Dates & Prices SQL for Data Analysis Bootcamp

Total Duration: 20-Hour
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.

Requirements

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

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Time Zone:

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.

Course Content

Understanding Databases and DBMS
- Database and DBMS
- Introduction to MS SQL Server
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
Filtering Data
- Using WHERE for filtering
- Using the NOT operator
- Using the LIKE operator
- Using IS NULL and IS NOT NULL
Sorting Data Using ORDER BY
- Sorting Data
- Sorting by Multiple Columns
- Specifying Sort Direction
Using Functions
- LEFT and Right
- MONTH
- YEAR
- DAY
Combining multiple SELECT Results
- UNION
- UNION ALL
Creating and Using Views
- Introduction of Views
- Creating Views using SQL
Built-In Functions
- Introduction to Built-In Functions
- Using System Functions
- Conversion Functions - CAST and CONVERT
- Using Mathematical functions
- Using String Functions
Date and Time Functions
- GETDATE
- DATEADD
- DATEDIFF
- DATENAME
- DATEPART
- DAY, MONTH and YEAR
- Using CONVERT to format a date/time
Subqueries
- Introduction of Subqueries
- Subqueries vs Joining Tables
- Subqueries with Comparison Operators
- Subqueries with IN and NOT IN Operators
Multi-Table Queries
- Joining Tables
- INNER JOIN
- INNER JOIN with more than two Tables
- OUTER JOIN
Aggregate Functions and Group by Extensions
- COUNT, SUM, AVG, MIN, MAX
- Grouping by fields
- Using HAVING to filter results
- Using CASE with aggregate functions
Windowing
- Ranking Functions
- ROW_NUMBER
- RANK and DENSE_RANK
Common Table Expressions (CTE)
- Introduction to CTE
- Non-Recursive CTE
- Recursive CTE
- When to use CTEs, and When not to
Temporary Tables and Table Variables
- Using temporary tables
- Creating table variables
User-Defined Functions - UDFs
- Introduction to UDFs
- Creating a Scalar-Valued Function
Stored Procedures
- Introduction to Stored Procedures
- Creating User Stored Procedures
- Stored Procedure with Parameters
Creating reports using SSRS
- Introduction to SSRS
- Create a new SSRS Project
- Create a report
- Grouping data in report
- Exporting report

Share This Course

Newsletter Sign-up

First Name

Last Name

Email address

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT

Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom

UK: +44 (0)208 432 6218
USA: +1 610-234-7870
CANADA: +1 416-900-1211

WhatsApp: +44 0749 461 6045