SQL FOR BUSINESS ANALYTICS | A live online course with Senior Data Scientist at DocuSign | ELVTR
live online course

SQL for
Business
Analytics

Scroll down
Adam Gorski
A LIVE ONLINE COURSE
with Senior Data Scientist
at DocuSign
Dates:
3 NOV 2021 - 20 DEC 2021
Duration:
6 weeks with a 1-week break
MONDAYS & WEDNESDAYS
5 PM PST / 8 PM EST

Discover the advantage of SQL for business analytics.

Master the enduring language of data in just 6 weeks. Start building robust skills for 200+ database systems in this dynamic, live online study program.

Do you see yourself below?
Then this course is for you.

  • Future data analysts.

     

    Rapidly expand your skill set in data management and manipulation.

  • Data-driven professionals.


    Solve messy business problems with tidy SQL-powered solutions.

  • Anyone with SQL skills.


    Ease your data work and increase your employability with an expanded SQL toolkit.

PREPARE TO ACCELERATE

Fast-Track Your Career

There's a reason that data-rich companies rank SQL abilities so highly. Build flexible data skills to steer decision-makers reliably, no matter how your industry shifts.

Live and Personal

Ask questions in real time. Get direct feedback on your work. Connect with other forward-looking data professionals.

DocuSign's Senior Data Scientist is all-in to help you uncover the potential of this evergreen programming language.

 
ABOUT THE COURSE
01
SOPHISTICATED INSIGHTS

Start solving complex problems with data, whether "analyst" is in your title yet or not. Move your career forward with critical database skills and dive into advanced SQL functions

02
ELASTIC
INDUSTRY SKILLS

Show up in your role ready to jump into any data-related project. Finish this course able to competently interact with complex data, answer tough business questions, and market yourself for the data role you want.

03
RIGOROUS
PRACTICE

Apply new data concepts independently and get immediate instructor feedback. Check your understanding with dozens of practice problems and weekly office hours with Adam.

Instructor
  • Senior Data Scientist at DocuSign, specializing in feature instrumentation and predictive modeling
  • Empowers hundreds of millions in annual revenue as owner of data tracking and analytics for a thousands-strong account vertical
  • Built the tooling for instrumenting and success measurement of several novel DocuSign products, including the innovative remote notarization solution Notary
  • Entered database creation as a data analyst in the public sector and in just 4 years rose to Senior Data Scientist at DocuSign, a company valued at $1.5 billion
  • Passionate about using data to solve problems in the private, public, and non-profit sectors
Adam Gorski
Adam Gorski
COURSE INTRODUCTION
SYLLABUS
01
WED (11/3) at 5 PM PST/8 PM EST
Why SQL? + Basic Querying

SQL is one of the most important languages in today's data-driven world. You'll understand why that is and learn the basics of how SQL works: what different types of databases are out there, the database management systems that are used, and how SQL language can retrieve specific information from these systems.

  • What is SQL and what it can be used for (and by whom)
  • Database structures: schemas, tables
  • SELECT FROM functions
  • WHERE clauses (=, <>, >, <, IS/IS NOT NULL)

Assignment 01: Connect to the course database and begin constructing your own queries for specific data requests. Query individual tables, subsetting by column and row using SQL syntax.

more
02
MON (11/8) at 5 PM PST/8 PM EST
Joins

Logic and syntax of join statements is the focus of today's class. Learn how to use a variety of join functions across multiple tables and how to avoid common issues with joining, such as duplicate creation.

  • Inner/outer join
  • Multiple joins, aliases
  • Understanding joins and avoiding duplicates

Assignment 02: Write queries that join data across multiple tables. Practice with the different types of joins, adding conditional statements to joins and performing joins without creating unwanted duplicates.

more
03
WED (11/10) at 5 PM PST/8 PM EST
Querying for Answers

This class builds on the last to begin constructing queries that return answers to specific questions. You'll learn how to calculate aggregation and to order operations across one or multiple tables.

  • Aggregations (GROUP BY): SUM, COUNT, MIN, MAX, AVG
  • ORDER BY
  • Additional conditions: OR, IN, LIKE

Assignment 03: Construct queries using aggregation functions to return specific numeric answers. Practice with ranking results and creating nested queries to answer more complex data requests.

more
04
MON (11/15) at 5 PM PST/8 PM EST
Workshop #1: Database Creation and Solving Common Data Questions

Today, you'll apply the techniques you've learned so far to more complex use cases. You'll be presented with several common data questions in the business arena and practice developing a SQL solution for each of them.

Assignment 04: Continue practicing the techniques covered today to solve for a variety of practical business use cases.

