Home Page Icon
Home Page
Table of Contents for
Title
Close
Title
by Robin Dewson
Beginning SQL Server 2012 for Developers
Title
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
CHAPTER 1: Overview and Installation
Why SQL Server 2012?
Evolution of SQL Server
Hardware Requirements
The Example
Installation
Security
Summary
CHAPTER 2: SQL Server Management Studio
A Quick Overview of SSMS
Query Editor
Summary
CHAPTER 3: Database Design and Creation
Defining a Database
Prebuilt Databases Within SQL Server
Choosing the Database System Type
Gathering the Data
Determining the Information to Store in the Database
External and Ignored Information
Building Relationships
Normalization
Creating the Sample Database
Summary
CHAPTER 4: Security and Compliance
Logins
Server Logins and Database Users
Roles
Schemas
Before You Can Proceed with Your Solution
Declarative Management Framework
Summary
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
What Is an Index?
Determining What Makes a Good Index
Determining What Makes a Bad Index
Reviewing Your Indexes for Performance
Creating an Index
Dropping an Index
Altering an Index
When an Index Does Not Exist
Diagramming the Database
Summary
CHAPTER 7: Database Backups and Recovery
Backup Strategies
Transaction Logs
When Problems May Occur
Backups: Taking a Database Offline
Backing Up the Data
Restoring a Database
Detaching and Attaching a Database
Producing SQL Script for the Database
Summary
CHAPTER 8: Database Maintenance
Creating a Database Maintenance Plan
Executing the Plan
Setting Up Database Mail
Modifying a Maintenance Plan
Summary
CHAPTER 9: Data Insertion, Deletion, and Transactions
Inserting Data
Transactions
Deleting Data
Summary
CHAPTER 10: Selecting and Updating Data
Retrieving Data
Limiting a Search: The Use of WHERE
String Functions
Order! Order!
The LIKE Operator
Creating Data: SELECT INTO
Updating Data
Using More Than One Table
Summary
CHAPTER 11: Building a View
Why a View?
Creating a View: SQL Server Management Studio
Creating a View Using a View
Creating a View Using T-SQL Syntax
Indexing a View
Summary
CHAPTER 12: Stored Procedures, Functions, and Security
What Is a Stored Procedure?
Creating a Stored Procedure
Returning Results
Controlling the Flow
Bringing It All Together
Security
User-Defined Functions
Summary
CHAPTER 13: Essentials for Effective Coding
Variables
Temporary Tables
Aggregations
Grouping Data
HAVING
Distinct Values
Functions
RAISERROR
Error Handling
Summary
CHAPTER 14: Advanced T-SQL and Debugging
Sequences Instead of IDENTITY
Creating a SEQUENCE
Subqueries
The APPLY Operator
Common Table Expressions
Pivoting Data
Ranking Functions
Cursors
Debugging Your Code
Summary
CHAPTER 15: Triggers
What Is a Trigger?
The DML Trigger
DDL Triggers
Summary
CHAPTER 16: Connecting via Code
General Application Security
Connecting with Excel or Excel Visual Basic for Applications (VBA)
Visual Studio
Java
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset