Master the essential skills of SQL querying to unlock robust data insights, perfect for database managers and IT professionals seeking to enhance their data analysis capabilities.
Connect to SQL Server and execute queries.
Perform complex data retrieval using functions and conditions.
Organize and present data efficiently.
Generate reports and save query outcomes.
In Fundamentals of SQL Querying, students will compose SQL queries to retrieve desired information from a database.
No upcoming dates. Please check back later.
Connect to the SQL Database
Query a Database
Save a Query
Modify a Query
Execute a Saved Query
Search Using a Simple Condition
Compare Column Values
Search Using Multiple Conditions
Search for a Range of Values and Null Values
Retrieve Data Based on Patterns
Perform Date Calculations
Calculate Data Using Aggregate Functions
Manipulate String Values
Sort Data
Rank Data
Group Data
Filter Grouped Data
Summarize Grouped Data
Use PIVOT and UNPIVOT Operators
Combine Results of Two Queries
Compare the Results of Two Queries
Retrieve Data by Joining Tables
Check for Unmatched Records
Retrieve Information from a Single Table Using Joins
Save the Query Result
Generate an XML Report
Your team deserves training as unique as they are.
Let us tailor the course to your needs at no extra cost.
Trusted by Engineers at:
and more...
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier
Aaron Steele
Casey Pense
Chris Tsantiris
Javier Martin
Justin Gilley
Kathy Le
Kelson Smith
Oussama Azzam
Pascal Rodmacq
Randall Granier