MySQL for Data Analytics and Business Intelligence

4.7 /5

(36 Ratings)

Offered byUDEMY

MySQL for Data Analytics and Business Intelligence
at
UDEMY
Overview

Duration	9 hours
Mode of learning	Online
Difficulty level	Beginner
Official Website	Go to Website
Credential	Certificate

MySQL for Data Analytics and Business Intelligence
at
UDEMY
Highlights

Get unlimited access to the course content
Earn a Certificate from Udemy on successful course completion
154 articles + 95 downloadable resources
Compatible on Mobile and TV

MySQL for Data Analytics and Business Intelligence
at
UDEMY
Course details

Skills you will learn

C Software Testing MySQL

What are the course deliverables?

advanced topics in programming like SQL?s triggers, sequences, local and global variables, indexes
Complex SQL joins

More about this course

Students will create, design, and operate with SQL databases
Adopt professionally tested SQL best practices
They will proficiency in MySQL Workbench

MySQL for Data Analytics and Business Intelligence
at
UDEMY
Curriculum

Introduction

Why SQL?

Why MySQL?

Introduction to databases

SQL Theory

SQL as a declarative language

Data definition language (DDL)

SQL keywords

Data manipulation language (DML)

Data control language (DCL)

Transaction control language (TCL)

Relational database essentials

Databases vs spreadsheets

Database terminology

Relational schemas - Primary key

Relational schemas - Foreign key

Installing MySQL

Additional note -Installing -Visual C

Installing MySQL on macOS and Unix systems

The Client-Server Model

Setting up a connection

Read me!!!

New Authentication Plugin - Creating a New User

Introduction to the MySQL interface

Creating a Database - Part I

SQL files

Creating a Database - Part I - exercise

Creating a Database - Part I - solution

Creating a Database - Part II

Creating a Database - Part II - exercise

Creating a Database - Part II - solution

Introduction to data types

PRIMARY KEY constraint

PRIMARY KEY constraint - exercise

PRIMARY KEY constraint - solution

FOREIGN KEY constraint - Part I

FOREIGN KEY constraint - Part II

FOREIGN KEY constraint - Part II - exercise

FOREIGN KEY constraint - Part II - solution

MySQL for Data Analytics and Business Intelligence
at
UDEMY
Entry Requirements

Eligibility criteria Up Arrow Icon

No prior experience is required.

Conditional Offer Up Arrow Icon

Not mentioned

Other courses offered by UDEMY

TallyPrime+GST+Payroll+IncomeTax+TDS+TCS+MSExcel

UDEMYCertificate

Total Fees

₹549

Duration

50 hours

Difficulty level

– / –

Skills

Tally Inventory management Excel Taxation

Financial Modelling with Python & Excel : DCF Valuation

UDEMYCertificate

Total Fees

₹3 K

Duration

10 hours

Difficulty level

– / –

Skills

Financial modelling

Technical SEO Audit Masterclass - Semrush Advanced SEO

UDEMYCertificate

Total Fees

₹549

Duration

4 hours

Difficulty level

– / –

Skills

SEO

Data Lake Mastery: The Key to Big Data & Data Engineering

Certificate

Total Fees

₹599

Duration

10 hours

Difficulty level

– / –

View Other 2344 Courses

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

4.7/5

36 Ratings

4-5
24
3-4
12

Prem M

MySQL for Data Analytics and Business Intelligence

Offered by UDEMY

Learning Experience: it was good

Faculty: faculty was good in teaching everything was good

Course Support: good

Reviewed on 13 Jan 2023Read More

Palak Grover

MySQL for Data Analytics and Business Intelligence

Offered by UDEMY

Learning Experience: Learnt about the basic concepts of the database, primary and foreign key constraints, all types of joins, stored routines, procedures, triggers, indexes, visualising data via tableau and gain hands-on experience on working with MYSQL database.

Faculty: Faculty and the resources were great. Yes. The curriculum is upto the mark.

Course Support: Yes. This course will help me land a Data Analyst job soon.

Reviewed on 8 Oct 2022Read More

Mohammed Hyder Ali

MySQL for Data Analytics and Business Intelligence

Offered by UDEMY

Learning Experience: The course was very depth and easy to understand

Faculty: Faculty was very good and clear Course was not updated it was created on 2018

Course Support: Yes

Reviewed on 11 Sep 2022Read More

Apurva Ravindra Patil

MySQL for Data Analytics and Business Intelligence

Offered by UDEMY

Learning Experience: Overall course was good. Each and every concept was clearly explained.

Faculty: Faculty was very good. He was having in-depth knowledge regarding SQL. At the end of every lecture, there are assignments in order to check what you learned in previous lecture.

Course Support: No

Reviewed on 28 Aug 2022Read More

AMIT KUMAR

MySQL for Data Analytics and Business Intelligence

Offered by UDEMY

Learning Experience: The course is having good content and it is well structured for beginners who want ro start career in Data Analytics.Aling with theory a lot of SQL question have been given for practice the skills learnt.

Faculty: The faculty for this course has explained all the concepts in very easy way.Aling with that there is discussion forum on which we can discuss his/her doubts Yes the curriculum is being updated on regular basis.One can sure to enhance their skills upto date.There are many assessment given to track ones learnings.

Course Support: No as such there is no career support with the couse, but one can apply to jobs after leaning SQL here.

Reviewed on 29 Jul 2022Read More

View All 21 Reviews