Learning JDBC


Author: Frank Moley
Released: 2/11/2019
Skill Level: Intermediate
Duration: 2h 14m




Whether developers want to build mobile device apps for Android or web-based or desktop-based applications with the core Java SDK from Oracle, they must contend with the fact that many dynamic applications need to integrate data from a relational database. In this course, Frank Moley helps you get up to speed with the Java Database Connectivity (JDBC) API, showing how to use it to read and manage data from relational databases such as Postgres, Oracle Database, MySQL, and SQL Server in applications programmed with Java. Frank begins by going over key JDBC terminology, the basics of configuring a PostgreSQL database, and how to create the course project. He then provides detailed instructions on how to select and update data, work with transactions, handle exceptions, and more.
Topics include:
Deciphering JDBC terminology
Using containerized PostgreSQL
Creating, reading, updating, and deleting data
The Repository pattern
Using stored procedures
Ordering and limiting results
Transactions in JDBC
Handling exceptions

Exercise Files
https://drive.google.com/open?id=1PMxLEmHG9bimeY5brT17ixn3KK_DPxKz



Comments

Post a Comment

Popular posts from this blog

Programming Foundations: Algorithms

Image
Author: Joe Marini Released: 11/8/2018 Skill Level: Beginner Duration: 1h 45m Algorithms are the universal building blocks of programming. They power the software you use every day, whether it's a spreadsheet, a social network, or a driving assistant. Algorithms offer a way to think about programming challenges in plain English, before they are translated into a specific language like C# or JavaScript. In this course, author and developer Joe Marini explains some of the most popular and useful algorithms for searching and sorting information, working with techniques like recursion, and understanding common data structures. He also discusses the performance implications of different algorithms and how to evaluate the performance of a given algorithm. Each algorithm is shown in practice in Python, but the lessons can be applied to any programming language. Topics include: Measuring algorithm performance Working with data structures such as arrays, stacks, and queues ...
Read more

Learning Java

Image
Author: Kathryn Hodge Released: 3/21/2018 Skill Level: Beginner Duration: 2h 11m Java is one of the top five programming languages, and is used for websites, embedded controllers, and Android app development. This is an introduction to get you started programming with Java 9-and the newly introduced JShell. Instructor Kathryn Hodge covers all the basics: data types, strings, arrays, loops, and functions. She helps you control the flow and logic of your code, and debug your project to make sure it runs perfectly. Then go a bit beyond the basics and learn advanced techniques such as encapsulation, inheritance, functional programming, and lambdas. Kathryn introduces challenges along the way to practice your new skills. This three-hour course is perfect for developers who need to get up to speed with Java fast, as well as for beginning programmers who want their first taste of this popular language. Topics include: Downloading Java 9 and choosing an IDE Understandin...
Read more

C++: Building a String Library

Image
Author: Bill Weinman Released: 7/21/2015 Skill Level: Intermediate Duration: 40m 8s Adapt your C++ projects to provide the best resource management with custom string libraries. In this short course, Bill Weinman provides an overview of an example string library, BWString, and its key components: constructors, operators, utility methods, and memory management features. He'll also show you how to build find and replace methods and implement split methods. Exercise Files https://drive.google.com/open?id=1SP8FpGHAQdSpysykybKeYXljEgcAn2SP
Read more