Buch, Englisch, 372 Seiten, Format (B × H): 178 mm x 235 mm, Gewicht: 755 g
ISBN: 978-1-84628-394-9
Verlag: Springer
The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL. The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently. A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.
Zielgruppe
Professional/practitioner
Autoren/Hrsg.
Fachgebiete
- Mathematik | Informatik EDV | Informatik Daten / Datenbanken Zeichen- und Zahlendarstellungen
- Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmierung: Methoden und Allgemeines
- Mathematik | Informatik EDV | Informatik Technische Informatik Netzwerk-Hardware
- Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
- Mathematik | Informatik EDV | Informatik Technische Informatik Systemverwaltung & Management
Weitere Infos & Material
A simple, single-table database.- to Part 1.- Tables.- Queries/Views.- Forms.- Reports.- Summary of Part 1.- A multi-table database.- to Part 2.- Serious problems with single tables.- Multiple tables cure serious problems.- Making multiple tables work together.- Getting the data into the correct tables.- Relationships in the real world.- How are relationships modeled?.- Revisiting the big four — the synergy begins.- Integrity.- Summary of Part 2.- Database Design & Architecture.- Database design.- The seven layers of wisdom.- Database architecture.- Related database topics.- What exactly is a relational database?.- 22 Triggers and stored procedures.- Transactions, logs, backup, locking and concurrency.- Codd’s rules.- Normalization.- More about normalization.- The system tables.- More on queries: data manipulation.- SQL.- Domains.- What does null mean?.- Primary keys.- Speeding up your database.- Hardware considerations.- Indexing.- More on optimization.- Denormalization.
