|
|
|
|
Sams Teach Yourself SQL in 24 Hours (4th Edition) |
 |
To download torrents you need a BitTorrent client like BitTorrent
|
Description |
 |
| Sams Teach Yourself SQL in 24 Hours (4th Edition)
Pub. Date: June 2008 |Publisher: Sams |Format: pdf |Series: Sams Teach Yourself -- Hours Series |ISBN-13: 9780672330186 |ISBN: 0672330180 |Size :2mb |Edition Number: 4 www.woebooks.com
Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
See inside the book click me www.woebooks.com
Download Links www.woebooks.com
Table of Contents
Introduction 1
Pt. I A SQL Concepts Overview 5
Hour 1 Welcome to the World of SQL 7
Pt. II Building Your Database 25
Hour 2 Defining Data Structures 27
Hour 3 Managing Database Objects 41
Hour 4 The Normalization Process 61
Hour 5 Manipulating Data 71
Hour 6 Managing Database Transactions 85
Pt. III Getting Effective Results from Queries 97
Hour 7 Introduction to the Database Query 99
Hour 8 Using Operators to Categorize Data 115
Hour 9 Summarizing Data Results from a Query 139
Hour 10 Sorting and Grouping Data 149
Hour 11 Restructuring the Appearance of Data 161
Hour 12 Understanding Dates and Times 183
Pt. IV Building Sophisticated Database Queries 199
Hour 13 Joining Tables in Queries 201
Hour 14 Using Subqueries to Define Unknown Data 219
Hour 15 Combining Multiple Queries into One 235
Pt. V SQL Performance Tuning 251
Hour 16 Using Indexes to Improve Performance 253
Hour 17 Improving Database Performance 263
Pt. VI Using SQL to Manage Users and Security 279
Hour 18 Managing Database Users 281
Hour 19 Managing Database Security 293
Pt. VII Summarized Data Structures 309
Hour 20 Creating and Using Views and Synonyms 311
Hour 21 Working with the System Catalog 327
Pt. VIII Applying SQL Fundamentals in Today's World 339
Hour 22 Advanced SQL Topics 341
Hour 23 Extending SQL to the Enterprise, the Internet, and the Intranet 355
Hour 24 Extensions to Standard SQL 365
Pt. IX Appendixes 375
App. A Common SQL Commands 377
App. B Using MySQL for Exercises 383
App. C Answers to Quizzes and Exercises 387
App. D Create Table Statements for Book Examples 431
App. E Insert Statements for Data in Book Examples 435
App. F: Glossary 441
App. G: Bonus Exercises 445
Index 451 |
|
|
Related Torrents |
|
|
|
