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.
Cost: Price on application
Duration: 1 day
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Basic end-user computer skills and some familiarity with database terminology and structure are required.
In this course, you will compose SQL queries to retrieve desired information from a database.
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 :
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