+92-51-4864925-26
info@sina.edu.pk
693, Rehman Baba Road, Sector I-8/4, Islamabad.
Home
About Us
IT
Telecom
Language
Management
CISCO
Digital Media
Contact
Menu
Home
About Us
IT
Telecom
Language
Management
CISCO
Digital Media
Contact
Chat Now
Curriculum
20 Sections
118 Lessons
10 Weeks
Expand all sections
Collapse 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
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content
