Database Systems Concepts & Design

About this Course

This course presents an example of applying a database application development methodology to a major real-world project.

[

At the end of this course the learner will:

• Understand and apply the concepts of data independence, database and database management system architecture, and the role and placement of a database management system the application stack

• Understand and apply the theoretical foundation of relational databases and query languages to create SQL data structure definitions and queries that meet identified requirements

• Create a relational database application, including the requirement analysis, specification, design and implementation of relational database applications

• Evaluate alternative internal schema structures and create indices for efficient database operation

• Understand the concepts of database access control and SQL injection

lesson 1
Database Concepts
Database ConceptsTechniques and tools needed to develop database applications.
Database application development methodologies.
lesson 2
Database Models
Extended Entity Relationship Models.
Relational Models.
Relational Algebra, Calculus, and SQL.
lesson 3
Database Management
Database normalization.
Database efficiency and indexing
Metadata management and archiving.