What You Will Learn!
- A refresher on SQL topics.
- Real-world practice problems.
- PgAdmin program for PostgreSQL.
- Prep for your upcoming interview or build your skills to feel more confident in your current role.
Description
This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job. Consider it like a “Level 2” course to be taken after an intro course. It provides a refresher on SQL topics and offers real-world practice problems. Topics covered include GROUP BY, Window functions, Unions and Joins, Subqueries and more. The course includes video introductions by Barbara, a data scientist with 10 years of experience in the field, as well as slide decks with voiceovers where Barbara explains concepts in more detail.
Course Highlights
Real World SQL Application:
You'll be using the actual PgAdmin program during this course - no fake interface! This is the actual program you'd use on the job if your company uses PostgreSQL. If your company uses something else (Microsoft, Oracle, etc.) don't worry, PgAdmin is very similar.
Relevant Business Problems:
In addition to review slide decks and videos, this course contains dozens of real world practice problems designed to mimic what you'd face on the job or in an interview.
Support:
Stuck on an exercise? Want to ask general SQL questions? We offer both email and video chat support options. You can even ask questions about other related analytics topics like Excel, Python, or a problem you are having at work.
Who Should Attend!
- This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job.
