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.

"Thank you ... for participating in our Manufacturer's Summit" Adams County Economic Development Corporation
The Manufacturers' Association
160 Roosevelt Avenue
York, PA 17401
(717) 843-3891
office@mascpa.org