MCSA SQL Server 2012 Exam Code 70-461 Course Outline

Microsoft Course 10774:

Exam 70-461:

This instructor-led course provides students with 2012 for Microsoft SQL Server, and the technical skills required to write basic Transact-SQL queries. This course is a SQL Server; that is the basis of all disciplines, database administration, database development, and business intelligence. The course description for the test 70-461. Many of the exercises in this course enabled SQL Azure. Led.

This course explains students preparing for the exam 70-461.

Audience Profile:

This course is designed for administrators of databases, database developers and professional business intelligence. Participation course Advanced SQL user, probably not establish data bases, or plan to take the test; authors of the report, is a developer of applications, client and business analyst.

At Course Completion:

Upon completion of this course, students will be able to:

• Write a select query
• Multiple-table query
• Using built-in functions
• Using subqueries
• Execute the stored procedure
• Use the operator system
• Implement error handling
• Transaction implementation
• Use table expressions
• Sorting and filtering data
• Use statistical ranking window function and offset
• The metadata query of SQL Server
• With t-SQL procedures
• To improve query performance

Prerequistes:

Before attending this course, students must have:

Working knowledge of relational databases.

Basic knowledge of the Microsoft Windows operating system and its core functionality.

Course Outline:

Introduction to Microsoft SQL server 2012:

This module introduces the SQL Server platform, and fixed assets. He discusses the release that is used to query, access to documents and the structure of the logical database tool.

• SQL Server Denali architecture
• Use SQL Server Denali
• Use a SQL Server database

After completing this module, students will have the opportunity to:

• Describes SQL Server components
• The t-SQL script in SQL Server Management Studio to create and maintain
• To view the objects in the database
• Search for t-SQL syntax is defined in the books online

Introduction to Transact SQL querying:

This module describes a query of Transaccion-sql as the primary language of SQL Server. Discussed the t-SQL query, click the basic structures of the logical flow of statements and introduced the concept as a predicate and a set-based operation.

• Enter the TRANSACT-SQL
• Understanding kits
• Understanding of logic
• Understand the logical sequence of operations in a select statement

After completing this module, students will have the opportunity to:

• Describes the elements of t-SQL and his role in writing a query
• Describes how to use the set of SQL Server
• Describes how to use the predicate logic in SQL Server
• In the SELECT statement defined in the logical order of actions

Sorting and Filtering Data:

This module explains how to improve your queries to limit the rows returned, and control lines in the order shown. The module also describes how to resolve an unknown and missing results.

• To sort the data
• Data drip
• Extraction of main options with an offset filter
• Unknown value

After completing this module, students will be able to:

• And the predicate in the where clause to filter data
• Using the order by data type
• With a lid in the select clause to filter data
• Filter with an offset and retrieve data
• Understand and work with Null values

Using built in functions:

This module provides an introduction to the built-in to SQL Server Denali and discuss some common applications include a conversion of data types, the logical result and empty test functions.

• Writing queries using built-in functions
• Use the convert function
• Use logical functions
• Nullability of the tests by using the function

After completing this module, students will be capable of:

• Write queries with functions scalar
• Use the convert function
• Use logical functions
• Use a function to handle null values