• Overview of Data Science 
• Key Roles & Responsibilities 
• Essential Tools & Technologies .
• Career Path in Data Science Fields 
• Roles in Data Science Field.

Introduction to SQL

• What is DBMS and RDBMS, difference between them and why do we need to know these fundamentals
• What is Normalization, types of norm forms and when to use what
• What are different keys in RDBMS
• What are different types of schemas

Creating Database

• Create a Database in MySQL
• SQL Data Types
• Create Table in SQL
• SQL INSERT INTO Statement
• SQL UPDATE Query - SQL UPDATE Statement

Clauses in SQL

• SQL Query Execution Order
• From Clause in SQL
• SQL WHERE Clause
• SQL GROUP BY
• SQL HAVING Clause
• ORDER BY in SQL
• SQL Aliases

Filtering in SQL

• SQL Operators
• AND & OR Operators in SQL
• Not Equal in SQL
• SQL BETWEEN Operator
• NULL Value in SQL
• Case Statements

Joins and Subqueries

• SQL JOINS (INNER, LEFT, RIGHT, and FULL Join)
• Self Join in SQL
• Types of Subqueries

Aggregation and window functions in SQL

• Aggregate Functions in SQL
• Group by Multiple Columns in SQL
• Rank functions (RANK, Dense Rank and Row number)
  

  SQL Constraints

• SQL PRIMARY KEY
• SQL FOREIGN KEY
• UNIQUE Constraint
• SQL CHECK Constraint
• Cascade in SQL
  

  Advanced Topics

• Views
• User defined Function
• Indexing

Data Types and Variables

• Integers, Floats, Strings, Booleans
• Type Conversion
• Variables and Assignment

Basic Operators

• Arithmetic Operators
• Comparison Operators
• Logical Operators

Control Structures

• Conditional Statements (if, elif, else)
• Loops (for, while)
• break, continue, and pass

Basic Data Structures

• Lists
• Tuples
• Sets
• Dictionaries

Functions

• Defining and Calling Functions
• Arguments and Return Values
• Local and Global Variables
• Functions (continued)

Lambda Functions

• *args and **kwargs
• Decorators
• Generators

File Handling

• Reading and Writing Files
• Working with Directories
• Exception Handling during I/O

Error and Exception Handling

• try, except, finally
• • • • • • Custom Exceptions

Module 1:Introduction to Big Data and Cloud Computing

• What is Big-Data and Types of Data.

• What is Cloud Computing?

• Types of Cloud deployment models

  • Private Cloud

  • Public Cloud

  • Hybrid Cloud 

• Types of Cloud services

  • IaaS – Infrastructure as a Service

  • PaaS – Platform as a Service

  • SaaS – Software as a Service

• Create a Storage account
• Types of Storage accounts
• Create a ADLS account
• Load data to ADLS
• Read and write Data to ADLS
• Configure Backup and Disaster Recovery

Module 3: Introduction to Azure

• Create an Azure account
• Overview of Azure portal.
• Subscription
• Resource Group
• Blob Storage, Data Lake Storage
• Azure Data Factory
• Azure Databricks
• Azure Key Vaults
• Azure Logic Apps

Module 4: Azure Data Factory

• Introduction to Azure Data Factory
• Components of Azure Data Factory
• Integration Runtime (IR)
• Azure Auto Integration Runtime
• Self Hosted Integration Runtime
• Azure SSIS Integration Runtime
• Linked Service
• Datasets
• Pipelines and Activities in pipelines
• Copy Data
• Delete
• Stored Procedure
• Get-Metadata
• Lookup
• For Each
• IF Condition, Switch
• Until
• Wait
• Fail
• Data Flow
• Set Variable
• Append Variable
• Databricks Notebook
• Execute Pipelines
• Triggers
• Schedule Trigger
• Tumbling Window Trigger
• Storage Events
• Parameters in linked servers, datasets, pipelines, Triggers
• Monitor Jobs
• Send Failure notifications using Logic Apps
• Manage credentials using Azure Key Vault

• Introduction to Spark
• Overview of Spark Architecture
• RDD Vs DataFlow Vs Dataset
• Transformations & Actions 
• Introduction to DataBricks
• Create Databricks Workspace
• Create Clusters
• Create Databricks Notebooks
• Databricks File System (DBFS)
• Create, copy, move les within DBFS 
• Handle multiple les and folders
• Archive les in DBFS 
• Databricks Utilities (dbUtils) 
• File system
• Secrets
• Notebook 
• Widgets