SAMS TCH YSLF SQL 24 HR_p5
De som köpt den här boken har ofta också köpt How to Win At Chess av Levy Rozman, Gothamchess (inbunden).
Köp båda 2 för 456 krDespite its highly adaptable and flexible nature, C++ is also one of the more complex programming languages to learn. Once mastered, however, it can help you organize and process information with amazing efficiency and quickness. The C++ Cookbook ...
For more than 10 years, the authors have studied, applied, and documented the SQL standard and its application to critical database systems in this book. Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm. PTI specializes in database technologies, primarily Oracle and SQL servers running on all UNIX, Linux, and Microsoft platforms. Starting out as data analysts and database administrators, Ryan and Ron now lead a team of impressive technical subject matter experts who manage databases for clients worldwide. They authored and taught database courses for Indiana University-Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and high availability of critical systems. Arie D. Jones is the principal technology manager for Perpetual Technologies, Inc. (PTI) in Indianapolis, Indiana. Arie leads PTI's team of experts in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. He is a regular speaker at technical events and has authored several books and articles pertaining to database-related topics.
Part I: An SQL Concepts Overview
HOUR 1: Welcome to the World of SQL 1
SQL Definition and History 1
SQL Sessions 8
Types of SQL Commands 9
The Database Used in This Book 12
Summary 17
Q&A 17
Workshop 18
Part II: Building Your Database
HOUR 2: Defining Data Structures 21
What Is Data? 21
Basic Data Types 22
Summary 31
Q&A 31
Workshop 32
HOUR 3: Managing Database Objects 37
What Are Database Objects? 37
What Is a Schema? 37
Tables: The Primary Storage for Data 39
Integrity Constraints 49
Summary 54
Q&A 55
Workshop 55
HOUR 4: The Normalization Process 61
Normalizing a Database 61
Denormalizing a Database 69
Summary 70
Q&A 70
Workshop 71
HOUR 5: Manipulating Data 73
Overview of Data Manipulation 73
Populating Tables with New Data 74
Updating Existing Data 80
Deleting Data from Tables 82
Summary 83
Q&A 83
Workshop 84
HOUR 6: Managing Database Transactions 87
What Is a Transaction? 87
Controlling Transactions 88
Transactional Control and Database Performance 95
Summary 96
Q&A 96
Workshop 97
Part III: Getting Effective Results from Queries
HOUR 7: Introduction to the Database Query 99
What Is a Query? 99
Introduction to the SELECT Statement 99
Examples of Simple Queries 108
Summary 112
Q&A 112
Workshop 113
HOUR 8: Using Operators to Categorize Data 115
What Is an Operator in SQL? 115
Comparison Operators 116
Logical Operators &...