SQL: Fundamentals of Querying (Second Edition)

Course Specifications

Course number: 085561
Software: XXXXXX
Course length: 1.0 day(s)

Course Description

You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions.

Course Objective: You will learn how to compose SQL queries to retrieve information from the database.

Target Student: Any person with basic computer skills, familiar with concepts related to database structure and terminology, and wants to use SQL to query databases.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses, or have equivalent skills and knowledge of either: Windows XP: IntroductionWindows XP Professional: Level 1 and Windows XP Professional: Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-Based Objectives

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 based on the data types to perform calculations on data.
• organize the data obtained from the query before it is displayed on the screen.
• retrieve data by combining information from multiple tables.
• format the output, save the result, and generate a report.

Course Content

Lesson 1: Executing a Simple Query

Topic 1A: Connect to the Database

Topic 1B: Query the Database

Topic 1C: Modify a Query

Topic 1D: Save 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

Topic 3C: Manipulate String Values

Lesson 4: Organizing Data

Topic 4A: Sort Data

Topic 4B: Group Data

Topic 4C: Filter Grouped Data

Topic 4D: Summarize Grouped Data

Lesson 5: Retrieving Data from Multiple Tables

Topic 5A: Combine Results of Two Queries

Topic 5B: Retrieve Data by Joining Tables

Topic 5C: Check for Unmatched Records

Topic 5D: Retrieve Information from a Table Using Joins

Lesson 6: Presenting Query Results

Topic 6A: Customize and Save the Query Result

Topic 6B: Generate an HTML Report

Appendix A: The Bindery Database