edX Databases are incredibly prevalent -- they underlie technology used by most people every day if not every hour. Databases reside behind a huge number of websites; they're a crucial component of telecommunications systems, banking systems, video games, and just about any other software system or electronic device that maintains some amount of persistent information. In addition to persistence, database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages. Databases are so ubiquitous and important that computer science graduates frequently cite their database class as the one most useful to them in their industry or graduate-school careers.
Course Objectives:
- Creating indexes for increased query performance
- Using transactions for concurrency control and failure recovery
- Database constraints: key, referential integrity, and "check" constraints
- Database triggers
- How views are created, used, and updated in relational databases
- Authorization in relational databases.
Recommended Background
- Recommended for individuals heading towards a career in data science or information technology / currently in a business data analyst/ data scientist role.
Course ID
ED142
Skill Focus
Intermediate
Instructor(s)
edX
Employee Type
New applicants, Operations teams, Leadership
Method of Delivery
Online
Estimated Effort
40 hrs
Cost
Contact for Pricing
Certification is paid for $ 50.00 ; Full financial aid available for certification