- About This eBook
- Title Page
- Copyright Page
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- Lesson 1. Database Basics
- Lesson 2. SQL Server Basics
- Lesson 3. Creating a SQL Server Database
- Lesson 4. Working with SQL Server Tables
- Lesson 5. Working with Table Relationships
- An Introduction to Relationships
- Creating and Working with Database Diagrams
- Working with Table Relationships
- Designating Table and Column Specifications
- Adding a Relationship Name and Description
- Determining When Foreign Key Relationships Constrain the Data Entered in a Column
- Designating Insert and Update Specifications
- Summary
- Q&A
- Workshop
- Activities
- Lesson 6. Getting to Know the SELECT Statement
- Lesson 7. Taking the SELECT Statement to the Next Level
- Lesson 8. Building SQL Statements Based on Multiple Tables
- Lesson 9. Powerful Join Techniques
- Lesson 10. Modifying Data with Action Queries
- Lesson 11. Getting to Know the T-SQL Functions
- Working with Numeric Functions
- Taking Advantage of String Functions
- Using the LEFT Function
- Working with the RIGHT Function
- Exploring the LEN Function
- Using the REPLACE Function
- Using the REVERSE Function
- Using the REPLICATE Function
- Taking Advantage of the STUFF Function
- Using the SPACE Function
- Using the SUBSTRING Function
- Using the LOWER Function
- Using the UPPER Function
- Working with the LTRIM Function
- Working with the RTRIM Function
- Exploring the Date/Time Functions
- Working with Nulls
- Summary
- Q&A
- Workshop
- Activities
- Lesson 12. Working with SQL Server Views
- Lesson 13. Using T-SQL to Design SQL Server Stored Procedures
- Lesson 14. Stored Procedure Techniques Every Developer Should Know
- Lesson 15. Power Stored Procedure Techniques
- Lesson 16. Stored Procedure Special Topics
- Lesson 17. Building and Working with User-Defined Functions
- Lesson 18. Creating and Working with Triggers
- Lesson 19. Authentication
- Lesson 20. SQL Server Permissions Validation
- Lesson 21. Configuring, Maintaining, and Tuning SQL Server
- Lesson 22. Maintaining the Databases You Build
- Lesson 23. Performance Monitoring
- Lesson 24. Installing and Upgrading SQL Server
- Index
- Code Snippets
Dedication
Many people are important in my life, but there is no one as special as my husband Dan. I dedicate this book to Dan. Thank you for your ongoing support, for your dedication to me, for your unconditional love, and for your patience. Without you, I’m not sure how I would make it through life. Thank you for sticking with me through the good times and the bad! There’s nobody I’d rather spend forever with than you.
I also want to thank God for giving me the gift of gab, a wonderful career, an incredible husband, two beautiful children, a spectacular area to live in, a very special home, and an awesome life. Through your grace, I am truly blessed.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.