UOP PRG421 Week 5 Discussion Latest 2020

PRG421 Java Programming II

Week 5 Discussion

DQ1 Databases Accessible via JDBC

The purpose of this discussion is to identify the purpose and utility of JDBC to Java™ programmers, including the data formats that JDBC allows Java™ programmers to interact with. Research and discuss the differences between a flat database and a relational database. Does JDBC provide a way for Java™ programmers to access flat databases, relational databases, or both? What specific relational databases can be accessed via JDBC?

DQ2 Basic SQL Statements

The purpose of this activity is for you to familiarize yourself with the basics of SQL syntax, which is required for retrieving data from a database using JDBC. As a Java™ programmer, you do not have to be an expert at Structured Query Language (SQL), the language used to access and manipulate data stored in relational databases. However, to retrieve or update data in a relational database, you will need a passing familiarity with SQL statements, because you will need to pass these SQL statements as arguments to one or more JDBC API calls and should understand enough to see the issue if they do not work.

Familiarize yourself with basic SQL statements by taking the linked 25-question "W3Schools SQL Quiz." Use the answers to each quiz question to familiarize yourself with basic SQL query statements and keywords, such as SELECT and JOIN.