Pour les demandes entreprises : (+33) 970 466 303
Pour les demandes particuliers : (+33) 180 272 016
Pour les demandes entreprises : (+33) 970 466 303
Pour les demandes particuliers : (+33) 180 272 016
The "Relational Databases and SQL" training course offers a comprehensive introduction to relational databases and covers SQL, the standard query language for relational database systems. Participants will gain a solid understanding of the relational model, concepts in relational databases, and the fundamentals of SQL. This course serves as the foundation for advanced topics in SQL and databases, providing learners with the necessary knowledge to pursue further training in database management.
Databases 1: Introduction to Relational Databases and SQL
Learn the foundational concepts of the relational model and relational database management systems (RDBMS).
Explore SQL, the widely accepted standard query language for interacting with relational databases.
Databases 2: Advanced SQL Topics (prerequisite: Introduction to Relational Databases and SQL)
Master the creation of indexes to enhance query performance.
Gain proficiency in using transactions for managing concurrency and ensuring failure recovery.
Understand database constraints, including key constraints, referential integrity, and "check" constraints.
Learn about database triggers and their role in automating actions in response to database events.
Discover how views are created, utilized, and modified in relational databases.
Explore authorization mechanisms for controlling access to resources in relational databases.
Databases 3: OLAP and Recursive Queries
Delve into star schemas and the data cube concept, along with OLAP features like Cube and Rollup operators.
Learn the SQL standard for executing queries over recursively defined relations.
Databases 4: Modeling and Theoretical Foundations
Study relational algebra, the formal query language underlying SQL.
Explore dependency theory and normalization techniques for effective schema design.
Understand how the Unified Modeling Language (UML) is used in data modeling and its translation into relational structures.
Databases 5: Semistructured Data Handling
Examine the XML model for managing semistructured and self-describing data, including XML Schema and Document Type Definitions (DTDs).
Learn about the JSON model for handling structured or semistructured data in a human-readable format.
Explore XPath for navigating and querying XML data, along with advanced features of XQuery.
Gain an introduction to XSLT for transforming and querying XML data based on predefined rules.
