There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
In this introductory SQL Programming training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. It will describe the standard language, but also identify deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. In this SQL training, you will choose between working with the PostgreSQL database product or Microsoft SQL Server as you practice these skills with the hands-on exercises. The ability to write the SQL language - the cornerstone of all relational database operations - is essential for anyone who develops database applications. Attend the three-day instructor-led course and learn to leverage all that the SQL language has to offer.
View the SQL Learning Path to determine your learning journey ›
BLENDED LEARNING
Unlimited annual access to:
Standard $1090/Year USD
Government $1090/Year USD
ADD TO CARTPRODUCT #70A8
LIVE, INSTRUCTOR-LED
PREMIUM TRAINING
Unlimited annual access to:
Standard $2450/Year USD
Government $2450/Year USD
ADD TO CARTPRODUCT #70A9
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
This product offers access to a library of Microsoft on-demand courses including SQL, Windows, Exchange, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Writing SQL Queries (4551).
You'll be able to register for a Training Review Session at any time after you've placed your order.
No specific experience is required.
No. While many of the same points are covered, taking the instructor-led Introduction to SQL Programming course provides the deepest dive into that area. This offering is intended for those who wish to gain a broad knowledge of the topics described in the course outline above - including SQL.
An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrollment period.
You will get access 19 pre-configured lab bundles spanning the Microsoft curriculum.
17 practice exams spanning the Microsoft curriculum are included
Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.
Once you are enrolled in the program, specific details and dates will be sent to you.
No. This course was designed to teach you the fundamentals of the SQL language. You will learn SQL over 3 days with instructor-led training and hands on experience using either the PostgreSQL database product or Microsoft SQL Server 2016.
SQL is the standard language for relational database management systems. Your ability to produce good database applications will be highly dependant on your knowledge of SQL.
Oracle and Microsoft SQL Server are both types of relational database management systems. Although all relational database management systems use SQL, unfortunately, different products have different dialects of SQL. One of the benefits of taking this course is that it will cover all of the topics using product-specific features of the latest versions of both Oracle and Microsoft SQL Server.
May 19 - 21
9:00 AM - 4:30 PM MDT
Online (AnyWare)
Jun 16 - 18
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Aug 4 - 6
9:00 AM - 4:30 PM PDT
San Francisco / Online (AnyWare)
Aug 25 - 27
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Sep 15 - 17
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Oct 13 - 15
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare)
Nov 17 - 19
9:00 AM - 4:30 PM MST
Aurora / Online (AnyWare)
Dec 15 - 17
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Jan 26 - 28
9:00 AM - 4:30 PM PST
San Francisco / Online (AnyWare)
Feb 23 - 25
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Mar 16 - 18
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.In this training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This course describes the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. For the hands-on exercises, the course environment allows the students to choose between working with the PostgreSQL database product or Microsoft SQL Server. This SQL Class includes 17 hours of Instructor-Led Training (ILT) or Virtual Instructor-Led Training (VILT) presented by a real-world SQL expert instructor.
For the hands-on exercises, the course environment allows the students to choose between working with PostgreSQL database product or Microsoft SQL Server.
This course offers you the opportunity to earn the following industry credits and certifications
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
Creating tables and columns
Protecting data integrity with constraints
Improving performance with indexes
Modifying table contents
Applying transactions
Writing Single Table queries
Restricting rows with the WHERE filter
Applying the ANSI/ISO standard join syntax
Combining results with set operators
Processing data with row functions
Performing analysis with aggregate functions
Applying subqueries in filter conditions
Including subqueries in expressions
Breaking down complex problems
Creating views in a database
No. This course was designed to teach you the fundamentals of the SQL language. You will learn SQL over 3 days with instructor-led training and hands on experience using either the PostgreSQL database product or Microsoft SQL Server 2016.
SQL is the standard language for relational database management systems. Your ability to produce good database applications will be highly dependant on your knowledge of SQL.
Oracle and Microsoft SQL Server are both types of relational database management systems. Although all relational database management systems use SQL, unfortunately, different products have different dialects of SQL. One of the benefits of taking this course is that it will cover all of the topics using product-specific features of the latest versions of both Oracle and Microsoft SQL Server.
This product offers access to a library of Microsoft on-demand courses including SQL, Windows, Exchange, and more. At any time during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Writing SQL Queries (4551). Enrolling in this bundle also grants you access to any of our multi-day Introduction to SQL Programming (925) course events.
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
May 19 - 21 9:00 AM - 4:30 PM MDT Online (AnyWare)
Jun 16 - 18 9:00 AM - 4:30 PM EDT Online (AnyWare)
Aug 4 - 6 9:00 AM - 4:30 PM PDT San Francisco / Online (AnyWare)
Aug 25 - 27 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare)
Sep 15 - 17 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare)
Oct 13 - 15 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare)
Nov 17 - 19 9:00 AM - 4:30 PM MST Aurora / Online (AnyWare)
Dec 15 - 17 9:00 AM - 4:30 PM EST New York / Online (AnyWare)
Jan 26 - 28 9:00 AM - 4:30 PM PST San Francisco / Online (AnyWare)
Feb 23 - 25 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare)
Mar 16 - 18 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare)
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.No specific experience is required.
No. While many of the same points are covered, taking the instructor-led Introduction to SQL Programming course provides the deepest dive into that area. This offering is intended for those who wish to gain a broad knowledge of the topics described in the course outline above - including SQL.
Once you are enrolled in the program, specific details and dates will be sent to you.
An outline of the content you will receive can be seen above. You will also get access to any new on-demand content that becomes available during your annual enrollment period.
You will get access 19 pre-configured lab bundles spanning the Microsoft curriculum.
17 practice exams spanning the Microsoft curriculum are included
Once payment is received, you will receive an email from Learning Tree with all the links and information you need to get started.
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
You'll be able to register for a Training Review Session at any time after you've placed your order.
Brian V. - Statistical Reports Analyst, Federal reserve Bank of Chicago
“Great course - extremely satisfied. Can't wait to bring what I learned back to my job and apply it!”
Nana U. - Elderplan
“Comprehensive and is general enough that it can be applied to a number of situations.”
Cheyney A. - NGA
“I thought it was really well run -- and the class length was good. Not long enough to be overwhelming, but long enough to gain an intro understanding of the program. I came in with VERY little SQL experience, and I feel like I learned quite a bit in the 3 days without being bombarded with too much information.”
Melissa M. - Jr. Systems Administrator, Loudoun County Treasurer's Office
“First time here at Learning Tree Courses - LOVED the experience.”
Christina G. - Solution Architect, Automotive Resources International
“Better than I expected. I learned a lot, the instructor was engaging and the tech worked well.”
Relational Database Design Training: Tools and TechniquesSQL Server with Management Studio Training
Questions about which training is right for you?
It allows us to direct your request to the appropriate Customer Care team.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.