SQL 2008: Fundamentals

1 day

Beginner

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases.

Basic end-user computer skills and some familiarity with database terminology and structure are required.

You will compose SQL queries to retrieve desired information from a database.

To find out when this course is being offered next, please refer to our Course Schedule.

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.

Lesson 1: Executing a Simple Query
Topic 1A: Connect to the SQL Database
Topic 1B: Query a Database
Topic 1C: Save a Query
Topic 1D: Modify a Query
Topic 1E: Execute a Saved Query

Lesson 2: Performing a Conditional Search
Topic 2A: Search Using a Simple Condition
Topic 2B: Compare Column Values
Topic 2C: Search Using Multiple Conditions
Topic 2D: Search for a Range of Values and Null Values
Topic 2E: Retrieve Data Based on Patterns

Lesson 3: Working with Functions
Topic 3A: Perform Date Calculations
Topic 3B: Calculate Data Using Aggregate Functions
Topic 3C: Manipulate String Values

Lesson 4: Organizing Data
Topic 4A: Sort Data
Topic 4B: Rank Data
Topic 4C: Group Data
Topic 4D: Filter Grouped Data
Topic 4E: Summarize Grouped Data
Topic 4F: Use PIVOT and UNPIVOT Operators

Lesson 5: Retrieving Data from Tables
Topic 5A: Combine Results of Two Queries
Topic 5B: Compare the Results of Two Queries
Topic 5C: Retrieve Data by Joining Tables
Topic 5D: Check for Unmatched Records
Topic 5E: Retrieve Information from a Single Table Using Joins

Lesson 6: Presenting Query Results
Topic 6A: Save the Query Result
Topic 6B: Generate an XML Report

Appendix A: The OGCBooks Database

MicroAssist’s instructor-led training consists of group-paced learning models with structured hands-on activities. The dedicated learning environment encourages focused learning supported by key resources.

• Private Training Facility – Our training rooms are designed to provide students with a comfortable and distraction-free environment. Being able to focus on each step and its implications leads to better retention of the new material.
• In-person Instructor – The instructor presents learning material live in the classroom, allowing for effective information dissemination and active classroom management. The face-to-face nature of the class allows for student-teacher interaction that aids in successfully completing each lesson.
• Student Work Station – Each student is provided a desktop or laptop computer to work with during the training class. The computers are equipped with the appropriate student files and programs so students can replicate the steps in each lesson. Being able to manually complete each lesson fosters increased understanding.
• Student Manual – Each student is supplied a manual that provides a general overview of each concept as well as detailed instructions on how to complete each task. The manual is the student’s to keep and makes an excellent reference guide.

$425 (U.S.)