SQL Queries for Analysts

Unlock the power of data analysis with our SQL Queries for Analysts course, designed to equip both seasoned professionals and beginners with essential SQL skills for transforming raw data into actionable insights.

Course Thumbnail

Essential Skills Gained

Checkmark

Design and execute SQL queries for efficient data retrieval and analysis.

Checkmark

Implement complex queries to combine and analyze data from multiple tables.

Checkmark

Understand and utilize advanced SQL functions for data manipulation and transformation.

Checkmark

Master the use of subqueries for in-depth analytical tasks.

Format

  • Instructor-led
  • 4 days with lectures and hands-on labs.

Audience

  • Data Analysts
  • Database Administrators
  • Business Intelligence Professionals
  • IT Specialists

Description

Welcome to the SQL Queries for Analysts course, a comprehensive journey designed to empower you with the expertise in SQL for effective data analysis. As you embark on this educational adventure, you’ll gain a deep understanding of how SQL query writing can transform raw data into actionable insights. This course is meticulously crafted to cater to both experienced professionals and newcomers in the field of data analysis. Regardless of your programming background, you will find the content both accessible and challenging. The curriculum starts with the fundamentals of SQL, using Microsoft SQL as the platform for practical learning. You’ll be guided through a series of progressively complex scenarios, where you’ll learn to construct and refine SQL queries to extract meaningful information from databases. By the conclusion of this course, you will have developed a robust skill set in SQL query writing, equipping you to tackle real-world data analysis challenges with confidence and proficiency. Whether your goal is to enhance your existing database skills or to start a new journey in data analysis, this course will be a pivotal step in your professional development.

Calendar icon

Upcoming Course Dates

July 14-17, 2025

9:00 AM - 4:30 PM

Virtual: Online - US/Eastern

Enroll

$1795

September 9-12, 2025

9:00 AM - 4:30 PM

Virtual: Online - US/Eastern

Enroll

$1795

Course Outline

Download PDF

Introduction

  1. Course Overview

  2. Data Manipulation Verbs

  3. Courseware Overview

  4. Datasets Overview

Overview of SSMS and Query Writing

  1. Working with SSMS

  2. Using the SQL Editor

  3. Creating SSMS Script Projects

  4. Tips and Tricks with SSMS

  5. Adding Comments to Queries

  6. Understanding Batches and Scripts

Database Design Concepts

  1. What is SQL

  2. Database Diagrams

  3. Database Terminology Overview

  4. Lab

  5. Solution to the Exercise

Basic SELECT Statements

  1. The SELECT Statement

  2. Execution Order of SELECT Statements

  3. Ordering Results

  4. Additional SELECT Options

  5. Lab

  6. Answers to Exercises

Working with Data Types

  1. Data Type Precedence

  2. String Related Data Types

  3. Numeric Data Types

  4. Date and Time Data Types

  5. Converting Between Data Types

  6. How to Find Help on Functions

  7. Understanding Data Type Conversion

  8. Lab

  9. Answers to Exercises

Enhanced SELECT Statements

  1. Expressions

  2. Filtering Rows

  3. Comparison Operators

  4. Logical Operators

  5. Lab

  6. Answers to Exercises

Handling NULL Data

  1. NULL vs Blank

  2. = vs IS NULL

  3. ISNULL function

  4. COALESCE

  5. Concatenating NULL Data

  6. Lab

  7. Answers to Exercises

Aggregating and Grouping Data

  1. Aggregate Functions

  2. GROUP BY

  3. HAVING

  4. HAVING vs WHERE

  5. Lab

  6. Answers to Exercises

Joining Multiple Tables

  1. JOINS

  2. INNER JOIN

  3. OUTER JOIN

  4. CROSS JOIN

  5. Joining Three or More Tables

  6. Self-join

  7. Alternate Syntax, Implicit Joins

  8. Set Operations

  9. Working with Multiple Set Operators

  10. Viewing Graphical Execution Plans

  11. Lab

  12. Answers to Exercises

Built-in Functions Overview

  1. Working with Functions

  2. Mathematical Function Overview

  3. String Function Overview

  4. Date Time Function Overview

  5. Nesting Functions

  6. Lab

  7. Answers to Exercises

Subqueries

  1. Subqueries

  2. Nested vs Correlated Subqueries

  3. Subqueries in the SELECT Clause

  4. Subqueries in the WHERE Clause

  5. EXISTS

  6. Subqueries in FROM Clause

  7. Alternatives to Subqueries

  8. Lab

  9. Answers to Exercises

Final Lab

  1. Final Lab Goals

  2. Final Lab Resources

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.