Course Includes

• Introduction to RDBMS

• What is Data?

• Databases

• Types of Databases

• Relational DBMS

• Entities and Relationships

• Tables in RDBMS

• Primary Key, Foreign Key,EF Codd’s Rules

• What is a transaction

• ACID property

• Introduction to Python

• Basic Python Syntax

• String Handling

• Operators

• Conditional Statements

• Looping Statements

• Control Statements

• Collections

• Functions

• Modules

• Packages

• File Handling

• OOPS Concepts

• Classes and Objects

• Inheritance and Polymorphism

• Abstract classes and Interfaces

• Exception Handling

• Regular Expression

• Database Connectivity

• Python XML and JSON Parsers

• Introduction to Pandas

• Handling DataFrame

• Merge and Groupby

• Pivot table and Stack Unstack

• Time Series analysis

• Numpy

• Data Visulization

• Introduction to PowerBI

• PowerBI Desktop Interface

• Connecting Power BI to excel

• Charts and thier properties

• Table,matrix properties, Tree Map

• Introduction to DAX,Derived Fields and Date functions

• Introduction to conditional statements

• Slicers and its basic uses properties

• Super aggregations and Scatter plot

• Introduction to rank and Parameter

• Introduction to Power BI Service,Row Level Security

• Time intelligence functions YTD,QTD,MTD

• Date ADD, Same period, Parallel Period

• Introduction to cloud computing

• Overview of an AWS free tier offer

• Creating an AWS account

• Intoduction to EC2 service

• Launching Windows and linux instances

• Connecting to windows and linux instances

• Introduction to S3

• Creating Buckets and uploading object to a Bucket

• S3 bucket policy

• Introduction to RDS

• Launching Oracle Database server

• Connecting to Oracle database

• Introduction to IAM

• Creating users and attaching services to a user

• File commands

• Dir commands

• Vi editor

• Linux process

• Grep and its options

• Shell scripting & awk

• Cron job scheduling

A capstone project is a culminating and often multifaceted project undertaken at the end of an academic program or training, It allows students to apply the knowledge and skills they’ve acquired throughout their studies to solve a real-world problem or address a specific challenge. Capstone projects can vary widely in scope and format, ranging from research papers and presentations to software development, design prototypes, or even community service initiatives. They serve as a practical demonstration of a student’s readiness for graduation or entry into their chosen field.