text.skipToContent text.skipToNavigation
  1. Home
  2. Computer Science & IT
  3. SQL in 24 Hours, Sams Teach Yourself

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

  • Ryan Stephens
  • Arie D. Jones
  • Ron Plew

Published by Sams Publishing (December 13th 2015) - Copyright © 2016

6th edition

Chosen format
View all
SQL in 24 Hours, Sams Teach Yourself

ISBN-13: 9780134305899

Includes: Unassigned

This product is not available in your country

What's included

  • Unassigned

Overview

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

For teachers

All the material you need to teach your courses.

Discover teaching material