Build Projects using Java JDBC & SQL with practical examples

Course Curriculum

Chapter 1: Introduction & Setup

Lecture 1: Course Overview

Lecture 2: About your Instructor

Lecture 3: What is Database and Database Server and Tables

Lecture 4: Real world Explanation of Tables Rows Relationship between Tables

Lecture 5: Different Types of SQL Commands

Lecture 6: Data Types in SQL

Lecture 7: Downloading and Installing the Database Server

Chapter 2: Practicing SQL Queries & Joins

Lecture 1: Creating Category Table

Lecture 2: Create, Alter, Drop and Truncate commands

Lecture 3: DML Insert Data to the Table

Lecture 4: Select Query Examples

Lecture 5: DML Update Query with Example

Lecture 6: DML DELETE Query Example

Lecture 7: Join In SQL with Example

Lecture 8: Types of Join in SQL

Chapter 3: Core Java Mastery: Everything You Need to Know to Start Writing Java Programs

Lecture 1: Introduction and Advantages of Java

Lecture 2: Disadvantages of Java

Lecture 3: Basics of Java Programming Language

Lecture 4: Java Life Cycle

Lecture 5: Downloading and Installing Java

Lecture 6: Writing , Compiling and Running our First Java Program

Lecture 7: Understanding our First Java Program

Lecture 8: Downloading and Installing IDE

Lecture 9: Creating first java project in IDE

Lecture 10: Comments in Java

Lecture 11: Naming Convention Part-1

Lecture 12: Naming Convention Part-2

Lecture 13: Variable and Data Types in Java

Lecture 14: Playing around with data Type Variables and Operators

Lecture 15: Using For Loop in Java

Lecture 16: Using While Loop in Java

Lecture 17: Using do While Loop in Java

Lecture 18: If and If Else in Java

Lecture 19: If ElseIf Else in java

Lecture 20: Taking User Input from Keyboard

Lecture 21: Making Java Program to keep running

Lecture 22: TernaryOperator in Java

Lecture 23: Switch Case and Break in Java

Lecture 24: Understanding Object Oriented Programming

Lecture 25: Understanding OOPS Concept Part-1

Lecture 26: OOPS Concept Analogy

Lecture 27: Understanding OOPS Concepts wit Real World Examples

Lecture 28: Object and Reference vs Heap and Stack

Lecture 29: Working with Object and Classes

Lecture 30: Understanding concept of Polymorphism, Static and Dynamic Polymorphism in Java

Lecture 31: Polymorphism, Method Overloading, Debugging

Lecture 32: What are Constructors

Lecture 33: Constructor Overloading, this keyword

Lecture 34: Understanding concept of Inheritance in Java

Lecture 35: Inheritance, super keyword, Dynamic Polymorphism

Lecture 36: Inner Class and Object of Inner class in Java

Lecture 37: Undertsanding abstract class and abstraction in Java

Lecture 38: Handson examples of Abstraction and Abstract class in Java

Lecture 39: Understanding Arrays in Java

Lecture 40: Handson with Array Examples

Lecture 41: Mini Project with Array

Lecture 42: Concept of Static in Java

Lecture 43: Handson and Debugging for Static concept in Java

Lecture 44: Concept of Final in Java

Lecture 45: Handson with Final keyword in java

Lecture 46: Concept of Interface and Multiple Inheritance in Java

Lecture 47: Handson and Debugging for Interface and Multiple Inheritance in Java

Lecture 48: Concept of Wrapper Class, Autoboxing and Unboxing

Lecture 49: Handson Examples for Wrapper class, Autoboxing and Unboxing

Lecture 50: Concept Of String and its methods in Java

Lecture 51: Handson with String and String Functions

Lecture 52: Handson with StringBuilder and its Functions

Lecture 53: Handson with CompareTo method in String

Lecture 54: Concept of Access Modifiers in Java

Lecture 55: Handson with Accessmodifiers

Lecture 56: Concept of Collection Framework in Java

Lecture 57: Handson with Raw ArrayList with Mixed Datatype elements

Lecture 58: Handson with Generics based ArrayList

Lecture 59: Handson with Custom Class and ArrayList

Lecture 60: Handson with ArrayList methods

Lecture 61: Handson with Set and Hashset in Collection Framework

Lecture 62: Handson with Map and its Uses

Lecture 63: Concept of Exception Handling in Java

Lecture 64: Handson with Arithmetic Exception handling

Lecture 65: Handson with NullPointerException handling

Lecture 66: Handson with ArrayIndexOutOfBoundException handling

Lecture 67: Concept of Finally Block in Exception handling

Lecture 68: Handson with Finally Block in Exception Handling – part-1

Lecture 69: Handson with Finally Block in Exception Handling – part-2

Lecture 70: Handosn with Custom Exception handling

Chapter 4: JDBC in Action: Concepts and Practical Code Examples

Lecture 1: What is JDBC in Java and Why do we need it

Lecture 2: JDBC concept of getting connection and executing queries

Lecture 3: Creating new Java Project and Adding Jar to Intellij

Lecture 4: Creating database Configuration class to create connection

Lecture 5: Adding new User to Database by Taking user Input

Lecture 6: Testing adding of new user

Lecture 7: Get All users and test it

Lecture 8: Update User data and test it

Lecture 9: Delete user based on Username and test it

Chapter 5: Source Code

Lecture 1: Codebase