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
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
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
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
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]
Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for Essential SQL Training is designed to help users understand the most common language for database wrangling, SQL.
All the lessons have been recorded in SQLite Studio, an intuitive and easy-to install database manager. Our instructors provide all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using sub selects and views. We offer a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real world example of building a simple application using SQL.
81 Courses
0 students
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!
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.
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.