Synopses & Reviews
In just one hour a day, master all the skills you need to crate effective queries, reports, and database applications with T-SQL and SQL Server! World-renowned Microsoft database expert Alison Balter guides you quickly through the basics, and then helps you master powerful T-SQL techniques for both application development and database administration.
Just getting started with T-SQL? Balter teaches from the ground up, covering all you need to know to work successfully with it inside Microsoft's SQL Server Management Studio. Her step-by-step, down-to-earth approach helps you easily progress from basic database design all the way to advanced optimization techniques, using carefully-designed hands-on examples. Drawing on 20+ years of experience teaching Microsoft database technologies, Balter simplifies topics other books leave confusing… even complex topics such as stored procedures, triggers, functions, transactions, and security.
Synopsis
Master T-SQL database design, development, and administration the easy way-hands-on
In just one hour a day, you'll build all the skills you need to create effective database applications with T-SQL and SQL Server. With this complete tutorial, you'll quickly master the basics and then move on to more advanced features and concepts:
- Learn the fundamentals of T-SQL from the ground up, one step at a time
- Succeed with the newest versions of T-SQL, SQL Server, and SQL Server Management Studio
- Use T-SQL effectively as both an application developer and DBA
- Master powerful stored procedures, triggers, transactions, and user-defined functions (UDFs)
- Systematically optimize and secure your SQL Server databases
Learn on your own time, at your own pace - No previous T-SQL or database programming experience required
- Learn how to design efficient, reliable SQL Server databases
- Define efficient tables, table relationships, fields, and constraints
- Make the most of T-SQL's SELECT and UPDATE statements
- Work effectively with simple and complex views and joins
- Master stored procedure techniques every developer should know
- Build and use powerful User-Defined Functions (UDFs)
- Secure databases with authentication, roles, permissions, and principals
- Configure, maintain, and tune SQL Server for maximum reliability, performance, and value
- Back up, restore, and audit databases
- Optimize databases with the SQL Server Profiler, System Monitor, and Index Tuning Wizard
- Leverage valuable insight and time saving techniques from a world renowned database expert
Register your book at informit.com/register for access to source code, example files, updates, and corrections as they become available.
Table of Contents
Part I: Introduction To SQL Server
1. Basic Relational Database Design
2. SQL Server Basics 25 Pages
3. Creating a SQL Server Database
Part II: Working With Tables, Views, and Stored Procedures
4. SQL Server Tables
5. Working with Database Diagrams
6. Getting to Know the SELECT Statement
7. Taking the SELECT Statement to the Next Level
8. Building SQL Statements Based on Multiple Tables
9. Powerful Join Techniques
10. Modifying Data with Action Queries
11. Getting to Know the T-SQL Functions
12. Working With SQL Server Views
13. Using T-SQL to Design SQL Server Stored Procedures
14. Stored Procedure Techniques Every Developer Should Know
15. Power Stored Procedure Techniques
16. Stored Procedure Special Topics
17. Building and Working with User-Defined Functions
18. Creating and Working with Triggers
Part III: Security and Administration
19. Authentication
20. Working with Principals
21. SQL Server Permissions Validation
22. Configuring, Maintaining and Tuning SQL Server
23. Maintaining the Databases that You Build
24. Performance Monitoring