Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

SQL: A Beginner's Guide, Third Edition 3rd edition [Pehme köide]

3.77/5 (41 hinnangut Goodreads-ist)

Robert Sheldon, Andy Oppel

Formaat: Paperback / softback, 534 pages, kõrgus x laius x paksus: 229x185x28 mm, kaal: 890 g, 52 Illustrations
Sari: Beginner's Guide
Ilmumisaeg: 16-Sep-2008
Kirjastus: McGraw-Hill Professional
ISBN-10: 0071548645
ISBN-13: 9780071548649

Teised raamatud teemal:

SQL Server / MS SQL

Pehme köide
Hind: 43,74 €*
* saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
Kogus:
- - 1
  - 2
  - 3
  - 4
  - 5
  - 6
  - 7
  - 8
  - 9
  - 10
Lisa ostukorvi
Tasuta tarne
Lisa soovinimekirja

Formaat: Paperback / softback, 534 pages, kõrgus x laius x paksus: 229x185x28 mm, kaal: 890 g, 52 Illustrations
Sari: Beginner's Guide
Ilmumisaeg: 16-Sep-2008
Kirjastus: McGraw-Hill Professional
ISBN-10: 0071548645
ISBN-13: 9780071548649

Teised raamatud teemal:

SQL Server / MS SQL

Püsilink: https://www.kriso.ee/db/9780071548649.html

Märksõnad:

An beginner's guide to SQL programming discusses the new features of the SQL:2006 ANSI/ISO standard, including SQL/XML, and explains how to program with SQL, covering topics including database objects, queries, modifications, embedded statements, troubleshooting, and management and administration functions. Original. (Beginner)

The third edition of this guide to the SQL programming language has been updated to include basic information on SQL/XML, and how to use new features in conjunction with RDBMS software such as MySQL 5.0, SQL Server 2008 and Oracle Database 11g. Oppel, an experienced database designer, has written this book for experienced programmers and users who need an introduction to Structured Query Language, underlining the ability to retrieve, insert, update and delete data while performing regular maintenance on the SQL database. Each chapter ends with self- quizzes and exercises designed to promote fluency in the SQL language. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

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

Acknowledgments

Introduction

PART I Relational Databases and SQL

Introduction to Relational Databases and SQL

(26)

Understand Relational Databases

(11)

The Relational Model

(10)

Learn About SQL

(14)

The SQL Evolution

(3)

Types of SQL Statements

(1)

Types of Execution

(2)

SQL Standard versus Product Implementations

(8)

Working with the SQL Environment

(20)

Understand the SQL Environment

(2)

Understand SQL Catalogs

(8)

Schemas

(1)

Schema Objects

(2)

Then What Is a Database?

(3)

Name Objects in an SQL Environment

(2)

Qualified Names

(1)

Create a Schema

(2)

Create a Database

(5)

Creating and Altering Tables

(24)

Create SQL Tables

(4)

Specify Column Data Types

(9)

String Data Types

(2)

Numeric Data Types

(1)

Datetime Data Types

(2)

Interval Data Types

(1)

Boolean Data Types

(1)

Using SQL Data Types

(1)

Create User-Defined Types

(1)

Specify Column Default Values

(5)

Delete SQL Tables

(4)

Enforcing Data Integrity

(30)

Understand Integrity Constraints

(2)

Use NOT NULL Constraints

(1)

Add UNIQUE Constraints

(2)

Add PRIMARY KEY Constraints

(4)

Add FOREIGN KEY Constraints

(12)

The MATCH Clause

(1)

The <referential triggered action> Clause

(6)

Define CHECK Constraints

(8)

Defining Assertions

(1)

Creating Domains and Domain Constraints

(5)

Creating SQL Views

103

(20)

Add Views to the Database

104

(10)

Defining SQL Views

108

(6)

Create Updateable Views

114

(3)

Using the WITH CHECK OPTION Clause

116

(1)

Drop Views from the Database

117

(6)

Managing Database Security

123

(22)

Understand the SQL Security Model

124

(6)

SQL Sessions

126

(2)

