java training in delhi

SQL Training in Delhi

We offers SQL Training using oracle and SQL server in west delhi. If you are in delhi and searching for best sql and oracle training institute in delhi, then VSIT is best place to learn it. our oracle trainer is qualified and professional, he is working on oracle technology, he will teach you how to use sql in IT industry.

Oracle Developer OCA / OCP Certification

EXAM	+	EXAM	=	Oracle PL/SQL Developer Certified Associate
Introduction to Oracle9i SQL ( 1Z0-007 )
or		Oracle Database 9i/10g Program with PL/SQL ( 1Z0-147 )
Oracle Database 10g: SQL Expert ( 1Z0-047 )		OR
or		Oracle Database 11g: Program with PL/SQL ( 1Z0-144 )
Oracle Database 11g: SQL Fundamentals I ( 1Z0-051 )

Oracle Certification Name & Code

Oracle Certification program is offered by Oracle Corporation for Professionals who they wants to be Oracle Certified Professional
List Of Oracle Certification:

OCA  (Oracle Certified Associate )
OCP (Oracle Certified Professional ) and
OCM (Oracle Certified Master )

Connect Oracle Table using JDBC

Connect Oracle Table using JDBC

We can connect oracle database using JDBC (JAVA). There are four steps to connect oracle database using JDBC :

1) Register the JDBC driver
    eg : Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
2) Open a connection
    eg : con=DriverManager.getConnection("jdbc:odbc:data","scott","tiger");
3) Create statement
    eg : stmt=con.createStatement();
4) Execute a Query and Extract data from table
    eg : rs=stmt.executeQuery("select * from table");
   
Following is the code to connect oracle database table.

    import java.sql.*;
    public class DataBase
    {
    Statement stmt;
    Connection con;
    ResultSet rs;
    public DataBase()

    {

        try{

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con=DriverManager.getConnection("jdbc:odbc:data","scott","tiger");
        stmt=con.createStatement();
        rs=stmt.executeQuery("select * from table");
        while(rs.next())
        {
            System.out.print(rs.getInt(1));
            System.out.print(rs.getString(2));
            System.out.print(rs.getString(3));

        }

        }

        catch(Exception e){}

    }
    public static void main(String arg[])
    {
        DataBase db=new DataBase();
    }
}
     

Oracle DBA Training in Delhi

Oracle DBA Training in Delhi : Oracle DBA Training at VSIT is designed in a very project oriented way. From the start of the course we keep in mind that the student should not only be given the conceptual or theoretical knowledge but also the practical knowledge. Not only this, a student is prepared to face the interview on the completion of the course by giving them interview handling tips as well. We call the industry experts to visit us and train students.