COURSE OBJECTIVE:
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.
•
Organise the data obtained from a query before it is displayed on-screen.
•
Retrieve data from multiple tables.
•
Export the results of a query.
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 PREREQUISITES:
Basic end-user computer skills and some familiarity with database terminology and structure are required.
COURSE CONTENT:
Executing a Simple Query
•
Connect to a SQL Database
•
Query a Database
•
Save a Query
•
Modify and Execute a Query
Performing a Conditional Search
•
Search using one or more Conditions
•
Search for a Range of Values and Null Values
•
Retrieve Data based on Patterns
Working with Functions
•
Perform Data Calculations
•
Calculate Data using Aggregate Functions
•
Manipulate String Values
Organising Data
•
Sort Data
•
Rank Data
•
Group Data
•
Filter Grouped Data
•
Summarise Grouped Data
•
Use PIVOT and UNPIVOT Operators
Retrieving Data From Tables
•
Combine Results of Two Queries
•
Compare Results of Two Queries
•
Retrieve Data by Joining Tables
Exporting Query Results
•
Generate a Text File
•
Generate an XML File
FOLLOW ON COURSES:
Not available. Please contact.