Toll-free in USA 1-877-545-5763
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Copyright MindLeaders, Inc. 2013