Job Oriented Advanced Java 1

• Basic CRUD (Create, Read, Update, Delete) Commands
• Select: Where Clause, Like and Wildcards
• Distinct, Alias and Aggregate Functions
• Order By, Group By and Limit
• SQL Constraints
• Join: Inner, Left, Right and Full
• Normalization

• Learn JDBC to connect your Java application with the MySQL database.

  ---

  • Introduction, use, API, Driver, Data Types, SQLExceptions
  • Important interfaces – Connection, Statement, ResultSet, ResultSetMetaData, PreparedStatement
  • Interview Topics
  • Transaction Management & Stored Procedures – ACID properties, commit and rollback
  • Security – SQL injection and other common attacks

Get a good grasp of fundamental technology working behind the scenes of any Java web application.

• What is J2EE, Server Application, Role of Browser, Working with Apache Tomcat and Glassfish web server
• Java Servlet
• Web Programming – Introduction, Basic terminologies
• Servlet – Introduction, Servlet API, Interfaces
• Servlet Lifecycle & Working – init(), service(), destroy()
• Form data – GET & POST requests
• Cookies and Sessions, URL rewriting, File Upload/Download
• Event and Listener in Servlet

• Architecture & Lifecycle of JSP – jspInit(), _jspService(), jspDestroy()
• JSP scripting elements – scriptlet tag, expression tag and declaration tag
• Implicit objects – request, response, out, session, application, and others
• Directives, Action, Client request, Server response, Http Status Codes, Cookies & Sessions
• Using Tags of JSTL (Java Standard tag Libraries)

You are now ready to face interviews. Trisect will help you in getting Delhi NCR based interviews.