Data Analysis Course 30 hours

• Reading Material: History of Databases & NoSQL Database Choosing the Right RDBMS
• Installation of the software (Windows and Linux)

• • History and Features of TSQL
  • Types 0f TSQL Commands
  • Data Definition Language (DDL) – Create, Alter and Drop
  • Data Manipulation Language (DML) – Insert, Delete, Update, Truncate
  • Data Query Language (DQL) – Select
  • Data Control Language (DCL) – Grant and Revoke
  • Transaction Control Language (TCL) – Rollback, save point
  • Constrains (Not Null, Unique, Default, Check constraints,
  Primary Key and Referential Integrity or foreign key constraints
  • Data Types In TSQL
  • Clauses
  Where, Group by, Having and Order by

• Numeric Functions
• Date Functions
• Aggregate Functions
• Super Aggregates Over (partition by …) Clause
• Ranking Functions
• Common Table Expressions (CTE)

•  Self Join
•  Left Join
•  Right Join and full outer join

• Multi Row Sub Queries
• Co-Related Sub Queries
• Clustered Index
• No Clustered Index
• Create, Alter and Drop Indexes
• Using Indexes
• Purpose of Views
• Creating, Altering and Dropping Indexes
• Simple and Complex View
• Encryption and Schema Binding Options in creating views

• Introduction
• Begin Transaction
• Commit Transaction
• Rollback Transaction
• Save Transaction

• Working with Cursors
• Types of Cursors
• Static, Dynamic and Keyset Cursors
• Local and Global Cursors
• Stored procedure
• Creating, Altering, and Dropping
• Input and Output Parameters

• Creating, Altering, and Dropping
• Types of User-Defined Functions
• Table Valued Functions
• Inline Table-Valued Functions
• Multi Statement Table Valued Functions

• Purpose of Triggers
• Differences Between Stored
• Procedures and User-Defined
• Functions and Triggers
• Creating, Altering and Dropping Triggers

• Task – Data Analysis using SQL project.
• Introduction to Data Warehouse
• Introduction to ETL Tools
• Introduction to Schemas
• Introduction to Dimension and Fact Tables

• Introduction to Python
• Python Installation
• Interpreters’ vs Compilers
• Integrated Development Environments (IDES) (Notebook, VS code, Azure Data Studio etc.) Basic concepts

• Python Arithmetic Operators
• Python Comparison Operators
• Python Assignment Operators
• Python Bitwise Operators
• Python Logical Operators

• Variables
• Assigning Values to Variables
• Multiple Assignment
• Python Numbers
• Python Strings
• Accessing Values in Strings
• String Special Operators
• String Formatting Operator
• Triple Quotes
• Built-in String Operations

• Accessing Values in Lists
• Updating Lists
• Delete List Elements
• Basic List Operations
• Indexing, Slicing, and Matrixes
• Built-in List Functions & Methods

• Accessing Values in Tuples
• Updating Tuples
• Delete Tuple Elements
• Basic Tuples Operations
• Indexing, Slicing, and Matrixes
• No Enclosing Delimiters
• Built-in Tuple Functions

• Accessing Values in Dictionary
• Updating Dictionary
• Delete Dictionary Elements
• Properties of Dictionary Keys
• Built-in Dictionary Functions & Methods

• if statements
• if..else statements
• nested if statements
• while loop
• for loop
• nested loops
• Loop Control Statements
• break statement
• continue statement
• pass statement

• Defining a Function
• Calling a Function
• Pass by reference vs value
• Function Arguments
•  Required arguments
• Keyword arguments
• Default arguments
•  Variable-length arguments
• The return Statement
• Scope of Variables
• Global vs. Local variables

• Creating class in Python
• Documented String
• Private Identifier
• Constructor
• Inheritance
• Polymorphism
• Decorator, Iterator and Generator

• Lambda
• Map
• Filter
• Reduce

• Create
• Open
• Read
• Write
• Delete
• Append
• Others

• Lambda
• Map
• Filter
• Reduce

• NumPy.
• Pandas
• Matplotlib
• Seaborn
• Explanatory Data Analysis