Database

Work emphasis is on the relational database model including queries using SQL and also ERD modeling and normalization.

SQL Queries:

• Simple Queries
  • Retrieving data using clauses, operators, and functions.
• Queries using Joins
  • Demonstrating the use of Join clauses in queries.
• Advanced Queries
  • More complicated queries using joins, clauses, operators, functions, nested queries, and views.
• Stored Procedure Queries
  • Creating, updating, and deleting a stored procedure for repetitive use.

Entity-Relationship Diagram (ERD) Modeling:

• Business Rules and Entities ICE 1
• ERD ICE 1
  • Created from business rules and entities.

Normalization

• ICE 3
  • Putting relationships into 3rd Normal form to remove anomalies.