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

Programming Foundations: Object-Oriented Design

Image
Author: Barron Stone, Olivia Chiu Stone Released: 11/27/2018 Skill Level: Beginner Duration: 2h 40m All good software starts with a great design. Object-oriented design helps developers plan applications before they write a single line of code, and break down ideas into reusable and maintainable components. This course focuses on the foundational concepts, teaching them in a fun, interactive way to help you quickly develop your skills. Tag team Olivia and Barron Stone introduce you to the concepts and terms—objects, classes, abstraction, inheritance, and more—that you need to get started. They then show how to take the requirements for an app, identify use cases, and map out classes using Universal Modeling Language (UML). The final design can then be translated into code using one of the many popular object-oriented programming languages, such as Java, C#, Ruby, or Python. Topics include: Object-oriented basics: objects, classes, and more Encapsulation Inhe
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