SQL Querying: Fundamentals

Request more details:

submit request
Description:
Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.
Prerequisites:
Basic end-user computer skills and some familiarity with database terminology and structure are required.
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.
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