Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
What is included with this book?
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 on your own time, at your own pace
Register your book at informit.com/register for access to source code, example files, updates, and corrections as they become available.
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 Alison@techismything.com or visit InfoTech Services Group’s website at www.TechIsMyThing.com.
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
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