MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server Fundamentals

Course Summary

This course is primarily for C# developers who use SQL Server in their applications. T-SQL developers and Database Administrators will also find it useful.


  • +

    Course Syllabus

    ● Introduction to SQL Server
        ◦ Overview
        ◦ What is SQL Server
        ◦ Application
        ◦ Using SSMS
        ◦ Drop a Database
        ◦ Add a Database
        ◦ Using T-SQL
        ◦ sqlcmd
        ◦ sqlps
        ◦ T-SQL Language
        ◦ Metadata
        ◦ T-SQL Example
        ◦ Scripting Objects
        ◦ Linq To Sql
        ◦ Linq to Sql Example
        ◦ SMO
        ◦ Analysis and Reporting
        ◦ SSAS
        ◦ SSIS
        ◦ SSRS
        ◦ Summary
        ◦ References
    ● Using Group By and Having
        ◦ Overview and Examples
        ◦ Basic Group By
        ◦ Using Aggregate Functions and Having
        ◦ Trimming Input And Summary
    ● CTE's and Ranking
        ◦ CTE and Ranking Overview
        ◦ Common Table Expressions
        ◦ Top
        ◦ Ranking
        ◦ Row Number
        ◦ Rank and DenseRank
        ◦ NTile
        ◦ Partitioning
        ◦ Aggregate Partitions
        ◦ Summary
    ● Hierarchies
        ◦ Title
        ◦ Overview
        ◦ Hierarchyid/Tree
        ◦ Why use hierarchyid?
        ◦ Hierarchyid properties
        ◦ Finding Descendents
        ◦ Adding Nodes
        ◦ GetReparentedValue
        ◦ Depth & Breadth
        ◦ Summary
    ● Managing Query Plans
        ◦ Overview
        ◦ Query Plans
        ◦ Query Optimizer
        ◦ Plan Reuse
        ◦ Example Plan Cache
        ◦ Example Stored Procedure Plan
        ◦ Ad hoc Expressions
        ◦ Example Ad hoc Optimization
        ◦ Example Ad hoc Off
        ◦ Parameterization
        ◦ Example Parameterization
        ◦ Example ADO.NET Parameters
        ◦ Plan Guides
        ◦ Kinds of Plan Guides
        ◦ Example Plan Guide
        ◦ Managing Plan Guides
        ◦ Example Managing Plan Guides
        ◦ Example Plan Guide From Handle
        ◦ Example Object Plan Guide
        ◦ Example Optimize For
        ◦ Example Template Plan Guide
        ◦ Summary
    ● Recursion, Pivoting, and Sampling
        ◦ Overview
        ◦ Recursive Query
        ◦ Numeric Recursion Example
        ◦ Tabular Recursion Example
        ◦ Aggregate Recursion Example
        ◦ Pivot
        ◦ Cross-Tab Example
        ◦ Group By Equivalent
        ◦ Unpivot
        ◦ Entity Attribute Value
        ◦ Entity Attribute Example
        ◦ Sampling
        ◦ Sampling Example
        ◦ Summary
    ● Security I
        ◦ Overview
        ◦ Databases and Security
        ◦ Authentication and Authorization
        ◦ Principals
        ◦ Example Managing Principals
        ◦ Example Server Principals
        ◦ Example Database Principals
        ◦ Example Role Principals
        ◦ Objects
        ◦ Authorization and Permissions
        ◦ Covering Permissions
        ◦ Example Authorizing Principals
        ◦ Example Using Permissions
        ◦ Example Impersonation
        ◦ Groups and Roles
        ◦ Example Groups and Roles
        ◦ Summary
        ◦ References
    ● Security II
        ◦ Overview
        ◦ Schemas
        ◦ Schemas Example
        ◦ Schemas Summary
        ◦ Roles
        ◦ Server Roles
        ◦ Database Roles
        ◦ Roles Example
        ◦ Roles Summary
        ◦ Execution Context
        ◦ Changing Execution Context
        ◦ Execution Context Scope
        ◦ Execution Context Example
        ◦ Execution Context Summary
        ◦ Summary
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top