Cargando…
SQL Server 2014 Development Essentials /
In Detail SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high p...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2014.
|
| Colección: | Professional Expertise Distilled
|
| Temas: | |
| Acceso en línea: | Texto completo |
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.