This book is a practical, no nonsense guide to using SQL Server 2005. SQL Server is a great database and is used by many businesses for their database applications. If you are an application developer or aspiring DBA you should read this book. This book will teach you the topics you need to know to write effective SQL including:

• Relational Database Theory and Normalization Techniques
• How to create databases and tables
• Using Indexes and Constraints
• How to use SQL to retrieve data, modify data, and join tables
• Using System Functions and user-defined functions
• Taking advantage of Stored Procedures, Views and Triggers

Benefits of Reading this Book

This book is over 300 pages of great SQL Server tips and tricks! You will be given many examples of how best to use SQL Server to build real-world business applications.

By the end of reading this book you will have learned several very useful techniques that will allow you to build a database in SQL Server, create tables, stored procedures and perform data retrieval and data modification statements.

Level: Beginning SQL to Intermediate SQL
# of Pages: 328