Course Length: 1 Day
Delivered: Virtually
OVERVIEW:
This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases. This course may earn a Credly Badge.
COURSE PREREQUISITES:
- Windows 8 Transition from Windows 7
- Using Microsoft Windows 8.1
TARGET AUDIENCE:
This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
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.
COURSE CONTENT:
Executing a Simple Query
- Connect to the SQL Database
- Query a Database
- Save a Query
- Modify and Execute a Saved Query
Performing a Conditional Search
- Search Using One or More Conditions
- Search for a Range of Values and NULL Values
- Search Data Based on Patterns
Working with Functions
- Perform Date Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
Organizing Data
- Sort Data
- Rank Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
- Use PIVOT and UNPIVOT Operators
Retrieving Data from Multiple Tables
- Combine the Results of Two Queries
- Compare the Results of Two Queries
- Retrieve Data by Joining Tables
Exporting Query Results
- Generate a Text File
- Generate an XML File
