This course runs for a duration of 1 Day.
The class will run daily from 8 AM CT to 4 PM CT.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
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.
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.
Target Student:
Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Module 1: Executing Basic SQL Statements
Connect to a SQL Server database
Create, modify, and execute queries
Save and reopen query files
Module 2: Filtering with Conditional Logic
Limit results using comparison operators
Combine multiple conditions
Search for ranges, NULL values, and patterns
Module 3: Using Built-In SQL Functions
Perform date and time calculations
Manipulate strings and text fields
Calculate summaries with aggregate functions
Module 4: Structuring and Summarizing Output
Sort results and apply custom rankings
Group data and filter grouped rows
Pivot and unpivot results for advanced formatting
Module 5: Working Across Tables
Merge data with inner and outer joins
Identify records without matches
Compare and combine multiple result sets
Module 6: Exporting Results and Creating Reports
Format and save query results
Generate basic XML output
Review common reporting use cases
Basic computer literacy
Basic PC operating system navigation skills
Basic Internet usage skills
Course Comments
This course is the starting point for those who are new to SQL or a good refresher for those who have some knowledge but would like to fine tune their skills.
The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Sybase, etc.
You may also be interested in our Microsoft Querying Class: Writing Analytical Queries for Business Intelligence- Course 55232