Institutional Repository
Institutional Repository Institutional Repository Login  Institutional Repository  
  • UOC Library |
  •  |
  •  |

Home >
Academics >
IT, Multimedia and Telecommunications >
Free Software >
Learning materials >

Please use this identifier to cite or link to this item: http://hdl.handle.net/10609/194
Title: Bases de dades, febrer 2007
Authors: Camps Paré, Rafael
Casillas Santillán, Luis Alberto
Costal Costa, Dolors
Gibert Ginestà, Marc
Martín Escofet, Carme
Pérez Mora, Óscar
Director: Megías Jiménez, David
Mas i Hernàndez, Jordi
Keywords: SQL
PostgreSQL
MySQL
databases
Issue Date: 16-Feb-2007
Publisher: Universitat Oberta de Catalunya
Type: Lecture notes
Abstract: Databases are the preferred method for structured data storage. Large multi-user applications, mobile telephones and electronic agendas all use database technology to ensure data integrity and to facilitate the task of both the users and the programmers who developed them. Since the first data model was created, followed by administration of the management system and, finally, development of the application, the technology and associated concepts have been extremely diverse. It is also essential to know the key aspects of each of these topics to ensure success in any project that involves working with databases. This course will attempt to offer a comprehensive view of the concepts related to database management systems. To begin with, we will look at the aspects involved in the engines of these data warehouses, their historical evolution and the different types of organisation and abstraction they have gone through from their initial design to the present day. We will then look at the 'relational' model (the most common one nowadays), providing the tools and methods that allow us to represent data storage and query needs in this model. Following on from this, we will study Structured Query Language (SQL) in depth, since it is essential for working with relational databases, whether directly or through a programming language. Database design also has a chapter on learning how to model a database and represent it graphically, to detect possible design issues before they affect the application and to build optimal databases for the different cases of relations between entities that will form our database. Once we have established these bases, we will be ready to take a detailed look at two of the most popular free software database management systems currently available. Hence, we will learn about the use, administration and special features of MySQL and PostgreSQL with examples and case studies. We will also look at query and graphic administration tools for these two database management systems, which will enhance our productivity in our day-to-day work with them. We will then study the methods for accessing these database management systems from some programming languages. In each case, we will discuss the best practices and their special features, and we will introduce concepts related to programming in databases, such as persistence, dealing with errors, etc. Lastly, we believe that the best way to end this course is a complete case study looking at the topics we have discussed in the order in which they would occur in a real project, putting practice before theory. To sum up, this course attempts to provide students with a comprehensive understanding of the aspects of working with databases. Although we will not discuss certain specialist topics, such as the internal design of a database management system, we will take a technical approach to the more essential topics.
Language: Catalan
URI: http://hdl.handle.net/10609/194
Appears in Collections:Learning materials


Add This:

RefWorks:

Ratings:
  0 (0 valuations)


Files in This Item:

File Description SizeFormat
Bases de dades_Mòdul4_Disseny de bases de dades.pdfMòdul 4236.26 kBAdobe PDFPreview  Download
Bases de dades_Mòdul3_El llenguatge SQL.pdfMòdul 3253.74 kBAdobe PDFPreview  Download
Bases de dades_Mòdul2_El model relacional i l'àlgebra relacional.pdfMòdul 2245.21 kBAdobe PDFPreview  Download
Bases de dades_Mòdu8_Cas d'estudi.pdfMòdul 8233.26 kBAdobe PDFPreview  Download
Bases de dades_Portada.pdfPortada128.69 kBAdobe PDFPreview  Download
Bases de dades_Mòdul7_Desenvolupament d'aplicacions en connexió amb bases de dades.pdfMòdul 7229.48 kBAdobe PDFPreview  Download
Bases de dades_Mòdul6_Bases de dades en PostgreSQL.pdfMòdul 6568.17 kBAdobe PDFPreview  Download
Bases de dades_Mòdul5_Bases de dades en MySQL.pdfMòdul 51.14 MBAdobe PDFPreview  Download
Bases de dades_Llicència_GNU Free Documentation License.pdfLlicència_GNU Free Documentation License93.39 kBAdobe PDFPreview  Download
Bases de dades_Mòdul1_Introducció a les bases de dades.pdfMòdul 1184.66 kBAdobe PDFPreview  Download

Author names in Twitter


Author names in FriendFeed



Recommend this item

SFX Query

Items in Repository e are protected by copyright, with all rights reserved, unless otherwise indicated.

 

The library replies
A product of the Universitat Oberta de Catalunya Virtual Library
Legal notice | Cookie policy