SQL Demystified

Erscheinungsjahr 2005
ISBN: 978-0-07-226224-7
Verlag: McGraw-Hill Education

Buch, Englisch, 312 Seiten, Format (B × H): 191 mm x 235 mm, Gewicht: 629 g

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.There’s no easier, faster, or more practical way to learn the really tough subjectsSQL Demystified explains how to use SQL (Structured Query Language)--the ubiquitous programming language for databases. Readers will learn to create database objects, add and retrieve data from a database, and modify existing data. This self-teaching guide comes complete with key points, background information, quizzes at the end of each chapter, and even a final exam. Simple enough for beginners but challenging enough for advanced students, this is a lively and entertaining brush-up, introductory text, or classroom supplement.

Autoren/Hrsg.

Oppel, Andrew J.

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmier- und Skriptsprachen

Inhaltsverzeichnis

Chapter 1: Relational Database ConceptsChapter 2: SQL ConceptsChapter 3: Defining Database Objects Using SQLChapter 4: Retrieving Data Using Data Query Language (DQL)Chapter 5: Combining Data From Multiple TablesChapter 6: Advanced Query WritingChapter 7: Maintaining Data Using DMLChapter 8: Applying Security Controls Using Data DCLChapter 9: Preserving Database Integrity Using TransactionsChapter 10: Integrating SQL into ApplicationsChapter 11: SQL Performance Tuning ConsiderationsFINAL EXAMANSWERS TO QUIZZES AND FINAL EXAMINDEX

Über Autor(innen)

Oppel, Andrew J.
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Andy Oppel (Alameda, CA) has designed and implemented hundreds of databases for a wide range of applications, including medical research, banking, insurance, apparel manufacturing, telecommunications, wireless communications, and human resources. He is the author of Databases Demystified (McGraw-Hill/Osborne, 2004). His database product experience includes IMS, DB2, Sybase, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7, 8, 8i, and 9i).