SQL: A Beginner's Guide, Fourth Edition
- 9h 1m
- Andrew J. Oppel
- McGraw-Hill/Osborne
- 2016
Essential SQL Skills Made Easy
Fully revised to cover the latest software versions, this easy-to-follow guide will get you started programming in SQL right away. Discover how to create database tables, access and modify data, work with triggers and transactions, build effective queries, and handle management and administrative functions. SQL: A Beginner's Guide, Fourth Edition offers clear instruction on each topic and is loaded with step-by-step examples. This practical book includes coverage of database security, SQL/XML, and new temporal data features.
Designed for Easy Learning:
- Key Skills & Concepts--Lists of specific skills covered in the chapter
- Ask the Expert--Q&A sections filled with bonus information and helpful tips
- Try This--Hands-on exercises that show how to apply your skills
- Notes--Extra information related to the topic being covered
- Tips--Helpful reminders or alternate ways of doing things
- Cautions--Errors and pitfalls to avoid
- Self-Tests--Chapter-ending quizzes to test your knowledge
- Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated
About the Author
Andrew J. (Andy) Oppel has held a wide variety of information technology positions, including programmer, programmer/analyst, systems architect, and project manager. He is a Technical Trainer at GoodData Corporation, an instructor at University of California (Berkeley) Extension, and author of many instructional books, including SQL Demystified, Databases, A Beginner's Guide, and SQL: The Complete Reference, 3rd Edition.
In this Book
-
Introduction
-
Introduction to Relational Databases and SQL
-
Working with the SQL Environment
-
Creating and Altering Tables
-
Enforcing Data Integrity
-
Creating SQL Views
-
Managing Database Security
-
Querying SQL Data
-
Modifying SQL Data
-
Using Predicates
-
Working with Functions and Value Expressions
-
Accessing Multiple Tables
-
Using Subqueries to Access and Modify Data
-
Working with Temporal Data
-
Creating SQL-Invoked Routines
-
Creating SQL Triggers
-
Using SQL Cursors
-
Managing SQL Transactions
-
Accessing SQL Data from Your Host Program
-
Working with XML Data
