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 compelli


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Retrieving IDENTITY value using @@IDENTITY
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Concepts Related to Identity Values
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Difference between WHERE and HAVING
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Order in WHERE clause
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Concepts Around Temporary Tables and Table Variables
        ◦ Misconception
        ◦ Resolution
        ◦ Demo: Table variables exists in Memory misconception
        ◦ Demo: Temp tables exist in Physical drive myth
        ◦ Demo: Shows Table variables can have Index
        ◦ Demo: Scope of transaction with table and temp tables
        ◦ Additional Info
        ◦ Summary
    ● Are stored procedures pre-compiled?
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● UNIQUE INDEX and NULLs problem
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● DELETE VS TRUNCATE
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Locks and Duration of Transactions
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Nested Transaction and Rollback
        ◦ Misconception
        ◦ Resolution
        ◦ Demo: Nested Transaction - 1
        ◦ Demo: Nested Transaction - 2
        ◦ Demo: Nested Transaction - 3
        ◦ Summary
    ● Understanding Date/Time Datatypes
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Differences between VARCHAR and NVARCHAR datatypes
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Precedence of DENY and GRANT security permissions
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Identify Blocking Process
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● NULLS usage with Dynamic SQL
        ◦ Misconception
        ◦ Resolution
        ◦ Demo
        ◦ Additional Info
        ◦ Summary
    ● Appendix Tips and Tricks with Tools
        ◦ Using the ssms command-line tool
        ◦ Using Activity Monitor
        ◦ Using filtering in query results
        ◦ Configuration options in SSMS

     


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