Western India Regional Council of
The Institute of Chartered Accountants of India

(Set up by an Act of Parliament)

Welcome, Guest

Virtual Workshop on Data Management using Tools MySQL, R and Excel (Students)

Fees: Member & Student ₹2000                          

Please Pay your Attention here: Separate Link will be sent for each day for Joining Webinar. Each day new Link will be shared on the email id submitted while carrying out registration. 

To ensure timely receipt of link, kindly: 1. White list email from wirc@icai.in /customercare goto webinar.com. 2. Check Spam Box. 3. Incase of non-receipt of link & technical difficulty write email with payment details on wircevents@icai.in 

Event Details

Event Date 01-12-2020 6:00 pm
Event End Date 10-12-2020 8:00 pm
CPE Credit Hrs No CPE

Introduction

Data science is an exciting discipline that allows you to turn raw data into understanding, insight, and knowledge. The goal of this programme is to help you learn the most important tools in R and MySql that will allow you to do data science. You will have the tools to tackle a wide variety of data science challenges, using the best parts of MySQL and R.

Topic

Speaker

01.12.2020: 06.00 pm to 08.00 pm

Day # 1 Database Fundamentals:

  • MYSQL Server Basics,  
  • Database models 
  • ER Model Overview 
  • Data types 
  • Understanding Test Database 
  • Basics Queries 
  • Removing Duplicates 
  • Data Filters Using Operators 
  • Data Sorting

Prof. Asif Rampurawala

Prof. Sanjeela Sagar

02.12.2020: 06.00 pm to 08.00 pm

Day# 2 Sql Queries:

  • Grouping 
  • Joins 
  • Arithmetic and String functions 
  • Advanced Functions 
  • SET Operators 
  • Creating Complex Queries 
  • DML operations - Insert, Update & Delete

Prof. Asif Rampurawala

Prof. Sanjeela Sagar

03.12.2020: 06.00 pm to 08.00 pm

Day# 3 Advance queries

  • Database Objects - Create, Alter and Drop Tables 
  • Views 
  • Complex Views 
  • Indexes 
  • Advanced Index Concepts 
  • How Data is Stored 
  • Security - User Management 

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
 04.12.2020: 06.00 pm to 08.00 pm 

Day# 4 Triggers and Transactions:

  • Transaction Concepts 
  • Triggers
  • SQL for working with Transaction 

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
05.12.2020: 06.00 pm to 08.00 pm 

Day# 5 Introduction to R:

  • The Basics
  • Vectors and Matrices
  • Data Frames
  • Factors
  • Lists

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
06.12.2020: 06.00 pm to 08.00 pm

Day# 6 R conditions and functions:

  • Dates 
  • If Statements and Operators 
  • Loops 
  • Functions 
  • Apply 

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
 07.12.2020: 06.00 pm to 08.00 pm  

Day# 7 Time Series Data Analysis in R:

  • Introduction to eXtensible Time Series, using xts and zoo for time series
  • First Order of Business - Basic Manipulations
  • Merging and modifying time series
  • Apply and aggregate by time
  • Extra features of xts

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
 08.12.2020: 06.00 pm to 08.00 pm 

Day# 8 Importing and Managing Data in R:

  • Introduction and downloading data
  • Extracting and transforming data
  • Managing data from multiple sources
  • Aligning data with different periodicities
  • Importing text data, and adjusting for corporate actions

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
09.12.2020: 06.00 pm to 08.00 pm  

Day# 9 Introduction to Portfolio Analysis in R:

  • The building blocks
  • Analysing performance
  • Performance drivers
  • Optimizing the portfolio

Prof. Asif Rampurawala

Prof. Sanjeela Sagar
10.12.2020: 06.00 pm to 08.00 pm  

Day# 10 Data analytics using Excel:

  • Analysis Tool Pak
  • What if Analysis
  • Solver
  • Visualization

Prof. Asif Rampurawala

Prof. Sanjeela Sagar

 

 

 

 

Students