Log On/Register  

855.838.5028

SQL Querying Fundamentals

Duration: 1 Day
Course Price: $495

This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

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.

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.

 

This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

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.

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.

 

Basic Computer Knowledge

COURSE OUTLINE

1 - EXECUTING A SIMPLE QUERY

Connect to the SQL Database Query a Database Save a Query Modify and Execute a Saved Query

2 - PERFORMING A CONDITIONAL SEARCH

Search Using One or More Conditions Search for a Range of Values and NULL Values Search Data Based on Patterns

3 - WORKING WITH FUNCTIONS

Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values

4 - ORGANIZING DATA

Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators

5 - RETRIEVING DATA FROM MULTIPLE TABLES

Combine the Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables

6 - EXPORTING QUERY RESULTS

Generate a Text File Generate an XML File

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):

The PMI logo is a registered mark of the Project Management Institute, Inc.