SQL Module

SQL-Class 1-M 1-Text 1   //  Video No.SQL 01.01.01

 SQL-Class 1-M 1-Text 2  // Video No.SQL.01.01.02.

SQL-Class 2-M 1-Text 3   //  Video No.SQL 02.01.03

 SQL-Class 1-M 1-Text 2  // Video No.SQL.01.01.02.

Data Analytics -> SQL->Module 1.Topics

# History of SQL language 

# Understanding SQL Server Connection with different Services 

#Familiarisation and setup SQL Server Tools

# How to Create a Project and save Files

# How to save code in any folder, under project and server side 

#Use of SQL Server 

#Configuration Manager Create and Setup database / Tables with code and without code #Understanding System database (master …….) 

#Restore AdventureWorks and Adventure

#WorksDW database Download resource for Practice ( HR Schema database) 

#Fetch data from employee tables (slicing and dicing data) 

#What is Schema? 

#Import and Export data ( .csv or .xls files) 

#SQL Data Types ( int, varchar() …..)

Class.Module.Video No.=01.01.01

Class 1.Data Analytics ->SQL ->Module 1.Video No.SQL.01.01.01

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 1.Video No.SQL.01.01.02.

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 2.Data Analytics -> SQL->Module 1.Video No.SQL.02.01.03

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 1.Video No.SQL.02.01.04

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 3.Data Analytics -> SQL->Module 1.Video No.SQL.03.01.05

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 1.Video No.SQL.03.01.06

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 4.Data Analytics -> SQL->Module 1.Video No.SQL.04.01.07

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 1.Video No.SQL.04.01.08

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 2,Topics

• UUnderstanding the list of system Aggregation Understanding the list of system Aggregation functions

• When and how group by statement is going to be used.

• When and how Where and Having clause used in Aggregations.

• Homework #3 for Aggregation.

• What are Primary key and Foreign Key and their differences

• Concept of Entity relational diagram (ERD)

• Type of Relationship among tables using Key

• What are a join-in table and Different types of Join databases?

• Learned types of join by using emp1 and dept1 tables.

• Homework #4 Join tables of Employees and Departments.

• Learned types of join by using Employees and Departments tables

• Fetch data from the HRSchma using 7 tables.

• Create a database diagram from HRSchema and saved it

• Homework #5 understand left and right join.

• Homework #6 understand join and filter.

 

Class 5.Data Analytics -> SQL->Module 2.Video No.SQL.05.02.09

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 Data Analytics -> SQL->Module 2.Video No.SQL.05.02.10

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 6 Data Analytics -> SQL->Module 2.Video No.SQL.06.02.11

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks 

Data Analytics -> SQL->Module 2.Video No.SQL.06.02.12

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks 

Class 7.Data Analytics -> SQL->Module 2.Video No.SQL.07.02.13

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 2.Video No.SQL.07.02.14

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 8.Data Analytics -> SQL->Module 2.Video No.SQL.08.02.15

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 2.Video No.SQL.08.02.16

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 3.Topics

1. Differentiate and categorize the SQL command.
2. Understand the difference among Delete, Truncate, and Drop data.
3. What is a view? What is the use of view? Sum Limitation.
4. Understand and create local and Global temporary tables.
5. Understand and create Union and Union ALL
6. What are subqueries and Co-related subqueries
7. When and why need to use Sub queries inside the data dataset?
8. Learned all window functions ( such as row_number, Rank, dense_rank)
9. Who get the highest salary in the company, Find out using Subqueries and Window functions.
10. When to use partition in a query.

 

Class 9.Data Analytics -> SQL->Module 3.Video No.SQL.09.03.17

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 3.Video No.SQL.09.03.18

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 10.Data Analytics -> SQL->Module 3.Video No.SQL.10.03.19

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 3.Video No.SQL.10.03.20

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 11.Data Analytics -> SQL->Module 3.Video No.SQL.11.03.21

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 3.Video No.SQL.11.03.22

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Class 12.Data Analytics -> SQL->Module 3.Video No.SQL.12.03.23

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 3.Video No.SQL.12.03.24

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 4.Topics

1. What is a Calculated column and how do create them
2. Use plus sign for concatenation and multiply for commission
3. Use isNULL() function for converting null in a table
4. Use case statement() for calculated column.
5. Learn CAST() and CONVERT() functions for converting integers.
6. What is a variable? How to create a variable and use it.
7. How to use variables in the queries.
8. How to create table variables and when to use them a queries.
9. What is an index? How index helps the performance of the queries.
10. Understand different types of Index and their uses.
11. What is constraints in SQL? Why need to use it?

 

Class 13.Data Analytics -> SQL->Module 4.Video No.SQL.13.04.25

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 Data Analytics -> SQL->Module 4.Video No.SQL.13.04.26

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 14.Data Analytics -> SQL->Module 4.Video No.SQL.14.04.27

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 4.Video No.SQL.14.04.28

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 15.Data Analytics -> SQL->Module 4.Video No.SQL.15.04.29

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 4.Video No.SQL.15.04.30

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 16.Data Analytics -> SQL->Module 4.Video No.SQL.16.04.31

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 4.Video No.SQL.16.04.32

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 5.Topics

 

1. What is Stored Procedure? Advantage of Stored Procedure.
2. Create Stored Procedure with and without Parameters.
3. Insert conditional statement inside the Stored Procedure.
4. Learn Global variable uses in a SQL queries.
5. Only while loop use in SQL statement.
6. Most important DATE related functions and their uses.
7. Homework

 

Class 17.Data Analytics -> SQL->Module 5.Video No.SQL.17.05.33

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 5.Video No.SQL.17.05.34

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 18.Data Analytics -> SQL->Module 5.Video No.SQL.18.05.35

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 5.Video No.SQL.18.05.36

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 19.Data Analytics -> SQL->Module 5.Video No.SQL.19.05.37

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 5.Video No.SQL.19.05.38

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

 

Class 20.Data Analytics -> SQL->Module 5.Video No.SQL.20.05.39

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks

Data Analytics -> SQL->Module 5.Video No.SQL.20.05.40

#Text-> Read Carefully  

#Video-> Watch Attentively 

#Sample MCQ with Answer for Exam

#Exam Total Marks 20  i) MCQ: 10  ii) Project Video :10 marks