Build Projects using Java JDBC & SQL with practical examples

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

4.65 (23 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
6,031
students
11 hours
content
Jun 2023
last update
$54.99
regular price

What you will 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.

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.

Content

Introduction & Setup

Course Overview
About your Instructor
What is Database and Database Server and Tables
Real world Explanation of Tables Rows Relationship between Tables
Different Types of SQL Commands
Data Types in SQL
Downloading and Installing the Database Server

Practicing SQL Queries & Joins

Creating Category Table
Create, Alter, Drop and Truncate commands
DML Insert Data to the Table
Select Query Examples
DML Update Query with Example
DML DELETE Query Example
Join In SQL with Example
Types of Join in SQL

JDBC in Action: Concepts and Practical Code Examples

What is JDBC in Java and Why do we need it
JDBC concept of getting connection and executing queries
Creating new Java Project and Adding Jar to Intellij
Creating database Configuration class to create connection
Adding new User to Database by Taking user Input
Testing adding of new user
Get All users and test it
Update User data and test it
Delete user based on Username and test it

Screenshots

Build Projects using Java JDBC & SQL with practical examples - Screenshot_01Build Projects using Java JDBC & SQL with practical examples - Screenshot_02Build Projects using Java JDBC & SQL with practical examples - Screenshot_03Build Projects using Java JDBC & SQL with practical examples - Screenshot_04

Reviews

Jing
May 2, 2023
The explaination for sql and JDBC is great ad easy to understand but for java he is just reading the code insteading of writing it himhelf. All in all i would still recommand this course.

Coupons

DateDiscountStatus
2/26/2023100% OFF
expired
2/27/2023100% OFF
expired
2/27/2023100% OFF
expired
3/1/2023100% OFF
expired
3/24/2023100% OFF
expired
9/13/2023100% OFF
expired

Charts

Price

Build Projects using Java JDBC & SQL with practical examples - Price chart

Rating

Build Projects using Java JDBC & SQL with practical examples - Ratings chart

Enrollment distribution

Build Projects using Java JDBC & SQL with practical examples - Distribution chart
5178214
udemy ID
2/24/2023
course created date
2/26/2023
course indexed date
Bot
course submited by