T-SQL in One Hour a Day, Sams Teach Yourself

by Balter, Alison

• ISBN13: 9780672337437
• ISBN10: 0672337436
• Edition: 1st
• Format: Paperback
• Copyright: 2015-10-20
• Publisher: Sams Publishing

Summary

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.

 

 

Author Biography

Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Venice Beach, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 30 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly InfoTechnology Partners) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, AIG Insurance, Northrop, the Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the United States Navy, the United States Marines, the University of Southern California (USC), Massachusetts Institute of Technology (MIT), and others.

 

Alison is the author of more than 300 internationally marketed computer training videos, including 18 Access 2000 videos, 35 Access 2002 videos, 15 Access 2003 videos, a complete series of both user and developer videos on Access 2007, and Access 2010 and Access 2013 user videos. Alison travels throughout North America giving training seminars in Microsoft Access and Microsoft SQL Server.

 

Alison is also author of 14 books published by Sams Publishing including: Alison Balter’s Mastering Access 95 Development, Alison Balter’s Mastering Access 97 Development, Alison Balter’s Mastering Access 2000 Development, Alison Balter’s Mastering Access 2002 Desktop Development, Alison Balter’s Mastering Access 2002 Enterprise Development, Alison Balter’s Mastering Microsoft Access Office 2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003 in a Snap, Alison Balter’s Mastering Access 2007 Development, a power user book on Microsoft Access 2007, Using Access 2010, Access 2013 Absolute Beginner’s Guide, and Teach Yourself SQL Express 2005 in 24 Hours.

 

An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users’ Group. She is also past president of the Ventura County Professional Women’s Network. Alison is a Microsoft Access MVP and was selected as Ventura County Woman Business Owner of the Year for 2012/2013.

 

On a personal note, Alison keeps herself busy skiing, taking yoga classes, running, walking, lifting weights, hiking, and traveling. She most enjoys spending time with her husband, Dan, their daughter Alexis, and their son Brendan.

 

Contact Alison via [e-mail] or visit InfoTech Services Group’s website at www.TechIsMyThing.com.

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