SQL in 24 Hours, Sams Teach Yourself, 6th Edition

About

Features

• The up-to-the-minute SQL tutorial for everyone who wants to create applications, query data, or manage databases
• Covers SQL as implemented in MySQL, Oracle, and Microsoft SQL Server 
• Covers everything from the basics through optimization, security, and enterprise techniques
• Step-by-step instructions, examples, quizzes, exercises, and tips

Description

Includes Coverage of Oracle and Microsoft SQL Implementations

In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours, Sixth Edition, helps you use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security.

This book’s straightforward, step-by-step approach shows you how to work with database structures, objects, queries, tables, and more. In just hours, you will be applying advanced techniques, including views, transactions, web connections, and powerful Oracle and SQL Server extensions. Every lesson builds on what you’ve already learned, giving you a rock-solid foundation for real-world success.

Step-by-step instructions carefully walk you through the most common SQL tasks.
Practical, hands-on examples show you how to apply what you learn.
Quizzes and exercises help you test your knowledge and stretch your skills.
Notes and tips point out shortcuts and solutions.

Learn how to…
• Define efficient database structures and objects
• “Normalize” raw databases into logically organized tables
• Edit relational data and tables with DML
• Manage transactions
• Write effective, well-performing queries
• Categorize, summarize, sort, group, and restructure data
• Work with dates and times
• Join tables in queries, use subqueries, and combine multiple queries
• Master powerful query optimization techniques
• Administer databases and manage users
• Secure databases and protect data
• Use views, synonyms, and the system catalog
• Extend SQL to the enterprise and Internet
• Master important Oracle and Microsoft extensions to ANSI SQL

Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.

Sample Content

Sample Pages

Download the sample pages (includes Chapter 9 and Index)

Table of Contents

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     8
Canary Airlines: The Database Used in This Book     11
Summary     15
Q&A     16
Workshop     16

PART II: BUILDING YOUR DATABASE
Hour 2: Defining Data Structures     19
What Is Data?     19
Basic Data Types     20
Summary     28
Q&A    29
Workshop     29
Hour 3: Managing Database Objects     33
Database Objects and Schema     33
Tables: The Primary Storage for Data    35
Integrity Constraints     44
Summary    49
Q&A     50
Workshop     50
Hour 4: The Normalization Process    55
Normalizing a Database     55
Denormalizing a Database    63
Summary     64
Q&A    64
Workshop     64
Hour 5: Manipulating Data     67
Overview of Data Manipulation     67
Populating Tables with New Data     68
Updating Existing Data    73
Deleting Data from Tables     75
Summary     76
Q&A     77
Workshop     77
Hour 6: Managing Database Transactions    81
What Is a Transaction?     81
Controlling Transactions     82
Poor Transactional Control     90
Summary     90
Q&A     90
Workshop     91

PART III: GETTING EFFECTIVE RESULTS FROM QUERIES
Hour 7: Introduction to Database Queries     93
The SELECT Statement     93
Case-Sensitivity     101
Fundamentals of Query Writing    102
Summary     106
Q&A     106
Workshop     107
Hour 8: Using Operators to Categorize Data     109
What Is an Operator in SQL?     109
Comparison Operators     110
Logical Operators    113
Conjunctive Operators     120
Negative Operators     123
Arithmetic Operators     128
Summary     130
Q&A    131
Workshop     131
Hour 9: Summarizing Data Results from a Query     133
Aggregate Functions     133
Summary    141
Q&A     142
Workshop    142
Hour 10: Sorting and Grouping Data    145
Why Group Data?     145
The GROUP BY Clause     146
GROUP BY Versus ORDER BY     150
CUBE and ROLLUP Expressions    153
The HAVING Clause     155
Summary     156
Q&A     157
Workshop     157
Hour 11: Restructuring the Appearance of Data     159
ANSI Character Functions     159
Common Character Functions     160
Miscellaneous Character Functions     169
Mathemat

Updates

Errata

Download errata for Sams Teach Yourself SQL in 24 Hours, 6th Edition (103 KB .pdf).

Submit Errata