Rescued by SQL / Edition 1

Rescued by SQL / Edition 1

by Ted Brockwood, Kris A. Jamsa
     
 

If you are just getting started with SQL or databases in general, Rescued by SQL is for you! Rescued by SQL covers the history of SQL, language syntax, and concepts of database design, all of which are necessary to build a solid foundation in database development or administration. For intermediate to advanced users, this book is also helpful as it provides an

See more details below

Overview

If you are just getting started with SQL or databases in general, Rescued by SQL is for you! Rescued by SQL covers the history of SQL, language syntax, and concepts of database design, all of which are necessary to build a solid foundation in database development or administration. For intermediate to advanced users, this book is also helpful as it provides an overview of SQL functions as they are performed on Microsoft SQL Server and MySQL database system. The lessons presented in Rescued by SQL are intended to build upon one another so that by following them in order, you should gain an excellent overall understanding of the SQL language. The lessons can also serve as an excellent reference when a question arises about a specific SQL feature or syntax question. Rescued by SQL is designed to be used with Microsoft SQL Server 7.0; however, special notes relating to the use of the popular MySQL database server are included. The examples and code contained within are fully compliant with SQL standards (unless specifically noted) and should work on any database server which is SQL compliant. The SQL language, or subsets of it, can be found in most database servers, including Microsoft SQL Server, Microsoft Access, Oracle SQL Server, and MySQL so this book is useful for anyone working with databases.

Read More

Product Details

ISBN-13:
9780766849464
Publisher:
Cengage Learning
Publication date:
11/14/2001
Pages:
400
Product dimensions:
7.86(w) x 8.76(h) x 0.95(d)

Table of Contents

Fundamental Concepts. What is SQL? What kind of language is SQL. History of ANSI SQL. 3 Parts of SQL. Design Considerations. Types of databses. Elements of a Database (structure). Elements (flow option 1). Elements (flow option 2). The Relational Model. How Tables relate to each other. Briefly describe the 2 main components. Describe some different service models between clients and servers. Structure Management. Data Management. Data Extraction. Security Management. Transaction Management. Getting Started. Multiple Tables. Structure Management. Data Management. Performance. Safety. Embedded SQL. SQL Standards.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >