Cart 0

Advanced SQL Course
Course 929
3 DAY COURSE

Price:
Course Outline

SQL is the cornerstone of all relational database operations. In this hands-on Writing Advanced SQL Queries course, you will learn how 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.

Attend this Writing Advanced SQL Queries training in one of three formats - live, instructor-led, on-demand or a blended on-demand/instructor-led version.

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

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 Powerful SQL Queries for SQL Server (4559).

Course Dates

For course questions or any customer service inquiry, please contact your Customer Service team at BAHCustomerService@LearningTree.com.

We are excited that Learning Tree now offers a deferred direct bill payment option for Booz Allen employees. The deferred direct bill payment option enables employees to enroll in learning opportunities with no upfront costs. This payment option will require the employee to sign a Family Educational Rights and Privacy Act (FERPA) agreement with Learning Tree to release grades/completion to Booz Allen to satisfy the FlexEd Program completion requirement. Note, Learning Tree may also be used for the FlexEd Program reimbursement payment option.

Attendance Method
Additional Details (optional)

Private Team Training

Interested in this course for your team? Please complete and submit the form below and we will contact you to discuss your needs and budget.