Database Management course for advanced learners by CSI Mumbai Chapter

Fundamentals of R
Introduction to R
Understanding R programs
Case study on data management
o Reading and writing data
o Manipulating data
o Conditional statements
o Merging , sorting and exporting datasets
Data preparation and cleaning in R
Needs & methods of data preparation
Handling missing values
Outlier treatment
Transforming variables
Derived variables
Binning data
Data visualization in R
Creating a bar chart, dot plot
Creating a scatter plot, pie chart
Creating a histogram and box plot
Plotting with base & lattice graphics
Plotting and coloring in R
Using functions in R
Sapply, apply, tapply functions
Connecting R with databases
Basics of SQL
RODBC and DBI Package
Performing queries
Basic statistics in R
Summarizing data, measures of central tendency