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 2012 New Features

Course Summary

Explore the new possibilities in SQL Server 2012, and protect, unlock, and scale the power of your data.     


  • +

    Course Syllabus

    Introduction
       Welcome 
       What you should know 
       Using the exercise files 
    1. Getting Started
       Finding and downloading SQL Server 2012 Express edition 
       Setting up the SQL Server 2012 Express edition environment 
    2. Database Engine Improvements
       Using FileTables to enhance FileStream 
       Exploring the new semantic search for unstructured data 
       Exploring enhancements to full text search 
       Implementing ad-hoc paging with offset and fetch 
       Using the new throw statement to enhance try-catch blocks 
    3. Improvements to SQL Server Management Studio Debugging
       Using breakpoint condition, breakpoint hit count, breakpoint filter, and breakpoint action 
       Exploring the Watch, Quick Watch, and Quick Info windows 
       Reviewing Transact-SQL IntelliSense improvements 
    4. Changes to the Scope of Objects
       Understanding changes to user passwords and logins 
       Creating user-defined server roles 
       Understanding auditing 
    5. High Availability from the Developer's Point of View
       Exploring AlwaysOn 
       Examining changes to replication 
    6. Licensing
       Choosing an edition 
       Licensing SQL Server 2012 in a non-virtual environment 
       Licensing SQL Server 2012 in a virtual environment 
    7. Additional Changes
       Introducing new conversion, logical, and string functions 
       Understanding changes to hardware and operating system support 
       Exploring new types of indexes and new options on indexes 
       Understanding new administrative options 
       Accommodating changes to database structure 
    Conclusion
       Goodbye 


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

2 - 3 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