Introduction to creating and using simple relational databases. Topics include basic terminology, database tools, data security, design concepts, query functions, and importing/exporting data. A selected database application is used to illustrate the database concepts.
In this class, we learned the basics relating to SQL coding, how a database works, table relationships, what primary keys are, and what foreign keys are. Below you can view some pictures of assignments and class work that I have done for Introduction to Database.
Introduction to multi-user and relational database development. The entity-relationship, normalization, and relational algebra concepts are covered. Students will use appropriate tools to document the designs of multi-user and relational databases, and implement the designs within appropriate database development environments.
Below you can view some pictures of assignments and class work that I have done for Database Development. All assignments and tests were taken using Microsoft SQL Server Management Studio 2012.
Detailed coverage of database programming using Oracle PL/SQL programming environment. Topics covered include, but are not limited to, procedures, functions, triggers, packages, code maintenance, code abstraction, program efficiency, modular programming, data retrieval, maintenance, and update. Course work includes testing and applying the concepts through a series of guided computer exercises and programs.
Below you can view some pictures of assignments and class work that I have done for PL/SQL Programming. All assignments and tests were taken using Oracle SQL Developer.