SQL Server 2014: Management Studio

Explore how to use the query editor in SQL Server Management Studio, manage multiple windows and tab groups, and leverage scripting, debugging, and IntelliSense to write and refine SQL code.

Explore templates and snippets in SQL Server Management Studio that provide ready-to-use code for common tasks and query editor work.

Explore executing code in the query editor, displaying results, and configuring them; examine execution plans and client statistics to refine your queries in SQL Server Management Studio.

Explore executing queries in management studio, including running partial statements and viewing results and messages. Use execution plans and client statistics to optimize performance and organize work with projects.

Learn how SQL Server Management Studio supports offline coding, offering flexibility to write code without accessing database objects, while you must connect to the server to test and run code.

Master relational database design fundamentals by defining keys, normal forms, and relationships, using surrogate or primary keys, foreign keys, and normalization forms from first to third normal form.

Understand how normalization informs database design to store data effectively for applications. Aim to keep all databases in the third normal form, unless a strong reason exists to go beyond.

Enforces referential integrity to protect data and ensure correct relationships between related tables, helping maintain clean, well-structured databases with reliable data integrity.

Explore how referential integrity enforces relationships across normalized tables using foreign keys, primary keys, and cascades in one-to-one, one-to-many, and many-to-many scenarios.

Implement database-resident business rules that SQL Server automatically enforces across all data manipulations, and choose a practical scheme that fits your databases and applications.

Explore how the logical relational model translates into SQL Server by examining how the server physically manages data and revealing the physical details of SQL Server 2012.

Explore how SQL Server stores data using pages, extents, and files, manages transaction logs and recovery models—simple, full, and bulk-logged—and creates databases with SQL Server Management Studio and T-SQL.

Explore how SQL Server 2005 decouples schema names from user names, allows any valid identifier, and enables assigning the same default schema to multiple users with schema-level permissions.

Explore SQL Server data types, including non unicode and unicode strings, fixed and variable length, text, numeric and date time types, binary and uniqueidentifier, plus XML and CLR types.

Explore the rich data types in SQL Server and how the database stores a variety of data while enforcing that only proper data enters each column to protect data integrity.

Create a computed column that automatically calculates values based on an expression referencing other columns. See how SQL Server derives dependent values when a column depends on other data.

Create a computed column by multiplying price per unit by units, with optional persistence and automatic recalculation, and review primary key, foreign key, not null, default, check, and unique constraints.

Learn how check constraints replace deprecated rules in SQL Server 2014, with multiple check constraints per column and check constraints defined in create table statement, while rules are created separately.

Learn how a trigger fires on insert, update, or delete statements, accesses data in the changing table and other tables, and can roll back the transaction.

Explore when to use triggers and indexes to enforce complex rules and accelerate queries, and learn to model foreign keys and relationships with database diagrams.

Design and specify your database at the outset to save time during implementation, using Management Studio to set data types, constraints, and triggers for integrity and adaptability to new requirements.