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 jo
This SQL for the Windows Environment online training series provides over 21 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:
1 . Advanced SQL Functions
2 . Calculations and Functions
3 . Data and Tables
4 . Filtering Data
5 . Groups and Queries
6 . Introduction to Databases and SQL
7 . Joins
8 . Summarizing Data
9 . Transaction Processing and Cursors
10 . Views and Stored Procedures
Lesson Detail:
Advanced SQL Functions
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
Calculations and Functions
This course shows you how to manipulate data returned from a query using calculated fields and functions.
Data and Tables
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.
Filtering Data
This course explains how to filter data from a database with the SQL WHERE clause.
Groups and Queries
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.
Introduction to Databases and SQL
This course explains the basic structure and uses of databases and how to use the SQL SELECT statement to retrieve data.
Joins
This course shows you how to access data stored in multiple relational tables by using joins in your queries.
Summarizing Data
This course explains how to use the SQL aggregate functions to summarize data from database tables.
Transaction Processing and Cursors
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.
Views and Stored Procedures
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.
Certification:
SQL for the Windows Environment
Audience:
This series is for anyone who wants to use Structured Query Language (SQL) in a Windows Environment.
Features:
What You Get:
You will receive Unlimited Access to all of the SQL for the Windows Environment training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.
Web-Based Training Products:
You might also be interested in our Technical Package which includes all of the SQL for the Windows Environment training courses listed above plus hundreds of hours of related online training courses