Automating Administration with PowerShell
Microsoft Office Excel Level 1
Microsoft Office Excel Level 2
Microsoft Office Excel Level 3
Data List Management
Microsoft Office Excel Level 4
Spreadsheet Analysis
Microsoft Office Excel Level 5 VBA Macros
Microsoft SharePoint Course for End Users
Microsoft Office Powerpoint Level 1
Microsoft Office Powerpoint Level 2
Microsoft Office Outlook Level 1
Microsoft Office Outlook Level 2
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]
