« Back to Class Listing

SQL Level 2: Intermediate

Description

Take your SQL skills to the next level by learning how to do more work with SQL inside the database before pushing data across the network to your applications. This class takes a time efficient ‘problem / solution/ discussion’ approach and covers the topics that are important to today’s SQL developers.

This class teaches you how to use window functions, pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set. Also covered is the topic of ‘bucketization’, how to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course, students will know about:

  • Retrieving Records
  • Conditional SQL & Sample Data
  • Conditional Sorting & Stacking Rows
  • Views and Different Join Types
  • Working with Text Data
  • Working Numerical Data
  • Working with Dates
  • Grouping and Window Functions
  • Pivoting and Pivot Reports
  • Other Ways to Pivot
  • Bucketization and Histograms
  • Analyzing and Presenting Data

Section:
Dates: - Time: 9:00 AM
Tuition: Instructor:

Class Schedule

Date Times Meeting Type Location
11/04/2017 9:00 AM - 4:30 PM Classroom Executive Park
11/11/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Clock Hours: