What Will You Learn?
Explore the intricacies of relational databases and SQL through a comprehensive course covering foundational concepts and advanced topics. Delve into key areas such as query optimization, transactions, constraints, triggers, and authorization. Progress to OLAP and recursion in databases, including star schemas and data cube concepts. Gain insights into relational algebra, dependency theory, and schema design, utilizing Unified Modeling Language (UML). Extend your knowledge to semistructured data, mastering XML and JSON models, XPath, XQuery, and XSLT for querying and transforming XML data. Elevate your understanding of databases with this advanced course encompassing theory, practical applications, and cutting-edge data handling techniques.
About This Course
Provider: Edx
Format: Online
Duration: 20 hours to complete [Approx]
Target Audience: Intermediate
Learning Objectives: Upon completion of this advanced database course, participants will master the intricacies of relational databases and SQL, gaining expertise in areas such as query optimization, transaction management, constraints, triggers, and advanced data modeling.
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Standford Online
Key Topics: Database Design, Computer Science, Relational Databases, Referential Integrity, Telecommunications, Data Abstraction, Persistence, Reliability, Concurrency Controls, Query Languages, Authorization (Computing), Database Systems, SQL (Programming Language), Scalability
Topic Covered:
- - Getting Started
- - Indexes
- - Introduction to Transactions
- - Transactions Properties
- - Isolation Levels
- - Constraints of Several Types
- - Referential Integrity
- - Triggers Introduction
- - Triggers Demo
- - Defining and Using Views
- - View Modifications - Introduction
- - View Modifications Using Triggers
- - Automatic View Modifications
- - Materialized Views
- - Authorization
0 Comments