Writing Advanced SQL Queries is unfortunately unavailable

Thankfully we have 4 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

Questions about this class?
Get help now from a knowledge expert!

Writing Advanced SQL Queries

at Learning Tree International - Herndon

Course Details
Price:
$2,650
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Herndon
13650 Dulles Technology Dr Ste #175
At Sunrise Valley Dr
Herndon, Virginia 20171
(Map)
Share:
Important:
Course 929
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 16

What you'll learn in this sql class:

SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation.

The course describes the ANSI/ISO SQL standard, but also identifies deviations from the standard in the two most widely used database products, Oracle and Microsoft SQL Server.

You Will Learn How To
  • Maximize the potential of SQL to build powerful, complex and robust SQL queries
  • Query multiple tables with inner joins, outer joins and self joins
  • Construct recursive common table expressions
  • Summarize data using aggregation and grouping
  • Execute analytic functions to calculate ranks
  • Build simple and correlated subqueries
  • Thoroughly test SQL queries to avoid common errors
  • Select the most efficient solution to complex SQL problems

Who Should Attend:
Those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries.

Recommended Experience:
This is an advanced course and knowledge of the basics of SQL at the level of Introduction to SQL Programming Training or equivalent is assumed.


Course Outline
  • Introduction and Overview
  • Querying Multiple Tables
  • Aggregate Functions
  • Performing Extensive Analysis with Analytic Functions
  • Building Subqueries
  • Breaking Down Complex Queries

Still have questions? Ask the community.

Refund Policy
If a customer would like to cancel or transfer their course, they must notify Coursehorse prior to two weeks before the start date of the course or within seven days of registration. On-Demand Courses cannot be cancelled once purchased and are not eligible for refund.

If a customer transfers to another course prior to two weeks before the start date or within seven days of registration of the course in which originally enrolled, 100% of any prepaid course tuition will be applied toward the course tuition for the subsequent course.

If a customer needs to cancel an enrollment two weeks prior to the start of the class or within seven days of registration, we will refund 100% of any prepaid course tuition for that enrollment.

If a customer does need to transfer or cancel a course within two weeks of the start date of the course or after seven days from the date of registration, a fee equal to 50% of the price of the course will be assessed for any standard attendances. Attendances associated with a Learning Tree program will be assessed a $500 fee. Training Passports, Training Vouchers and Pay-As-You-Learn Vouchers cannot be used after their expiration dates, and a course cancellation or transfer by the customer will not extend a Training Passport, Training Voucher Pack or Pay-As-You-Learn Voucher Pack expiration date.

Map

Google Map

Learning Tree International

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 26500 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: Learning Tree International

Learning Tree International

Established in 1974, Learning Tree International is a leading provider of IT training and management training to business and government organizations worldwide. In addition, Learning Tree provides IT Workforce Optimization Solutions – a modern approach that improves the adoption of skills, and accelerates...

Read more about Learning Tree International

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified DC educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

4 Top Choices

SQL Querying: Advanced

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle...

Monday Nov 4th, 10am - 5pm

SQL Bootcamp

at General Assembly - Penn Quarter 509 7th St NW 3rd Fl, Washington, District of Columbia 20004

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways  -...

Saturday Nov 9th, 10am - 5pm

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

SQL Querying: Basic

at Certstaffix Training - Largo 1300 Caraway Ct Ste 200, Largo, Maryland 20774

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but...

Tuesday Dec 10th, 10am - 5pm

  (2 sessions)
$990

2 sessions