JAVA

1. java
2. Java history
3. java features
4. java platform & components(JVM, JRE,JDK)
5. java lifecycle
6. Run & Set & compile java program

SQL

Sql Intro
SQL Database & User Creation
listener Trouble Shoot for database connect
Oracle & SQL developer installation & uninstallation

=================================DDL ====================================

Create Table(DDL-Data Definition Language)
Alter Table
Drop Table
Truncate Table
Rename Table
Copy Table

=================================DML====================================

Insert(Data Manipulation Language)
Update
Delete
Difference between Truncate / Delete / Drop

===============================DRL  / DSL=================================

Where Clause

Having Clause

Order By Clause(Asc, Desc, Limit, Random)

Select Clause(from, where, group by, order by, distinct, count, top, limit)

Group By Clause

Distinct Clause

Differences (group by v/s order by, having v/s where)

https://data-flair.training/blogs/sql-clauses/

Spark

Spark Intro
Spark Architecture
Spark Context  & Spark Physical Structure & Stage Execution
Spark API's(RDD, DF, Data Set)

Spark RDD

Spark Lazy Evolution

Spark Installation and Configuring

Spark RDD Creation with Parallelize

Spark RDD creation with READ FROM FILE

Data frame creation

Data Frame Creation with read& load functions

Scala

1. Scala Intro
2. Sample Program
3. Variable Declaration & Data Types

==============================    STRING     ==============================

1. string creation
2. creating format strings
3. string comparisons
4. string Interpolation
5. string methods

          Link

Python

1. Python Intro
2. Java v/s Python Program
3. Python Comments & Indentation
4. Print Function
5. Python Example

==========================VARIABLES=======================================

1. Variable Intro & Rules for naming
2. Var Example 1
3. Variable Assignment Example (sequence, Extended Seq, multi target, augmented)
4. Var - Multiple Assignment
5. Variables Types (Local, Global)
6. Variable Deletion
7. Variable Print (single, multiple)
8. Object Identifier(id of variables)

=========================== LIST ======================================

1. Python List
2. list example
3. List indexing and splitting
4. list negative indexing
5. Updating List values
6. List Basic operations
7. List_Built in Methods (append,copy,sort,insert,index,extend,pop,remove,del,reverse)
8. Iterating a List
9. list comprehension
10. Adding elements to the list
11. Removing elements from the list
12. list examples

#Example:1-removing duplicates in list

#Example:2- Write a program to find the sum of the element in the list.

#Example: 3- Write the program to find the lists consist of at least one common element.

=========================TUPLE========================================

1. Variable Tuple Assignment
2. Variable Tuple Assignment - indexing and slicing
3. Access Tuple Items(Tuple Indexing)
4. Tuple Update
5. Tuple Deletion
6. Tuple Operations
7. Tuple Loops
8. Tuple joins
9. 
   
10. List V/s Tuple   

==========================FUNCTIONS=======================================

1. Functions
2. Input and output Functions
3. Functions Arguments
4. Return Statement
5. scope and lifetime variables
6. Built in Functions

1. Lambda Function
2. Lambda Function with filter
3. Lambda Function with multiple statements
4. Lambda Function with if-else
5. Lambda Function with map
6. Lambda Function with list comprehension 

=========================STRING========================================

1. python strings
2. String Indexing & Splitting
3. String Slicing
4. String Modify
5. String Basic Operations
6. String Methods
7. String Formats
8. String Escape characters
9. String Indexing & Splitting

=========================Control Statements========================================

control Statements(if, if-else, if-else-if, nested if)

=========================Iterative Statements========================================

Iterative Statements(for, while, do-while)

=======================Break / Pass / Continue =======================================

Break Statement

Pass Statement

Continue Statement

========================Quick Examples========================================

1. Python Syntax & comments
2. Variables
3. Numbers
4. Casting
5. Strings
6. Operators
7. Lists

Home

 

HIVE

1. Hive Basic Commands(database)
2. Table Creation
3. Load / Insert data into Hive Tables
4. Property Files
5. Interview Quesitons_Hive