Live in-person instructors      Always guaranteed to run      Customizable objectives   

Book SQL Training

Book SQL training for yourself or for your team! We offer three different SQL classes – see below for each outline.
SQL Basics

Designed for:
This course is designed for application developers who work in any relational database environment, including Oracle, Sybase, SQL Server, Access, DB2, Ingres, Informix and many others.

Goals:
  • Write SQL SELECT statements, including all allowable WHERE expressions, sorting, functions joins and subqueries.
  • Write INSERT, UPDATE and DELETE statements.
Upcoming Classes:
  • August 29-31, 2022 10am to 5pm EST
  • January 9-11, 2023 10am to 5pm EST
  • May 1-3, 2023 10am to 5pm EST
SQL Intermediate

Designed for:
This course is designed for application developers.

Goals: By the end of the training, you’ll be able to:
  • Sample a very large database to have accurate knowledge of the structure and contents
  • Use several tools to monitor and possibly improve the performance of complex queries on large databases, including using the query execution plan, optimizer hints, and other tools
  • Know when and how to use temporary tables, query-scope tables, Common Table Expressions, and subqueries of various types to solve complex problems
  • Summarize data, including handling missing values, creating pivot reports using Pivot or Case logic, using Rollup and Cube, and using basic analytic (OLAP) functions
Upcoming Classes:
  • September 1 & 2, 2022 10am to 5pm EST
  • January 12 & 13, 2023 10am to 5pm EST
  • May 4 & 5, 2023 10am to 5pm EST
SQL Advanced

Designed for:
This course is designed for application developers.

Goals: By the end of this training, you’ll be able to:
  • Understand basic relational database design principles and how tables and other objects are created and maintained
  • Use a wide variety of tools and techniques to improve performance of complex queries on large databases
  • Follow best practices to improve security of data
  • Create and manage complex views and handle updating of views, the Check Option, materialized views, and virtual columns
  • Create and manage indexes, including knowing when to create and when not to create indexes, and the use of partitioning, clustering, filtered, full-text, and other types of indexes
  • Create stored procedures, including the use of required and optional parameters, variables, conditional statements, looping, cursors, exception handling, transactions, and debugging
  • Create user-defined functions, including the use of parameters, and all language features; create scalar and table functions and understand the differences between table functions, stored procedures, and views
  • Create triggers, including table, database and server triggers, before, instead of, and after triggers, handling various events, using the "transition" data involved, and dealing with transaction issues
Upcoming Classes:
  • May 24 & 25, 2022 10am to 5pm EST
  • September 6 & 7, 2022 10am to 5pm EST
  • December 19 & 20, 2022 10am to 5pm EST
Booking training for your company? Learn more about how we can help Managers, HR Professionals and IT Departments.
It’s hard to know which platform you should use for your database. This free webinar will explore your options and explain when to use each platform. Finally, we will show you the potential in a properly created database.

With our SQL Training you can learn to...

  • Work Efficiently
    • Add, update and delete rows of data with SQL
    • Quickly generate tables and other database projects
    • Retrieve or update data from a database within minutes
  • Work Effectively
    • Retrieve information from a database for analytics
    • Easily manage large amounts of data
    • Know when to amend the meeting agenda and why
  • Work Brilliantly
    • Set permissions on tables, procedures, and views
    • Create new databases or new tables in a database
    • Quickly update or delete records from your database
  • And More!

Professional SQL Training That Sets You Apart

Sign up now for our SQL courses to help you:
  • Develop and maintain complex database and information solutions
  • Define data in your database and manipulate that data
  • Allow members of your team to access data in the relational database management systems
  • And so much more…

Why You Need It

SQL training will help you organize and manage large amounts of data.

  • Unsure how to set permissions on tables, procedures and views?
  • Want to learn how to create and drop databases and tables?
  • Need to store, extract and organize large amounts of data?
Our SQL training is the perfect solution for you.

Available With These Courses

Your course comes with the following

Workbook

A workbook will be sent to you prior to the start of training

Person

Real time support: Ask your instructor any questions in a small classroom experience. Feel free to give permission to your instructor to view your computer for additional assistance

Certificate

You will receive a Certificate of Completion after your session

How You’ll Learn

Learn from anywhere! Your training will be hosted online via Zoom. You don’t have to travel and can attend from your home, office or anywhere with an internet connection. 

You’ll learn from experienced expert trainers in your live training. Feel free to ask questions throughout your interactive hands-on learning experience.

Why Learn With Us

Protech is partnered with The Great Canadian Training & Consulting Company to offer expert training that will help you both personally and professionally.

Protech’s training is taught live, by expert and experienced trainers. You can ask for real time feedback and have the time to ask questions throughout the session.

Contact us today to book your SQL training!