PDP Url

Microsoft SQL Server 2014 Performance Tuning and Optimization (MS-55144)

This Microsoft SQL server training course teaches the practical and functional techniques and knowledge which can be implemented in the workplace from the get go.

Virtual

Learning Style

Intermediate

Difficulty

5 Days

Course Duration

5 Days

SATV Value

Course Info

Download PDF

Certificate

See Sample

Subscribe Buy Individually
When you subscribe, you get:
Master subscription plan gives you access to this course PLUS:

  • high impact technical, end user and leadership courses
  • Includes courses in multi-modality - online self-paced + Virtual Classroom courses
  • Peer to peer learning and access to expert mentors
  • Learner and Manager Analytics
  • Access to Cognitive Learning Research platform to troubleshoot project issues
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
This Microsoft SQL server training course teaches the practical and functional techniques and knowledge which can be implemented in the workplace from the get go.

Course Information

About this course

This Microsoft SQL server training course teaches the practical and functional techniques and knowledge which can be implemented in the workplace from the get go. Students through this exhaustive course go on to understand SQL Server architecture, tempdb, optimizing transaction log operations, locking and blocking, indexing and statistics strategies, data file configuration, and transactions and isolation levels. This IT ops training also provides students with the valuable opportunity of learning how to comprehend and examine workload and specify problem creation avenues, in addition to learning the creation of baselines and benchmark SQL Server performance and finally their fixing procedure. Top of the line technology and methodologies are also covered such as in-memory tables along with stored procedures.

Course Objectives

A successful completion of this IT Ops training would make the students able to:

  • Have a comprehensive and functional knowledge of memory optimized tables

  • Make use of startup stored procedures

  • Comprehend and Execute instant file initialization process

  • Have extensive grasp over SQL data location

  • Explore the practicality of the latest cardinality estimator

  • Have a comprehensive and functional grip of startup stored procedures..

  • Have a comprehensive and functional grip of transactions.

  • Have a comprehensive and functional grip of SQL Server locking architecture.

  • Have a comprehensive and functional grip of SQL on virtual machines.

  • Have a comprehensive and functional grip of partitioned tables and indexes.

  • Have a comprehensive and functional grip of Activity Monitor.

  • Have a complete knowledge of how to monitor SQL using Transact-SQL.

  • Have a complete knowledge of indexes and their importance.

  • Produce and edit indexes

  • Have a comprehensive and functional grip of Database Tuning Advisor.

  • Have a complete knowledge of fragmentation of indexes and utilize page splits.

  • Have a comprehensive and functional grip of indexed views.

  • Have a complete knowledge of index best practices.

  • Have a comprehensive and functional grip of histogram.

  • Have a comprehensive and functional grip of incremental statistics.

  • Have a comprehensive and functional grip of filtered statistics..

  • Have a comprehensive and functional grip of statistics maintenance plan.

  • Have a comprehensive and functional grip of tables and indexes.

  • Have a comprehensive and functional grip of natively compiled stored procedures.

  • Have a comprehensive and functional grip of the Analyze Migrate Report tool.

  • Have a comprehensive and functional grip of the SQL Trace Default template.

  • Set up and operate templates for slow paced queries

  • Utilize profiler to identify deadlocks and blocked processes.

  • Produce and implement plan guides

  • Have a comprehensive and functional grip of plan freezing.

  • Have a complete knowledge of SQLIO Utility and its uses.

  • Have a comprehensive and functional grip of the Resource Governor.

  • Have a complete knowledge of Live Query Statistics.

  • Have a comprehensive and functional grip of performance DMVs.

  • Have a complete knowledge of index types.

  • Have a comprehensive and functional grip of index metadata.

  • Have a comprehensive and functional grip of Index Data Management Objects.

  • Have a complete knowledge of index storage strategies.

  • Have a complete knowledge of monitoring indexes.

  • Have a comprehensive and functional grip of statistics objects.

  • Have a comprehensive and functional grip of new vs old cardinality estimator.

  • Have a comprehensive and functional grip of computed columns.

  • Have a comprehensive and functional grip of ascending keys

  • Understand architecture.

  • Have a comprehensive and functional grip of the hash index.

  • Understand restrictions.

  • Have a comprehensive and functional grip of in-memory data management views.

  • Have a comprehensive and functional grip of the SQL Profiler Tuning template.

  • Observe and figure out extensive and lengthy queries

  • Have a comprehensive and functional grip of query hints.

  • Authorize SQL Profiler to create plans

  • Have a comprehensive and functional grip on the new cardinality estimator

  • Have a complete knowledge of all performance issues.

  • Comprehend database structures

  • Have a grasp over SQL stored data

  • Have a theoretical understanding of temporary table intervals

  • Use and have complete knowledge of memory optimized tables

  • Have a comprehensive and functional grip of table valued parameters.

  • Have complete knowledge of concurrency.

  • Have a complete knowledge of isolation levels

  • Have a complete knowledge of SQL and Storage Area Networks (SAN).

