Register your product to gain access to bonus material or receive a coupon.
SQL in 24 Hours, Sams Teach Yourself, 6th Edition
- By Ryan Stephens, Arie D. Jones, Ron Plew
- Published Dec 13, 2015 by Sams. Part of the Sams Teach Yourself series.
Book
- Sorry, this book is no longer in print.
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
- Copyright 2016
- Dimensions: 7" x 9-1/8"
- Pages: 464
- Edition: 6th
- Book
- ISBN-10: 0-672-33759-2
- ISBN-13: 978-0-672-33759-8
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).