MICROSOFT SQL SERVER 2012

  • Home
  • Course
  • MICROSOFT SQL SERVER 2012

SQL

OVERVIEW

Managing required information by storing and retrieving data is part of Database Administrators day-to-day activities. One of the most effective ways to manage required information is by using databases. You may need to manipulate and modify your table data based on changing business requirements. The course, Microsoft SQL Server 2012: Database Querying will help you use SQL Server 2012 as a tool to manage organizational data.

 

In this course, you will create queries to retrieve, add, update, and maintain your database data. You will also work with data sorting, built-in functions, stored procedures, sub queries, table operators, set operators, conditional operators, views, indexes, and error handling features of SQL Server 2012. This course is designed for Database Administrators, Database Developers and Business Intelligence professionals. This course will be attended by report writers, business analysts, and client application developers who wish to upgrade their skills and knowledge in SQL Server 2012.

PREREQUISITES

To ensure your success in this course you should have some working knowledge of relational databases. You should also be comfortable working with the Microsoft Windows 7 Operating System, and be able to use the core functionalities of Windows 7.

WHO SHOULD TAKE THIS COURSE

This course is suitable for application designers and developers, database administrators and operators, and end users

Course Contents

  • Overview of SQL Server 2012
  • Work with SSMS
  • Overview of T-SQL
  • Work with T-SQL Statements
  • Manage SQL Server Constraints
  • Write SELECT Statements
  • Assign Aliases Using Queries
  • Write CASE Expressions
  • Work with String and Numeric Data Types
  • Work with Date and Time Data Types
  • Work with Binary Data Types
  • Work with the XML Data Type
  • Sort the Queried Data
  • Filter the Queried Results
  • Work with Predicates
  • Perform Advanced Filtering
  • Combine Data Using Simple Joins
  • Create Queries Using Join Algorithms
  • Insert Data
  • Update Data
  • Delete Data
  • Merge Data
  • Create Queries Using Built-in Functions
  • Create Queries to Test Nullability
  • Group and Aggregate Data
  • Work with Variables and Batches
  • Control Program Flow
  • Manage Triggers
  • Work with Data Access Technologies
  • Manage Stored Procedures
  • Work with Dynamic SQL
  • Work with Subqueries
  • Work with Table Expressions
  • Work with Set Operators
  • Work with Window Functions
  • Configure User-Defined Functions (UDF)
  • Work with Advanced Functions
  • Work with PIVOT and UNPIVOT
  • Work with Grouping Sets
  • Implement Error Handling
  • Manage Transactions
  • Work with System Databases
  • Work with SSPs and SMOs
  • Work with System Catalog Views
  • Manage Query Plans
  • Configure Indexes
  • Manage Views
  • Analyze Data from Query Plans