UDEMY
UDEMY Logo

SQL - MySQL for Data Analytics and Business Intelligence 

  • Offered byUDEMY

SQL - MySQL for Data Analytics and Business Intelligence
 at 
UDEMY 
Overview

SQL that will get you hired - SQL for Business Analysis, Marketing, and Data Management

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
Read more
Details Icon

SQL - MySQL for Data Analytics and Business Intelligence
 at 
UDEMY 
Course details

Who should do this course?
  • 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
What are the course deliverables?
  • 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
Read more
More about this course
  • 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

Other courses offered by UDEMY

549
50 hours
– / –
3 K
10 hours
– / –
549
4 hours
– / –
599
10 hours
– / –
View Other 2344 CoursesRight Arrow Icon

SQL - MySQL for Data Analytics and Business Intelligence
 at 
UDEMY 
Students Ratings & Reviews

4.6/5
Verified Icon58 Ratings
R
Rohit Nair
SQL - MySQL for Data Analytics and Business Intelligence
Offered by UDEMY
5
Learning Experience: It was great. They covered concepts from basics like DDL and DML commands to advanced concepts like producers and functions. Overall it was a great course. I would recommend it to someone whos new to IT field.
Faculty: The faculty was very well versed in the topic. They had deep knowledge and gave out insights for carrying out tasks in better way and forced us to brainstorm too. Each section had a quiz at the end of every topic. They had hands on exercises and pdfs to read through them.
Course Support: Ive just completed the course and Im applying to open positions. Would let you know once I land a job.
Reviewed on 18 Mar 2023Read More
Thumbs Up IconThumbs Down Icon
R
Rahul Pandagale
SQL - MySQL for Data Analytics and Business Intelligence
Offered by UDEMY
5
Learning Experience: Learning experience was very good, the course curriculum covered everything from basic to advance
Faculty: The faculty was 365 careers which was very good, highly experienced, the course was very well designed Course resources were very helpful, it also had a lot of assignments which helped me practice and become good at itm
Reviewed on 28 Jan 2023Read More
Thumbs Up IconThumbs Down Icon
Z
Zeeshan Ahmed
SQL - MySQL for Data Analytics and Business Intelligence
Offered by UDEMY
5
Learning Experience: Concepts are explained in such a way that a person having no exposure to coding before, can also learn the concepts. Doing This course is an enjoyable experience.
Faculty: The teaching style of faculty is quite engaging. Concepts are explained from the very basics. (There were no live sessions). All important concepts are included in the course. Assessment questions are not very tough but it requires thorough understanding to do the assessments.
Course Support: SQL is a must in Data Analytics field,
Reviewed on 20 Jan 2023Read More
Thumbs Up IconThumbs Down Icon
M
Madhur Pandey
SQL - MySQL for Data Analytics and Business Intelligence
Offered by UDEMY
5
Learning Experience: Use lucid language and adequate time on each concept to make a strong foundation. Program has realistic data set with hands on assignment that gave real simulation of learning.
Faculty: Great. The main attraction was the remarkable educator and his teachings style. Started with basic keywords and later expanded to advanced topics like creating temporary tables.
Course Support: I gained a new skill that expanded my job search horizon.
Reviewed on 14 Jan 2023Read More
Thumbs Up IconThumbs Down Icon
A
Ajithkumar Palanisamy
SQL - MySQL for Data Analytics and Business Intelligence
Offered by UDEMY
5
Learning Experience: Very nice to learn new upskilling and new hit course. Cons nothing need to mention particularly
Faculty: My trainer is Microsoft employer so easily catchup with them and clear all concepts This course is understand about basic concepts in cloud like a port, firewall, network security
Course Support: Learned new upskilling
Reviewed on 2 Jan 2023Read More
Thumbs Up IconThumbs Down Icon
View All 42 ReviewsRight Arrow Icon
qna

SQL - MySQL for Data Analytics and Business Intelligence
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...