• Email info@koenig-solutions.com
  • WhatsApp +91 81307 98752
  • Phone +1 877 226 2244

10776: Developing Microsoft SQL Server 2012 Databases

  • Overview

    This instructor-led course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this course helps you prepare for the Exam 70-464. The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012 product features and technologies for implementing a database.

    Course Objectives

    • Design, implement and troubleshoot security
    • Design the locking granularity level
    • Design and implement stored procedures
    • Create, use and alter user-defined functions (UDFs)
    • Design T-SQL table-valued and scalar functions
    • Design for implicit and explicit transactions
    • Capture and analyse execution plans
    • Collect performance and system information

    Course Content / Exam(s)

    Schedule for 10776: Developing Microsoft SQL Server 2012 Databases
    Course# Course Contents Exam# Exam Regular Track
    (days)
    10776 Developing Microsoft SQL Server 2012 Databases 70-464 Developing Microsoft SQL Server 2012 Databases 5
    Total 5
    Prerequisites

    In addition to their professional experience, students who attend this training should already have the following technical knowledge:

    • Knowledge of writing T-SQL queries.
    • Knowledge of basic relational database concepts.

    Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

    Recommended Courses and Certification:
  • Students Reviews
    Roshan Bhavsar Koenig IT Training Student

    I came for MCSA: Windows Server 2012 R2 training at Koenig Delhi. We really enjoyed our training with you and the staff at Koenig. We are greatly impressed with the service you provided. I...

    Read MoreRoshan BhavsarIndia
    Haitham Mohamed Salih Koenig IT Training Student

    I came to Koenig Delhi for Microsoft Business Intelligence Specialist. Choosing Koenig was a wise and pleasurable decision. I not only gained a lot of knowledge related to my field of study, but also...

    Read MoreHaitham Mohamed SalihSudan
    Abraham Akuei Makuac Koenig IT Training Student

    We came to Koenig Delhi for training on MCSE SQL Server 2014 BI Platform. We are from South Sudan.  We visited Koenig Solutions for the second time.  Our instructors were much quantified in...

    Read MoreAbraham Akuei MakuacSouth Sudan
    Josh  Koenig IT Training Student

    I came to Koenig Delhi for training on Microsoft Sharepoint 2013. I am sharing the experience of my stay at Koenig Solutions in New Delhi. I am what you would call a returning customer/student....

    Read MoreJosh Nigeria
    Mir Uzairuddin Ansari Koenig IT Training Student

    I came to Koenig Delhi for training on Microsoft Office Advance Excel Skills. I found this course through my colleagues and Koenig website. I thank Koenig Delhi administration for good services...

    Read MoreMir Uzairuddin AnsariAfghanistan
    View All Testimonials
  • Schedule & Prices
    1
    5
    5
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields