

Latest News


Core Java and SQL for Beginners

Dear Vasavites
Basics of JAVA
· What is JAVA?
· history of JAVA
· Features of java
· what is JDK, JRE, JVM?
· What are variables
· Datatypes
· Operators
· Keywords
CONTROL STRUCTURES/CONTROL FLOW STATEMEMTS
· If
· If-else
· switch
· For loop
· While loop
· Do while loop
· Break
· Continue
· programs on all the below stated topics
JAVA OBJECT CLASS AND POLYMORPHISM
· Constructor
· THIS KEYWORD
· STATIC KEYWORD
· Method Over Loading
· Method Over Riding
· Access Modifiers
OOPS CONCEPTS
· Object
· Class
· Method
· Abstraction
· Encapsulation
· Inheritance
· Polymorphism
STRINGS
· Java strings
· What is a string
· What is a substring
· String buffer class
· String builder class
· String methods
Exceptional handling
· Exceptions in java
· Try catch
· Multi catch
· Throw
· Throws
· Final
Multi -Threading
· What is multi-Threading
· Life cycle of thread
· Thread priority
· Garbage collection
· Dead lock
· Inter thread communication
· Synchronization in java
Collections
· What is Collection Framework
· Array List
· Linked LIST
· ARRAY LIST VS LINKED LIST
· List Interface
· Hash set
· Linked Hash Set
· Tree Set
· Map Interface
· Hash Map
· Comparable VS Comparator Interface
· Vector
· Stack
File Handling in Java
· Recursively List and Filter all files and folders
· Read content from a File
· Writing Content to a File - Files write method
JDBC
· JDBC introduction with Basic JDBC Operation (e.g. MySQL)
· Submitting SQL Queries
· Inserting Data into the Database
· Updating Data in the Database
· Deleting Data from the Database
· Creating Prepared Statements
· Calling Stored Procedure
· Transaction handling
FREQUENTLY ASKED CODING INTERVIEW PROGRAMS
Technical questions and Answers will be discussed
A project on java
SQL
· What is SQL?
· SQL syntax
· SQL Database
· How to create database
· How to UPDATE Database
· How to Rename database
· How to select database
· What is a table
· How to alter commands
· How to create a Table
· DROP table
· DELETE Table
· RENAME Table
· TRUNCATE Table
· Copy Table
· SELECT
· SELECT UNIQUE
· COUNT
· DISTINCT
· TOP
· LAST
· IN
· SUM
· DATE
Clauses: -
· WHERE
· AND
· OR
· HAVING
· ORDER BY
· ORDER BY ASC
· ORDER BY DESC
· RANDOM
· LIMIT
· INSERT
· UPDATE
· DELETE TABLE
· ROWS
· ALL ROWS
· DUPLICATE ROWS
· DATABASE
· VIEWS
· JOINS
SQL KEYS
· PRIMARY KEY
· FOREIGN KEY
· UNIQUE