Book description
Beginning SQL Server 2012 for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft's market-leading database system for the Windows platform. Now in its third edition, the book is enhanced to cover the very latest developments in SQL Server 2012.
Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012.
Within the book, there are plenty of examples of tasks that developers routinely perform. You'll learn to create tables and indexes, and best practices for securing your valuable data. You'll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code.
Beginning SQL Server 2012 for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you'll be able to design and create solid and reliable database solutions using SQL Server 2012.
Takes you through the entire database application development lifecycle
Includes brand new coverage of SQL Server 2012 features
Introduces the freely-available Express Edition
Table of contents
- Title
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- CHAPTER 1: Overview and Installation
- CHAPTER 2: SQL Server Management Studio
- CHAPTER 3: Database Design and Creation
- CHAPTER 4: Security and Compliance
-
CHAPTER 5: Defining Tables
- What Is a Table?
- SQL Server Data Types
- Columns As More Than Simple Data Repositories
- Creating a Table in SQL Server Management Studio
- Creating a Table Through Query Editor
- Creating a Table: Using a Template
- Creating and Altering a Template
- The ALTER TABLE Statement
- Defining the Remaining Tables
- Setting a Primary Key
- Creating a Relationship
- Building a Relationship via T-SQL
- Relationships: Database or Application
- Summary
- CHAPTER 6: Creating Indexes and Database Diagramming
- CHAPTER 7: Database Backups and Recovery
- CHAPTER 8: Database Maintenance
- CHAPTER 9: Data Insertion, Deletion, and Transactions
- CHAPTER 10: Selecting and Updating Data
- CHAPTER 11: Building a View
- CHAPTER 12: Stored Procedures, Functions, and Security
- CHAPTER 13: Essentials for Effective Coding
- CHAPTER 14: Advanced T-SQL and Debugging
- CHAPTER 15: Triggers
- CHAPTER 16: Connecting via Code
- Index
Product information
- Title: Beginning SQL Server 2012 for Developers
- Author(s):
- Release date: April 2012
- Publisher(s): Apress
- ISBN: 9781430237501
You might also like
book
SQL Server 2017 Administration Inside Out, First Edition
Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put …
book
Learning SQL, 3rd Edition
As data floods into your company, you need to put it to work right away—and SQL …
book
Beginning, Microsoft® SQL Server® 2008 Administration
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will …
book
Microsoft Visual C# Step by Step, Ninth Edition
Your hands-on guide to Microsoft Visual C# fundamentals with Visual Studio 2017 Expand your expertise--and teach …