« 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:
Notice: Undefined variable: SectionNumber in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 617
Dates:
Notice: Undefined variable: StartDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620

Notice: Undefined variable: EndDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620
-
Time: 9:00 AM
Tuition:
Notice: Undefined variable: Cost in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 624
Instructor:
Notice: Undefined variable: InstructorString in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 625

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 628

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 630

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 634

Notice: Undefined variable: SectionDescription in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 650

Class Schedule

Date Times Meeting Type Location
08/12/2017 9:00 AM - 4:30 PM Classroom Executive Park
08/19/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Notice: Undefined variable: FinalEnrollmentDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 706

Clock Hours:
Notice: Undefined variable: ClockHours in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 711