Free Course
Database Systems Concepts & Design
by
Offered at Georgia Tech as CS 6400
Nanodegree Program
Become a Data Analyst
Accelerate your career with the credential that fast-tracks you to job success.
About this Course
This course presents an example of applying a database application development methodology to a major real-world project.
Course Cost
Timeline
Approx. 16 weeks
Skill Level
intermediate
Included in Product
Rich Learning Content
Interactive Quizzes
Taught by Industry Pros
Self-Paced Learning
Student Support Community
Join the Path to Greatness
This course is your first step towards a new career with the Become a Data Analyst 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 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.
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