Accessing Database Objects

128

(2)

Create and Delete Roles

130

(1)

Grant and Revoke Privileges

131

(6)

Revoking Privileges

135

(2)

Grant and Revoke Roles

137

(8)

Revoking Roles

138

(7)

PART II Data Access and Modification

Querying SQL Data

145

(30)

Use a SELECT Statement to Retrieve Data

147

(5)

The SELECT Clause and FROM Clause

147

(5)

Use the WHERE Clause to Define Search Conditions

152

(7)

Defining the WHERE Clause

156

(3)

Use the GROUP BY Clause to Group Query Results

159

(5)

Use the HAVING Clause to Specify Group Search Conditions

164

(2)

Use the ORDER BY Clause to Sort Query Results

166

(9)

Modifying SQL Data

175

(18)

Insert SQL Data

176

(6)

Inserting Values from a SELECT Statement

180

(2)

Update SQL Data

182

(4)

Updating Values from a SELECT Statement

185

(1)

Delete SQL Data

186

(7)

Using Predicates

193

(32)

Compare SQL Data

194

(6)

Using the BETWEEN Predicate

199

(1)

Return Null Values

200

(3)

Return Similar Values

203

(6)

Reference Additional Sources of Data

209

(7)

Using the IN Predicate

209

(4)

Using the EXISTS Predicate

213

(3)

Quantify Comparison Predicates

216

(9)

Using the SOME and ANY Predicates

216

(2)

Using the ALL Predicate

218

(7)

Working with Functions and Value Expressions

225

(28)

Use Set Functions

226

(6)

Using the COUNT Function

227

(2)

Using the MAX and MIN Functions

229

(2)

Using the SUM Function

231

(1)

Using the AVG Function

232

(1)

Use Value Functions

232

(6)

Working with String Value Functions

233

(3)

Working with Datetime Value Functions

236

(2)

Use Value Expressions

238

(7)

Working with Numeric Value Expressions

238

(3)

Using the CASE Value Expression

241

(3)

Using the CAST Value Expression

244

(1)

Use Special Values

245

(8)

Accessing Multiple Tables

253

(24)

Perform Basic Join Operations

254

(7)

Using Correlation Names

257

(1)

Creating Joins with More than Two Tables

258

(1)

Creating the Cross Join

259

(1)

Creating the Self-Join

260

(1)

Join Tables with Shared Column Names

261

(2)

Creating the Natural Join

262

(1)

Creating the Named Column Join

263

(1)

Use the Condition Join

263

(6)

Creating the Inner Join

264

(2)

Creating the Outer Join

266

(3)

Perform Union Operations

269

(8)

Using Subqueries to Access and Modify Data

277

(22)

Create Subqueries That Return Multiple Rows

278

(5)

Using the IN Predicate

279

(2)

Using the EXISTS Predicate

281

(1)

Using Quantified Comparison Predicates

282

(1)

Create Subqueries That Return One Value

283

(1)

Work with Correlated Subqueries

284

(2)

Use Nested Subqueries

286

(2)

Use Subqueries to Modify Data

288

(11)

Using Subqueries to Insert Data

288

(2)

Using Subqueries to Update Data

290

(1)

Using Subqueries to Delete Data

291

(8)

PART III Advanced Data Access

Creating SQL-Invoked Routines

299

(30)

Understand SQL-Invoked Routines

300

(3)

SQL-Invoked Procedures and Functions

301

(1)

Working with the Basic Syntax

301

(2)

Create SQL-Invoked Procedures

303

(3)

Invoking SQL-Invoked Procedures

305

(1)

Add Input Parameters to Your Procedures

306

(5)

Using Procedures to Modify Data

309

(2)

Add Local Variables to Your Procedures

311

(2)

Work with Control Statements

313

(7)

Create Compound Statements

313

(1)

Create Conditional Statements

314

(2)

Create Looping Statements

316

(4)

Add Output Parameters to Your Procedures

320

(1)

Create SQL-Invoked Functions

321

(8)

Creating SQL Triggers

329

(22)

Understand SQL Triggers

