SQL Querying - Advanced Course Outline | Certstaffix® Training

SQL


SQL Querying - Advanced Course


Attend Our Classes From Home - No Software Needed - Learn More...

SQL Querying - Advanced

by Certstaffix® Training

SQL Query Training

Length: 1 day(s)      Public Class Price: $495/person (USD)      Group Class Price: Request Quote      Course Category: SQL


SQL Training
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 or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.
Course Description: Print It | Download PDF | Email It

Certstaffix® Training public classes are instructor-led, live online training you attend from your location or our training labs. Our live online instructors teach you from a remote location while being able to interact with students as in a traditional classroom setting.

  • A real, live instructor teaching you from another location
  • Hands-on learning with the software/skills you are being taught
  • Interaction with all students in the class at other locations
  • Any needed software for class provided in online lab environment
  • Easy assistance from the instructor
  • Attend from your location or our training labs

 Register ➥   April 1, 2022     
 Register ➥   May 19, 2022     
 Register ➥   June 24, 2022     

Group Onsite Training
At Your Organization

OR

Private Online Training
Live Online Instruction

Have a group of several students needing the same training? Then onsite or private online group training is a perfect option for you. We'll either come onsite to your office or deliver a private live online class so you don't have to travel. You'll be able to fully customize a course to your needs. Lastly, you can save per student versus our public classes.


  • An expert Instructor will either come to your office or deliver a private live online class to your students
  • Course can be fully customized to your training needs
  • Course is scheduled based on dates you provide (Subject to instructor availability)

SQL Training Reviews by Certstaffix® Training

Certstaffix® Training collects detailed class reviews via a formal post-class evaluation in all our instructor-led courses. Below are a sample of abbreviated reviews from real students from our past classes. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Certstaffix® Class Reviews

Student Average:
4.77 out of 5 from 254 students

4.73 out of 5

Wonderful content and instructor. Sheila also assisted me in getting scheduled for the class.I would highly recommend!


- attended our SQL Querying - Basic class

4.71 out of 5

Try to reference the the text more, we did not seem to use the text at all


- attended our SQL Querying - Basic class

4.95 out of 5

This was the best virtual training class I have taken. Instructor kept everyone involved and could tell if anyone was struggling. It required everyone to keep up with the class as if they were in the classroom.The only thing I would say is that I didn't feel this was "Advanced" material. The concepts that were in this class should already be known if you're taking an advanced SQL class. Wish there was a more advanced class maybe more stored procedure driven?


- attended our SQL Querying - Advanced class

4.66 out of 5

This was the best course that I have taken online. Very organized and professionally managed.


- attended our SQL Querying - Basic class

4.41 out of 5

This is the second SQL course I've taken with Serge Belich. He does a great job of explaining the database logic as well as how the topics can be applied in the real world. Serge starts with basic syntax then increases the complexity so you understand how each step impacts the end result. The course is engaging and extremely hands on. I was very pleased with the course and instructor - would definitely recommend to others!


- attended our SQL Querying - Advanced class

5.00 out of 5

This is my second course through Certstaffix and I would gladly sign up for others in the future.


- attended our SQL Querying - Advanced class

4.82 out of 5

This class was great and I feel confident that I can use most of what I have learned in my work environment! I think it would have helped if there was a short summary/review in the beginning to differentiate functions, statements, commands, etc. I still don't understand why some are blue or pink and why some need parenthesis while others don't. However, I have a feeling that with practice and reviewing the manual, I will catch on to the trend and figure this out.


- attended our SQL Querying - Basic class

5.00 out of 5

The SQL Query for beginners course was great. The teacher did a wonderful job in balancing between allowing the students to work on the queries by themselves and stepping in to assist. Also great sense of humor and very willing to answer any questions along the way. Definitely would recommend Cerstaffix.


- attended our SQL Querying - Basic class

4.63 out of 5

The presenter was awesome.


- attended our SQL Querying - Basic class

