Microsoft SQL Server 2012 : a beginner's guide

Microsoft SQL Server 2012 : a beginner's guide

Essential Microsoft SQL Server 2012 Skills Made Easy Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts...

Descripción completa

Detalles Bibliográficos
Otros Autores: Petkovic, Dušan Author (author), Petkoviâc, Duésan. Author
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] McGraw Hill 2012
Edición:5th edition
Materias:
SQL server.
Client/server computing
Relational databases
Engineering & Applied Sciences
Computer Science
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629406806719
Tabla de Contenidos:
  • Intro
  • A Beginner's Guide
  • About the Author
  • About the Technical Editor
  • Contents at a Glance
  • Contents
  • Acknowledgments
  • Introduction
  • Goals of the Book
  • SQL Server 2012 New Features Described in the Book
  • Organization of the Book
  • Changes from the Previous Edition
  • Differences Between SQL and Transact-SQL Syntax
  • Working with the Sample Databases
  • Part I: Basic Concepts and Installation
  • Chapter 1: Relational Database Systems: An Introduction
  • Database Systems: An Overview
  • Variety of User Interfaces
  • Physical Data Independence
  • Logical Data Independence
  • Query Optimization
  • Data Integrity
  • Concurrency Control
  • Backup and Recovery
  • Database Security
  • Relational Database Systems
  • Working with the Book's Sample Database
  • SQL: A Relational Database Language
  • Database Design
  • Normal Forms
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Entity-Relationship Model
  • Syntax Conventions
  • Summary
  • Exercises
  • Chapter 2: Planning the Installation and Installing SQL Server
  • SQL Server Editions
  • Planning Phase
  • General Recommendations
  • Which SQL Server Components Should Be Installed?
  • Where Will the Root Directory Be Stored?
  • Should Multiple Instances of the Database Engine Be Used?
  • Which Authentication Mode for the Database Engine Should Be Used?
  • Planning the Installation
  • Hardware and Software Requirements
  • Security Documentation
  • Online Release Notes
  • Setup Documentation
  • System Configuration Checker
  • Installing SQL Server
  • Summary
  • Chapter 3: SQL Server Management Studio
  • Introduction to SQL Server Management Studio
  • Connecting to a Server
  • Registered Servers
  • Object Explorer
  • Organizing and Navigating SQL Server Management Studio's Panes
  • Using SQL Server Management Studio with the Database Engine.
  • Administering Database Servers
  • Registering Servers
  • Connecting to a Server
  • Creating a New Server Group
  • Managing Multiple Servers
  • Starting and Stopping Servers
  • Managing Databases Using Object Explorer
  • Creating Databases Without Using Transact-SQL
  • Modifying Databases Without Using Transact-SQL
  • Managing Tables Without Using Transact-SQL
  • Authoring Activities Using SQL Server Management Studio
  • Query Editor
  • Solution Explorer
  • SQL Server Debugging
  • Summary
  • Exercises
  • Part II: Transact-SQL Language
  • Chapter 4: SQL Components
  • SQL's Basic Objects
  • Literal Values
  • Delimiters
  • Comments
  • Identifiers
  • Reserved Keywords
  • Data Types
  • Numeric Data Types
  • Character Data Types
  • Temporal Data Types
  • Miscellaneous Data Types
  • Binary and BIT Data Types
  • Large Object Data Types
  • UNIQUEIDENTIFIER Data Type
  • SQL_VARIANT Data Type
  • HIERARCHYID Data Type
  • TIMESTAMP Data Type
  • Storage Options
  • FILESTREAM Storage
  • Sparse Columns
  • Transact-SQL Functions
  • Aggregate Functions
  • Scalar Functions
  • Numeric Functions
  • Date Functions
  • System Functions
  • Metadata Functions
  • Scalar Operators
  • Global Variables
  • NULL Values
  • Summary
  • Exercises
  • Chapter 5: Data Definition Language
  • Creating Database Objects
  • Creation of a Database
  • Attaching and Detaching Databases
  • CREATE TABLE: A Basic Form
  • CREATE TABLE and Declarative Integrity Constraints
  • The UNIQUE Clause
  • The PRIMARY KEY Clause
  • The CHECK Clause
  • The FOREIGN KEY Clause
  • Referential Integrity
  • Possible Problems with Referential Integrity
  • The ON DELETE and ON UPDATE Options
  • Creating Other Database Objects
  • Integrity Constraints and Domains
  • Alias Data Types
  • CLR Data Types
  • Modifying Database Objects
  • Altering a Database
  • Modifying File or Filegroup Properties
  • Setting Database Options.
  • Storing FILESTREAM Data
  • Contained Databases
  • Altering a Table
  • Adding or Dropping a New Column
  • Modifying Column Properties
  • Adding or Removing Integrity Constraints
  • Enabling or Disabling Constraints
  • Renaming Tables and Other Database Objects
  • Removing Database Objects
  • Summary
  • Exercises
  • Chapter 6: Queries
  • SELECT Statement: Its Clauses and Functions
  • WHERE Clause
  • Boolean Operators
  • IN and BETWEEN Operators
  • Queries Involving NULL Values
  • GROUP BY Clause
  • Aggregate Functions
  • Convenient Aggregate Functions
  • Statistical Aggregate Functions
  • User-Defined Aggregate Functions
  • HAVING Clause
  • ORDER BY Clause
  • Using ORDER BY to Support Paging
  • SELECT Statement and IDENTITY Property
  • CREATE SEQUENCE Statement
  • Set Operators
  • UNION Set Operator
  • INTERSECT and EXCEPT Set Operators
  • CASE Expressions
  • Subqueries
  • Subqueries and Comparison Operators
  • Subqueries and the IN Operator
  • Subqueries and ANY and ALL Operators
  • Temporary Tables
  • Join Operator
  • Two Syntax Forms to Implement Joins
  • Natural Join
  • Joining More Than Two Tables
  • Cartesian Product
  • Outer Join
  • Further Forms of Join Operations
  • Theta Join
  • Self-Join, or Joining a Table with Itself
  • Semi-Join
  • Correlated Subqueries
  • Subqueries and the EXISTS Function
  • Should You Use Joins or Subqueries?
  • Subquery Advantages
  • Join Advantages
  • Table Expressions
  • Derived Tables
  • Common Table Expressions
  • CTEs and Nonrecursive Queries
  • CTEs and Recursive Queries
  • Summary
  • Exercises
  • Chapter 7: Modification of a Table's Contents
  • INSERT Statement
  • Inserting a Single Row
  • Inserting Multiple Rows
  • Table Value Constructors and INSERT
  • UPDATE Statement
  • DELETE Statement
  • Other T-SQL Modification Statements and Clauses
  • TRUNCATE TABLE Statement
  • MERGE Statement
  • The OUTPUT Clause.
  • Summary
  • Exercises
  • Chapter 8: Stored Procedures and User-Defined Functions
  • Procedural Extensions
  • Block of Statements
  • IF Statement
  • WHILE Statement
  • Local Variables
  • Miscellaneous Procedural Statements
  • Exception Handling with TRY, CATCH, and THROW
  • Stored Procedures
  • Creation and Execution of Stored Procedures
  • The EXECUTE Statement with RESULT SETS Clause
  • Changing the Structure of Stored Procedures
  • Stored Procedures and CLR
  • User-Defined Functions
  • Creation and Execution of User-Defined Functions
  • Invoking User-Defined Functions
  • Table-Valued Functions
  • Table-Valued Parameters
  • Changing the Structure of UDFs
  • User-Defined Functions and CLR
  • Summary
  • Exercises
  • Chapter 9: System Catalog
  • Introduction to the System Catalog
  • General Interfaces
  • Catalog Views
  • Querying Catalog Views
  • Dynamic Management Views and Functions
  • Information Schema
  • Information_schema.tables
  • Information_schema.columns
  • Proprietary Interfaces
  • System Stored Procedures
  • System Functions
  • Property Functions
  • Summary
  • Exercises
  • Chapter 10: Indices
  • Introduction
  • Clustered Indices
  • Nonclustered Indices
  • Transact-SQL and Indices
  • Creating Indices
  • Obtaining Index Fragmentation Information
  • Editing Index Information
  • Altering Indices
  • Rebuilding an Index
  • Reorganizing Leaf Index Pages
  • Disabling an Index
  • Removing and Renaming Indices
  • Guidelines for Creating and Using Indices
  • Indices and Conditions in the WHERE Clause
  • Indices and the Join Operator
  • Covering Index
  • Special Types of Indices
  • Virtual Computed Columns
  • Persistent Computed Columns
  • Summary
  • Exercises
  • Chapter 11: Views
  • DDL Statements and Views
  • Creating a View
  • Altering and Removing Views
  • Editing Information Concerning Views
  • DML Statements and Views
  • View Retrieval.
  • INSERT Statement and a View
  • UPDATE Statement and a View
  • DELETE Statement and a View
  • Indexed Views
  • Creating an Indexed View
  • Modifying the Structure of an Indexed View
  • Editing Information Concerning Indexed Views
  • Benefits of Indexed Views
  • Summary
  • Exercises
  • Chapter 12: Security System of the Database Engine
  • Authentication
  • Implementing an Authentication Mode
  • Encrypting Data
  • Symmetric Keys
  • Asymmetric Keys
  • Editing User Keys
  • SQL Server Extensible Key Management
  • Methods of Data Encryption
  • Setting Up the Database Engine Security
  • Managing Security Using Management Studio
  • Managing Security Using Transact-SQL Statements
  • Schemas
  • User-Schema Separation
  • DDL Schema-Related Statements
  • Create Schema
  • Alter Schema
  • Drop Schema
  • Database Security
  • Managing Database Security Using Management Studio
  • Managing Database Security Using Transact-SQL Statements
  • Default Database Schemas
  • Roles
  • Fixed Server Roles
  • Managing Fixed Server Roles
  • Fixed Database Roles
  • public Role
  • Assigning a User to a Fixed Database Role
  • Application Roles
  • Managing Application Roles Using Management Studio
  • Managing Application Roles Using T-SQL
  • Activating Application Roles
  • User-Defined Server Roles
  • User-Defined Database Roles
  • Managing User-Defined Database Roles Using Management Studio
  • Managing User-Defined Database Roles Using T-SQL
  • Authorization
  • GRANT Statement
  • DENY Statement
  • REVOKE Statement
  • Managing Permissions Using Management Studio
  • Managing Authorization and Authentication of Contained Databases
  • Change Tracking
  • Data Security and Views
  • Summary
  • Exercises
  • Chapter 13: Concurrency Control
  • Concurrency Models
  • Transactions
  • Properties of Transactions
  • Transact-SQL Statements and Transactions
  • Transaction Log
  • Locking
  • Lock Modes.
  • Lock Granularity.

Ejemplares similares