X
GO
YLFL public schedule - Instructor-Led Live Online Training OR LIVE IN CLASSROOM IF DEDICATED GROUP OF 5+)
/Portals/0/NADevEventsImages/Excel1_80.png

Introduction to SQL

Event Start Date: 5/23/2017 10:00 AM

Event End Date: 5/23/2017 2:00 PM

Average Rating:

Click here to create or view existing reviews.

This course is available to be streamed live online
Email Me A Reminder About This Event:
Email Me!
Sign Up To This Event
There are currently 50 spaces left.
Cost per place: CAD $500.00

SQL INTRODUCTION

Overview

This SQL training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

Goals

1.            Understand how relational databases work.

2.            Learn to use SQL to output reports.

3.            Learn to write SQL queries to retrieve data from multiple tables.

Outline

1.            Relational Database Basics

A.            Brief History of SQL

B.            Relational Databases

I.             Tables

II.            Rows

III.           Columns

IV.          Relationships

V.            Datatypes

VI.          Primary Keys

VII.         Foreign Keys

VIII.        Relational Database Management System

C.            Popular Databases

 .              Commercial Databases

I.             Popular Open Source Databases

II.            Valid Object References

D.            SQL Statements

 .              Database Manipulation Language (DML)

I.             Database Definition Language (DDL)

II.            Database Control Language (DCL)

2.            Simple SELECTs

 .              Introduction to the Northwind Database

A.            Some Basics

 .              Comments

I.             Whitespace and Semi-colons

II.            Case Sensitivity

B.            SELECTing All Columns in All Rows

C.            Exploring the Tables

D.            SELECTing Specific Columns

E.            Sorting Records

 .              Sorting By a Single Column

I.             Sorting By Multiple Columns

II.            Sorting By Column Position

III.           Ascending and Descending Sorts

F.            The WHERE Clause and Operator Symbols

 .              Checking for Equality

I.             Checking for Inequality

II.            Checking for Greater or Less Than

III.           Checking for NULL

IV.          WHERE and ORDER BY

G.           The WHERE Clause and Operator Words

 .              The BETWEEN Operator

I.             The IN Operator

II.            The LIKE Operator

III.           The NOT Operator

H.            More SELECTs with WHERE

I.             Checking Multiple Conditions

 .              AND

I.             OR

II.            Order of Evaluation

J.             Writing SELECTs with Multiple Conditions

3.            Advanced SELECTs

 .              Calculated Fields

 .              Concatenation

I.             Mathematical Calculations

II.            Aliases

A.            Calculating Fields

B.            Aggregate Functions and Grouping

 .              Aggregate Functions

I.             Grouping Data

II.            Selecting Distinct Records

C.            Working with Aggregate Functions

D.            Built-in Data Manipulation Functions

 .              Common Math Functions

I.             Common String Functions

II.            Common Date Functions

E.            Data Manipulation Functions

4.            Subqueries, Joins and Unions

 .              Subqueries

A.            Joins

 .              Table Aliases

I.             Multi-table Joins

B.            Using Joins

C.            Outer Joins

D.            Unions

 .              UNION ALL

I.             UNION Rules

E.            Working with Unions

5.            If time allows, one or more of the following may be covered:

 .              Conditional Processing with CASE

A.            INSERT, UPDATE, DELETE

B.            Student Challenges - Design your own reports

Expert Facilitator
  • DWH
  
 

What is live online training (LOT) and how do we do it so well?

Convinced you need an in-person class? Not comfortable with the idea of learning “online”? So were some of our students – until they attended one of our classes. We offer an extensive schedule of live, instructor-led online classes. Our instructor-led online classes allow you to attend a class from home or the office without the need to travel.
When you register for one of our instructor-led online courses you will receive:
Expert instruction from a live instructor who will guide you through the course material. This is not recorded eLearning, but a live, hands-on, interactive class. The only difference is that you and your instructor are not in the same room!
All of your course materials are shipped directly to your home or office.
Six months of post-class email support from an instructor.
Retake your class for free at any time in the future.
Access to our state-of-the-art online classroom which allows you to see and hear everything the instructor does. You can also ask questions using voice or chat at any time during the class, hear fellow student’s questions and even share your work with your instructor if you need assistance.

The best part about our instructor-led online classes is that they are guaranteed to run, even if you are the only student enrolled in the class! We are so confident your will completely enjoy your class experience that we offer a complete money-back guarantee if you are not completely satisfied. See commonly asked questions about our live, instructor-led online classes or watch a short demonstration of how our live, instructor-led online classes work.When we're talking about an online classroom, we mean a synchronous environment with a leader and participants in multiple locations speaking and interacting with one another at the same time, much as they would in a physical classroom. Participants can raise their hands, take surveys or tests, and participate in learning activities in a number of different ways. Audio is included in some products through Voice over IP, although some products provide only the collaboration and information-sharing tools and a phone is used for audio. What are the similarities and differences?  Our training organization has been using live, online training for over four years and our experience indicates that moving from the traditional classroom environment is not a difficult task. We train both employees and customers using this technology. READ MORE>

 
  Still not convinced, why not bring our course to your site with Onsite Training.  Private Group Training At Your Site
Youlearnforless specializes in providing expert training at your site for groups as small as 3 people.  Setup for most of our courses is usually simple and straight-forward and our staff guides you through the entire process. If your staff is geographically dispersed, or if you have fewer than 3 people to train, our Instructor-Led online course delivery may also be an option for your group (see above.) 
We’ve delivered training for many Fortune 500 companies – request an onsite training price quote.
View our full course catalog above.
 

 

CyberSafe

Is your staff cyber aware

CyberSec

Is your technical staff cyber certified?