Need Help? Call us at (281) 541-2807 Visit our Facebook Page Follow us on Twitter Subscribe to our RSS Feeds

SQL Querying - Level 1 Fundamentals of Querying On-Site Training

presented by New Horizons Computer Learning Center
View the New Horizons Computer Learning Center Profile and Available Training

There may be public open-enrollment dates/locations for this class near you.

Summary

In this course, students learn how to compose SQL queries to retrieve information from the database.

Workshop Description/Agenda

Duration
Classroom Learning - 1 Day(s)
Online LIVE - 1 Sessions

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.

Prerequisite(s) or equivalent knowledge
Access 2003 - Level 1
Relational Database Design A Practical Approach

Suggested Next Steps
SQL Querying - Level 2 Advanced Querying

Other Related Classes
2779 Implementing a Microsoft SQL Server 2005 Database
2783 Designing the Data Tier for Microsoft SQL Server 2005
2784 Tuning and Optimizing Queries Using Microsoft SQL Server 2005
2788 Designing a High Availability Database Solutions Using Microsoft SQL Server 2005

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

Who Should Attend

Database programmers/designers

Additional Information

Training Provider: New Horizons Computer Learning Center

Course Topics: Computers / IT Training > Database

Training Course Summary: In this course, students learn how to compose SQL queries to retrieve information from the database.

Private Group Training Request

For groups of 10 or more, consider bringing the training to you as a cost effective way to train your workforce. Fill out the following form and we will contact you right away.

 

Enter Your On-Site Training Requirements

 

Name:

Company:

Contact Number:

Email Address:

Your City:

Your State:

Expected Number of Attendees:

When To Hold the Class:

How Many Days of Instruction:
Briefly Describe Your Training Needs: