Discover Classes. Earn Rewards.
SQL Querying: Advanced is unfortunately unavailable

Thankfully we have 4 other Tech 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!

SQL Querying: Advanced

at Certstaffix Training - Green HIlls

(116)
Course Details
Price:
$495
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:
Green HIlls
4235 Hillsboro Pike Green Hills Office Ste 300
At Castleman Dr
Nashville, Tennessee 37215
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 3

What you'll learn in this sql class:

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.

Knowledge Pre-Requisites:
  • SQL Querying - Basic
Course Lessons:

Building on Subqueries, Common Table Expressions, and Unions
Using Derived Tables and Common Table Expressions
Using Derived Tables
Using Common Table Expressions
Using a Common Table Expression to Solve a Complicated Join Problem
Thinking About Performance

Advanced Joining Tables
Merge Join
Nested Loop
Hash Match

Advanced WHERE Clauses
Pattern Matching
Using LIKE
Restricting the Characters in Pattern Matches
Searching for Wildcards
Combining Wildcards
Using PATINDEX
Using WHERE Clauses with Three or More Predicates
Using NOT with Parentheses
Performing a Full-Text Search

Writing Advanced Queries
Advanced CTE Queries
Alternate CTE Syntax
Using Multiple CTEs
Referencing a CTE Multiple Times
Joining a CTE to Another CTE
Writing a Recursive Query
Data Manipulation with CTEs
Isolating Aggregate Query Logic
Correlated Subqueries in the SELECT list
Using Derived Tables
Common Table Expressions
Using CROSS APPLY and OUTER APPLY
The OUTPUT Clause
Using OUTPUT to View Data
Saving OUTPUT Data to a Table
The MERGE Statement
GROUPING SETS
CUBE and ROLLUP
Pivoted Queries
Pivoting Data with CASE
Using the PIVOT Function
Using the UNPIVOT Function
Paging
School Notes:
Important:
Courseware (if a course has a Courseware) will be shipped to the address provided two weeks before the class starts. Make sure that the additional info field is properly and correctly filled out to avoid Courseware being lost in transit. Please also note that P.O. Box addresses are not allowed.


The classes are instructor-led live training you attend in a local classroom or from your home/office. Our instructors teach from a remote location while being able to interact with students as in a traditional classroom setting.

Instructors can view student progress and take control of their PC to provide direct assistance. Students can see the instructor's presentation as well as voice questions directly to the instructor and participate in class discussions.

Still have questions? Ask the community.

Refund Policy
You can cancel or reschedule your registration without penalty or charge provided you give notice of 10 business days (M-F) or more days before the start of my class.

If you request to cancel or reschedule your registration 10 Business Days (M-F) or less days before the class start you will be charged 100% the course fee and will not be entitled to a refund. You have one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

You cannot change your class location ten (10) Business days (M-F) or less before the class start because Certified Staffing Solutions has shipped training materials and provisioned resources. Location changes requested prior to that timeframe are subject to availability and may incur an additional charge.

Should Certified Staffing Solutions need to cancel your class due to insufficient enrollment, or postpone it due to events beyond their control, Certified Staffing Solutions will notify you as soon as possible. In such cases, you may reschedule to a future class date at no additional charge or receive a refund for any money on account relating to that registration.

Travel arrangements and costs are the sole responsibility of the student. Certified Staffing Solutions suggests obtaining refundable reservations. Certified Staffing Solutions classes are confirmed approximately 14 days before the start of the class. We cannot guarantee class commitments before that window of time. Certified Staffing Solutions will not be responsible for any cancellation costs incurred, including but not limited to, airline/mass transit tickets, hotel reservations and so on.

Map

Google Map

Certstaffix Training

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!

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 4950 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.

Reviews of Classes at Certstaffix Training (24)

School: Certstaffix Training

Certstaffix Training

Certified Staffing Solutions specializes in providing computer training and instructors nationwide. Our instructors are professional trainers and utilize hands-on exercises to reinforce lecture. Each averages more than 5 years delivering classes to business professionals.

Our Advantages

  • Our Instructors:...

Read more about Certstaffix Training

CourseHorse Approved

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

Want to take this class?

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

4 Top Choices

Certified Scrum Master(CSM)

at MSys Training - West End Park 3102 West End Ave Ste 400, Nashville, Tennessee 37203

A ScrumMaster is the lifeline of an Agile project, removing roadblocks and facilitating processes, working with the Product Owner and the team to ensure that the values and practices of Scrum are followed. The Certified ScrumMaster course helps you gain a high degree of proficiency in the processes of the Scrum Methodology. Agenda: General Knowledge...

Thursday Oct 24th, 9am - 5pm

  (2 sessions)
$1,299

2 sessions

PMI-ACP

at PanLearn - Elm Hill Acres 555 Marriott Dr Ste 315, Nashville, Tennessee 37214

The PMI Agile Certified Practitioner (PMI-ACP®) is designed to identify your skills with agile techniques and knowledge of agile principles. This PMI-ACP certification helps you to shine brighter to your employers, peers and stakeholders. The PMI-ACP course is one of the fastest growing PMI online certifications. Highly agile companies are likely...

Tuesday Oct 29th, 9am - 5pm

  (3 sessions)
$1,899

3 sessions

PMI Agile Certified Practitioner (PMI-ACP)

at MSys Training - West End Park 3102 West End Ave Ste 400, Nashville, Tennessee 37203

The PMI Agile Certified Practitioner (PMI-ACP®) is designed to identify your skills with agile techniques and knowledge of agile principles. This MSys PMI-ACP certification helps you to shine brighter to your employers, peers and stakeholders. The PMI-ACP course is one of the fastest growing PMI online certifications. Highly agile companies are likely...

Wednesday Oct 30th, 9am - 5pm

  (3 sessions)
$1,899

3 sessions

ITIL® Foundation

at MSys Training - West End Park 3102 West End Ave Ste 400, Nashville, Tennessee 37203

Our ITIL Foundation® and Certification course material is designed by ITIL master instructors to ensure that participants pass the ITIL® Foundation certification exam. MSys ITIL certification training makes participants familiar with ITIL framework which is a source of good practice in IT service management. Our hands-on training helps participants...

Thursday Oct 31st, 9am - 5pm

  (2 sessions)
$1,699

2 sessions

Loading...