Programmers, Analysts, Database Administrators, Data Scientists, IT Managers and anyone that performs analytics on data in a relational database using SQL. This is specific to data stored in a relational database such as Db2, Oracle, SQL Server or PostgreSQL.
This class covers the functions and facilities available in SQL to analyze data stored in relational database. The basic tools of statistical analysis are presented, such as median, mode, variance, standard deviation, normal distribution, covariance, and coefficient of correlation. The related SQL functions are then reviewed along with how to interpret the results. This will be followed by a discussion of the SQL OLAP functions. The related concepts of partitioning, framing, and ranges are introduced and their use to focus on the specific data to be analyzed is explained. Additional techniques for grouping and aggregating data for analysis are then presented, including advanced GROUP BY clause syntax, and how to create pivot tables. Within each topic students will learn how to write the SQL query and then how to analyze the outputs. Each topic is reinforced with hands-on workshops.
A basic understanding of Structured Query Language (SQL).