Advanced Diploma in Database Systems
Course facts
- Payment: Free to learn, certificate paid
- Credits: CPD Credits
- Learning style: Self-paced, start anytime
- Format: Video Based
- Video access: Streaming Only
- Refund: Conditional Refund
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Learn database systems: ER models, relational algebra, SQL, normal forms, file organization and indexing, query optimization and transactions.
Almost every application stores its data in a database, and building good ones takes theory as well as SQL. This diploma covers database architecture, the entity-relationship model, the relational model and relational algebra, tuple relational calculus, converting ER models to relations, SQL data definition, queries, subqueries, aggregates and views, functional dependency and Armstrong’s axioms, normal forms up to 5NF, file organization, hashing and indexes, B+ trees, query evaluation and optimization, transactions, concurrency control and recovery.
What You Will Achieve
- Design an entity-relationship model and convert it to a relational model
- Write queries in relational algebra, tuple relational calculus and SQL
- Normalize a schema using functional dependencies and normal forms
- Explain file organization, indexing and query optimization
- Describe transaction schedules, ACID properties and lock-based concurrency control
- Explain how undo and redo logging recover a database
Program Overview
Models and Querying
Database architecture, data models and formal query languages.
- Database architecture
- Entity relationship model
- Relational algebra
- Tuple relational calculus
SQL and Database Design
Writing SQL and designing well-structured schemas.
- SQL principles and subqueries
- Aggregates, views and programmatic access
- Functional dependency
- Normal forms
Storage, Queries and Transactions
How databases store data, run queries and stay consistent.
- File organization and indexes
- B+ trees and multiple disks
- Query evaluation and optimization
- Transactions, concurrency and recovery
Certificate Awarded (Paid)
Pass the final course assessment to earn it. The course is free to study; the certificate is optional and has a fee.
Job Outlook
Database knowledge is used by database administrators and architects, data analysts, systems analysts and web developers.
- Database Administrator
- Database Architect
- Systems Analyst
Good for: Computer science students and developers who want a rigorous grounding in database theory and SQL.
Keep in mind: It is listed for beginners but follows a university syllabus, with formal topics such as relational calculus and normal forms.
Bottom line: A thorough university-style diploma in database systems.
Frequently Asked Questions
Does the course teach SQL?
Yes. It covers data definition, basic queries, subqueries and correlated subqueries, aggregate functions, views and programmatic access to SQL.
Does it cover normalization?
Yes. It covers functional dependency, Armstrong's axioms, and normal forms 2NF, 3NF, BCNF, 4NF and 5NF, with the properties of decomposition.
Does it cover transactions?
Yes. It examines ACID properties, transaction schedules, concurrency control with two-phase locking, and recovery with undo, redo and undo-redo logging.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.