Database Fundamentals

Course Objectives

The course gives basic information about SQL statements, functions, queries and data manipulation, in addition to PL/SQL statements, composite data types and exceptions

None Requisites for MySQL

  • Introduction
  • Objectives
  • Database Definition
  • Database System Definition
  • Database Properties
  • DBMS Definition
  • DBMS Functions
  • Advantages & Disadvantages of Database
  • The Three Levels of Architecture
  • External Level
  • Conceptual Level
  • Internal Level
  • Mapping
  • Advantages of the Architecture
  • How Does the Application Program Access the Database
  • Distributed Processing & Architectural Design
  • Data Independence
  • Data Models
  • Data Models Definition
  • Categories of Data Models
  • Who Deals with Database
  • Database Administrator
  • System Analyst
  • Database Designer
  • Application Programmer
  • End User
  • Entity-Relationship Model
  • Basic Concepts
  • Entities
  • Keys
  • Design Issues
  • Entity-Relationship Diagram
  • Weak Entity Sets
  • Design of an E-R Database Schema
  • Reduction of an E-R Schema to Tables
  • Relational Database Design Using ER-to-Relational Mapping
  • Secuirty
  • Introduction
  • DCL
  • Grant / Revoke
  • SQL- The Relational Database Standard Language
  • Data Definition, Constraints
  • Basic Queries in SQL
  • More Complex SQL Queries
  • Insert, Delete and Update Statements in SQL
  • Views (Virtual Tables) in SQL
  • Indexes
  • System Catalog
  • Embedded SQL
  • Normalization
  • Functional Dependencies
  • First Normal Form
  • General Definitions of Second and Third Normal Forms
  • Lectures:   15 Hours.
  • Lab: 12 Hours.

None

P IV 1000 1 GB RAM

  • Lab Assignments: 40 %
  • Exam60 %

None

CONTACT US TODAY AND WE WILL BE HAPPY TO SERVE YOU