Book description
Master all the fundamentals of modern SQL -- hands-on, step-by-step!
¿
The up-to-the-minute SQL tutorial for everyone who wants to create applications, query data, or manage databases
Updated to cover the latest ANSI/ISO standards, plus powerful Oracle and SQL Server extensions
Covers everything from the basics through optimization, security, and enterprise techniques
Step-by-step instructions, examples, quizzes, exercises, and tips
In just 24 sessions of one hour or less, beginning-to-intermediate-level readers learn how to use SQL to build effective databases, efficiently retrieve data, and manage everything from performance to security! Using this book's straightforward, step-by-step approach, you learn hands-on, through practical examples based on the free, open source MySQL database. One step at a time, you discover how to define efficient database structures, objects, and tables edit data and tables manage transactions write effective queries categorize, summarize, sort, group, and restructure data use joins and subqueries manage databases, users, and security use views, synonyms, and system catalogs extend SQL to the enterprise and Internet even master important Oracle and Microsoft SQL Server extensions. Step-by-step instructions carefully walk through common questions, issues, and tasks... Q and As, Quizzes, and Exercises help you build and test your knowledge... Notes, Tips, and Cautions point out shortcuts, solutions, and problems to avoid. Each lesson builds on what you've already learned, delivering a strong real-world foundation for success with any relational database environment or application!
Table of contents
- Title Page
- Copyright Page
- Dedication
- Contents at a Glance
- Table of Contents
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Part I: An SQL Concepts Overview
- Part II: Building Your Database
- Part III: Getting Effective Results from Queries
- Part IV: Building Sophisticated Database Queries
- Part V: SQL Performance Tuning
- Part VI: Using SQL to Manage Users and Security
- Part VII: Summarized Data Structures
- Part VIII: Applying SQL Fundamentals in Today’s World
- Part IX: Appendixes
- Index
Product information
- Title: Sams Teach Yourself SQL in 24 Hours, Fifth Edition
- Author(s):
- Release date: May 2011
- Publisher(s): Sams
- ISBN: 9780132603911
You might also like
book
Sams Teach Yourself XML in 10 Minutes
XML is the de-facto standard for manipulating and sharing data among applications. It is supported by …
book
Discovering SQL: A Hands-On Guide for Beginners
Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you …
book
SQL in 24 Hours, Sams Teach Yourself, Sixth Edition
Includes Coverage of Oracle and Microsoft SQL Implementations In just 24 lessons of one hour or …
book
Expert Performance Indexing for SQL Server 2012
Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important …