Audience

The course is primarily designed to target administrators and maintainers of SQL databases, who aim for achieving the optimal performance of their SQL Server. These administrators and maintainers are also responsible for drawing queries against the data while ensuring the perfect execution of available workload.

The course also attracts secondarily to application developers involved in content creation through SQL server databases.

Prerequisite

  • A comprehensive knowledge of MS Windows Operating systems and its practical implementation

  • A functioning understanding of database administration, maintenance and transact – SQL.

Suggested Prerequisite Course

  • Administering a Microsoft SQL Server Database Infrastructure (MS-20764)

  • Querying Data with Microsoft Transact-SQL (MS-20761)

    Course Outline

    Practice Certification Exam

    Coming Soon

    More Information

    More Information
    Brand Microsoft
    Subjects IT Ops & Management
    Lab Access Yes
    Technology Microsoft
    Learning Style Virtual Classroom
    Difficulty Intermediate
    Course Duration 5 Days
    Language English
    SATV Value 5 Days
    VPA Discount VPA Discount

    Reviews

    Write Your Own Review
    Only registered users can write reviews. Please Sign in or create an account

    Frequently Asked Questions

    FAQ's

    Frequently Asked Questions About Virtual Instructor-Led Courses

    I can't connect to my class, what are my options?

    The link to the class is available upon logging in to your dashboard. If you are unable to see it, please contact our support team at 1-855-800-8240 and they will be happy to provide you the direct link via email or the dial in number.


    I can't make it to attend to class. Can I reschedule?

    Yes, you can reschedule your class. Please contact your Sales representative and they will arrange this for you. If you forgot his/her name, feel free to contact our support team at support@quickstart.com or 1-855-800-8240.


    Will I get my certificate upon completion?

    Yes. Upon completion of the course, it will be available on your course as a Trophy Icon for you to download. If you do not see this, you will need to contact support@quickstart.com with the following details so they can email you the certificate: Class Name, Class Date, Account Rep, and Your Email.


    I cannot connect to my lab. Help!

    Your Lab is accessible on the bottom part of your course. You will see a button that says "LAB". Just click it to launch the lab. Please note that some classes don’t need/require a LAB. You can verify with our support team by calling them at 1-855-800-8240 or by email at support@quickstart.com. You can also check with your Instructor or the Associate Instructor if your class includes one.


    What is my access code for Skillpipe?

    A. Not all of the classes have or require Skillpipe. If your class includes one, please check your email as you should have received one from noreply@skillpipe.com. In case you do not find it in your inbox, please check the Spam / Junk folder. For any further assistance, you can call the support at 1-855-800-8240 or contact them via email at support@quickstart.com.


    I don't have audio. I can't hear the instructor.

    Make sure you are using a compatible headset for your laptop or computer. If you don’t have a headset, you can use the built-in speaker of your laptop. Otherwise, you can use the dial in option by calling the dial in number provided in the class joining email. You may also contact support team for the dial in numbers associated for your training at 1-855-800-8240 or contact them via email at support@quickstart.com.


    How can I reach student support?

    Support can be reach via phone at 1855-800-8240; via email at support@quickstart.com or via chat support through the chat button on our website. Please note that support office hours will be from 8am-5pm CST Monday to Friday. Any concerns after office hours will be attended the following business day.

    REQUEST MORE INFORMATION

    click here