Querying Microsoft SQL Server

Introduction to Microsoft SQL Server 2014

• editions

• versions

• tools used to query

• documentation sources

• the logical structure of databases

Introduction to T-SQL Querying

• basic structure of T-SQL queries

• logical flow of a SELECT statement

• concepts introduction: predicates and set-based operations

Writing SELECT Queries

• fundamentals of the SELECT statement

• queries against a single table

Querying Multiple Tables

• use of JOINs in T-SQL queries as a mechanism for retrieving data from multiple tables

Sorting and Filtering Data

• enhance queries to limit the rows they return

• control the order in which the rows are displayed

• how to resolve missing and unknown results

Working with SQL Server 2014 Data Types

• data types SQL Server

• types of numeric and special-use data types

• conversions between data types

• importance of type precedence

Using DML to Modify Data

• perform inserts

• updates

• deletes

Using Built-In Functions

• data type conversion

• testing for logical results

• nullability

Grouping and Aggregating Data

• grouping data

• aggregating the grouped data

• filtering groups with HAVING

Using Subqueries

• use of subqueries in various parts of a SELECT statement

• use of scalar

• multi-result subqueries

• use of the IN and EXISTS operators

Using Table Expression

• views

• derived tables

• common table expressions

• inline table-valued functions

Querying data with Stored Procedure

• use of EXECUTE

• how to pass input and output parameters to a procedure

• how to invoke system stored procedures

Implementing Transactions

• concepts of transaction management in SQL- Server

• transaction properties marking transactions with BEGIN, COMMIT and ROLLBACK

Introduction to SQL Server 2014 Database Administration

• Database Administration Overview

• Introduction to the SQL Server Platform

• Database Management Tools and Techniques

Installing and Configuring SQL Server 2014

• Planning SQL Server Installation

• Installing SQL Server 2014

• Post-Installation Configuration

Working with Databases and Storage

• Introduction to Data Storage with SQL Server

• Managing Storage for System Databases

• Managing Storage for User Databases

• Moving Database Files

• Configuring the Buffer Pool Extension

Planning and Implementing a Backup Strategy

• Understanding SQL Server Recovery Models

• Planning a Backup Strategy

• Backing up Databases and Transaction Logs

• Using Backup Options

• Ensuring Backup Reliability

Restoring SQL Server 2014 Databases

• Understanding the Restore Process

• Restoring Databases

• Advanced Restore Scenarios

• Working with Point-in-Time Recovery

Importing and Exporting Data

• Introduction to Transferring Data

• Importing and Exporting Table Data

• Copying or Moving a Database

Managing SQL Server Security

• Introduction to SQL Server Security

• Managing Server-Level Security

• Managing Database-Level Principals

• Managing Database Permissions