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 Questions and Answers

Course Summary

This course is designed to help you better understand how to use SQL Server effectively. The course presents many of the common misconceptions about SQL Server, and then carefully debunks those misconceptions with clear explanations and short but compelling demos, showing you how SQL Server really works.


  • +

    Course Syllabus

    Introduction
    - 0m 54s

    —Introduction 0m 54s
    Retrieving IDENTITY value using @@IDENTITY
    - 8m 38s

    —Misconception 0m 23s
    —Resolution 0m 26s
    —Demo 6m 9s
    —Additional Info 1m 14s
    —Summary 0m 26s
    Concepts Related to Identity Values
    - 4m 15s
    Difference between WHERE and HAVING
    - 5m 52s
    Order in WHERE clause
    - 7m 29s
    Concepts Around Temporary Tables and Table Variables
    - 9m 3s
    Are stored procedures pre-compiled?
    - 5m 9s
    UNIQUE INDEX and NULLs problem
    - 6m 40s
    DELETE VS TRUNCATE
    - 6m 7s
    Locks and Duration of Transactions
    - 15m 11s
    Nested Transaction and Rollback
    - 9m 16s
    Understanding Date/Time Datatypes
    - 7m 40s
    Differences between VARCHAR and NVARCHAR datatypes
    - 6m 38s
    Precedence of DENY and GRANT security permissions
    - 5m 29s
    Identify Blocking Process
    - 6m 37s
    NULLS usage with Dynamic SQL
    - 8m 3s
    Appendix Tips and Tricks with Tools
    - 20m 44s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

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