Book description
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.
Table of contents
- About This E-Book
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Authors
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Part I: An SQL Concepts Overview
-
Part II: Building Your Database
- Hour 2. Defining Data Structures
- Hour 3. Managing Database Objects
- Hour 4. The Normalization Process
- Hour 5. Manipulating Data
- Hour 6. Managing Database Transactions
-
Part III: Getting Effective Results from Queries
- Hour 7. Introduction to Database Queries
- Hour 8. Using Operators to Categorize Data
- Hour 9. Summarizing Data Results from a Query
- Hour 10. Sorting and Grouping Data
- Hour 11. Restructuring the Appearance of Data
- Hour 12. Understanding Dates and Times
- Part IV: Building Sophisticated Database Queries
- Part V: SQL Performance Tuning
-
Part VI: Using SQL to Manage Users and Security
- Hour 18. Managing Database Users
- Hour 19. Managing Database Security
-
Part VII: Summarized Data Structures
- Hour 20. Creating and Using Views and Synonyms
- Hour 21. Working with the System Catalog
-
Part VIII: Applying SQL Fundamentals in Today’s World
- Hour 22. Advanced SQL Topics
- Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
- Hour 24. Extensions to Standard SQL
-
Part IX: Appendixes
- Appendix A. Common SQL Commands
- Appendix B. Installing Oracle and Microsoft SQL
-
Appendix C. Answers to Quizzes and Exercises
- Hour 1, “Welcome to the World of SQL”
- Hour 2, “Defining Data Structures”
- Hour 3, “Managing Database Objects”
- Hour 4, “The Normalization Process”
- Hour 5, “Manipulating Data”
- Hour 6, “Managing Database Transactions”
- Hour 7, “Introduction to the Database Queries”
- Hour 8, “Using Operators to Categorize Data”
- Hour 9, “Summarizing Data Results from a Query”
- Hour 10, “Sorting and Grouping Data”
- Hour 11, “Restructuring the Appearance of Data”
- Hour 12, “Understanding Dates and Times”
- Hour 13, “Joining Tables in Queries”
- Hour 14, “Using Subqueries to Define Unknown Data”
- Hour 15, “Combining Multiple Queries into One”
- Hour 16, “Using Indexes to Improve Performance”
- Hour 17, “Improving Database Performance”
- Hour 18, “Managing Database Users”
- Hour 19, “Managing Database Security”
- Hour 20, “Creating and Using Views and Synonyms”
- Hour 21, “Working with the System Catalog”
- Hour 22, “Advanced SQL Topics”
- Hour 23, “Extending SQL to the Enterprise, the Internet, and the Intranet”
- Hour 24, “Extensions to Standard SQL”
- Appendix D. Bonus Exercises
- Appendix E. Glossary
- Index
- Code Snippets
Product information
- Title: SQL in 24 Hours, Sams Teach Yourself, Sixth Edition
- Author(s):
- Release date: December 2015
- Publisher(s): Sams
- ISBN: 9780134305905
You might also like
book
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see …
book
Sams Teach Yourself SQL in 24 Hours, Fifth Edition
Master all the fundamentals of modern SQL -- hands-on, step-by-step! ¿ The up-to-the-minute SQL tutorial for …
book
SQL: A Beginner's Guide, Fourth Edition, 4th Edition
This fully revised, self-paced learning tool lays out all the necessary steps to quickly and easily …
book
Python in 24 Hours, Sams Teach Yourself, Second Edition
In just 24 sessions of one hour or less, Sams Teach Yourself Python in 24 Hours …