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.

"A perfect speaker, at the perfect time. Your event always sets the tone for a business gathering in southcentral PA"   Annual Event attendee at 
Penn State's Pullo Center in York, PA
The Manufacturers' Association
160 Roosevelt Avenue
York, PA 17401
(717) 843-3891
office@mascpa.org