About this Course

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

Course Cost
Free
Timeline
Approx. 16 weeks
Skill Level
Intermediate
Included in Course
  • Rich Learning Content

  • Interactive Quizzes

  • Taught by Industry Pros

  • Self-Paced Learning

  • Student Support Community

Join the Path to Greatness

This free course is your first step towards a new career with the Data Analyst Nanodegree Program.

Free Course

Database Systems Concepts & Design

by Georgia Institute of Technology

Enhance your skill set and boost your hirability through innovative, independent learning.

Icon steps 54aa753742d05d598baf005f2bb1b5bb6339a7d544b84089a1eee6acd5a8543d

Course Leads

  • Leo Mark
    Leo Mark

    Instructor

  • Shabana Figueroa
    Shabana Figueroa

    Instructor

What You Will Learn

Lesson 1

Database Concepts

  • Database ConceptsTechniques and tools needed to develop database applications.
  • Database application development methodologies.
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 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.
Lesson 3

Database Management

  • Database normalization.
  • Database efficiency and indexing
  • Metadata management and archiving.

Prerequisites and Requirements

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.

See the Technology Requirements for using Udacity.

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

What do I get?
  • Instructor videos
  • Learn by doing exercises
  • Taught by industry professionals
Icon globe e82eae5d45465aba4fbe4bb746905ce55dc3324f310b79c60e4a20089057d347

Udacity 现已提供中文版本! A Udacity tem uma página em português para você! There's a local version of Udacity for you! Sprechen Sie Deutsch?

Besuchen Sie de.udacity.com und entdecken Sie lokale Angebote, unsere Partnerunternehmen und Udacitys deutschsprachigen Blog.

前往优达学城中文网站 Ir para a página brasileira Go to Indian Site Icon flag de deedb1a7a695700236cb6ef4204ddbede5d197dab9b47716c87a0b4d5d9fc325 Zu de.udacity.com continue in English