Ebook on basics of databases, applied to DB2

Printer-friendly version

Database Fundamentals is an interesting book db2university IBM, which explains the basics of databases, especially relational issues of logical and physical design, and how to use the SQL language to interact with them.

Fundamentals of Database Home

Furthermore, to make the exercises and apply the concepts explained in the book, from the sameplay/db2oncampus/FREE + ebook + - + Database + fundamentals "> home page Database Fundamentals can access a form for a free download IBM database DB2Express-C and management tool (development and management and Informix DB DB2) IBM Data Studio .

Is similar to databases Handbook of Free Software Master UOC Dataprix we have published, only instead of guiding the practices towards open source databases like MySQL or PostgreSQL usingIBM DB2.

Herewith the book, which is also freely downloadable from here and extract the headlines of the index, so that you look you can get an idea of the content.


Preface
Chapter 1 - Databases and information models
Chapter 2 - The relational data model
Chapter 3 - The conceptual data model
Chapter 4 - Relational Database Design
Chapter 5 - Introduction to SQL
Chapter 6 - Stored Procedures and functions
ChApter 7 - Using SQL in an application
Chapter 8 - Query languages ​​for XML
Chapter 9 - Database Security
Chapter 10 - Technology trends and databases
Appendix A - Solutions to review questions
Appendix B - Up and Running with DB2
Resources

Attached Size
Database_fundamentals.pdf 5.06 MB
 

I'm Robert, a computer professional in the SAP world. A few years ago working in a business intelligence project in a business where I was, with a sales data warehouse for...
EasyAsk, of Progress Software, is a tool of BI with the peculiaridad that for the application of reports, analysis or even pictures of control provides to the user an interface...
Then leave a little post on how to set up an automatic notification via mail that tells us what the status of our database. For example we can set a little before our workday...
We have published a new manual online in Dataprix. Treat of the Methodology Hefesto prepared by Ricardo Dario Bernabeu, to the one who agradecemos this important aportació...
  We want to give more importance to our users, and better distinguish the personal profiles of the corporate community, in order to enhance each in his way. When someone...
There are many different companies that offer tools for the creation and operation of a Data Warehouse. When it offers a complete suite, which covers the creation of...