more
05
WED (11/17) at 5 PM PST/8 PM EST
Modifying and Manipulating Data

Now that you've nailed querying, it's time for data modification and manipulation. You'll learn how to do that by renaming variables, changing data types, and creating new variables.

  • Renaming variables with AS
  • Changing data types with CAST
  • Creating new variables with CASE WHEN

Assignment 05: Continue writing queries on your own which modify existing data by renaming variables and changing data types. Perform within-query calculations to create new variables.

more
06
MON (11/29) at 5 PM PST/8 PM EST
Time Functions and Tables

Date and time data poses specific challenges for databases. In this class, you'll learn how to write queries using date / time functions and be able to perform specific date time operations.

  • Data types for which date/time functions are applicable
  • DATE, TIMESTAMP, AGE queries
  • Time data operations: DATE_TRUNC, EXTRACT
  • Aggregations by time period

Assignment 06: Practice working with date time data and the complications involved, such as data types, time zone adjustments, and operations with date time variables.

more
07
WED (12/1) at 5 PM PST/8 PM EST
Advanced SQL: Time Series Data

Today, we're learning time series analysis techniques for working with date time data. This class will teach you how to calculate answers to common business questions, such as aggregations by time period, cohort analysis, and growth analysis.

  • Iteratively building complex queries
  • Cohort analysis
  • SELECT DISTINCT, COUNT (DISTINCT), LAG

Assignment 07: Build queries to solve common business use cases involving date time data. Practice performing time period operations and aggregations, cohort analysis, and growth analysis.

more
08
MON (12/6) at 5 PM PST/8 PM EST
Advanced SQL: Nested Queries

Today, you'll deepen your understanding of the language with more involved SQL techniques. Finish this class able to employ methods for nesting queries, reusing created data, and joining data on itself.

  • Subselects, WITH statements
  • Growth analysis
  • Self join, join on inequalities

Assignment 08: Answer more complicated assigned data problems, specifically focusing on using WITH statements to reference the same created data multiple times, joining data on itself, and managing duplicates with SELECT DISTINCT and ROW_NUMBER functions.

more
09
WED (12/8) at 5 PM PST/8 PM EST
Advanced SQL: Window Functions

You'll learn how to use windows functions to partition data in order to return data and calculations across multiple dimensions.

  • Window function construction
  • PARTITION BY, OVER, ROW_NUMBER()
  • Window function use cases

Assignment 09: Answer more complicated data problems, specifically focusing on using window functions to execute a variety of data manipulation and aggregations/p>

more
10
MON (12/13) at 5 PM PST/8 PM EST
Workshop #2: Complex Business Use Cases

So far, we've learned how to write queries, structure and manipulate data, and solve common business questions using SQL. In this workshop, you'll bring together the techniques you have learned in the course so far to clearly trace how SQL functionality assists in real-life business scenarios.

Assignment 10: Solve the specific data-centered business use cases from Adam.

more
11
WED (12/15) at 5 PM PST/8 PM EST
Getting Hired as a Data Analyst

SQL is just one piece of the fast-moving data analysis industry. This class prepares you to land a data analyst position with tips from Adam's experience hiring for this role.

  • Skills that a great data analyst should have
  • Key tools for data analysis
  • How to get into the field
  • Preparing for the interview

Assignment 11: Go to indeed.com or LinkedIn and find a job posting you would like to apply for. Analyze what requirements you already meet and what skills you'll need to further develop to apply for that role. Then, update your resumé accordingly.

more
12
MON (12/20) at 5 PM PST/8 PM EST
Working with Database Administrators (DBAs) + The Future of Data

Database Administrators (DBAs) oversee access control and database development, and knowing how to communicate and work with them is no less essential than knowing how to work with databases themselves. In this class, you'll learn how to construct specific asks to DBAs for data tasks that are typically only performed by DBAs.

We'll wrap up the course with a discussion of the wider trends in data and where we can expect the industry to go in the near future.

  • DBA concerns: permissions (SELECT, WRITE), PII, database performance, refresh rates, data security
  • Database philosophies: fact/dimension tables, event data
  • Beyond SQL: non-relational dbs, data lakes, what’s next for data storage

Assignment 12: Craft several database modification requests for specific issues which you are likely to encounter in a business context and which usually require the cooperation of a DBA to execute.

more
REVIEWS
ENROLL
First name
This is required field!
Last name
This is required field!
Email
This is required field!
This is required field!
By registering and clicking “ENROLL”, you agree to our
Terms of Use, Privacy policy and Cookie Policy
 
 
 
 
ONE MOMENT...