SQL: A Beginner's Guide

3rd Edition
id: 5352 not VIP Open in MaM

By Andy Oppel, Robert Sheldon

Language: English

Category: Ebook - Computer/Internet

Categories: Computer/Internet

Size: 3.8 MiB pdf Files: 1

Uploader:

Uploaded At: 2009-04-20 07:50:22

McGraw-Hill Osborne Pub. Date: September 2008

Description

Essential Skills--Made Easy!  Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A BeginnerAnd#39;s Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g.  Designed for Easy Learning:      *      Key Skills Andamp; Concepts--Lists of specific skills covered in the chapter     *      Ask the Experts--QAndamp;A sections filled with bonus information and helpful tips     *      Try This--Hands-on exercises that show how to apply your skills     *      Notes--Extra information related to the topic being covered     *      Self-Tests--Chapter-ending quizzes to test your knowledge     *      Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated.  Table Of Contents: PART I Relational Databases and SQL 1 Introduction to Relational Databases and SQL 2 Working with the SQL Environment 3 Creating and Altering Tables 4 Enforcing Data Integrity 5 Creating SQL Views 6 Managing Database Security PART II Data Access and Modification 7 Querying SQL Data 8 Modifying SQL Data 9 Using Predicates 10 Working with Functions and Value Expressions 11 Accessing Multiple Tables PART III Advanced Data Access 13 Creating SQL-Invoked Routines 14 Creating SQL Triggers 15 Using SQL Cursors 16 Managing SQL Transactions 17 Accessing SQL Data from Your Host Program 18 Working with XML Data PART IV Appendices A Answers to Self Test B SQL:2006 Keywords C SQL Code Used in Try This Exercises Index

Other Torrents