SQL server 2014 development essentials design, implement, and deliver a successful database solution with Microsoft SQL Server 2014
This book is an easy-to-follow, comprehensive guide that is full of hands-on examples, which you can follow to successfully design, build, and deploy mission-critical database applications with SQL Server 2014. If you are a database developer, architect, or administrator who wants to learn how to de...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England :
[Packt] Publishing
2014.
|
| Edición: | 1st edition |
| Colección: | Professional Expertise Distilled
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629411606719 |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; Acknowledgments; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Microsoft SQL Server Database Design Principles; Database design; The requirement collection and analysis phase; The conceptual design phase; The logical design phase; The physical design phase; The implementation and loading phase; The testing and evaluation phase; The database design life cycle recap; Table design; Tables; Entities; Attributes; Relationships; A one-to-one relationship; A one-to-many relationship; A many-to-many relationship
- Data integrityThe basics of data normalization; The normal forms; The first normal form (1NF); The second normal form (2NF); The third normal form (3NF); Denormalization; The SQL Server database architecture; Pages; Extents; The transaction log file architecture; The operation and workings of a transaction log; Filegroups; The importance of choosing the appropriate data type; SQL Server 2014 system data types; Alias data types; Creating and dropping alias data types with SSMS 2014; Creating and dropping alias data types using the Transact-SQL DDL statement; CLR user-defined types; Summary
- Chapter 2: Understanding DDL and DCL Statements in SQL ServerUnderstanding the DDL, DCL, and DML language elements; Data Definition Language (DDL) statements; Data Manipulation Language (DML) statements; Data Control Language (DCL) statements; Understanding the purpose of SQL Server 2014 system databases; SQL Server 2014 system databases; The master database; The model database; The msdb database; The tempdb database; The resource database; The distribution database; An overview of database recovery models; The simple recovery model; The bulk-logged recovery model; Full recovery
- Creating and modifying databasesCreate, modify, and drop databases with T-SQL DDL statements; Creating a database with T-SQL DDL statements; Example 1 - creating a database based on a model database; Example 2 - creating a database that explicitly specifies the database data and the transaction log file's filespecs properties; Example 3 - creating a database on multiple filegroups; Modifying a database with T-SQL DDL statements; Example - adding a secondary data file to an existing database; Dropping a database with T-SQL DDL statements; Create, modify, and drop databases with SSMS 2014
- Creating a database with SSMS 2014Modifying a database with SSMS 2014; Dropping a database with SSMS 2014; Creating and managing database schemas; Managing schemas using T-SQL DDL statements; Managing schemas using SSMS 2014; Creating and managing tables; Creating and modifying tables; Creating and modifying tables with T-SQL DDL statements; Creating a table with T-SQL DDL statements; Modifying a table with T-SQL DDL statements; Dropping a table with T-SQL DDL statements; Creating and modifying tables with SSMS 2014; Creating a table with SSMS 2014; Modifying a table with SSMS 2014
- Deleting a table with SSMS 2014
