Back
  • 1-855-WE NRIVA
  • Your NRIVA Chapter  
    • NRI Vasavi Association

Category: Education Series
Chapter: All Chapters
Contact Email: training@nriva.org
Event For: Member
Speaker Name:
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