RDBMS course for graduates by Applied Business Solutions (P) Ltd

Chapter One: Who Needs a Database?
Outcomes:

Define relational databases

Understand the position of Relational Databases in the history of Databases

Identify major Relational Database Management Systems

Identify main characteristics of Relational databases

Understand SQLs role in relational database

Recognize some indications of where a database could be useful

Define a statement of scope for a given database scenario

Chapter Two: Gathering Information
Outcomes:

Review documents to discover relevant entities and attributes for database

Prepare interview questions and follow up

Prepare questionnaires

Observe work flow for process and exceptions

Chapter Three: Requirements And Business Rules

Outcomes:

Use nouns from notes and observations to discover database elements

Group elements into entities and attributes

Define business rules

Develop Use Case diagrams to model requirements

Chapter Four: Database Design

Use the database modeling template in Microsoft Visio

Create Entities and add attributes

Determine the appropriate relationship between entities

Resolve many to many relationships with a linking table

Chapter Five: Normalization and Design Review
Outcomes:

Evaluate entities against first three normal forms

Adjust the relational diagram to reflect normalization

Chapter Six: Physical

Outcomes:

Implement a physical design of the database based on the logical ERDs.

Choose appropriate data types for columns

Enter sample data into tables

Chapter Seven: SQL

Outcomes:

Name the main events in the development of SQL

Run SELECT queries with a variety of criteria

Join two or more tables in a query

Use the Aggregate Functions COUNT, AVG, SUM, MIN, and MAX

INSERT, UPDATE and DELETE records

Use SQL to test business rules

Chapter Eight: Is it Secure?

Outcomes

Analyze security needs and restrictions for users of the database

Analyze threats to database integrity

Understand the concepts of authentication and authorization

Create logins and users

Create roles