Microsoft SQL Server 10774 Training

Introduction of Microsoft SQL Server 10774 Training

Microsoft SQL Server 10774 is offered at SINA institute of networks and Aesthetics. SQL Server Querying is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. This exam is intended for SQL Server database administrators, system engineers and developers who are seeking to validate their skills and knowledge in writing queries. SINA is offering Microsoft SQL Server 10774 Training which starts with Microsoft SQL Server 2012 to the updated version.

Curriculum

20 Sections
118 Lessons
10 Weeks

Expand all sectionsCollapse all sections

Module 01: Introduction to Microsoft SQL Server 2012
4
- 2.1
  Introducing Microsoft SQL Server 2012
- 2.2
  Getting Started with SQL Server Management Studio
- 2.3
  Introducing Microsoft SQL Server 2012
- 2.4
  Getting Started with SQL Server Management Studio
Module 02: Getting Started with SQL Azure; Microsoft SQL Server 10774
2
- 3.1
  Overview of SQL Azure
- 3.2
  Working with SQL Azure
Module 03: Introduction to T-SQL Querying
7
- 4.1
  Introducing T-SQL
- 4.2
  Understanding Sets
- 4.3
  To Understanding Predicate Logic
- 4.4
  Understanding the Logical Order of Operations in SELECT statements
- 4.5
  Write simple SELECT Statements
- 4.6
  Executing queries which filter data using predicates
- 4.7
  Executing queries which sort data using ORDER BY
Module 04: Writing SELECT Queries
9
- 5.1
  Writing Simple SELECT Statements
- 5.2
  Eliminating Duplicates with DISTINCT
- 5.3
  Using Column and Table Aliases
- 5.4
  Writing Simple CASE Expressions
- 5.5
  Write simple SELECT Statements
- 5.6
  Writing Queries That Use Multiple-Table Inner Join
- 5.7
  Eliminate Duplicates Using Distinct
- 5.8
  Use Table and Column Aliases
- 5.9
  Use a Simple CASE Expression
Module 05: Querying Multiple Tables; Microsoft SQL Server 10774
9
- 6.1
  Understanding Joins
- 6.2
  Understanding Joins
- 6.3
  Querying with Inner Joins
- 6.4
  Querying with Cross Joins and Self Joins
- 6.5
  Writing Queries That Use Inner Joins
- 6.6
  Writing Queries That Use Multiple-Table Inner Join
- 6.7
  Writing Queries That Use Self Joins
- 6.8
  Writing Queries That Use Outer Loins
- 6.9
  Writing Queries That Use Cross Join
Module 06: Sorting and Filtering Data
8
- 7.1
  Sorting Data
- 7.2
  Filtering Data with a WHERE Clause
- 7.3
  Filtering with the TOP and OFFSET-FETCH Options
- 7.4
  Working with Unknown and Missing Values
- 7.5
  Writing Queries That Filter Data Using a WHERE Clause
- 7.6
  Writing Queries That Filter Data Using an ORDER BY Clause
- 7.7
  Writing Queries That Filter Data Using the TOP Option
- 7.8
  Writing Queries That Filter Data Using the OFFSET-FETCH Clause
Module 07: Working with SQL Server 2012 Data Types
7
- 8.1
  Introducing SQL Server 2012 Data Types
- 8.2
  Working with Character Data
- 8.3
  Working with Date and Time Data
- 8.4
  Writing Queries That Return Date and Time Data
- 8.5
  Writing Queries That Use Date and Time Functions
- 8.6
  The Writing Queries That Return Character Data
- 8.7
  Writing Queries That Use Character Functions
Module 08: Using Built-In Functions
7
- 9.1
  Using Logical Functions
- 9.2
  Writing Queries with Built-In Functions
- 9.3
  Using Conversion Functions
- 9.4
  Using Functions to Work with NULL
- 9.5
  Write queries which use conversion functions
- 9.6
  To Write queries which use logical functions
- 9.7
  Write queries which test for null ability
Module 09: Grouping and Aggregating Data
7
- 10.1
  Using Aggregate Functions
- 10.2
  Using the GROUP BY Clause
- 10.3
  Filtering Groups with HAVING
- 10.4
  Write queries which use the GROUP BY clause
- 10.5
  To Write queries which use aggregate functions
- 10.6
  Write queries which use distinct aggregate functions
- 10.7
  Write queries which filter groups with the HAVING clause
Module 10: Using Sub queries
6
- 11.1
  Writing Self-Contained Sub queries
- 11.2
  Writing Correlated Sub queries
- 11.3
  Using the EXISTS Predicate with Sub queries
- 11.4
  Write queries which use self-contained sub queries
