SQL for Data Analysis: Beginner MySQL Business Intelligence

Partner: Udemy
Affiliate Name:
Area:
Description: SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL data analysis and database analytics skills along the way.COURSE OUTLINE:SQL Intro & MySQL SetupWe’ll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)SQL Database Fundamentals (Part 1)Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions. Analyzing Data from Single Tables with MySQLIn this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data for analysis and business intelligence.[MID-COURSE MYSQL PROJ
Category: Development > Database Design & Development > Business Intelligence (BI)
Partner ID:
Price: 129.99
Commission:
Source: Impact
Go to Course