Database Fundamentals

About This Course:

Database Fundamentals is a self-paced, on-demand course that gives learners a complete grounding in how database systems are designed, built, queried, and managed. Delivered through 34 interactive lessons covering 324 topics, the course starts with databases and database users, system concepts and architecture, and data modeling with the ER and Enhanced ER models, then moves into the relational data model, SQL data definition, complex queries, triggers, and views, relational algebra and calculus, and normalization.

Learners go further into storage, indexing, query processing and optimization, transactions, concurrency control, recovery, distributed databases, NoSQL and big data systems, data mining, data warehousing and OLAP, and database security. 58 browser-based, auto-graded LiveLabs let learners practice real SQL and database tasks with no software installation, while 170 flashcards and 231 practice questions reinforce key concepts and measure progress.

Course Objectives:

• Database Concepts, Users, and Architecture

• ER and Enhanced ER Data Modeling

• The Relational Model, Relational Algebra, and Calculus

• SQL: Data Definition, Complex Queries, Triggers, and Views

• Normalization and Relational Database Design

• Storage, Indexing, Query Processing, and Optimization

• Transactions, Concurrency Control, and Recovery

• Distributed, NoSQL, and Big Data Systems

• Data Mining, Data Warehousing, and OLAP

• Database Security

Audience

Learners and professionals who need a strong, practical understanding of how databases are designed, queried, and managed, including:

• Students and Career Changers

• Junior Database Administrators

• Database and Software Developers

• Data and BI Analysts

• IT Support and Operations Staff

Prerequsites:

• None