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.
The document is an exam from the Université Virtuelle de Tunis focused on NoSQL concepts, specifically MongoDB operations and MapReduce. It includes three exercises covering CRUD operations for employee data, menu ingredient calculations, and building surface analysis. The methodology involves writing queries for specific tasks, including data insertion, filtering, aggregation, and surface calculations using MapReduce. The findings involve scenarios like updating MongoDB collections and performing data aggregation for decision-making processes.
The document provides a tutorial on using MongoDB with Python, focusing on installation, connection setup using PyMongo, and testing server status using pprint. It delves into exploring collections and documents, highlighting MongoDB's JSON-based structure compared to relational databases. The methodology for performing CRUD operations is described step-by-step with Python scripts for creating, reading, updating, and deleting documents in a MongoDB database. Practical examples demonstrate querying, modifying, and removing specific data from collections, ensuring understanding of core databa...
This document provides an in-depth exploration of MongoDB, a NoSQL document-oriented database system designed for scalability and flexibility. It describes MongoDB's architecture based on BSON (Binary JSON), its unique querying language, and its schema-free model. It also details CRUD operations, sharding, replication, and the practical tools like MongoDB Compass, MongoDB Atlas, and the Shell interface. Real-world examples demonstrate filtering, querying, and inserting JSON data with robust data management techniques.
MongoDB is one of the most popular NoSQL systems, based on a semi-structured data model and JSON encoding. It has no fixed schema, ensuring complete flexibility, and utilizes a unique query language. MongoDB is designed as a scalable, distributed system with features like sharding and replication for fault tolerance.
This document outlines the steps for preparing a virtual environment to study NoSQL databases, incorporating the setup of VirtualBox and a virtual Ubuntu 20 machine. It describes VirtualBox's networking modes, guides users through obtaining an Ubuntu ISO, creating and running a virtual machine, and provides essential terminal commands for updating packages and setting up network tools. The document is designed as a hands-on reference for students or practitioners in virtual environment preparation within database contexts.
This document outlines the preparation of the environment for a NoSQL database module using VirtualBox. It includes steps for installing VirtualBox, creating a VM with Ubuntu 20, and preparing the VM with essential network configuration tools. The instructions are intended for students to set up their environment for further database-related tasks.
This document provides an overview of NoSQL databases, including document-oriented, column-oriented, graph-oriented, and key-value stores. It outlines the pedagogical objectives aimed at mastering different types of NoSQL databases, especially with tools like MongoDB, Hbase, Neo4j, and Redis. The curriculum also covers the prerequisites, foundational concepts, and challenges of traditional relational databases in the context of big data and unstructured data management.
This document contains the questions and problems from the entrance exam for engineering cycles in Tunisia for the year 2019. It includes programming problems primarily in Python as well as relational algebra and SQL tasks. Students are required to demonstrate their understanding of algorithms and database management through practical coding exercises and query formulations.
The document provides SQL exercises focused on relational database schemas and queries to manage, manipulate, and retrieve data. It includes the creation of database tables, insertion of sample data, and writing complex queries for various relationships. Topics addressed cover SQL operations like table creation, data insertion, updates, and deletions, as well as advanced queries involving joins, grouping, and aggregation. Methodologies emphasize the practical implementation of database structures with the use of primary and foreign key constraints and queries to extract insights.
This document provides a comprehensive guide to SQL as a Data Manipulation Language (DML). It covers the essential SQL clauses such as SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY, along with their syntax, application, and use cases in querying relational databases. Examples demonstrate data extraction, aggregation functions, filters, logical operators, and table joins to facilitate understanding. The material also emphasizes conditions, NULL values, and advanced techniques like concatenation and reflexive joins while illustrating real-life database queries using an employee database.
This document introduces the fundamental aspects of databases, emphasizing their definition, benefits, and design methodologies. Key methodologies include collecting user requirements, conceptual modeling, logical schema generation, and physical schema implementation. The Entity-Relationship model is extensively discussed with concepts like entities, attributes, associations, and cardinalities. Examples and exercises further demonstrate creating entity-association schemes for real-world applications like managing cinemas, book loans, and corporate personnel systems.
This document introduces the relational model as a core concept for organizing data in database systems using tables. It outlines rules for transitioning from an Entity-Relationship model to a relational model, such as entity translation and handling associations of different cardinalities. Examples illustrating n-ary associations and special cases like binary associations are provided alongside exercises for developing relational and entity-relationship models. It emphasizes the importance of primary and foreign keys in maintaining data integrity and enabling relationships between tables.
This document contains a series of exercises related to database management, focusing on the representation and management of books, transport companies, library systems, and materials management. Each exercise outlines specific entities and relationships required for proper database schema design. The exercises also emphasize the importance of well-structured data management and client handling.
This document presents the concepts and issues surrounding distributed databases, highlighting the challenges posed by large volumes of information and high access rates. It discusses potential solutions, such as distributing data across multiple locations to improve access times. The document also outlines the functions of Database Management Systems (DBMS) and the processes involved in database design.
This document outlines the correction for Lab TP2 regarding data dictionaries in Oracle. It includes steps to connect and manage database instances, roles of various system tables, and SQL commands to describe data structures. Additionally, it provides instructions for creating storage spaces and retrieving instance information.
Ce document contient des questions de correction pour un TD sur l'architecture des bases de données ORACLE. Il explore les composants clés d'un SGBD Oracle, y compris l'instance, la mémoire SGA et les processus en arrière-plan. Des détails sur les fichiers associés et les structures de stockage logiques sont également fournis.
Ce TP a pour objectif de permettre aux étudiants d'écrire des requêtes SQL avancées en utilisant des constructions complexes telles que GROUP BY, HAVING, et des sous-requêtes. Les étudiants travailleront avec une base de données importée pour répondre à diverses questions concernant des coureurs et des étapes. Les exercices incluent des fonctions d’agrégation et des requêtes imbriquées.
This document contains a series of exercises focused on databases, including defining relationships between tables and writing SQL queries to extract information. It covers musicians, dishes, and student information, connecting various concepts of database management. Each exercise requires applying SQL knowledge to manipulate and query the database structures.
This document provides a series of exercises related to SQL queries for managing a database of culinary dishes. It includes requirements for creating tables, querying for expensive dishes, listing ingredients, and deleting unused items. Each exercise emphasizes correct SQL syntax and the use of specific functions.
This document presents a series of exercises related to the management of databases in various contexts including libraries and event management. The exercises require expressing queries in relational algebra based on provided schemas. Topics include querying for borrowed books, concert details, and athlete performance in competition.
This document provides an overview of PL/SQL, a procedural extension for SQL by Oracle. It explains the integration of SQL with procedural constructs to create complex database operations. Additionally, it covers variable declarations, data types, and examples of use in PL/SQL.
Ce document est un TD sur l'architecture d'Oracle Database. Les étudiants doivent compléter des phrases en se basant sur leurs connaissances des composants et processus d'un SGBD Oracle. Cela inclut des éléments comme la mémoire SGA, les processus en arrière-plan, et les stratégies de journalisation.
This document contains a series of exercises on database dependencies and normalization. It includes problems related to functional dependencies, key identification, and normalization forms for various relations. Each exercise presents distinct scenarios and challenges within the field of database management.