SQL

KnowledgeAir
Buffalo, New York, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

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

--------------------------------------------------------------------------------

Course Outline:

--------------------------------------------------------------------------------

Lesson 1: Executing a Simple Query

Connect to the Database
Query the 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


...''

Phone:866-322-3685

School Address:

KnowledgeAir Buffalo
726 Exchange St, Suite 628
Buffalo, NY 14210

KnowledgeAir Rochester
100 Allens Creek Road
Rochester, NY 14618


Jobs & Resumes: Buffalo
Houses & Roommates: Buffalo

Search other schools for SQL training resources.

OneNote 2007
PowerPoint 2003
Word 2007
Illustrator CS3
InDesign CS3
Photoshop CS3
SQL Server 2005
Implementing a Microsoft SQL Server 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
SQL Advanced Querying
Windows 2003 Active directory
Exchange Server 2007
ACT!
CISSP
Advanced Administration of Blackberry Enterprise Server
BlackBerry Enterprise Server
BlackBerry End User
Microsoft Windows SharePoint Services

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.