What Will You Learn?
Discover the world of databases from fundamentals to advanced topics. Learn the relational model and SQL basics, then progress to advanced SQL skills, covering index creation, transactions, constraints, triggers, and views. Explore OLAP concepts, recursion, relational algebra, dependency theory, and UML-based data modeling. Extend your knowledge to semistructured data, mastering XML and JSON models, XPath, XQuery, and XSLT. This comprehensive course provides a deep dive into database principles, equipping you with skills in SQL, advanced techniques, and handling diverse data structures.
About This Course
Provider: Standford Online
Format: Online
Duration: 20 hours to complete [Approx]
Target Audience: Beginners
Learning Objectives: Upon completion this free course, learners will acquire a comprehensive understanding of databases, progressing from relational model fundamentals and advanced SQL skills to mastering OLAP concepts, recursion and modeling
Course Prerequisites: NA
Assessment and Certification: NA
Instructor: Standford Online
Key Topics: Database Design, Computer Science, Relational Databases, Online Analytical Processing, Data Abstraction, Persistence, Reliability, Concurrency Controls, Query Languages, Authorization (Computing), Database Systems, SQL (Programming Language), Scalability
Topic Covered:
- - Getting Started
- - The Relational Model
- - Querying Relational Databases
- - Introduction to SQL
- - Basic SELECT Statement
- - Table Variables and Set Operators
- - Subqueries in WHERE Clause
- - Subqueries in FROM and SELECT
- - The JOIN Family of Operators
- - Aggregation
- - NULL Values
- - Data Modification Statements
0 Comments