SQL for Data Analysis - with SQL Server
What you'll learn
- Use SQL to apply complex criteria and transformations to database data
- Master SQL functions for sophisticated data manipulation
- Leverage an understanding of relational database design to link together data stored across multiple tables
- Use aggregate queries to produce summarized views and analysis
- Be comfortable putting SQL and SQL Server on your resume
- Gain experience with the kind of SQL coding problems you are likely to encounter in an interview
Requirements
- Access to a Windows 10 operating system (SQL Server only runs on Windows); there are known compatibility issues between Windows 11 and SQL Server 2019, so I STRONGLY recommend Windows 10 for this course. If you only have access to a Windows 11 machine, you can install SQL Server 2022 instead.
- Microsoft SQL Server 2019 and SQL Server Management Studio; these are both available for free, and I’ll walk you through installation and setup.
Description
If you spend a lot of time extracting, transforming, or analyzing data from databases, - or you're aiming for one of the many highly paid career paths that rely heavily on this skill - then this course is for you.
Learning to query databases with SQL is a substantial part of highly paid careers such as Data Analyst and Business Intelligence Analyst, but also provides a strong foundation for even more exotic roles like that of a Data Scientist. Experienced Data Scientists will tell you that the majority of their time isn't spent tuning machine learning algorithms, but rather preparing and cleaning data for use by those algorithms - something SQL does exceptionally well.
In this course, I have tried to avoid simply regurgitating an encyclopedia of facts about SQL, an approach that is all too common in introductory books and courses on programming. Instead, I carefully curated certain concepts and techniques that I have found to provide the most "bang for your buck" over my decade of experience as a data professional.
This enabled me to condense a complete course on SQL into just 36 instructional videos, averaging less than 10 minutes in length. So if you can commit to a video a day, in just over one month you’ll have added an extremely valuable and lucrative skill to your arsenal (and just as importantly, your resume!).
And to make sure all that knowledge sticks, I’ve included exercises...LOTS of exercises. Unlike most courses, which only feature sporadic opportunities to practice what you’ve learned, this course has practice problems after almost every video - so you can reinforce concepts right away.
Take it from someone who has built their career almost entirely on self-taught technical skills: it’s worth the effort. Several recent surveys have shown that SQL is actually the MOST in-demand tech skill sought after by recruiters!
In short, learning SQL can change your life, if you put in the work Let me be your guide to this next step in your career - I think you’ll find the journey a lot less daunting, and maybe even a little more fun, than you would have ever expected.
Who this course is for:
- Aspiring Data Analysts or Business Intelligence Analysts looking to break into these fields by learning SQL
- Data Scientists trying to improve their data cleaning and transformation skills by learning SQL
- Non-technical business professionals such as business analysts and project managers trying to gain a better understanding of the technical domains they interact with
Featured review
Instructor
- 4.7 Instructor Rating
- 7,141 Reviews
- 129,132 Students
- 3 Courses
Hi, I’m Travis. I’ve spent well over a decade architecting and coding data solutions - and training others to do the same - for Fortune 100 companies and small businesses alike. In that time, I’ve mastered programming languages such as SQL, VBA, Python, Javascript, and more...but it wasn’t always easy.
As a self-taught developer, I understand how hard it can be to learn highly technical subjects on your own. And I am passionate about making this process as efficient, intuitive, and fun (yes, fun!) for my students as possible.
I’m excited to apply what I’ve learned about programming (AND learning!) over the course of my career, to help you reach the next step of yours.