Microsoft SQL Database Administration
About this course:
SQL Server is a Microsoft product used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS). Broken apart, this term means two things. First, that data stored inside SQL Server will be housed in a “relational database”, and second, that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL.
Working knowledge of relational databases.
Some experience with database design.
  • Course Overview
  • Course Duration

Module 1: Introduction to Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012

Getting Started with SQL Server Management Studio

Module 2: Getting Started with SQL Azure

Overview of SQL Azure

Working with SQL Azure

Module 3: Introduction to T-SQL Querying

Introducing T-SQL

Understanding Sets

Understanding Predicate Logic

Understanding the Logical Order of Operations in SELECT statements

Module 4: Writing SELECT Queries

Writing Simple SELECT Statements

Eliminating Duplicates with DISTINCT

Using Column and Table Aliases

Writing Simple CASE Expressions

Module 5: Querying Multiple Tables

Understanding Joins

Querying with Inner Joins

Querying with Outer Joins

Querying with Cross Joins and Self Joins

Module 6: Sorting and Filtering Data

Sorting Data

Filtering Data with a WHERE Clause

Filtering with the TOP and OFFSET-FETCH Options

Working with Unknown and Missing Values

Module 7: Working with SQL Server 2012 Data Types

Introducing SQL Server 2012 Data Types

Working with Character Data

Working with Date and Time Data

Module 8: Using Built-In Functions

Writing Queries with Built-In Functions

Using Conversion Functions

Using Logical Functions

Using Functions to Work with NULL

Module 9: Grouping and Aggregating Data

Using Aggregate Functions

Using the GROUP BY Clause

Filtering Groups with HAVING

Module 10: Using Subqueries

Writing Self-Contained Subqueries

Writing Correlated Subqueries

Using the EXISTS Predicate with Subqueries

Module 11: Using Table Expressions

Using Derived Tables

Using Common Table Expressions

Using Views

Using Inline Table-Valued Functions

Module 12: Using Set Operators

Writing Queries with the UNION Operator



Module 13: Using Window Ranking, Offset and Aggregate Functions

Creating Windows with OVER

Exploring Window Functions

Module 14: Pivoting and Grouping Sets

Writing Queries with PIVOT and UNPIVOT

Working with Grouping Sets

Module 15: Querying SQL Server Metadata

Querying System Catalog Views and Functions

Executing System Stored Procedures

Querying Dynamic Management Objects

Module 16: Executing Stored Procedures

Querying Data with Stored Procedures

Passing Parameters to Stored Procedures

Creating Simple Stored Procedures

Working with Dynamic SQL

Module 17: Programming with T-SQL

T-SQL Programming Elements

Controlling Program Flow

Module 18: Implementing Error Handling

Using TRY / CATCH Blocks

Working with Error Information

Module 19: Implementing Transactions

Transactions and the Database Engine

20 Days
2 Hrs per day
enroll here
Please get in touch so we can answer any questions you may have.