SQL

A Beginner's Guide, Third Edition

By: Andy Oppel, Robert Sheldon

Write A Review

Paperback | 1 August 2008 | Edition Number 3

At a Glance

Paperback
534 Pages

Edition Type
Revised

Dimensions(cm)
22.86 x 19.05 x 3.18

New Edition

Published: 9th October 2015

Paperback

$79.75

or 4 interest-free payments of $19.94 with

Ships in 10 to 15 business days

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 Beginner'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 & Concepts--Lists of specific skills covered in the chapter
Ask the Experts--Q&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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Information Technology General Issue Databases Database Software SQL Server & MS SQL Computer Certification

Acknowledgments	p. xi
Introduction	p. xi
Relational Databases and SQL
Introduction to Relational Databases and SQL	p. 3
Understand Relational Databases	p. 4
The Relational Model	p. 5
Learn About SQL	p. 15
The SQL Evolution	p. 15
Types of SQL Statements	p. 18
Types of Execution	p. 19
SQL Standard versus Product Implementations	p. 21
Working with the SQL Environment	p. 29
Understand the SQL Environment	p. 30
Understand SQL Catalogs	p. 32
Schemas	p. 34
Schema Objects	p. 35
Then What Is a Database?	p. 37
Name Objects in an SQL Environment	p. 40
Qualified Names	p. 41
Create a Schema	p. 42
Create a Database	p. 44
Creating and Altering Tables	p. 49
Create SQL Tables	p. 50
Specify Column Data Types	p. 54
String Data Types	p. 55
Numeric Data Types	p. 57
Datetime Data Types	p. 58
Interval Data Type	p. 60
Boolean Data Type	p. 61
Using SQL Data Types	p. 62
Create User-Defined Types	p. 63
Specify Column Default Values	p. 64
Delete SQL Tables	p. 69
Enforcing Data Integrity	p. 73
Understand Integrity Constraints	p. 74
Use NOT NULL Constraints	p. 76
Add UNIQUE Constraints	p. 77
Add PRIMARY KEY Constraints	p. 79
Add FOREIGN KEY Constraints	p. 83
The MATCH Clause	p. 88
The [left angle bracket]referential triggered action[right angle bracket] Clause	p. 89
Define CHECK Constraints	p. 95
Defining Assertions	p. 97
Creating Domains and Domain Constraints	p. 98
Creating SQL Views	p. 103
Add Views to the Database	p. 104
Defining SQL Views	p. 108
Create Updateable Views	p. 114
Using the WITH CHECK OPTION Clause	p. 116
Drop Views from the Database	p. 117
Managing Database Security	p. 123
Understand the SQL Security Model	p. 124
SQL Sessions	p. 126
Accessing Database Objects	p. 128
Create and Delete Roles	p. 130
Grant and Revoke Privileges	p. 131
Revoking Privileges	p. 135
Grant and Revoke Roles	p. 137
Revoking Roles	p. 138
Data Access and Modification
Querying SQL Data	p. 145
Use a SELECT Statement to Retrieve Data	p. 146
The SELECT Clause and FROM Clause	p. 147
Use the WHERE Clause to Define Search Conditions	p. 152
Defining the WHERE Clause	p. 156
Use the GROUP BY Clause to Group Query Results	p. 159
Use the HAVING Clause to Specify Group Search Conditions	p. 164
Use the ORDER BY Clause to Sort Query Results	p. 166
Modifying SQL Data	p. 175
Insert SQL Data	p. 176
Inserting Values from a SELECT Statement	p. 180
Update SQL Data	p. 182
Updating Values from a SELECT Statement	p. 185
Delete SQL Data	p. 186
Using Predicates	p. 193
Compare SQL Data	p. 194
Using the BETWEEN Predicate	p. 199
Return Null Values	p. 200
Return Similar Values	p. 203
Reference Additional Sources of Data	p. 209
Using the IN Predicate	p. 209
Using the EXISTS Predicate	p. 213
Quantify Comparison Predicates	p. 216
Using the SOME and ANY Predicates	p. 216
Using the ALL Predicate	p. 218
Working with Functions and Value Expressions	p. 225
Use Set Functions	p. 226
Using the COUNT Function	p. 227
Using the MAX and MIN Functions	p. 229
Using the SUM Function	p. 231
Using the AVG Function	p. 232
Use Value Functions	p. 232
Working with String Value Functions	p. 233
Working with Datetime Value Functions	p. 236
Use Value Expressions	p. 238
Working with Numeric Value Expressions	p. 238
Using the CASE Value Expression	p. 241
Using the CAST Value Expression	p. 244
Use Special Values	p. 245
Accessing Multiple Tables	p. 253
Perform Basic Join Operations	p. 254
Using Correlation Names	p. 257
Creating Joins with More than Two Tables	p. 258
Creating the Cross Join	p. 259
Creating the Self-Join	p. 260
Join Tables with Shared Column Names	p. 261
Creating the Natural Join	p. 262
Creating the Named Column Join	p. 263
Use the Condition Join	p. 263
Creating the Inner Join	p. 264
Creating the Outer Join	p. 266
Perform Union Operations	p. 269
Using Subqueries to Access and Modify Data	p. 277
Create Subqueries That Return Multiple Rows	p. 278
Using the IN Predicate	p. 279
Using the EXISTS Predicate	p. 281
Using Quantified Comparison Predicates	p. 282
Create Subqueries That Return One Value	p. 283
Work with Correlated Subqueries	p. 284
Use Nested Subqueries	p. 286
Use Subqueries to Modify Data	p. 288
Using Subqueries to Insert Data	p. 288
Using Subqueries to Update Data	p. 290
Using Subqueries to Delete Data	p. 291
Advanced Data Access
Creating SQL-Invoked Routines	p. 299
Understand SQL-Invoked Routines	p. 300
SQL-Invoked Procedures and Functions	p. 301
Working with the Basic Syntax	p. 301
Create SQL-Invoked Procedures	p. 303
Invoking SQL-Invoked Procedures	p. 305
Add Input Parameters to Your Procedures	p. 306
Using Procedures to Modify Data	p. 309
Add Local Variables to Your Procedures	p. 311
Work with Control Statements	p. 313
Create Compound Statements	p. 313
Create Conditional Statements	p. 314
Create Looping Statements	p. 316
Add Output Parameters to Your Procedures	p. 320
Create SQL-Invoked Functions	p. 321
Creating SQL Triggers	p. 329
Understand SQL Triggers	p. 330
Trigger Execution Context	p. 331
Create SQL Triggers	p. 333
Referencing Old and New Values	p. 334
Dropping SQL Triggers	p. 335
Create Insert Triggers	p. 336
Create Update Triggers	p. 338
Create Delete Triggers	p. 343
Using SQL Cursors	p. 351
Understand SQL Cursors	p. 352
Declaring and Opening SQL Cursors	p. 353
Declare a Cursor	p. 355
Working with Optional Syntax Elements	p. 356
Creating a Cursor Declaration	p. 360
Open and Close a Cursor	p. 363
Retrieve Data from a Cursor	p. 363
Use Positioned UPDATE and DELETE Statements	p. 368
Using the Positioned UPDATE Statement	p. 368
Using the Positioned DELETE Statement	p. 370
Managing SQL Transactions	p. 377
Understand SQL Transactions	p. 378
Set Transaction Properties	p. 381
Specifying an Isolation Level	p. 382
Specifying a Diagnostics Size	p. 387
Creating a SET TRANSACTION Statement	p. 388
Start a Transaction	p. 389
Set Constraint Deferability	p. 390
Create Savepoints in a Transaction	p. 392
Releasing a Savepoint	p. 394
Terminate a Transaction	p. 395
Committing a Transaction	p. 395
Rolling Back a Transaction	p. 396
Accessing SQL Data from Your Host Program	p. 403
Invoke SQL Directly	p. 404
Embed SQL Statements in Your Program	p. 406
Creating an Embedded SQL Statement	p. 407
Using Host Variables in Your SQL Statements	p. 408
Retrieving SQL Data	p. 411
Error Handling	p. 413
Create SQL Client Modules	p. 417
Defining SQL Client Modules	p. 418
Use an SQL Call-Level Interface	p. 419
Allocating Handles	p. 421
Executing SQL Statements	p. 423
Working with Host Variables	p. 424
Retrieving SQL Data	p. 426
Working with XML Data	p. 433
Learn the Basics of XML	p. 434
Learn About SQL/XML	p. 437
The XML Data Type	p. 437
SQL/XML Functions	p. 439
SQL/XML Mapping Rule	p. 441
Appendices
Answers to Self Test	p. 449
SQL:2006 Keywords	p. 491
SQL Reserved Keywords	p. 492
SQL Nonreserved Keywords	p. 494
SQL Code Used in Try This Exercises	p. 497
SQL Code by Try This Exercise	p. 498
The INVENTORY Database	p. 514
Index	p. 519
Table of Contents provided by Ingram. All Rights Reserved.

SQL

A Beginner's Guide, Third Edition

At a Glance

New Edition

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Principles of Marketing Analytics

Understand Data-Driven Decision-Making

Proceedings of the 4th International Conference onâ Big Data and Artificial Intelligence Applications (ICBDAIA'25)

Innovative Approaches in Artificial Intelligence and Big Data

Python All-in-One For Dummies

3rd Edition

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

The Data Science and Psychology

Data Mining

Concepts, Techniques and Applications

Database Systems

A Practical Approach

Tools and Applications of Data Mining

Big Data Analytics

A Practical Guide

Mindf*ck

Inside Cambridge Analytica's Plot to Break the World

The Art of Explanation

How to Communicate with Clarity and Confidence

Fundamentals of Database Systems, Global Edition

7th edition

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Microsoft 365 Access For Dummies

Access for Dummies

Social Research Methods

4th Edition

Hands-On Programming with R

Write Your Own Functions and Simulations

Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

Fundamentals of Data Engineering

Plan and Build Robust Data Systems

The Data Hero Playbook

Developing Your Data Leadership Superpowers

Data Analytics for Accounting ISE

3rd Edition

Interactively exploring high-dimensional data and models in R

1st Edition

This product is categorised by