custom code gtranslate code

Essential SQL Training

Course Outlines

Module 1: Introduction
✓ Installation: Installing on Windows/Mac

Module 2: SQL
✓ About SQL
✓ Database Organization
✓ Select: Rows, Columns
✓ Counting Rows
✓ Inserting Data
✓ Updating Data
✓ Deleting Data

Module 3: Fundamental Concepts
✓ Creating Tables
✓ Deleting A Table
✓ Deleting Row
✓ The Null Value
✓ Constraining Columns
✓ Changing a Schema
✓ ID Columns
✓ Filters Data
✓ Removing Duplicates
✓ Ordering Output
✓ Conditional Expressions

Module 4: Relationships
✓ Understanding JOIN
✓ Accessing related tables
✓ Relating Multiple tables

Module 5: String
✓ About SQL Strings
✓ Strings: Length of string and finding the length, Selecting part of a string, Removing space, Folding case

Module 6: Numbers
✓ Numeric Types
✓ Types of Values
✓ Integer Division
✓ Rounding Numbers

Module 7: Data and Time
✓ Date and Times
✓ Functions related

Module 8: Aggregates
✓ What are aggregates
✓ Using Functions
✓ DISTINCT values

Module 9: Transactions
✓ What are Transactions
✓ Data integrity
✓ Performance

Module 10: Triggers
✓ Automating Data Triggers
✓ Preventing Updates

Module 11: Views and Subselects
✓ Crating a subselect
✓ Searching within results set
✓ Creating a view
✓ Creating a joined view

Module 12: Simple CRUD Application
✓ Embedding SQL
✓ SELECT Functions
✓ INSERT,UPATE, and DELETE functions

What you'll learn

Upon completion of this course the successful student will:
✓ How databases are organized
✓ Selecting rows and columns
✓ Creating new tables
✓ Inserting and updating data
✓ Sorting and filtering
✓ Accessing related tables with JOIN
✓ Working with strings
✓ Understanding numeric types
✓ Using aggregate functions and transactions
✓ Automating data with triggers
✓ Creating views
✓ Using CRUD function

Course Content

Upon completion of this course the successful student will:
✓ How databases are organized
✓ Selecting rows and columns
✓ Creating new tables
✓ Inserting and updating data
✓ Sorting and filtering
✓ Accessing related tables with JOIN
✓ Working with strings
✓ Understanding numeric types
✓ Using aggregate functions and transactions
✓ Automating data with triggers
✓ Creating views
✓ Using CRUD function

Customize a Course

We will be happy to assist you for inquiries about a customized scheduled or program:
Rachael McPherson, Director of Sales
☎(250)882-9549 📧[email protected]
Caroline Santos, Corporate and Custom Sales Manager- Eastern Canada
☎(514)771-3206 📧[email protected]

Course Info

Prerequisites
Computer Skills
Duration
15 Hours

Enroll Now

For Group Class Options

Enroll Now

For Corporate and Funding Agencies

You may also like

popup and lms tutor hidden code
X
Customize A Course
We will be happy to assist you for inquiries about a customized scheduled or program:
Caroline Santos
Corporate and Custom Sales Manager
(Eastern Canada)
Phone Number

Send your feedback

Phone Number

Request for Instructor Info

Phone Number

Become A Program Partner

Q Academy works with the most innovative, sustainable industries and we continue to review all the major skills gaps across the globe. We’re looking for industry leaders and academic partners to help us create courses for upgrading skills within growing sectors across globe. We’d love to work with you to build something great!

Phone Number

Become A Hiring Partner!

Phone Number

With so many companies looking for great talent why not look take your needs directly to Q Academy and ensure your candidates have all the most update skills they need. Hire Great Talent without the high costs of some job search platforms or services.

Become a Training Partner!

Q Academy works with thosands of business across the globe and we have become several business go to training partners for the past 5 years.

Phone Number

Inquire Now

Phone Number

Log in
Login / Signup