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
Beginning SQL Server 2012 Administration
Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful …
book
Beginning T-SQL 2012
Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL …
book
Pro SQL Server 2012 Administration
Pro SQL Server 2012 Administration is a one-stop source for all the knowledge you'll need to …
book
Beginning Microsoft® SQL Server® 2012 Programming
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server …