[valeri[µ]]

SQL in 24 Hours - 5th Edition


Год: 2011
Автор: Ryan Stephens
Жанр: WEB Development
Издательство: Sams
ISBN: 978-0-672-33541-9
Серия: Teach Yourself
Язык: Английский
Формат: PDF
Качество: Отсканированные страницы
Интерактивное оглавление: Нет
Количество страниц: 497
Описание: Welcome to the world of relational databases and SQL! This book is written for those selfmotivated individuals out there who would like to get an edge on relational database technology by learning the Structured Query Language—SQL. This book was written primarily for those with very little or no experience with relational database management systems using SQL. This book also applies to those who have some experience with relational databases but need to learn how to navigate within the database, issue queries against the database, build database structures, manipulate data in the database, and more. This book is not geared toward individuals with significant relational database experience who have been using SQL on a regular basis.

HOUR 1 Welcome to the World of SQL 1
Part II: Bulldlng Your Database
HOUR 2 Defining Data Structures 21
3 Managing Database Objects 37
4 The Normalization Process 61
5 Manipulating Data 73
6 Managing Database Transactions 87
Part III: Gettlng Effective Results from Queries
HOUR 1 Introduction to the Database Query 99
8 Using Operators to Categorize Data 115
9 Summarizing Data Results from a Query 141
10 Sorting and Grouping Data 153
11 Restructuring the Appearance of Data 169
12 Understanding Dates and Times 191
Part IV: Bulldlng Sophlstlcated Database Querles
HOUR 13 Joining Tables in Queries 207
14 Using Subqueries to Define Unknown Data 225
15 Combining Multiple Queries into One 239
Part V: SQL Performance Tuning
HOUR 16 Using Indexes to Improve Performance 255
17 Improving Database Performance 267
Part VI: Uslng SQI. to Manage Users and Securlty
HOUR 18 Managing Database Users 285
19 Managing Database Security 299
Part VII: summarlzed Data structures
HOUR 20 Creating and Using Views and Synonyms 313
21 Working with the System Catalog 329
Part VIII: Applylng SQL Fundamentals In Today's World
HOUR 22 Advanced SQL Topics 339
23 Extending SQL to the Enterprise, the Internet, and the Intranet 355
24 Extensions to Standard SQL 367
Part IX: Appendixes
A Common SQL Commands 377
B Using the Databases for Exercises 383
C Answers to Quizzes and Exercises 391
D CREATE TABLE Statements for Book Examples 439
E INSERT Statements for Data in Book Examples 443
F Glossary 451
G Bonus Exercises 455