Home Page Icon
Home Page
Table of Contents for
Part VIII: Applying SQL Fundamentals in Today’s World
Close
Part VIII: Applying SQL Fundamentals in Today’s World
by Arie D. Jones, Ron D. Plew, Ryan Stephens
Sams Teach Yourself SQL in 24 Hours, Fifth Edition
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
Hour 1. Welcome to the World of SQL
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 the Database Query
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
Hour 13. Joining Tables in Queries
Hour 14. Using Subqueries to Define Unknown Data
Hour 15. Combining Multiple Queries into One
Part V: SQL Performance Tuning
Hour 16. Using Indexes to Improve Performance
Hour 17. Improving Database Performance
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
A. Common SQL Commands
B. Using the Databases for Exercises
C. Answers to Quizzes and Exercises
D. CREATE TABLE Statements for Book Examples
E. INSERT Statements for Data in Book Examples
Glossary
G. Bonus Exercises
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Hour 21. Working with the System Catalog
Next
Next Chapter
Hour 22. Advanced SQL Topics
Part VIII: Applying SQL Fundamentals in Today’s World
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset
