Share Description
In this course, you will learn:-
- Java allows you to connect to a MySQL database.
- Insert, update, and delete data using SQL commands.
- Prepared Statements are used to handle SQL arguments.
- Stored methods are called and various parameter types are handled (IN, INOUT, etc).
- BLOB and CLOB data files can be read and written.
- Use properties files to set up your database connection details.
Syllabus:-
- JDBC Overview
- Database Setup Overview
- Install the MySQL Database
- Create New Database User in MySQL Workbench
- Download JDBC Source Code
- Setting up the Development Environment
- Submitting SQL Queries
- Getting rid of MySQL SSL Warning Message
- Inserting Data into the Database
- Updating Data in the Database
- Deleting Data from the Database
- Creating Prepared Statements
- Calling Stored Procedures - Part 1 - IN Parameters
- Calling Stored Procedures - Part 2 - INOUT Parameters
- Calling Stored Procedures - Part 3 - OUT Parameters
- Calling Stored Procedures - Part 4 - Result Set
- Defining JDBC Transactions
- Accessing Database MetaData
- Reading ResultSet MetaData
- Reading and Writing BLOBs
- Reading and Writing CLOBs
- Reading Database Connection Info from Properties File
- Summar
- Discount Coupon for More of My Java Training
- Direct Links to My Java Courses
