Build Projects using Java JDBC & SQL with practical examples

Name: Build Projects using Java JDBC & SQL with practical examples
Rating: 4.7 (26 reviews)

Master Java, SQL, Database and JDBC and learn to develop projects in a step by step hands-on based approach

Created byRanjan Pandey

Last updated 12/2023

English

What you'll learn

You will learn about Database and Database Server
You will learn about Core Java with concepts and code examples
You will learn about Tables and Relationship between them
You will learn about different types of SQL commands & Joins
You will learn about Java JDBC and how to use it in real world
You will learn how to establish a connection from Java code to the database and perform different operations like Select, Insert, Update, and Delete.
You will also get the complete source code.

Course content

5 sections • 95 lectures • 11h 9m total length

Course Overview1:24
About your Instructor0:18
What is Database and Database Server and Tables9:22
Real world Explanation of Tables Rows Relationship between Tables10:25
Different Types of SQL Commands7:31
Data Types in SQL5:24
Downloading and Installing the Database Server3:13

Introduction and Advantages of Java3:44
Disadvantages of Java3:15
Basics of Java Programming Language11:49
Java Life Cycle3:59
Downloading and Installing Java4:11
Writing , Compiling and Running our First Java Program5:48
Understanding our First Java Program6:43
Downloading and Installing IDE2:16
Creating first java project in IDE4:15
Comments in Java8:05
Naming Convention Part-15:49
Naming Convention Part-24:41
Variable and Data Types in Java5:13
Playing around with data Type Variables and Operators10:09
Using For Loop in Java11:52
Using While Loop in Java3:53
Using do While Loop in Java2:53
If and If Else in Java5:33
If ElseIf Else in java4:10
Taking User Input from Keyboard3:47
Making Java Program to keep running2:53
TernaryOperator in Java1:54
Switch Case and Break in Java4:47
Understanding Object Oriented Programming7:03
Understanding OOPS Concept Part-15:00
OOPS Concept Analogy2:06
Understanding OOPS Concepts wit Real World Examples6:50
Object and Reference vs Heap and Stack2:30
Working with Object and Classes19:14
Understanding concept of Polymorphism, Static and Dynamic Polymorphism in Java5:06
Polymorphism, Method Overloading, Debugging12:39
What are Constructors2:37
Constructor Overloading, this keyword10:29
Understanding concept of Inheritance in Java10:59
Inheritance, super keyword, Dynamic Polymorphism22:05
Inner Class and Object of Inner class in Java4:52
Undertsanding abstract class and abstraction in Java3:46
Handson examples of Abstraction and Abstract class in Java13:32
Understanding Arrays in Java14:02
Handson with Array Examples5:38
Mini Project with Array4:29
Concept of Static in Java14:26
Handson and Debugging for Static concept in Java10:21
Concept of Final in Java4:53
Handson with Final keyword in java3:55
Concept of Interface and Multiple Inheritance in Java9:50
Handson and Debugging for Interface and Multiple Inheritance in Java8:57
Concept of Wrapper Class, Autoboxing and Unboxing6:34
Handson Examples for Wrapper class, Autoboxing and Unboxing3:53
Concept Of String and its methods in Java30:59
Handson with String and String Functions21:36
Handson with StringBuilder and its Functions3:45
Handson with CompareTo method in String1:38
Concept of Access Modifiers in Java8:30
Handson with Accessmodifiers9:46
Concept of Collection Framework in Java14:38
Handson with Raw ArrayList with Mixed Datatype elements5:10
Handson with Generics based ArrayList3:05
Handson with Custom Class and ArrayList6:53
Handson with ArrayList methods3:30
Handson with Set and Hashset in Collection Framework3:52
Handson with Map and its Uses14:43
Concept of Exception Handling in Java21:50
Handson with Arithmetic Exception handling6:14
Handson with NullPointerException handling4:13
Handson with ArrayIndexOutOfBoundException handling2:00
Concept of Finally Block in Exception handling3:14
Handson with Finally Block in Exception Handling - part-14:28
Handson with Finally Block in Exception Handling - part-21:38
Handosn with Custom Exception handling11:49

What is JDBC in Java and Why do we need it2:57
JDBC concept of getting connection and executing queries8:04
Creating new Java Project and Adding Jar to Intellij3:03
Creating database Configuration class to create connection6:47
Adding new User to Database by Taking user Input11:38
Testing adding of new user3:46
Get All users and test it11:31
Update User data and test it9:17
Delete user based on Username and test it5:04

Requirements

No Prerequisites

Description

In this course, you will learn about JAVA, Databases, Tables, Schema, SQL, and JDBC. You will learn to connect and execute database queries from Java Code.

You will learn how to establish a connection from Java code to the database and perform different operations like Select, Insert, Update, and Delete.

You will also get the complete source code.

Databases are essential tools for storing and organizing large amounts of data, and they have become increasingly important as the amount of data that organizations collect continues to grow. A database is a collection of data that is organized in a way that makes it easy to access, manage, and update. Some common types of databases include relational databases, NoSQL databases, and graph databases.

One of the most popular languages for working with databases is SQL, which stands for Structured Query Language. SQL is a programming language that allows users to manipulate and query data stored in a database. It can be used to create tables, insert data into tables, update data in tables, and retrieve data from tables. SQL is a declarative language, which means that users specify what they want to do with the data, and the database management system (DBMS) figures out how to do it.

JDBC, which stands for Java Database Connectivity, is a Java API for connecting to databases and executing SQL statements. JDBC provides a standard interface for Java programs to interact with databases, making it easier for developers to work with different types of databases. With JDBC, developers can create database connections, execute SQL statements, and retrieve results from queries.

Together, SQL and JDBC are powerful tools for working with databases. SQL allows users to manipulate data stored in a database, while JDBC provides a standardized way for Java programs to connect to and interact with databases. This combination of tools has become a cornerstone of modern data-driven applications, enabling organizations to collect, store, and analyze vast amounts of data to gain insights and make better decisions.

Who this course is for:

Anyone who wants to learn about Java Programming and SQL and how to use Java JDBC with SQL to create Projects

Build Projects using Java JDBC & SQL with practical examples

What you'll learn

Explore related topics

Course content

Introduction & Setup7 lectures • 38min

Practicing SQL Queries & Joins8 lectures • 49min

Core Java Mastery: Everything You Need to Know to Start Writing Java Programs70 lectures • 8hr 41min

JDBC in Action: Concepts and Practical Code Examples9 lectures • 1hr 2min

Source Code1 lecture0

Requirements

Description

Who this course is for: