Java Programming Fundamentals Return to Image Map Database Specialist Database Design and Methodology is a three-day course that teaches students how to plan and design relational databases. Students will learn about the theory behind relational databases, relational database nomenclature, and relational algebra. Students will apply their knowledge with hands-on exercises designed to teach the intricacies of database design methodology. Students learn the concepts of system architecture and how a data access API fits into that architecture. The course details the mechanics of loading a JDBC driver, connecting to a database, and submitting SQL statements to the database.
Students also learn how to use prepared statements and stored procedures.
The new features of JDBC 2.0 are covered, including scrollable and updateable result sets, batch updates, data sources, and custom mapping. The course presents a survey of architecture paradigms, from early mainframe architectures to modern distributed object-oriented computing. Students learn to consider scalability, interoperability, and flexibility in the design of a system's architecture. The course examines each of these issues individually to provide a framework for further study. The course introduces students to the fundamentals of the Interface Definition Language and the Dynamic Invocation Interface.