SQL Masterclass: SQL for Data Analytics

4.8 /5

(32 Ratings)

Offered byUDEMY

SQL Masterclass: SQL for Data Analytics
at
UDEMY
Overview

Become competent in using sorting and filtering commands in SQL and learn basic to advanced topics for SQL Database

Duration	8 hours
Total fee	₹525
Mode of learning	Online
Difficulty level	Beginner
Credential	Certificate

SQL Masterclass: SQL for Data Analytics
at
UDEMY
Highlights

Student will get the Certificate Of Completion
This course covers covers basics, advanced SQL statements, PostgreSQL, mySQL, interview tips and performance tuning tips as well
This is a complete tutorial on SQL which can be completed within a weekend.
You can also take quizzes to check your understanding of concepts.
Full lifetime access

SQL Masterclass: SQL for Data Analytics
at
UDEMY
Course details

Skills you will learn

Excel Database management Data analysis MySQL

Who should do this course?

For Working Professionals beginning their Data journey or Anyone interested in learning about basic to advanced SQL topics for SQL Database

What are the course deliverables?

Knowledge of all the essential SQL commands
Become proficient in SQL tools like GROUP BY, JOINS and Subqueries
Become competent in using sorting and filtering commands in SQL
Master SQL's most popular string, mathematical and date-time functions
Enhance the performance of your Database by using Views and Indexes
Increase your efficiency by learning the best practices while writing SQL queries
Relevant theoretical concepts also covered so that you excel in BI Job interviews and Vivas
Solid understanding of SQL

More about this course

SQL is the most sought after skill for Data analysis roles in all the companies. PostgreSQL, mySQL are highly desired skills for database management and data analysis roles.
Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance.
It is the most universal and common used database language
It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL

SQL Masterclass: SQL for Data Analytics
at
UDEMY
Curriculum

MODULE:1 Installation And Getting Started

This is a milestone!

Installing and setting up PostgreSQL

MODULE:2 Case Study Demo

Part 1

Part 2

MODULE:3 Fundamental SQL Statement

Exercise 1: Create DB and Table

Solutions to all Exercises

INSERT

Import data from File

Exercise 2: Inserting and Importing

SELECT statement

SELECT DISTINCT

WHERE

Logical Operators

Exercise 3: SELECT & WHERE

UPDATE

DELETE

ALTER

Exercise 4: Updating Table

Fundamental SQL statements

MODULE:4 Restore And Back-up

Debugging restoration issues

Creating DB using CSV files

Debugging summary and Code for CSV files

Exercise 5: Restore and Back-up

MODULE:5 Selection Commands: Filtering

BETWEEN

Exercise 6: In, Like & Between

MODULE:6 Selection Commands: Ordering

Side Lecture: Commenting in SQL

ORDER BY

LIMIT

Exercise 7: Sorting

MODULE:7 Alias

MODULE:8 Aggregate Commands

COUNT

4.8/5

32 Ratings

4-5
26
3-4
5
2-3
1

vineeth

SQL Masterclass: SQL for Data Analytics

Offered by UDEMY

Learning Experience: Well detailed and explained

Faculty: Faculty is good Yes its updated, details in the topic explanation was good

Reviewed on 8 Oct 2022Read More

Suraj Maiti

SQL Masterclass: SQL for Data Analytics

Offered by UDEMY

Learning Experience: this course is good. and Udemy is a very good platform if you can find a good course.

Faculty: Quality of lectures are fine for me. There is no Live session as it is a prerocorded course Course resources are good enough. Course structure follows the basic to advance concept properly.

Course Support: No

Reviewed on 23 Sep 2022Read More

Abhishek Singh

SQL Masterclass: SQL for Data Analytics

Offered by UDEMY

Learning Experience: It was really a good experience to learn form Udemy

Faculty: Actually I don't remember the name exactly but he is best in his field Yus it is up to date

Course Support: No no

Reviewed on 15 Aug 2022Read More

SATYABRATA HATI

SQL Masterclass: SQL for Data Analytics

Offered by UDEMY

Learning Experience: This helps in data analysis on various projects and data sources. This makes life easier and faster in a good way of it own

Faculty: I learnt from YouTube. So no faculty. But Guy in the cube, enterprises dna helped me. There are more than 100 video which will help to get through it I loved it. I like the test since I like the field of work. I like the analysis process with various data sets

Course Support: I have got it and now looking for better opportunity

Reviewed on 10 Aug 2022Read More

Prashasti Shukla

SQL Masterclass: SQL for Data Analytics

Offered by UDEMY

Learning Experience: Yes, this is the course which i will recommend more. It has a lots of example that make theory easy. They have exercises as well. They will also provide you the database.

Faculty: Faculty was engaging. Enthusiastic. Soft spoken, he will let you grip ghe subject. Yes it was update. But database theory portion is easy. So i willl have to read it from somewhere else. Assessment and assignments were regularly given. Database to implement the knowledge wad provided.

Course Support: Yes. There was some interview questions given. A link to subscribe the job offers for Indian students.

Reviewed on 31 Jul 2022Read More

View All 20 Reviews