SQL: Fundamentals of Querying
Course Objective: You will compose SQL queries to retrieve desired information from a database.
Target Student: Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.
Pre-Requisites: Basic end-user computer skills and some familiarity with database terminology and structure are required. The following ON-TRACK courses or equivalent knowledge and skills are highly recommended:
- Access 2003: Designing a Database
- Windows XP Professional Level 1&2
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
Upon successful completion of this course, students will be able to:
- Create and modify Pivot Tables
- Create and Modify Macros
- Form Control
- Use Advanced Functions
- Trace Dependents and Precedents
- Create and Modify Scenarios
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 Data Calculations
- Calculate Data Using Aggregate Functions
- Manipulate String Values
- Lesson 4 - Organizing Data
- Sort Data
- Rank Data
- Group Data
- Filter Group Data
- Summarize Group 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
- Appendix A - The OGCBooks Database