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:
LIVE, INSTRUCTOR-LED
PREMIUM TRAINING
Unlimited annual access to:
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 indented 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.
Dec 18 - 20 9:00 AM - 4:30 PM EST New York / Online (AnyWare) Reserve Your Seat
Jan 29 - 31 9:00 AM - 4:30 PM EST Toronto / Online (AnyWare) Reserve Your Seat
Feb 5 - 7 9:00 AM - 4:30 PM EST Rockville, MD / Online (AnyWare) Reserve Your Seat
Feb 19 - 21 9:00 AM - 4:30 PM PST San Francisco / Online (AnyWare) Reserve Your Seat
Feb 26 - 28 9:00 AM - 4:30 PM CST Austin / Online (AnyWare) Reserve Your Seat
Mar 4 - 6 9:00 AM - 4:30 PM MST Denver / Online (AnyWare) Reserve Your Seat
Mar 11 - 13 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
Mar 18 - 20 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
Mar 25 - 27 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Reserve Your Seat
Apr 1 - 3 9:00 AM - 4:30 PM EDT Alexandria, VA / Online (AnyWare) Reserve Your Seat
May 13 - 15 9:00 AM - 4:30 PM MDT Denver / Online (AnyWare) Reserve Your Seat
May 20 - 22 9:00 AM - 4:30 PM PDT Seattle / Online (AnyWare) Reserve Your Seat
Jun 17 - 19 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
Jun 24 - 26 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare) Reserve Your Seat
Jul 8 - 10 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare) Reserve Your Seat
Jul 29 - 31 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare) Reserve Your Seat
Aug 12 - 14 9:00 AM - 4:30 PM PDT San Francisco / Online (AnyWare) Reserve Your Seat
Aug 26 - 28 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare) Reserve Your Seat
Sep 2 - 4 9:00 AM - 4:30 PM CDT Austin / Online (AnyWare) Reserve Your Seat
Sep 16 - 18 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
Sep 30 - Oct 2 9:00 AM - 4:30 PM EDT Alexandria, VA / Online (AnyWare) Reserve Your Seat
Nov 4 - 6 9:00 AM - 4:30 PM PST Seattle / Online (AnyWare) Reserve Your Seat
Nov 18 - 20 9:00 AM - 4:30 PM MST Denver / Online (AnyWare) Reserve Your Seat
Dec 2 - 4 9:00 AM - 4:30 PM EST Washington, DC / Online (AnyWare) Reserve Your Seat
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, location — 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.
Dec 18 - 20 9:00 AM - 4:30 PM EST New York / Online (AnyWare)
Jan 29 - 31 9:00 AM - 4:30 PM EST Toronto / Online (AnyWare)
Feb 5 - 7 9:00 AM - 4:30 PM EST Rockville, MD / Online (AnyWare)
Feb 19 - 21 9:00 AM - 4:30 PM PST San Francisco / Online (AnyWare)
Feb 26 - 28 9:00 AM - 4:30 PM CST Austin / Online (AnyWare)
Mar 4 - 6 9:00 AM - 4:30 PM MST Denver / Online (AnyWare)
Mar 11 - 13 9:00 AM - 4:30 PM EDT New York / Online (AnyWare)
Mar 18 - 20 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare)
Mar 25 - 27 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare)
Apr 1 - 3 9:00 AM - 4:30 PM EDT Alexandria, VA / Online (AnyWare)
May 13 - 15 9:00 AM - 4:30 PM MDT Denver / Online (AnyWare)
May 20 - 22 9:00 AM - 4:30 PM PDT Seattle / Online (AnyWare)
Jun 17 - 19 9:00 AM - 4:30 PM EDT New York / Online (AnyWare)
Jun 24 - 26 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare)
Jul 8 - 10 9:00 AM - 4:30 PM EDT Toronto / Online (AnyWare)
Jul 29 - 31 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare)
Aug 12 - 14 9:00 AM - 4:30 PM PDT San Francisco / Online (AnyWare)
Aug 26 - 28 9:00 AM - 4:30 PM EDT Herndon, VA / Online (AnyWare)
Sep 2 - 4 9:00 AM - 4:30 PM CDT Austin / Online (AnyWare)
Sep 16 - 18 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare)
Sep 30 - Oct 2 9:00 AM - 4:30 PM EDT Alexandria, VA / Online (AnyWare)
Nov 4 - 6 9:00 AM - 4:30 PM PST Seattle / Online (AnyWare)
Nov 18 - 20 9:00 AM - 4:30 PM MST Denver / Online (AnyWare)
Dec 2 - 4 9:00 AM - 4:30 PM EST Washington, DC / 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, location — 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 indented 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.
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
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.