- 11.5
  To Write queries which use scalar and multi-result sub queries
- 11.6
  Write queries which use correlated sub queries and EXISTS predicate
Module 11: Using Table Expressions
8
- 12.1
  Using Derived Tables
- 12.2
  To Using Common Table Expressions
- 12.3
  Using Views
- 12.4
  Using Inline Table-Valued Functions
- 12.5
  Write Queries Which Use Views
- 12.6
  Write Queries Which Use Derived Tables
- 12.7
  To Write Queries Which Use Common Table Expressions
- 12.8
  Write Queries Which Use Inline Table-Valued Functions
Module 12: Using Set Operators
6
- 13.1
  Writing Queries with the UNION Operator
- 13.2
  Using EXCEPT and INTERSECT
- 13.3
  Using APPLY
- 13.4
  Write queries which use UNION set operators and UNION ALL multi-set operators
- 13.5
  The Write queries which use CROSS APPLY and OUTER APPLY operators
- 13.6
  Write queries which use EXCEPT and INTERSECT operators
Module 13: Using Window Ranking, Offset and Aggregate Functions
5
- 14.1
  Creating Windows with OVER
- 14.2
  Exploring Window Functions
- 14.3
  Write queries which use ranking functions
- 14.4
  To Write queries which use offset functions
- 14.5
  Write queries which use window aggregate functions
Module 14: Pivoting and Grouping Sets
5
- 15.1
  Writing Queries with PIVOT and UNPIVOT
- 15.2
  Working with Grouping Sets
- 15.3
  Write queries which use the PIVOT operator
- 15.4
  To Write queries which use the UNPIVOT operator
- 15.5
  Write queries which use the GROUPING SETS sub clause
Module 15: Querying SQL Server Metadata
6
- 16.1
  Executing System Stored Procedures
- 16.2
  Querying System Catalog Views and Functions
- 16.3
  Querying Dynamic Management Objects
- 16.4
  Querying System Catalog Views
- 16.5
  The Querying System Functions
- 16.6
  Querying System Dynamic Management Views
Module 16: Executing Stored Procedures
7
- 17.1
  Querying Data with Stored Procedures
- 17.2
  Passing Parameters to Stored Procedures
- 17.3
  Creating Simple Stored Procedures
- 17.4
  Working with Dynamic SQL
- 17.5
  Use the EXECUTE statement to invoke stored procedures
- 17.6
  Pass parameters to stored procedures
- 17.6
  Execute system stored procedures
Module 17: Programming with T-SQL
4
- 18.1
  Using Control-of-Flow Elements
- 18.2
  Using Synonyms
- 18.3
  Generating Dynamic SQL
- 18.4
  Controlling Program Flow
Module 18: Implementing Error Handling
3
- 19.1
  Working with Error Information
- 19.2
  Using TRY / CATCH Blocks
- 19.3
  Working with Error Information
Module 19: Implementing Transactions
4
- 20.1
  Transactions and the Database Engine
- 20.2
  Controlling Transactions
- 20.3
  Controlling transactions with BEGIN, COMMIT, and ROLLBACK
- 20.4
  Adding error handling to a CATCH block
Module 20: Improving Query Performance
4
- 21.1
  Factors in Query Performance
- 21.2
  Displaying Query Performance Data
- 21.3
  Viewing Query Execution Plans
- 21.4
  Viewing Index Usage and Using SET STATISTICS Statements

Instructor

SINA Institute

Requirements

Basic SQL Query Knowledge and Basic Knowledge of Microsoft Excel.

Features

Objectives : Microsoft SQL Server 10774 Training covers all details of Managing Multiple Servers, Tracing Access to SQL Server, and Authorizing Users to Access Resources.
Outcomes : After completing Microsoft SQL Server 10774 Training the student will be able to know about the administering sql server 2012 databases by using SQL Server 2012 and other Microsoft technologies and how to plan and implement high availability and disaster recovery solutions.

Free

Course Features

Lectures 118
Quizzes 0
Duration 10 weeks
Skill level All levels
Language English
Students 0
Assessments Yes

Microsoft SQL Server 10774 Training

Introduction of Microsoft SQL Server 10774 Training

Curriculum

Instructor

Requirements

Features

Course Features

Quick Links

Learn

Support

Microsoft SQL Server 10774 Training

Introduction of Microsoft SQL Server 10774 Training

Curriculum

Instructor

Requirements

Features

You May Like

Microsoft Window Server 70 410

Windows Server 70 411

MCSE SharePoint Administration Training

Power Electronics Course

Arduino Course

Course Features

Quick Links

Learn

Support

Modal title