×

Contact Us

Corporate Headquarters

TeachUcomp, Inc.
1140 Abbot Road
#64
East Lansing MI 48823
USA

Phone

Toll Free (U.S. and Canada): 877-925-8080
International:  +1-517-333-2560

Email

sales@teachucomp.com

Hours of Operation

Monday-Friday 9:00-5:00 Eastern.

Policies

Privacy Policy

Terms and Conditions

SALE!

Mastering SQL Made Easy v 1.0- DVD-ROM

Original price was: $50.00.Current price is: $10.00.

Course Title: Mastering SQL Made Easy
Hours of Content: 3
Video Lessons: 43
Manual: 84 Pages

Categories: , ,

Description

Our complete SQL training course on DVD-ROM. Includes:

  • Video Lessons
  • Printable Instruction Manuals
  • Practice Exam
  • Final Exam
  • Certificate of Completion

 Topics Covered:

Introduction to Databases and SQL
1. Overview of a Database
2. The “Flat-File” Method of Data Storage
3. The Relational Model of Data Storage
4. Tips for Creating a Relational Database
5. What is SQL?
6. Using SQL in Access 2013

Data Definition Language
1. The CREATE Statement
2. The CREATE DATABASE Statement
3. The CREATE TABLE Statement
4. The CREATE INDEX Statement
5. SQL Constraints
6. The DROP Statement
7. The ALTER TABLE Statement
8. NULL Values in SQL
9. Data Types in SQL
10. Auto-Increment in SQL

Data Manipulation Language
1. The INSERT Statement
2. The UPDATE Statement
3. The DELETE Statement
4. The SELECT Statement
5. The WHERE Clause
6. Criteria Notation and Wildcard Characters in the WHERE Clause
7. The ORDER BY Clause
8. The GROUP BY Clause and Aggregate Functions
9. The JOIN Clause
10. The UNION Operator
11. The SELECT INTO Statement
12. The INSERT INTO SELECT Statement
13. Subqueries

Data Control Language
1. The CREATE USER and CREATE ROLE Statements
2. Privileges
3. The GRANT Statement
4. The REVOKE Statement
5. The ALTER USER and ALTER ROLE Statements
6. The DROP USER and DROP ROLE Statements

Transaction Control Language
1. The TRANSACTION Statement

SQL Functions and Aliases
1. Understanding SQL Functions
2. Calculated Fields and Column Aliases
3. Table Aliases

Views
1. About Views
2. The CREATE VIEW Statement
3. The ALTER VIEW Statement
4. The DROP VIEW Statement

Additional information

Weight 1 oz

You may also like…

  • One Year Subscription- Access to Entire Library

    $29.00 for 1 year
    Add to CartMORE INFO
TOP
SALE! $29 All-Access 19 Days 18 Hours 36 Minutes 21 Seconds      $199 $29 Entire Library!
See Deal