Database Systems Concepts & Design
Georgia Institute of Technology via Udacity (1)
- Provider
Udacity
- Cost
Free Online Course
- Session
Self Paced
- Language
English
- Duration
16 weeks long
Overview
This course presents an example of applying a database application development methodology to a major real-world project.
Why Take This Course?
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
Syllabus
Database Concepts
- Techniques and tools needed to develop database applications.
- Database application development methodologies.
Database Models
- Extended Entity Relationship Models.
- Relational Models.
- Relational Algebra, Calculus, and SQL.
Database Management
- Database normalization.
- Database efficiency.
- Database indexing.
- Metadata management and archiving.