Ready to Checkout?

shopping-cart

Quality Training Since 2001

SQL Tutorial Training Course

demo-buttonbuy-now-buttonsyllabus-button

html-training-tutorial

Course Title: Mastering Introductory SQL Made Easy
Hours of Content: 3
Video Lessons: 43
Manuals: 1
Download/DVD: $50 |   
Online: Access ALL courses. One price. | 
Multi-User: Need to train multiple people? | 
CPE Credits: 5

Course Description

Learn SQL with this video training course from TeachUcomp, Inc. Mastering Introductory SQL Made Easy features 43 video lessons with over 3 hours of expert instruction. SQL is a standardized programming language that is used to create, edit and delete databases and database objects. It is also the language that is used to extract, add, update, and delete data within a database. SQL is used in nearly every aspect of database interactions. Watch, listen and learn as your instructor guides you through the “core,” or essential, statements within SQL. Variations of the core statements for the specific database systems of MySQL 5.7, SQL Server 2012, and Access 2013 will also be referenced by hyperlinks to the associated online documentation for each system. The goal of this course to give the student the knowledge of which SQL statement they will need to use to accomplish specific tasks within a database, as well as provide links to database-specific implementations of those core statements. Reinforce your learning with the text of our printable classroom instruction manual, additional images and practice exercises.

Whether you are completely new to SQL or are simply in need of a refresher or excellent reference source, this course will empower you with the knowledge and skills necessary to be a proficient user. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs.  Simply launch the easy-to-use interface, click to start a video lesson or open the manual and you are on your way to mastering SQL.

 

Course Syllabus & Sample Lessons

Select any of the video lessons markedfreeto view them in a new window.

To view samples of the instruction manuals in PDF, click here: Introductory SQL

CHAPTER 1- Introduction to Databases and SQL
Lesson 1.1- Overview of a Database
Lesson 1.2- The “Flat-File” Method of Data Storage
Lesson 1.3- The Relational Model of Data Storage
Lesson 1.4- Tips for Creating a Relational Database
Lesson 1.5- What is SQL?
Lesson 1.6- Using SQL in Access 2013 free
CHAPTER 2- Data Definition Language
Lesson 2.1- The CREATE Statement
Lesson 2.2- The CREATE DATABASE Statement
Lesson 2.3- The CREATE TABLE Statement
Lesson 2.4- The CREATE INDEX Statement
Lesson 2.5- SQL Constraints
Lesson 2.6- The DROP Statement
Lesson 2.7- The ALTER TABLE Statement free
Lesson 2.8- NULL Values in SQL
Lesson 2.9- Data Types in SQL
Lesson 2.10- Auto-Increment in SQL
CHAPTER 3- Data Manipulation Language
Lesson 3.1- The INSERT Statement
Lesson 3.2- The UPDATE Statement
Lesson 3.3- The DELETE Statement
Lesson 3.4- The SELECT Statement free
Lesson 3.5- The WHERE Clause
Lesson 3.6- Criteria Notation and Wildcard Characters in WHERE Clause
Lesson 3.7- The ORDER BY Clause
Lesson 3.8- The GROUP BY Clause and Aggregate Functions
Lesson 3.9- The JOIN Clause
Lesson 3.10- The UNION Operator
Lesson 3.11- The SELECT INTO Statement
Lesson 3.12- The INSERT INTO SELECT Statement
Lesson 3.13- Subqueries
CHAPTER 4- Data Control Language
Lesson 4.1- The CREATE USER and CREATE ROLE Statements
Lesson 4.2- Privileges
Lesson 4.3- The GRANT Statement
Lesson 4.4- The REVOKE Statement
Lesson 4.5- The ALTER USER and ALTER ROLE Statements free
Lesson 4.6- The DROP USER and DROP ROLE Statements
CHAPTER 5- Transaction Control Language
Lesson 5.1- The TRANSACTION Statement
CHAPTER 6- SQL Functions and Aliases
Lesson 6.1- Understanding SQL Functions free
Lesson 6.2- Calculated Fields and Column Aliases
Lesson 6.3- Table Aliases
CHAPTER 7- Views
Lesson 7.1- About Views
Lesson 7.2- The CREATE VIEW Statement
Lesson 7.3- The ALTER VIEW Statement
Lesson 7.4- The DROP VIEW Statement


SQL Training Course Overview

During this 3 hour video training course, our expert instructor will teach you how to create, edit and delete databases and database objects with SQL.  The course is designed to provide a complete overview of how to use SQL to create and manipulate databases. This SQL tutorial covers the same material as our classroom training and was designed to provide a solid foundation in SQL.

Course includes video lessons, printable instruction manual, a practice exam with evaluative feedback (find out why your answers are right or wrong), your final exam submission, and a course certificate of completion.

At TeachUcomp, Inc., you choose how you want your SQL training delivered.

Online subscriptions offer the most flexibility and value. With online training, you can access your courses anytime and anywhere you have an internet connection (including all new releases and updates). Your subscription grants you instant access to ALL of our courses for one low price. There are no contracts and you can cancel at any time. You may choose between a monthly or annual plan.

Courses are also available individually via digital download and online for a one-time charge.

TOP