SQL - MySQL for Data Analytics and Business Intelligence
- Offered byUDEMY
SQL - MySQL for Data Analytics and Business Intelligence at UDEMY Overview
Duration | 10 hours |
Total fee | ₹12,480 |
Mode of learning | Online |
Difficulty level | Intermediate |
Credential | Certificate |
SQL - MySQL for Data Analytics and Business Intelligence at UDEMY Highlights
- Access on mobile and TV
- Certificate of Completion
- Learn from 365 Careers
- 9.5 hours on-demand video
- 154 Articles
- 95 downloadable resources
- Full lifetime access
SQL - MySQL for Data Analytics and Business Intelligence at UDEMY Course details
- People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
- Beginners to programming
- Everyone who wants to learn how to code and apply their skills in practice
- Become an expert in SQL
- Learn how to code in SQL
- Boost your resume by learning an in-demand skill
- Create, design, and operate with SQL databases
- Start using MySQL â?? the #1 Database Management System
- Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
- Adopt professionally tested SQL best practices
- Gain theoretical insights about relational databases
- Work with a sophisticated real-life database throughout the course
- Get maximum preparation for real-life database management
- Add data analytical tools to your skillset
- Develop business intuition while solving tasks with big data
- Study relational database management theory that you will need in your workplace every day
- Learn how to create a database from scratch
- The ability to take control of your dataset â?? insert, update, and delete records from your database
- Be confident while working with constraints and relating data tables
- Become a proficient MySQL Workbench user
- Acquire top-notch coding techniques and best practices
- Know how to answer specific business questions by using SQLâ??s aggregate functions
- Handle complex SQL joins with ease
- Approach more advanced topics in programming like SQLâ??s triggers, sequences, local and global variables, indexes, and more
- Merge coding skills and business acumen to solve complex analytical problems
- Become a proficient SQL user by writing flawless and efficient queries
- Tons of exercises that will solidify your knowledge
- The freedom to query anything you like from a database
- Become a proficient SQL user by writing flawless and efficient queries.
- Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
- Gain theoretical insights about relational databases
- Get maximum preparation for real-life database management
- Work with a sophisticated real-life database throughout the course
- Start using MySQL â?? the #1 Database Management System
- Learn how to code in SQL
- Create, design, and operate with SQL databases
- Work with a sophisticated real-life database throughout the course
SQL - MySQL for Data Analytics and Business Intelligence at UDEMY Curriculum
Introduction to databases, SQL, and MySQL
SQL theory
Basic database terminology
Installing MySQL and getting acquainted with the interface
First steps in SQL
MySQL constraints
SQL best practices
Loading the 'employees' database
SQL SELECT statement
SQL INSERT statement
SQL UPDATE Statement
SQL DELETE Statement
MySQL - Aggregate functions
SQL Joins
SQL Subqueries
SQL Self Join
SQL Views
Stored routines
Advanced SQL Topics
Combining SQL and Tableau - Introduction
Combining SQL and Tableau - Task 1
Combining SQL and Tableau - Task 2
Combining SQL and Tableau - Task 3
Combining SQL and Tableau - Task 4
Combining SQL and Tableau - Task 5
Practice SQL â?? 10 Final Query Questions
BONUS LECTURE