The Tutorials in this series are created using R3.0.0, 3.2.3, 3.4.4 on Mac OS and Ubuntu 16.04. R is a free, useful software package to anybody who wishes to undertake extensive statistical computations (a user community that includes students, researchers and professionals belonging to various disciplines). Read more
Foss : R - English
Outline: What is working directory in R How to know the current working directory How to use getwd function How to set a working directory from the user interface of RStudio How to set..
Outline: Shortcut key for assignment operator (<-) How to perform numeric indexing How to extract a row or column from a data frame How to retrieve multiple rows from a data frame How ..
Outline: Data required in a matrix format Convert a data frame into a matrix Create a matrix with known data Add two matrices Subtract two matrices Multiply two matrices elementwise..
Outline: How to find the inverse of a matrix How to calculate the sum of elements in a matrix using for loop How to calculate the sum of elements in a matrix using the sum function How..
Outline: Use of built-in functions in R for exploring a data frame Access help in RStudio Advantages of merging data frames Merge two data frames Import data from command line Impor..
Outline: What is an object in R Types of R - objects What is an atomic vector in R Types of atomic vectors How to find types of vectors Factors in R Levels of a factor in R Identi..
Outline: Lists in R Atomic vectors in R Difference between atomic vectors and lists in R How to create a list How to assign names to the elements of a list Named list in R How to..
Outline: How to find the dimensions of a data frame Define a histogram Plot a histogram in R Add labels to the histogram Add color to the bins of a histogram Change the number of b..
Outline: What is a bar chart Draw a bar chart Use the barplot function Add labels to the bar chart Adjust the labels of the bar chart What is a scatter plot Draw a scatter plot Use ..
Outline: Define visualization About grammar of graphics- ggplot2 Use of the plot function Add labels to a plot Change the color and type of plot Plot two graphs in the same plot Add..
Outline: Define aesthetic Need for aesthetic in plotting Draw a scatter plot Customize a scatter plot View the structure of an object View the levels of a categorical variable Dr..
Outline: What is data visualization Need for data manipulation What is dplyr package Functions in dplyr package Install dplyr package Use filter function Use filter function wit..
Outline: Functions in the dplyr package Select multiple variables in a data frame Remove variables from a data frame Use of select function Use of starts_with function Change the ..
Outline: About summarise function in dplyr About group_by function in dplyr Difference between summarise and group_by functions Use summarise and group_by functions together About pip..
Outline: About conditional statements Syntax of if, else and else if statements Use if, else and else if statements Use if else function Arguments of if else function Add a new column ..
Outline: Define a function About built-in functions and user-defined functions Need for a user-defined function Syntax of a function Parts of a function Create a user-defined functio..
Foss : RDBMS PostgreSQL - English
Outline: Introduction to RDBMS Common Software based on RDBMS Prerequisites for learning PostgreSQL OS and PostgreSQL version used Features of PostgreSQL Who can use PostgreSQL? Glimp..
Outline: Installation of PostgreSQL on Linux Installation of PostgreSQL on Windows Installation of pgAdmin Connect to PostgreSQL database Set Password for the database Disconnect from ..
Outline: How to connect to the server Introduction to database and its objects How to create a database Table and its attributes pgAdmin interface. New server registration How to crea..
Outline: Insert single row to the table Insert multiple rows to the table How to execute the query Retrieve the data using select statement Introduction to Primary key Rules to define ..