Microsoft SQL Tutorial for Faster BIG Data Analysis
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft SQL Tutorial for Faster BIG Data Analysis to your Wishlist.

Add to Wishlist

Microsoft SQL Tutorial for Faster BIG Data Analysis

Learn MS SQL tutorial with Examples in simple & easy steps starting from basic to advanced concept for Data Analysis
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
24 students enrolled
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $50 Discount: 80% off
30-Day Money-Back Guarantee
Includes:
  • 5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Will be able to manage Database using Microsoft SQL
  • Will be able to do data analysis using Microsoft SQL
  • Will be able to download and install MS SQL Server
  • Will be able to do SQL Join, use SQL functions, DDL, DML
View Curriculum
Requirements
  • MS SQL software 2010 version required
  • Beginner can also join this course to learn SQL for Database Management
Description

Learning SQL is one of the greatest career decisions you could make. This may be a bold statement, but it also means that once you know SQL, you do not have to rely on other for information. Once you can write SQL queries, there are literally no questions you cannot ask to your data.

Get high paid job in SQL, here are some facts about earning opportunities for SQL Developer:

  1. Average SQL Developer salary is $73,718 - Figures by Glassdoor dot com
  2.  9473+ Jobs opening for professional with SQL as part of their skillset
  3. Companies like TCS, Capgemini, Accenture and many more MNC need project managers
  4. SQL is must have skills if you are a Analyst, Digital Marketer, Developers and Engineer

People in this job generally don't have more than 10 years' experience. Experience strongly influences pay for this job.

Ever crashed Excel because you had a ton of rows in a spreadsheet?

Do you feel dependent on your team to help you answer sales last year or customer satisfaction rating 2 months ago or how you reduced expenses? Relational databases are designed in such a way that they can store billions and millions of rows of data. But the problem is you've never used SQL and find learning this coding mind boggling.

You may be the best at producing high-quality reports but you ask yourself - "How did I make this report?" since you are stuck at doing long multi-step process with no scalability

To learn SQL - you have 3 options:

  1. Attend a local workshop - take a day off and gulp everything the instructor talks. 
  2. Watch YouTube videos - Which is unstructured with no learning path
  3. Ask your busy friend to explain you all

I would like you to introduce to the fourth option - Online Video Course. The effectiveness of Classroom workshop and flexibility to watch it anytime/anywhere. 

Advantages of using SQL for data management:

  1. SQL is supported by almost all  databases system.
  2. It's standardized. It's widely used and it's a basic skill to developers.
  3. It's declarative, based on relation model, you can just run a simple command to query data without  needing to know how the data is stored or retrieved.

Enroll with confidence Udemy offers 30 days money back Guarantee. You'll be able to learn and practice learning in this course in real life.

Who is the target audience?
  • Data Analyst who wish to do analysis of Big Data available on SQL server
  • Looking for job in Microsoft SQL
  • Looking to learn developing, maintaining, and optimizing data assets and databases
Students Who Viewed This Course Also Viewed
Curriculum For This Course
84 Lectures
04:51:41
+
Introduction
2 Lectures 02:27


Quiz on Introduction
1 question
+
Download SQL Files for Practice
1 Lecture 00:01
SQL Files
00:01
+
An Overview of SQL
2 Lectures 02:35
What is DBMS and RDBMS?
01:09

Data Definition Language(DDL) and Data Manipulation Language(DML)?
01:26

Quiz on Overview of SQL
3 questions
+
Setup a Testing Environment
4 Lectures 13:25


Installing AdventureWorks Database
04:22

A Quick Introduction to SQL Server Management Studio
02:21
+
Important SQL Clauses (DML)
5 Lectures 22:36
Create example databases, tables and data rows 1
07:06

Create example databases, tables and data rows 2
07:15

Learn about SQL FROM Clause
02:32

SQL SELECT DISTINCT Statement
03:13

Learn about SQL WHERE Clause
02:30

Quiz on Important SQL Clauses (DML)
6 questions
+
Conditions and Operators (DML)
8 Lectures 24:51
SQL AND Operator
01:45

SQL OR Operator
02:06

SQL IN Operator
03:12

SQL EXISTS Condition
03:11

SQL NOT IN or NOT EXISTS? Conditions
03:30

SQL Comparison Operators
02:50

SQL LIKE Operator
04:08

SQL BETWEEN Operator
04:09

Quiz on Conditions and Operators (DML)
6 questions
+
Data grouping, sorting, select and dates (DML)
8 Lectures 28:42
Learn about SQL ORDER BY Clause
03:43

Learn about SQL GROUP BY Clause 1
04:13

Learn about SQL GROUP BY Clause 2
03:24

Learn about SQL HAVING Clause
03:05

SQL LIMIT or TOP Clause
02:46

SQL Aliases
02:13

SQL Wildcards (%, _)
03:52

SQL Dates
05:26

Quiz on Data grouping, sorting, select and dates (DML)
11 questions
+
Conditions and Operators (DML)
2 Lectures 05:38
SQL Numeric Operators
02:39

SQL Concatenation Operator
02:59

Quiz on Conditions and Operators (DML)
1 question
+
Insert, Read, Update, Delete the Data Rows (DML)
3 Lectures 18:00
SQL INSERT INTO SELECT Statement
08:09

Update data rows using UPDATE Statement
06:32

Delete data rows using DELETE Statement
03:19

Quiz on Insert, Read, Update, Delete the Data Rows (DML)
6 questions
+
SQL JOINS (DML)
12 Lectures 43:40
What are JOINS in SQL? Types of SQL JOINS
01:08

INNER JOIN in SQL
03:45

LEFT OUTER JOIN in SQL
03:45

RIGHT OUTER JOIN in SQL
02:16

FULL OUTER JOIN in SQL
02:50

CROSS JOIN in SQL
03:09

SQL Join with Condition
05:15

SQL UNION Operator
03:25

SQL UNION ALL Syntax
01:27

SQL Case
02:44

Nested Case
05:14

SQL VIEWS
08:42

Quiz on SQL JOINS (DML)
19 questions
3 More Sections
About the Instructor
Yoda Learning
4.3 Average rating
1,479 Reviews
35,522 Students
49 Courses
MS OFFICE & PMP | Join 32K+ Udemy Students Become 4X Faster

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).

Rishabh Pugalia
4.2 Average rating
530 Reviews
9,329 Students
29 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.