Information Technology
SQL Querying Fundamentals – Part 1
This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.
1 Day
8 Hrs
6 Lessons
Course Objectives
In this course, you will compose SQL queries to retrieve desired information from a database. You will:
- Connect to the SQL Server database and execute a simple query. Include a search condition in a simple query. Use various functions to perform calculations on data. Organize the data obtained from a query before it is displayed on
- screen. Retrieve data from multiple tables. Export the results of a query.
Agenda
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify and Execute a Saved Query
- Search Using One or More Conditions
- Search for a Range of Values and NULL Values
- Search 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 the Results of Two Queries
- Compare the Results of Two Queries
- Retrieve Data by Joining Tables
- Generate a Text File
- Generate an XML File
FREE
Interested in course?
Course Type: Instructor Led