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: 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 ..
Outline: View data in the Edit data window Insert records in the Edit data window Inserting a NULL value in a record Basic SELECT statement SELECT statement with WHERE clause Compariso..
Outline: DISTINCT clause in SELECT statement How to use BETWEEN operator in SELECT statement How to use LIKE operator in SELECT statement Usage of percent and underscore wildcards with e..
Outline: What is a Foreign key? Foreign key link between students and department table Create a parent table department Alter table command Add a new column to the existing students tab..
Outline: Aggregate functions What is Group by clause? Syntax for Group by clause Examples for using Group by clause with one/multiple columns Having clause Syntax for Having clause Ex..
Outline: Update statement Syntax for Update statement Examples for Update statement Updating multiple columns Syntax for Delete statement Examples for Delete statement Delete rows for..
Foss : Ruby - Assamese
Outline: 1.1 ৰুবিৰ পৰিচয় ৰুবি কি? বৈশিষ্ট্য ৰুবি জেম্চ ৰুবিত সাহায্য
Outline: 2.1 পৰিচয় -ৰুবি আৰু ভেৰিয়বল ডায়নামিক টাইপিঙ এটা ভেৰিয়বল ডিক্লেয়াৰ কৰা - ভেৰিয়বল টাইপ পৰিবর্তন কৰা - var মান ৰুপান্তৰ কৰা অর্থাৎ float,string,binary লৈ ইত্..
Outline: 3.1 মেথড কি মেথডৰ সৈতে কাম কৰা মেথডক ঘোষণা আৰু কল কৰা 3.2 মেথডত আর্গুমেন্ট পাস কৰা উদাহৰণ দ্বাৰা আর্গুমেন্ট আৰু সিনট্যাক্স ব্যাখ্যা কৰা 3.3 মেথডত ভ্যালু পাস কৰা উদাহৰণ দ্বা..
Outline: গাণিতিক অপাৰেটৰ যোগ বিয়োগ গুণ বিভাগ মডিউলস সূচক
Outline: লজিক্যাল অপাৰেটৰ And && Or || Not ! সমান্তৰাল নিয়োগ ৰেন্জ অপাৰেটৰ ইনক্লুসিভ অপাৰেটৰ (..) এক্সক্লুসিভ অপাৰেটৰ (...)
Outline: ৰুবিত কন্ট্ৰোল স্টেতমেন্ট * সিনট্যাক্স আৰু ব্যবহাৰ * if statement * else statement * elsif statement * case statement * উপৰৰ প্রতিটোৰ উদাহৰণেৰে সম্পাদন
Outline: * ৰুবিত for & each loops * “loop” শব্দটিৰ অর্থ * loopৰ বিভিন্ন ধৰণৰ * “for” loop ৰ সিনট্যাক্স * “for” loopৰ উদাহৰেণে সম্পাদন *“each” loopৰ সিনট্যাক্স * “each” loopৰ উদাহৰেণে..