Catalog

Toll-free in USA 1-877-545-5763

SQL for the Windows Environment

Total Items: 10

Total Time: 21 hour(s)

Audience: This series is for anyone who wants to use Structured Query Language (SQL) in a Windows Environment.

Description: SQL is the most widely-used database language. Acquiring a good working knowledge of SQL is an important skill for anyone who interacts with databases. Short, focused lessons start with simple data retrieval and progress to complex topics such as using joins, subqueries, stored procedures, and table constraints.

Features

Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
Activities allow learners to apply course concepts in an interactive questioning environment.
Exercises allow learners to practice in the actual application being studied.
Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
Search text enables learners to rapidly search all text within a course to easily retrieve information required.
Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
A skill assessment generates a customized learning path based on the results of a pre-test.
A glossary provides a reference for definitions of unfamiliar terms.
Bookmarking tracks the learner's progress in a course.

Includes:

Time: 2 hour(s)

SQL for the Windows Environment: Introduction to Databases and SQL

Course Code: sqlw01

Description: This course explains the basic structure and uses of databases and how to use the SQL SELECT statement to retrieve data.

Objectives:

Describe the basics of database structure
Explain how to use SQL to interact with most database applications
Use the SELECT statement to retrieve data
Explain the sorting options available when using the ORDER BY clause

Topics:

Understanding databases
Understanding SQL
Retrieving data
Sorting data
Sorting options

Time: 2 hour(s)

SQL for the Windows Environment: Filtering Data

Course Code: sqlw02

Description: This course explains how to filter data from a database with the SQL WHERE clause.

Objectives:

Use the WHERE clause in a SELECT statement
Use the AND, OR, IN, and NOT operators in a WHERE clause
Use the LIKE operator in a WHERE clause
Use wildcards to create search patterns

Topics:

Filtering with the WHERE Clause
Using the WHERE Clause
Combining WHERE Clauses
Using the IN and NOT Operators
The LIKE Operator and Wildcards
Using Wildcards

Time: 2 hour(s)

SQL for the Windows Environment: Calculations and Functions

Course Code: sqlw03

Description: This course shows you how to manipulate data returned from a query using calculated fields and functions.

Objectives:

Concatenate fields in your queries
Perform mathematical calculations in your queries
Use text and numeric functions in your queries
Use date and time functions in your queries

Topics:

Understanding calculated fields
Concatenating fields
Performing mathematical calculations
Understanding functions
Using text and numeric functions
Using date and time functions

Time: 1 hour(s)

SQL for the Windows Environment: Summarizing Data

Course Code: sqlw04

Description: This course explains how to use the SQL aggregate functions to summarize data from database tables.

Objectives:

Explain the purpose of the SQL aggregate functions
Use the SUM() and COUNT() functions
Use the AVG(), MAX(), and MIN() functions
Use aggregate functions for advanced operations

Topics:

Aggregate Functions
Using the SUM() and COUNT() Functions
The AVG(), MAX(), and MIN() Functions
Using Advanced Aggregate Functions

Time: 2 hour(s)

SQL for the Windows Environment: Groups and Queries

Course Code: sqlw05

Description: This course explains how to use the GROUP BY and ORDER BY clauses to sort and group data. It also explains how to use subqueries and combined queries to add more options to retrievals using the SQL SELECT statement.

Objectives:

Create data groups using the GROUP BY clause
Sort and filter grouped data
Understand and filter subqueries
Use subqueries as calculated fields
Create combined queries using UNION

Topics:

Understanding data grouping
Creating groups
Filtering groups
Grouping and sorting
Understanding and filtering subqueries
Using subqueries as calculated fields
Creating combined queries
Advanced UNION features

Time: 3 hour(s)

SQL for the Windows Environment: Joins

Course Code: sqlw06

Description: This course shows you how to access data stored in multiple relational tables by using joins in your queries.

Objectives:

Query multiple tables using a join
Use table aliases in your queries
Perform inner, outer, self, and natural joins
Use aggregate functions with joins

Topics:

Understanding joins
Creating a join
Joining multiple tables
Using table aliases
Self joins
Natural joins
Outer joins
Using joins with aggregate functions

Time: 3 hour(s)

SQL for the Windows Environment: Data and Tables

Course Code: sqlw07

Description: This course explains how to insert data into existing database tables and then modify or delete that data. It also explains how to create new database tables and modify or delete existing tables.

Objectives:

Insert rows of data into a database table
Copy data from one table to another
Update and delete data from a database table
Create database tables
Modify and delete database tables

Topics:

Inserting Data
Inserting Partial Rows and Retrieved Data
Copying from One Table to Another
Updating Data
Deleting Data
Guidelines for Updating and Deleting Data
Creating Tables
Working with NULL and Default Values
Modifying Tables

Time: 2 hour(s)

SQL for the Windows Environment: Views and Stored Procedures

Course Code: sqlw08

Description: This course teaches the learner the use of views in SQL and how views can be used to simplify complex operations. It also provides an overview on the use and creation of stored procedures.

Objectives:

Explain the makeup of views
Use views to simplify joins
Use views to reformat retrieved data
Use filtering and calculated fields within your views
Explain the use of stored procedures
Execute stored procedures
Describe some of the features involved in creating stored procedures

Topics:

Understanding views
Using views to simplify complex joins
Using views to reformat retrieved data
Unwanted data and calculated fields
Understanding stored procedures
Executing stored procedures
Creating stored procedures

Time: 2 hour(s)

SQL for the Windows Environment: Transaction Processing and Cursors

Course Code: sqlw09

Description: This course shows you how to use transaction processing to execute SQL operations in batches. This enables you to prevent processing errors from corrupting the database.

Objectives:

Explain how transaction processing works in SQL code
Control transactions
Explain how cursors are used to save SQL results
Declare and use cursors in your SQL code

Topics:

Understanding transaction processing
Controlling transactions
Setting savepoints
Understanding cursors
Working with cursors

Time: 2 hour(s)

SQL for the Windows Environment: Advanced SQL Functions

Course Code: sqlw10

Description: This course explains the use of constraints in databases. The user will learn about primary and foreign keys, and unique and check constraints. The user will also learn about the use of indexes and triggers within databases. Finally, the user will receive an overview of the tools used to manage database security.

Objectives:

Explain the use of database constraints
Define primary and foreign keys
Describe the use of unique and check constraints
Explain the function of database indexes
Describe the function of triggers
Identify the tools used in database security

Topics:

Understanding constraints
Primary and foreign keys
Unique and check constraints
Understanding indexes
Understanding triggers
Database security