English | Size: 3.13 GB
Genre: eLearning
What you’ll learn
Write advanced SQL queries to explore and analyze databases with MySQL Workbench
Learn how to use subqueries and temporary tables to handle complex multi-step data problems
Solve practical hands-on assignments and real-world eCommerce use cases
Analyze data across multiple tables with powerful MySQL JOIN statements
Master unique tips and tools that you won’t find anywhere else
Get LIFETIME access to resource files, quizzes, assignments, and expert support
If you want to develop practical, real-world analytics & BI skills using advanced SQL, you’re in the right place.
This course is unlike anything you’ve seen before, guaranteed. Instead of using random sample data and obscure demos, we’ll be working with a rich, custom-built eCommerce database that we’ve designed from scratch to help you apply your SQL skills to real projects and learn how to truly THINK like an analyst.
You’ll be playing the role of a newly hired Database Analyst for Maven Fuzzy Factory, an eCommerce start-up, and will be working directly with the CEO, Marketing Director and Website Manager to help grow the business and analyze performance along the way. You’ll use a range of advanced SQL tools and techniques, and work through actual projects that data analysts and business intelligence professionals work on every day.
_____________________________
COURSE OUTLINE:
Prerequisite SQL Skills Assessment
In this section we’ll address the core SQL/MySQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. If you aren’t sure how your skills stack up, we’ve included a quiz to assess your baseline SQL knowledge.
MySQL Setup & Install
For students who haven’t completed our intro course, we’ll demonstrate exactly how to download and install the tools that we’ll need to access MySQL, including MySQL Community Server & MySQL Workbench. We’ll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we’ll analyze throughout the course.
Traffic Analysis & Optimization
In this section we’ll use MySQL to analyze where our website traffic is coming from, how different sources perform in terms of traffic volume and conversion rates, and how we can adjust bids to optimize our budgets.
Website Measurement & Testing
In this section we’ll dive into page-level website data to compare traffic and conversion rates, and use MySQL to build and analyze conversion funnels to help optimize the customer purchase experience.
***MID-COURSE PROJECT: Preparing data for the executive board meeting
Channel Analysis & Optimization
In this section we’ll dig deeper into our traffic channel mix, explore paid vs. free traffic, break down performance by device type, and write advanced SQL queries to conduct some time-series analyses to understand trending and seasonality.
Product-Level Analysis
In this section we’ll use MySQL to break down product-level sales and conversion rates, analyze cross-selling patterns, and use refund rates to keep a pulse on quality.
User-Level Analysis
In this section we’ll take a closer look at user behavior and repeat sessions, and use MySQL techniques to identify our most valuable customers and explore which channels they are coming from.
***FINAL PROJECT: Building a data-driven growth story for potential investors
Who this course is for:
Analysts or BI professionals looking to quickly retrieve or analyze data stored in relational database systems
Excel users looking to shift into a broader business intelligence or database-focused role
SQL users looking to develop advanced skills and master one of the world’s most popular and powerful database programming languages
Students looking for a hands-on, practical, and highly engaging way to master MySQL for data analysis and business intelligence
Anyone looking to pursue a career in data analysis or business intelligence
NOTE: This course is NOT for database administrators (we won’t cover tools to build or maintain databases in this course)
nitroflare.com/view/E4C5996B127D12B/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part01.rar
nitroflare.com/view/5FE333D529F7136/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part02.rar
nitroflare.com/view/BCA5283245D5FF7/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part03.rar
nitroflare.com/view/134DAA6514FBA69/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part04.rar
nitroflare.com/view/35FEC786374CDC1/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part05.rar
nitroflare.com/view/1517D39AF1903D9/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part06.rar
nitroflare.com/view/50BB8F4E42AAB1E/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part07.rar
rapidgator.net/file/6cefd1f6366b2e1e243001b360114365/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part01.rar.html
rapidgator.net/file/fe69ff785c8a068d168a8ae81b1f1b93/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part02.rar.html
rapidgator.net/file/ed1db98d2ec7a9122cef8346f6afab2c/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part03.rar.html
rapidgator.net/file/476208412797c4d1de6f20d56d25517a/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part04.rar.html
rapidgator.net/file/803bfb3ba537ae87088eb78387e50bc5/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part05.rar.html
rapidgator.net/file/3244b43ec1b2bb1515f205460746b664/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part06.rar.html
rapidgator.net/file/87a44a62220d0f195becbc7e20e4c0ec/AdvancedSQLMySQLforAnalyticsBusinessIntelligence.4.8.part07.rar.html
If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9