R Language Programming with SQL

Unit I

Introduction to Analytics and R programming (NOS 2101)

  • Introduction to R, RStudio (GUI)
  • R Windows Environment,
  • introduction to various data types, Numeric, Character, date, data frame, array, matrix etc.,
  • Reading Datasets,
  • Working with different file types .txt,.csv etc.
  • Outliers,
  • Combining Datasets,
  • R Functions and loops.
  • Summary Statistics - Summarizing data with R,
  • Probability,
  • Expected, Random,
  • Bivariate Random variables,
  • Probability distribution. Central Limit Theorem etc.

Unit II

SQL using R & Correlation and Regression Analysis (NOS 2101)

  • Introduction to NoSQL,
  • Connecting R to NoSQL databases.
  • Excel and R integration with R connector.
  • Regression Analysis,
  • Assumptions of OLS Regression,
  • Regression Modelling.
  • Correlation, ANOVA, Forecasting, Heteroscedasticity, Autocorrelation,
  • Introduction to Multiple Regression etc.

 

For registrations contact: 8169 543 099 or 9860 246 128.