Teach Yourself Sql Essay

128517 Words 515 Pages
Teach Yourself SQL in 21 Days, Second Edition

Table of Contents:
Introduction

Week 1 at a Glance
Day 1 Introduction to SQL Day 2 Introduction to the Query: The SELECT Statement Day 3 Expressions, Conditions, and Operators Day 4 Functions: Molding the Data You Retrieve Day 5 Clauses in SQL Day 6 Joining Tables Day 7 Subqueries: The Embedded SELECT Statement

Week 1 in Review Week 2 at a Glance
Day 8 Manipulating Data Day 9 Creating and Maintaining Tables

Day 10 Creating Views and Indexes Day 11 Controlling Transactions Day 12 Database Security Day 13 Advanced SQL Topics Day 14 Dynamic Uses of SQL

Week 2 in Review Week 3 at a Glance
Day 15 Streamlining SQL Statements for Improved Performance Day 16 Using Views to Retrieve
…show more content…
This book is dedicated to my beautiful wife, Becky. I am truly appreciative to you for your support, encouragement, and love. Thanks for staying up with me during all those late-night sessions. You are absolutely the best. -- Bryan Morgan Thanks to my family, Leslie, Laura, Kelly, Valerie, Jeff, Mom, and Dad. Their support made working on this book possible.

-- Jeff Perkins

About the Authors
Ryan K. Stephens Ryan K. Stephens started using SQL as a programmer/analyst while serving on active duty in the Indiana Army National Guard. Hundreds of programs later, Ryan became a database administrator. He currently works for Unisys Federal Systems, where he is responsible for government-owned databases throughout the United States. In addition to his full-time job, Ryan teaches SQL and various database classes at Indiana University-Purdue University Indianapolis. He also serves part-time as a programmer for the Indiana Army National Guard. Along with Ron Plew and two others, Ryan owns a U.S. patent on a modified chess game. Some of his interests include active sports, chess, nature, and writing. Ryan lives in Indianapolis with his wife, Tina, and their three dogs, Bailey, Onyx, and Sugar. Ronald R. Plew Ronald R. Plew is a database administrator for Unisys Federal Systems. He holds a bachelor of science degree in business administration/management from the Indiana Institute of Technology. He is an instructor

Related Documents