eLearning Bundle - SQL Querying Online Course

SQL TrainingeLearning Bundle - SQL Querying

by Certstaffix® Training

Length: 1 Course(s)      Price: $500/person (USD)      Access Length: 6 Months      Category: SQL


This training course provides a thorough introduction to SQL and shows you how to generate business reports from your relational database management system (RDBMS). The course begins by providing an overview of the history of SQL, how databases work, and common SQL statements. Then, you'll learn how to work with SQL, from creating reports with simple SELECT statements to writing queries to retrieve data from multiple tables. The course also covers conditional processing with the CASE function and how to insert, update and delete records. This SQL course is applicable for use with all major databases, including Oracle, SQL Server and MySQL. Differences between databases will be pointed out where they exist.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online SQL Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • Desktop Software Courses: We provide lab environment with the software you are learning, no need to have the software on your computer
  • 6 month subscription length

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
SQL Training

Features:

• Audio Narration
• Video
• Inline Activities

Introduction to SQL Training (SQL Server) - 16:07 hours

Goals:

Understand how relational databases work.
Learn to use SQL to output reports.
Learn to write SQL queries to retrieve data from multiple tables.

Outline:

Relational Database Basics
Brief History of SQL
Relational Databases
Tables
Rows
Columns
Relationships
Datatypes
Primary Keys
Foreign Keys
Relational Database Management System
Popular Databases
Commercial Databases
Popular Open Source Databases
Valid Object References
SQL Statements
Database Manipulation Language (DML)
Database Definition Language (DDL)
Database Control Language (DCL)
Simple SELECTs
Introduction to the Northwind Database
Some Basics
Comments
Whitespace and Semi-colons
Case Sensitivity
SELECTing All Columns in All Rows
Exploring the Tables
SELECTing Specific Columns
Sorting Records
Sorting By a Single Column
Sorting By Multiple Columns
Sorting By Column Position
Ascending and Descending Sorts
The WHERE Clause and Operator Symbols
Checking for Equality
Checking for Inequality
Checking for Greater or Less Than
Checking for NULL
WHERE and ORDER BY
The WHERE Clause and Operator Words
The BETWEEN Operator
The IN Operator
The LIKE Operator
The NOT Operator
More SELECTs with WHERE
Checking Multiple Conditions
AND
OR
Order of Evaluation
Writing SELECTs with Multiple Conditions
Advanced SELECTs
Calculated Fields
Concatenation
Mathematical Calculations
Aliases
Calculating Fields
Aggregate Functions and Grouping
Aggregate Functions
Grouping Data
Selecting Distinct Records
Working with Aggregate Functions
Built-in Data Manipulation Functions
Common Math Functions
Common String Functions
Common Date Functions
Data Manipulation Functions
Subqueries, Joins and Unions
Subqueries
Joins
Table Aliases
Multi-table Joins
Using Joins
Outer Joins
Unions
UNION ALL
UNION Rules
Working with Unions
Course Description: Print It | Download PDF | Email It