- +92-51-4864925-26
- info@sina.edu.pk
- 693, Rehman Baba Road, Sector I-8/4, Islamabad.
Introduction of Microsoft SQL Server Querying Course
Microsoft SQL Server Querying 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 Querying which starts with Microsoft SQL Server 2012 to the updated version.
Curriculum
- 20 Sections
- 128 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Module 01: Introduction to SQL Server 2012 and its Toolset4
- Module 02: Getting Started with SQL Azure5
- Module 03: Introduction to T-SQL Querying8
- Module 04: Writing SELECT Queries9
- 5.1Writing Simple SELECT Statements
- 5.2Using Column and Table Aliases
- 5.3Eliminating Duplicates with DISTINCT
- 5.4Writing Simple CASE Expressions
- 5.5Writing Queries That Use Inner Joins
- 5.6Writing Queries That Use Multiple-Table Inner Join
- 5.7The Writing Queries That Use Self Joins
- 5.8Writing Queries That Use Outer Loins
- 5.9Writing Queries That Use Cross Join
- Module 05: Querying Multiple Tables8
- 6.1Understanding Joins
- 6.2Querying with Inner Joins
- 6.3To Querying with Outer Joins
- 6.4Querying with Cross Joins and Self Joins
- 6.5Writing Queries That Filter Data Using a WHERE Clause
- 6.6Writing Queries That Filter Data Using an ORDER BY Clause
- 6.7Writing Queries That Filter Data Using the OFFSET-FETCH Clause
- 6.8The Writing Queries That Filter Data Using the TOP Option
- Module 06: Sorting and Filtering Data4
- 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 that use the GROUP BY clause
- 10.5To Write queries that use aggregate functions
- 10.6Write queries that use distinct aggregate functions
- 10.7Write queries which filter groups with the HAVING clause
- Module 10: Using Subqueries6
- 11.1Writing Correlated Subqueries
- 11.2Writing Self-Contained Subqueries
- 11.3Using the EXISTS Predicate with Subqueries
- 11.4Write queries that use self-contained subqueries
- 11.5To Write queries that use scalar and multi-result subqueries
- 11.6Write queries that use correlated subqueries 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-SQL6
- Module 18: Implementing Error Handling4
- Module 19: Implementing Transactions4
- Module 20: Improving Query PerformanceIn Microsoft SQL Server Querying Course Islamabad you will get to learn SQL Server Query Training Rawalpindi under the supervision of experienced instructors who focus on the concepts and make you a professional in the respected field. In SINA Microsoft SQL Server Querying Training Rawalpindi training focuses on the key elements, concepts, and terminologies associated with this course. You will not only learn verbally but also practically by doing tasks and assignments.12
- 21.1Factors in Query Performance
- 21.2Displaying Query Performance Data
- 21.3Viewing Query Execution Plans
- 21.4Viewing Index Usage and Using SET STATISTICS Statements
- 21.5Introduction of Microsoft SQL Server 2012
- 21.6Writing queries
- 21.7Sorting and filtering Data
- 21.8Data types
- 21.9Set operators
- 21.10Subqueries
- 21.11Tables
- 21.12Grouping and Aggregating Data
Instructor
Requirements
- Basic SQL Query Knowledge and Basic Knowledge of Microsoft Excel.
Features
- Objectives: After compilation Microsoft SQL Server Querying these topics cover by all details of Managing Multiple Servers, Tracing Access to SQL Server, and Authorizing Users to Access Resources.
- Outcomes: After completing Microsoft SQL Server Querying the student will be able to know about 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.