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
Course code: LERN 2000
Credits: 0.0
Tuition: $0*
Length: 48.0 hours
Course outline:
view
https://www.vcc.ca/vccphp/courseoutline?subject=LERN&number=2000

0
Additional Information
- 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 do I apply for this course?
This course is offered as part of a VCC program only.
* Fees are approximate and subject to change. Students are required to pay any applicable fee increases. Fees listed are for domestic students. For international programs, visit VCC International.
† 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.
Facebook
Twitter
Instagram
YouTube
Flickr
RSS
More accounts