Image
Overview
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.
Please email STTCE@fanshawec.ca or call 519-633-2030 to ensure your email is accurate to obtain access to this course.
Please note this is not a Fanshawe Certificate or course. Ensure your contact information is up to date on Web Advisor. This course runs asynchronously online and is offered in partnership with LERN and UGotClass. Once completed you will obtain a LERN certificate.
Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
This Certificate must be taken in the following order:
1. Introduction to SQL
Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.
2. Intermediate SQL
Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.
3. Advanced SQL
Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision-making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.
For each Unit, you will:
- Access the online readings
- Listen to the audio presentation for the Unit and view the slides
- Take a self-quiz to see how much you have learned
- Engage in written online discussion with your instructor and other participants
For best learning, you should make one or more comments at 2-3 different times each day.
The content (readings, audio lectures, slides) and self-quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.
Course Code:
COMP-9744
Area of Interest:
Computers, Design, and Media
Prerequisites:
Credential:
Course Offerings
Summer 2025
to
$814.00
Delivery:
Online
Location:
St. Thomas
Days & Times:
Section Number:
65ST
Refund Policy:
7 days after course start date
Course Details
More details
Download the Part-time Studies Guide
What's included:
- How to assess if part-time learning is right for you
- Part-time learning options and the differences between each
- How to pay for your part-time education
- Part-time options within your area of interest
- How to sign up for part-time studies and where to get help