SQL Querying Level 1 Fundamentals of Querying
Overview: In this course, students will compose SQL queries to retrieve desired information from a database.
Who Should Attend: Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
At Course Completion: Upon successful completion of this course, students will be able to: - 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 data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report.
Prerequisite(s) or equivalent knowledge: Access 2003 - Level 1, Relational Database, Design A Practical Approach, Windows XP - Level 1 Outline:Lesson 1: Executing a Simple Query-Connect to the SQL Database, Query a Database, Save a Query, Modify a Query, Execute a Saved Query Lesson 2: Performing a Conditional Search-Search Using a Simple Condition, Compare Column Values, Search Using Multiple Conditions, Search for a Range of Values and Null Values, Retrieve Data Based on Patterns Lesson 3: Working with Functions-Perform Date Calculations, Calculate Data Using Aggregate Functions, Manipulate String Values Lesson 4: Organizing Data- Sort Data, Rank Data, Group Data, Filter Grouped Data, Summarize Grouped Data,Use PIVOT and UNPIVOT Operators Lesson 5: Retrieving Data from Tables-Combine Results of Two Queries, Compare the Results of Two Queries, Retrieve Data by Joining Tables, Check for Unmatched Records, Retrieve Information from a Single Table Using Joins Lesson 6: Presenting Query Results-Save the Query Result, Generate an XML Report
Cost: $ (Lunch is not included)
Fee must accompany non-member registration. No shows will be charged full price. Register By: . Cancellation policies apply. Cancellations with less than five business days notice will be charged.