Bases de données
121 documents à télécharger gratuitement
Cours, examens, TD, TP et exercices de bases de données. Thèmes couverts : SQL, MySQL, Oracle, modèle relationnel, SGBD, MERISE.
This document provides examples of PL/SQL code for various database operations, including deleting departments, updating employee salaries, and retrieving employee data. It also demonstrates the use of cursors and exception handling in SQL. Various operations are illustrated through specific use cases within a sample database.
This document provides an in-depth comparison of traditional relational database systems (RDBMS) and NoSQL databases. It discusses strengths of RDBMS such as complex querying capabilities and ACID compliance but highlights their limitations with scaling and handling semi-structured data. NoSQL databases are categorized into key-value, column-oriented, document-oriented, and graph-based models, focusing on scalability, distributive architecture, and performance over ACID properties. Specific examples like Cassandra, MongoDB, Neo4J, and others illustrate their architectures, replication mecha...
This document provides an introduction to SQL, detailing its structure, including DDL, DML, DQL, and DCL. It explains the various data types available, such as alphanumeric, numeric, and temporal types. Additionally, it covers DDL commands, with a focus on the CREATE command and its constraints.
This lab focuses on writing SQL queries to extract and manipulate data related to restaurants and their offerings. It includes various tasks ranging from displaying restaurant information to calculating averages and ordering results. Students will demonstrate their SQL skills through practical applications in a database context.
This document outlines an exam focusing on the SQL and PL/SQL programming related to a TV channel management application. It includes tasks such as creating views, stored procedures, and functions to manage and analyze program schedules and audience ratings. The exam is structured with specific requirements and constraints for each task.
This document presents a programming lab focused on PL/SQL functions and cursors. It provides a detailed exercise for creating a tax bracket table, facilitating tax calculation through cumulative values. The lab includes tasks for implementing PL/SQL blocks and testing the functionality of inserting new tax brackets.
This document presents a lab assignment focused on data manipulation in SQL within a database system. It includes instructions for inserting data into multiple tables related to restaurants, dishes, orders, and delivery personnel. The assignment also outlines tasks to update and manipulate ratings, quantities, and other attributes based on business logic.
This document provides an overview of cursor manipulation in PL/SQL, detailing the types of cursors, their attributes, and simplified usage. It includes practical examples of declaring, opening, executing, and closing cursors. The aim is to enhance understanding of how to effectively handle SQL query results in PL/SQL programming.
This document introduces PL/SQL programming models and the structure of a PL/SQL block. It covers the declaration and executable sections of blocks, along with examples of variable declarations. Additionally, it highlights the features and types supported in PL/SQL.
This document provides a comprehensive overview of data extraction techniques using SQL, covering essential concepts such as functions, subqueries, joins, and set operators. It includes detailed explanations and examples of the SELECT instruction, various functions, and the importance of NULL values and aliases in queries. This resource is aimed at students and professionals looking to enhance their skills in database management and data manipulation.
Ce document traite de l'insertion, de la mise à jour et de la suppression de lignes dans une base de données en utilisant le langage SQL. Il fournit des exemples détaillés et des syntaxes pour chaque opération, mettant en avant l'utilisation de requêtes SQL pour manipuler les données efficacement. Le document est destiné aux étudiants en ingénierie et sciences des données.
This document provides a comprehensive overview of SQL, focusing on the creation, modification, and management of tables, views, sequences, indexes, and synonyms. It also covers the essential data constraints within SQL and their syntax. Readers will gain practical examples and a structured approach to working with SQL.
This document provides a step-by-step guide to installing Oracle Database 11g Express Edition (XE) on Windows systems. It describes the system requirements, the installation procedure, and how to set up users on the database using SQL*Plus. It also includes instructions for interacting with the Oracle web-based user interface, unblocking a demo database, and testing database functionalities. The focus is on practical procedures for beginners in database administration.
This document introduces the Entity-Relationship (E/A) model, a high-level conceptual data model developed by Chen and Tardieu in the mid-1970s. It explains the fundamental concepts such as entities, attributes, and associations, providing examples and definitions essential for structuring real-world data. The document emphasizes the importance of abstraction in data modeling and how it aids in representing data for non-technical users.
Ce document présente le modèle relationnel développé par Codd en 1970, qui structure les données sous forme de tables. Il aborde les objectifs, les définitions clés et les concepts fondamentaux associés au modèle relationnel, tout en soulignant son importance pour les concepteurs et utilisateurs de bases de données. Les notions de domaine, relation, attribut et clé, ainsi que la théorie de la normalisation, y sont également discutées.
This thesis investigates real-time reporting implementation on a MongoDB cluster at Vermeg, a software solutions company for financial and insurance industries. The project involves the development of a scalable and efficient data architecture leveraging NoSQL MongoDB databases and addressing specific challenges like real-time data reporting and dashboard visualization. Utilizing the agile 2TUP methodology, an environment combining Spring Boot, MongoDB, and Qlik Sense was set up to create a high-performance decision-making tool. The study concludes with the detailed realization of the dashb...
Ce document présente une introduction aux bases de données, y compris leur définition, les systèmes de gestion de bases de données, et les notions fondamentales comme le modèle et le schéma de données. Il décrit également les défis associés à la gestion des données avant l'usage des SGBD. Enfin, les caractéristiques et avantages des SGBD sont abordés, illustrant leur importance dans le traitement et la gestion des données en entreprise.
This report documents the internship project focused on Business Intelligence at IDsoft. It outlines the company's background, the project presentation, and the processes involved in implementing a SaaS solution using various SQL Server tools. The report also details the design and creation of reporting datasets and reports.
This document provides exercises for PL/SQL focusing on the creation and management of a tax tranche table. It outlines the structure of the table, the calculation of cumulative taxation, and the implementation of functions to insert new tax tranches. The exercises aim to enhance understanding of procedural programming in the context of tax computations.
This document serves as an introduction to PL/SQL, focusing on its syntax, structures, and error handling. It covers various topics including variables, arrays, and procedures. The document is intended for students learning Oracle PL/SQL.
This document introduces Microsoft SQL Server Integration Services (SSIS), an advanced ETL tool integrated into SQL Server 2005, designed to handle data integration tasks efficiently. The tutorial provides a comprehensive overview of the SSIS environment, including creating and configuring projects within Visual Studio, the workspace layout, and the use of tools like Control Flow and Data Flow for organizing tasks and processing data. A detailed case study is included, demonstrating the import of data from a flat file source into a structured SQL Server database, involving data transformati...
Ce chapitre présente le modèle Entité-Association, qui fournit un cadre abstrait pour décrire un domaine d'application à travers des entités et leurs associations. Il aborde les concepts de base tels que les entités, leurs propriétés et les différentes types d'associations qui existent entre elles. Le document illustre également les formalismes graphiques utilisés pour représenter ces concepts.
Ce livre propose une approche métier de la Business Intelligence, s'adressant aux différents membres d'une équipe décisionnelle. L'auteur détaille progressivement les concepts clés et leur application à travers des outils de la suite SQL Server. Il inclut des exemples concrets et des bonnes pratiques pour créer un système décisionnel complet.
The document provides an in-depth overview of the PL/SQL programming language, delving into its structured programming features such as variables, control structures, and data interaction with SQL databases. It covers advanced functionalities like cursors, exception handling, and procedural structuring through procedures and functions. A focus is placed on optimizing database interaction using declarative and programming elements of PL/SQL, with exercises geared toward real-world scenarios. Lastly, it emphasizes error handling and precise data manipulation techniques.