Develop your SQL skills and learn how to answer business questions from data
Work on realistic case studies and examples that will guide you step by step through understanding requirements, reviewing the database, and developing the right queries
Discover everything you need to know to query your database and feed the results into Tableau, Excel, or other tools for further analysis
Description
Many of us know a bit of SQL. But when it comes to answering real-world business questions, our rusty memories of database classes let us down!
This video course will take you to an intermediate level of familiarity with SQL in the context of writing maintainable and sophisticated SQL for specific business queries. You will start by importing our first dataset which will be the DVD rental database. We then will explore and put into practice various SQL clauses and Join types. All examples of fundamental concepts are tightly guided by practical and hands-on exercises. No “Foo Bar” allowed anywhere, just problems from the wild, brought into the educational space. You will also learn tricks to get external data into the database, without worrying excessively about DBA functions and considerations.
You’ll also find out how to take the data into popular BI tools (Excel and Tableau) and refine the analysis further while discussing the interpretation of the data. By the end of the course, you will have developed your SQL skills and learnt how to answer business questions from the set of data.
What you will learn
? Set up PostgreSQL in your environment (Mac or PC)
? Get the working files loaded
? Review the fundamentals of SQL from the unique POV of an advanced SQL write
? Get data into the system: common approaches including the basics of indexing
What do you get with a video?
Download this video in MP4 format
Access this title in our online reader with advanced features
DRM FREE - Read whenever, wherever and however you want
Jeffrey James has been working in the analytics and data space since 2006. With roots in digital marketing and web analytics, he's applied analytical techniques to problems including customer value analysis, financial forecasting, machine learning, and process automation. He's made his share of mistakes on the way to mastery and understands the mindset of a beginner/learner.
How can I download a video package for offline viewing?
Login to your account at Packtpub.com.
Click on "My Account" and then click on the "My Videos" tab to access your videos.
Click on the "Download Now" link to start your video download.
How can I extract my video file?
All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.
How can I get help and support around my video package?
If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.
Video
Format watched (HTML, MP4, streaming)
Chapter or section that issue relates to (if relevant)
System being played on
Browser used (if relevant)
Details of support
Why can’t I download my video package?
In the even that you are having issues downloading your video package then please follow these instructions:
Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.