Database Fundamentals

Database Fundamentals Course Objectives


Database Fundamentals 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 %
  • Exam: 60 %


None



CONTACT US TODAY AND WE WILL BE HAPPY TO SERVE YOU