sql for the windows environment online training course tutorials

Receive your login ID to take the training courses online, as many times as you wish, for 1 year. Click here for group orders.

Buy this entire online training course with one easy payment of $67

Benefits

Unlimited access for 1 year
Learn anytime, anywhere
You control the pace
Start & stop wherever you want
No books to read
No software needed
Value Packs include Free online tech support
Double guarantee

100% Money back guarantee
One time payment No monthly fee
Use the course index for review anytime
Answer course questions with at least 70% accuracy and print your own certificates of completion to prove that you have mastered each training course.
Free status reports for company managers

Requirements

All you need is a PC with Windows, the Microsoft Internet Explorer (browser) and an Internet connection.
Note: The online computer training is designed to work only with Internet Explorer. Prices shown are per user.

What You will Learn

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.

Introduction to Databases and SQL

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

Filtering Data

Use the WHERE clause in a SELECT statement
Use the LIKE operator in a WHERE clause

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

Calculations and Functions

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

Summarizing Data

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

Groups and Queries

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

Joins

Query multiple tables using a join
Use table aliases in your queries

Perform inner, outer, self, and natural joins
Use aggregate functions with joins

Data and Tables

Insert rows of data into a database table
Update and delete data from a database table

Create database tables
Modify and delete database tables
Copy data from one table to another

Views and Stored Procedures

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

Transaction Processing and Cursors

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

Advanced SQL Functions

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

SQL for the Windows Environment Join over 1 million people who learn online, with these complete interactive computer training courses.

SQL for the Windows Environment
Join over 1 million people who learn online, with these complete interactive computer training courses.