Home Microsoft SQL Server Training CoursesSQL Fundamentals – Part 1: Essential Querying Skills

SQL Fundamentals – Part 1: Essential Querying Skills

Guaranteed to Run
Price
$695.00
Duration
1 Day
Delivery Methods
Virtual Instructor Led Private Group
Delivery
Virtual
EST
Description
Objectives
Prerequisites
Content
Course Description

Over 70% of business decision-makers say their teams struggle with data access—most don’t know how to use SQL effectively. This one-day beginner-level training course provides a hands-on introduction to SQL fundamentals using Microsoft SQL Server.

You’ll learn SQL from the ground up, gaining the skills to write queries, filter and sort results, combine data from multiple tables, and manipulate output for analysis or reporting. Real-world exercises guide you through every step so you can confidently retrieve information from a relational database.

Course Objectives

After completing this course, you’ll be equipped to use SQL to extract and manipulate data from relational databases. You'll gain practical experience writing queries, formatting results, and applying functions using SQL Server.

  • Run basic SQL statements to retrieve data
  • Apply conditions and logical filters using WHERE clauses
  • Use string, numeric, and date functions for calculated results
  • Organize and group query output
  • Join tables and identify missing or unmatched records
Who Should Attend?

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Course Prerequisites
  • Basic computer literacy
  • Basic PC operating system navigation skills
  • Basic Internet usage skills
Course Content
Module 1: Executing Basic SQL Statements
Module 2: Filtering with Conditional Logic
Module 3: Using Built-In SQL Functions
Module 4: Structuring and Summarizing Output
Module 5: Working Across Tables
Module 6: Exporting Results and Creating Reports
Do You Need Help? Please Fill Out The Form Below
First Name*
Last Name*
Business Email*
Phone Number*
What do you need assistance with?*
Best way to contact me*
How can we help you?*