companyservicessolutionscasesstoreresourcessoftwarepartnercontact
SQL101: Introduction to SQL

 

LIMITED TIME OFFER:

FREE Laptop Attache

Free Laptop Attache when you register for SQL101 In-Class

 


 

Shop by category:

SQL101: Introduction to SQL
Location and Date Group Discount
Price
WEBINAR on July 27-28
IN-CLASS on Sept. 14-15
WEBINAR on Oct. 26-27
1 - 2 students
(price per student)
3 or more students
(price per student)


 

Recommended for:
Business Users, Technical Users

Duration: 2 Days

Pre-requisites: None

Webinar
On-line Webinar: $365 per student
(groups of 3 or more: $295 per student)

In-class
In-class at SQL Power Toronto Training Facility:
$895 per student
(groups of 3 or more: $750 per student)

 

This course will teach students everything they need to know about SQL (Structured Query Language) in order to be fully functional in a relational database environment. Students will learn the syntax for issuing the various select, insert, update and delete statements (including data joins and subqueries). They will also learn how to create and drop the various database objects.

SQL 101 is ideal for report builders, business analysts and technical users with little or zero SQL experience.

 

Topics covered:

  1. What is SQL?
  2. The Select statement
  3. SQL Functions
  4. The Where clause
  5. The Order By clause
  6. The Group By clause
  7. Subqueries
  8. The Join clause
  9. The Insert, Update and Delete statements
  10. Commit and Rollback
  11. The Union, Intersect and Minus operators
  12. Creating, Modifying and Dropping database objects
  13. Introduction to Security and Protecting your Data
  14. Introduction to the SQL Power Wabit BI Tool

 


Email this page
Print‑friendly version
BI Savings Calculator
Contact Us
Info Request
Demo Request

SQL Power Consulting
Member Log-In




Need an account?
Register for free

Looking for SQL Power Software?
Log-In Here