SQL Databases, IT 422
About this Course:
Advanced topics in database management and programming including client server application development are introduced. Expands knowledge of data modeling concepts and introduces object-oriented data modeling techniques. Students will learn the use of Structured Query Language in a variety of application and operating system environments.
This is an advanced Oracle course focusing on advanced data design, advanced SQL, Oracle management tools, views, transactions, stored procedures and triggers. Reporting engines will also be covered
IT 421 Database Concepts with Oracle, relational database concept, SQL and basic oracle knowledge or equivalent experience required for enrollment.
Who Should Attend:
Professionals, who are interested in learning about client/server technology, designs of databases and developing client/server applications for business solutions.
Participants, who complete the course successfully will be able to define the client/server architecture, design databases for client/server application, design and develop client/server applications for various business solutions.
Introduction to Client/Server, Hardware, and Operating Systems
The fundamental concepts of client/server technology are introduced. Participants will receive an overview of client/server architecture, be introduced to client/server terminology, and discuss the difference between two-tier and three-tier client/server models. The networking portion of the program will focus on network hardware and software, and include a discussion of the Internet as a platform for client/server applications.
Database Fundamentals and Building Database Systems
The fundamentals of database design, including how relational database systems are built, are taught. Participants will design databases using the relational database model, and learn how relational databases fit into on-line transaction processing (OLTP) applications. The module continues with a detailed study of Relational Database Management Systems (RDBMS) and SQL concepts.
Designing Client/Server Application Systems
The design and development of client/server applications for various business solutions, incorporating client/server application design, business system planning, analysis, development and implementation are discussed. Participants will learn how to design event-driven applications utilizing application management tools. Participants will also discuss the capabilities and benefits of object-oriented programming.
This module teaches more advanced topics in Oracle by introducing participants to Oracle programming in PL/SQL. Participants will learn to create stored procedures and functions, packages, and triggers. Participants will also learn how to manipulate data with cursors and utilize Oracle's built-in functions.