Home Tech & Coding Databases Databases
Database Systems Concepts & Design

Database Systems Concepts & Design

This course presents an example of applying a database application development methodology to a major real-world project.
Video Beginner Advanced
UPVOTE 0
SAVE THIS COURSE
Course Website
www.udacity.com
Share this page
Other courses you might like
Gallery
Description

Summary

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

Expected Learning

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.

Required Knowledge

Learners should be familiar with at least one scripting or programming language, e.g. PHP, Python, Java. Some familiarity with software engineering concepts would be helpful. Flexibility to work remotely with team members.

Required text:
Elmasri & Navathe: Fundamentals of Database Systems. 7th Edition. Pearson 2016.

Additional course material will be available online.

Additional Resources: WAMP installation guide, and more will be posted online.


Pricing:
Free
Level:
Intermediate
Duration:
17 weeks
Educator:
Leo Mark
Organization:
Georgia Institute of Technology
Submitted by:
Coursearena
Reviews
Would you recomment this course to a friend?
Discussion
There are no comments yet. Please sign in to start the discussion.
Other courses you might like