330

(3)

Trigger Execution Context

331

(2)

Create SQL Triggers

333

(3)

Referencing Old and New Values

334

(1)

Dropping SQL Triggers

335

(1)

Create Insert Triggers

336

(2)

Create Update Triggers

338

(5)

Create Delete Triggers

343

(8)

Using SQL Cursors

351

(26)

Understand SQL Cursors

352

(3)

Declaring and Opening SQL Cursors

353

(2)

Declare a Cursor

355

(8)

Working with Optional Syntax Elements

356

(4)

Creating a Cursor Declaration

360

(3)

Open and Close a Cursor

363

(1)

Retrieve Data from a Cursor

363

(5)

Use Positioned UPDATE and DELETE Statements

368

(9)

Using the Positioned UPDATE Statement

368

(2)

Using the Positioned DELETE Statement

370

(7)

Managing SQL Transactions

377

(26)

Understand SQL Transactions

378

(3)

Set Transaction Properties

381

(8)

Specifying an Isolation Level

382

(5)

Specifying a Diagnostics Size

387

(1)

Creating a SET TRANSACTION Statement

388

(1)

Start a Transaction

389

(1)

Set Constraint Deferability

390

(2)

Create Savepoints in a Transaction

392

(3)

Releasing a Savepoint

394

(1)

Terminate a Transaction

395

(8)

Committing a Transaction

395

(1)

Rolling Back a Transaction

396

(7)

Accessing SQL Data from Your Host Program

403

(30)

Invoke SQL Directly

404

(2)

Embed SQL Statements in Your Program

406

(11)

Creating an Embedded SQL Statement

407

(1)

Using Host Variables in Your SQL Statements

408

(3)

Retrieving SQL Data

411

(2)

Error Handling

413

(4)

Create SQL Client Modules

417

(2)

Defining SQL Client Modules

418

(1)

Use an SQL Call-Level Interface

419

(14)

Allocating Handles

421

(2)

Executing SQL Statements

423

(1)

Working with Host Variables

424

(2)

Retrieving SQL Data

426

(7)

Working with XML Data

433

(86)

Learn the Basics of XML

434

(3)

Learn About SQL/XML

437

(12)

The XML Data Type

437

(2)

SQL/XML Functions

439

(2)

SQL/XML Mapping Rule

441

(8)

PART IV Appendices

Answers to Self Test

449

(42)

SQL: 2006 Keywords

491

(6)

SQL Reserved Keywords

492

(2)

SQL Nonreserved Keywords

494

(3)

SQL Code Used in Try This Exercises

497

(22)

SQL Code by Try This Exercise

498

(16)

The INVENTORY Database

514

(5)

Index

519

Andrew J. (Andy) Oppel is a proud graduate of The Boys Latin School of Maryland and of Transylvania University (Lexington, KY) where he earned a BA in computer science in 1974. Since then he has been continuously employed in a wide variety of information technology positions, including programmer, programmer/analyst, systems architect, project manager, senior database administrator, database group manager, consultant, database designer, and data architect. In addition, he has been a part-time instructor with the University of California (Berkeley) Extension for over 20 years, and received the Honored Instructor Award for the year 2000. His teaching work included developing three courses for UC Extension, Concepts of Database Management Systems, Introduction to Relational Database Management Systems, and "Data Modeling and Database Design." He also earned his Oracle 9i Database Associate certification in 2003. He is currently employed as a senior data modeler for Blue Shield of California. Aside from computer systems, Andy enjoys music (guitar and vocals), amateur radio (Pacific Division Vice Director, American Radio Relay League) and soccer (Referee Instructor, U.S. Soccer). Andy 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) and SQL Demystified (McGraw-Hill/Osborne, 2005). His database product experience includes IMS, DB2, Sybase, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7, 8, 8i, 9i, and 10g).

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

SQL: A Beginner's Guide, Third Edition 3rd edition [Pehme köide]

Konto & seaded

Otsing

Otsingu andmebaas

Filtreeri tulemusi

Teemad Ingliskeelsed raamatud

Vali ostukorv