SQL Certificate

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst.
You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs. This course is offered in partnership with Learning Education Resource Network - UGotClass. For more information see http://yougotclass.org/index.cfm/VCC

Prerequisites

What you will learn

• INTRODUCTION TO SQL
  The Relational Database and Structured Query Language
  The relational database structure
  Structured Query Language
  Table creation and data insertion
  Defining datatypes and constraints
  Creating Indexes
• INTRODUCTION TO SQL
  Table Management
  Table management
  Adding columns to a table
  Deleting columns from a table
  Deleting a table
• INTRODUCTION TO SQL
  Selecting and Retrieving Data
  Creating a SELECT statement to retrieve data
  Using DISTINCT to display unique values in a column
  Using the AS keyword to create an alternate name for a column
  Merging columns
• INTRODUCTION TO SQL
  Filtering Data
  Creating a WHERE clause
  Using comparison, character, and logical operators to match conditions
  Using the IN operator to match a condition
  Using the BETWEEN operator to match a condition
• INTERMEDIATE SQL
  Creating Calculated Fields and using Aggregate Functions
  Structured Query Language Review
  Creating calculated fields
  Concatenating columns
  Using aggregate functions
• INTERMEDIATE SQL
  Using Clauses in Structured Query Language
  Using the ORDER BY clause
  Using the GROUP BY clause
  Using the GROUP BY clause and WHERE clause
  Using the HAVING clause
• INTERMEDIATE SQL
  Creating Table Joins
  Creating Inner joins
  Creating Outer joins
  Creating Self joins
• INTERMEDIATE SQL
  Creating Subqueries
  Creating subqueries
  Creating subqueries that contain calculated fields
  Creating subqueries that contain aggregate functions
• ADVANCED SQL
  Creating Advanced Subqueries
  Structured Query Language Review
  Using the IN keyword to link queries
  Using the EXISTS keyword to link queries
  Using the ANY keyword to link queries
  Using the ALL keyword to link queries
• ADVANCED SQL
  Creating Advanced Joins
  Creating inner joins review
  Creating outer joins review
  Creating joins with aggregate functions
  Creating nested joins
• ADVANCED SQL
  Creating Union Queries
  Creating UNION queries
  Creating UNION ALL queries
  Creating a WHERE clause and multiple UNION queries
• ADVANCED SQL
  Transaction Processing, Stored Procedures, Triggers
  Implementing transaction processing
  Implementing stored procedures
  Implementing triggers

How to register

This course is offered as part of a VCC program only.

Contact us

If you have any question, please email at advising@vcc.ca.

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.