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

Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server


  • +

    Course Syllabus

    Introduction to SQL Server
    - 1h 14m

    —Overview 0m 54s
    —What is SQL Server 0m 55s
    —Application 3m 22s
    —Using SSMS 2m 47s
    —Drop a Database 0m 23s
    —Add a Database 4m 35s
    —Using T-SQL 5m 25s
    —sqlcmd 7m 20s
    —sqlps 4m 42s
    —T-SQL Language 3m 2s
    —Metadata 3m 52s
    —T-SQL Example 8m 0s
    —Scripting Objects 1m 52s
    —Linq To Sql 3m 32s
    —Linq to Sql Example 5m 20s
    —SMO 3m 31s
    —Analysis and Reporting 5m 33s
    —SSAS 2m 1s
    —SSIS 1m 40s
    —SSRS 1m 34s
    —Summary 3m 9s
    —References 1m 0s
    Using Group By and Having
    - 16m 7s

    —Overview and Examples 2m 12s
    —Basic Group By 4m 13s
    —Using Aggregate Functions and Having 4m 36s
    —Trimming Input And Summary 5m 6s
    CTE's and Ranking
    - 54m 59s
    Hierarchies
    - 1h 9m
    Managing Query Plans
    - 1h 15m
    Recursion, Pivoting, and Sampling
    - 59m 22s
    Security I
    - 1h 3m
    Security II
    - 1h 19m


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