4.85 out of 5

The only issue I had was I already knew much of the material. Otherwise it was a really good course.The instructor was excellent!


- attended our SQL Querying - Basic class



  Detailed Course Topics

Course Description: Print It | Download PDF | Email It

Knowledge Pre-Requisites


Course Topics

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
Course Description: Print It | Download PDF | Email It

SQL Courses By City:

AL - Birmingham       GA - Columbus       NC - Raleigh       RI - Providence      
AL - Huntsville       GA - Savannah       NC - Winston-Salem       SC - Greenville      
AL - Mobile       HI - Honolulu       ND - Fargo       SC - Myrtle Beach      
AR - Bentonville       IA - Des Moines       NE - Lincoln       SC - North Charleston      
BC - Vancouver       IA - Iowa City       NE - Omaha       SD - Sioux Falls      
CA - Bakersfield       ID - Boise       NH - Bedford       SK - Regina      
CA - Fresno       IL - Chicago       NJ - Bridgewater       SK - Saskatoon      
CA - Los Angeles       IN - Fort Wayne       NM - Albuquerque       TN - Chattanooga      
CA - Modesto       IN - Indianapolis       NS - Halifax       TN - Knoxville      
CA - Oakland       KS - Topeka       NV - Henderson       TN - Memphis      
CA - Oxnard       KY - Lexington       NV - Reno       TN - Nashville      
CA - Rancho Cucamonga       KY - Louisville       NY - Albany       TX - Amarillo      
CA - Sacramento       LA - Baton Rouge       NY - Buffalo       TX - Austin      
CA - Salinas       LA - Lafayette       NY - New York City       TX - Beaumont      
CA - San Diego       LA - New Orleans       NY - Rochester       TX - Corpus Christi      
CA - San Jose       LA - Shreveport       NY - Syracuse       TX - Dallas      
CA - Santa Rosa       MA - Burlington       OH - Cincinnati       TX - El Paso      
CA - Stockton       MA - Springfield       OH - Columbus       TX - Fort Worth      
CO - Boulder       MA - Westborough       OH - Dayton       TX - Houston      
CO - Colorado Springs       MB - Winnipeg       OH - Highland Heights       TX - Killeen      
CO - Denver       MD - Largo       OH - Toledo       TX - Laredo      
CT - Cheshire       MD - Laurel       OK - Oklahoma City       TX - Longview      
CT - New Haven       ME - Portland       OK - Tulsa       TX - Lubbock      
CT - Stamford       MI - Ann Arbor       ON - Ottawa       TX - McAllen      
DE - Wilmington       MI - Grand Rapids       ON - Toronto       TX - Midland      
FL - Daytona Beach       MI - Lansing       OR - Beaverton       TX - San Antonio      
FL - Fort Lauderdale       MI - Livonia       OR - Bend       TX - Tyler      
FL - Fort Myers       MN - Minnetonka       OR - Eugene       TX - Waco      
FL - Gainesville       MO - Columbia       OR - Medford       UT - Ogden      
FL - Jacksonville       MO - Kansas City       PA - Allentown       UT - Salt Lake City      
FL - Lakeland       MO - St. Louis       PA - Erie       VA - Glen Allen      
FL - Miami       MS - Biloxi       PA - Harrisburg       VA - Roanoke      
FL - Naples       MS - Jackson       PA - Malvern       VA - Virginia Beach      
FL - Pensacola       MT - Billings       PA - Philadelphia       VT - Burlington      
FL - Sarasota       NB - Moncton       PA - Pittsburgh       WA - Seattle      
FL - Tallahassee       NB - Saint John       PA - Reading       WA - Spokane      
FL - Tampa       NC - Asheville       PA - Scranton-Wilkes Barre       WI - Green Bay      
FL - Winter Park       NC - Charlotte       PA - York       WI - Madison      
GA - Atlanta       NC - Greensboro       QC - Montreal       WI - Milwaukee      
GA - Augusta