SQL Fundamentals Using Server 2005
Duration
One Day
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.
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.
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.
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
- Connect to the Database
- Query the Database
- Modify a Query
- Save 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
- Topic 2E: Retrieve Data Based on Patterns
Lesson 3: Working with Functions
- Perform Date Calculations
- Calculate Data
- Manipulate String Values
Lesson 4: Organizing Data
- Sort Data
- Group Data
- Filter Grouped Data
- Summarize Grouped Data
Lesson 5: Retrieving Data from Multiple Tables
- Combine Results of Two Queries
- Retrieve Data by Joining Tables
- Check for Unmatched Records
- Retrieve Information from a Table Using Joins
Lesson 6: Presenting Query Results
- Customize and Save the Query Result
- Generate an HTML Report
