Free Course
Database Systems Concepts & Design
by
Offered at Georgia Tech as CS 6400
Start Free Course
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
Enhance your skill set and boost your hirability through innovative, independent learning.
Course Leads
-
Leo Mark
Instructor
-
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
Related Courses
Eigenvectors and Eigenvalues
Software Analysis & Testing
Compilers: Theory and Practice
Cyber-Physical Systems Security
Human-Computer Interaction
Network Security
Popular Courses
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.
Zu de.udacity.com
continue in English