This course will empower you with a working knowledge of the SQL language, from basic querying to using SQL to solve business questions. You'll end your learning able to confidently apply SQL in a professional context.
Because everything happens live, you'll be able to ask questions in real time and work out queries during office hours. You'll even get direct feedback on your work. DocuSign's Senior Data Scientist is all-in to help you master this simple and ubiquitous programming language.
Instructor-led learning can lead to up to 37% better outcomes than self-study.
You'll learn one of the hottest skills in any industry that handles data — and be ready to start immediately applying your knowledge of SQL in a data-related position or serving your business and/or managerial needs.
Send Adam a short self introduction, relating your existing knowledge of data and/or programming, if any, and what you hope to gain from the course.
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.
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.
Construct queries using aggregation functions to return specific numeric answers. Practice with ranking results and creating nested queries to answer more complex data requests.
Continue practicing the techniques covered today to solve for a variety of practical business use cases.
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.
Practice working with date time data and the complications involved, such as data types, time zone adjustments, and operations with date time variables.
Build queries to solve common business use cases involving date time data. Practice performing time period operations and aggregations, cohort analysis, and growth analysis.
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.
Solve a number of specific data-centered business use cases, which will require the techniques they have learned in the previous lessons.
Construct queries using aggregation functions to return specific numeric answers. Practice with ranking results and creating nested queries to answer more complex data requests.
Reflect on the course, what you have learned, and what you would like to continue learning. How will you employ the skills you have learned in your current or desired role?
ON-DEMAND LESSON STREAMING | + | + | + | + |
LIVE INSTRUCTION | + | - | - | - |
GRADING BY THE INSTRUCTOR | + | - | - | - |
PERSONAL INSTRUCTOR FEEDBACK | + | - | - | - |