Home
Complete Catalog
Search
Online Courses
Free Courses
Students
Shopping Cart
Help
Special Packages
Desktop Computing
Home and Small Business
Business Skills Development
Technical General
Technical Microsoft
Technical Web Development
European Computer Driving Licence
International Computer Driving Licence
UK Further Education
HIPAA Training and Awareness
Videos: Essentials
Videos: Management
Videos: Personal Development
CompTIA A+
Customer Service
Dynamic HTML
Excel 2000
HTML
Investing Fundamentals
Negotiating
UNIX
Windows 2000 Server MCSE 70-215
Top
->
Catalog
->
Technical General
->
SQLWIN
My Account
|
Cart Contents
|
Checkout
Categories
End User Desktop Computing
End User Home and Small Business
End User Business Skills Development
Technical General
Technical Microsoft
Technical Web Development
European Computer Driving Licence
International Computer Driving Licence
UK Further Education
HIPAA Training and Awareness
Business Skills Videos: Essentials
Business Skills Videos: Management
Business Skills Videos: Personal Development
Tell A Friend
Tell someone you know about this product.
Shopping Cart
0 items
What's New?
Stress Management
$32.99
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
Notifications
Notify me of updates to
SQL for the Windows Environment
Information
Refund Policy
Privacy Policy
Conditions of Use
Contact Us
SQL for the Windows Environment
[SQLWIN]
$64.99
Course Content :
SQL for the Windows Environment:1 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.
More Info
SQL for the Windows Environment:2 Filtering Data
This course explains how to filter data from a database with the SQL WHERE clause.
More Info
SQL for the Windows Environment:3 Calculations and Functions
This course shows you how to manipulate data returned from a query using calculated fields and functions.
More Info
SQL for the Windows Environment:4 Summarizing Data
This course explains how to use the SQL aggregate functions to summarize data from database tables.
More Info
SQL for the Windows Environment:5 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.
More Info
SQL for the Windows Environment:6 Joins
This course shows you how to access data stored in multiple relational tables by using joins in your queries.
More Info
SQL for the Windows Environment:7 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.
More Info
SQL for the Windows Environment:8 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.
More Info
SQL for the Windows Environment:9 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.
More Info
SQL for the Windows Environment:10 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 an overview of the tools used to manage database security.
More Info
Friday 05 September, 2008
1220508 requests since Wednesday 30 March, 2005
