- +92-51-4864925-26
- info@sina.edu.pk
- 693, Rehman Baba Road, Sector I-8/4, Islamabad.
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 20124
- Module 02: Getting Started with SQL Azure; Microsoft SQL Server 107742
- Module 03: Introduction to T-SQL Querying7
- Module 04: Writing SELECT Queries9
- 5.1Writing Simple SELECT Statements
- 5.2Eliminating Duplicates with DISTINCT
- 5.3Using Column and Table Aliases
- 5.4Writing Simple CASE Expressions
- 5.5Write simple SELECT Statements
- 5.6Writing Queries That Use Multiple-Table Inner Join
- 5.7Eliminate Duplicates Using Distinct
- 5.8Use Table and Column Aliases
- 5.9Use a Simple CASE Expression
- Module 05: Querying Multiple Tables; Microsoft SQL Server 107749
- 6.1Understanding Joins
- 6.2Understanding Joins
- 6.3Querying with Inner Joins
- 6.4Querying with Cross Joins and Self Joins
- 6.5Writing Queries That Use Inner Joins
- 6.6Writing Queries That Use Multiple-Table Inner Join
- 6.7Writing Queries That Use Self Joins
- 6.8Writing Queries That Use Outer Loins
- 6.9Writing Queries That Use Cross Join
- Module 06: Sorting and Filtering Data8
- 7.1Sorting Data
- 7.2Filtering Data with a WHERE Clause
- 7.3Filtering with the TOP and OFFSET-FETCH Options
- 7.4Working with Unknown and Missing Values
- 7.5Writing Queries That Filter Data Using a WHERE Clause
- 7.6Writing Queries That Filter Data Using an ORDER BY Clause
- 7.7Writing Queries That Filter Data Using the TOP Option
- 7.8Writing Queries That Filter Data Using the OFFSET-FETCH Clause
- Module 07: Working with SQL Server 2012 Data Types7
- 8.1Introducing SQL Server 2012 Data Types
- 8.2Working with Character Data
- 8.3Working with Date and Time Data
- 8.4Writing Queries That Return Date and Time Data
- 8.5Writing Queries That Use Date and Time Functions
- 8.6The Writing Queries That Return Character Data
- 8.7Writing Queries That Use Character Functions
- Module 08: Using Built-In Functions7
- Module 09: Grouping and Aggregating Data7
- 10.1Using Aggregate Functions
- 10.2Using the GROUP BY Clause
- 10.3Filtering Groups with HAVING
- 10.4Write queries which use the GROUP BY clause
- 10.5To Write queries which use aggregate functions
- 10.6Write queries which use distinct aggregate functions
- 10.7Write queries which filter groups with the HAVING clause
- Module 10: Using Sub queries6
- 11.1Writing Self-Contained Sub queries
- 11.2Writing Correlated Sub queries
- 11.3Using the EXISTS Predicate with Sub queries
- 11.4Write queries which use self-contained sub queries
- 11.5To Write queries which use scalar and multi-result sub queries
- 11.6Write queries which use correlated sub queries and EXISTS predicate
- Module 11: Using Table Expressions8
- 12.1Using Derived Tables
- 12.2To Using Common Table Expressions
- 12.3Using Views
- 12.4Using Inline Table-Valued Functions
- 12.5Write Queries Which Use Views
- 12.6Write Queries Which Use Derived Tables
- 12.7To Write Queries Which Use Common Table Expressions
- 12.8Write Queries Which Use Inline Table-Valued Functions
- Module 12: Using Set Operators6
- Module 13: Using Window Ranking, Offset and Aggregate Functions5
- Module 14: Pivoting and Grouping Sets5
- Module 15: Querying SQL Server Metadata6
- Module 16: Executing Stored Procedures7
- Module 17: Programming with T-SQL4
- Module 18: Implementing Error Handling3
- Module 19: Implementing Transactions4
- Module 20: Improving Query Performance4
Instructor
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.