Virtual Live Instructor
Free Training Manual
Free Repeat
Course Details
Course Description:
The SQL Querying: Fundamentals course is a 1-day entry-level course that is designed to teach students how to use core SQL commands to access date from a SQL Database.
Topics covered in the course include:
- Connecting to a SQL Server database and executing a simple query
- Including a search condition in a simple query
- Using various functions to perform calculations on data
- Organizing the data obtained from a query before it is displayed on-screen
- Retrieving data from multiple tables
Target Student:This course is designed for students with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Students should possess the following experience before attending the course:
- Some knowledge of database terminology and structure is helpful, but not required.
Section 1: Executing a Simple Query
Connecting to the SQL Database
Querying a Database
Saving a Query
Modifying and Executing a Saved Query
Section 2: Performing a Conditional Search
Search Using One or More Conditions
Searching for a Range of Values and NULL Values
Searching Data Based on Patterns
Section 3: Working with Functions
Performing Date Calculations
Calculating Data Using Aggregate Functions
Manipulating String Values
Section 4: Organizing Data
Sorting Data
Ranking Data
Grouping Data
Filtering Grouped Data
Summarizing Grouped Data
Using PIVOT and UNPIVOT Operators
Section 5: Retrieving Data from Multiple Tables
Combining the Results of Two Queries
Comparing the Results of Two Queries
Retrieving Data by Joining Tables
Please check the course description to find prerequisite information.
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
- Experienced Professional Instructor Trains Your Team
- Content Focused On Your Team's Needs
- Convenient Scheduling and Class Setup
- Significant Per/Student Cost Savings
- Online, On-Site and Blended Options Available
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Public Class Schedule
Instructor led training is a cost effective and convenient learning platform for busy professionals. Most courses are available at over 300 locations nationwide and Online.
The classes are taught via the RCI method by professionally certified instructors, and are usually limited to 12 or less students. Each student receives a training manual and practice problems, along with a free course retake. Click here to learn more about Instructor Led Training
Below is a list of upcoming Sqlserver Instructor Led Class Dates:
Location: Available Nationwide and Online
Class Date(s): 12/6/2024 - 12/6/2024
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 12/27/2024 - 12/27/2024
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 1/17/2025 - 1/17/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 2/3/2025 - 2/3/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 2/21/2025 - 2/21/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 3/21/2025 - 3/21/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 4/11/2025 - 4/11/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 5/2/2025 - 5/2/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 5/27/2025 - 5/27/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 6/13/2025 - 6/13/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 7/3/2025 - 7/3/2025
Course Fee : $395
Location: Available Nationwide and Online
Class Date(s): 7/21/2025 - 7/21/2025
Course Fee : $395
We offer private SQL Server group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how SQL Server Private Group Training from Business Computer Skills can help your team.
