Java Core Class (Type, File)

5. GROUP BY, Having...

1. Grouping data using Group by.

2. Group by vs Distinct.

3. Aggregation functions and group by.

4. Filtering data with Having clause.

5. Difference between group by and having.

6. Best practice of using group by and having.

6. Delete, Truncate, Drop

1. Delete operation details.

2. Truncate operation details.

3. Drop sql command.

4. Delete vs truncate. Best practice.

5. Deleting duplicate rows when there is no primary key on a database table.

Web
1. Java Web application

1. What is a Web application?

2. Web server, Application server, web container differences.

3. What is the structure of a java Web application (optional and mandatory elements).

4. Deployment of a java Web application. Best practice.

5. Web.xml overview, versions.

6. Structure of Web.xml, key elements.

7. Ways to configure Web Application with web.xml.

2. HTTP

1. Http basic features.

2. Versions of http.

3. Http vs Https.

4. Structure of Http. Optional and mandatory parts.

5. Structure of Request and Response message in Http.

6. Request methods overview.

7. Difference between get and post methods.

8. Idempotent methods.

9. Status code in Http.

10. Structure of Header part of Http. Limitations.

11. Structure of Body part of Http. Limitations.

12. How session is maintained on Http?

13. Cookies. Advantage and disadvantage of using. Best practice.