Cena tečaja * 1.200,00 €
Obseg v dneh 3
Število ur 27

Trenutno nimamo razpisanih terminov za ta tečaj. Prijavite se na seznam interesentov in obvestili vas bomo o prvem možnem terminu.
Prijavite se na seznam interesentov

* Cena je brez DDV

SQL Server 2012 for Experienced Developers and DBAs SQL2012-DBE

Predznanje: 6231; 6232
  • SQL Server 2012 Overview and Installation
    • Components and Services
    • Editions
    • Licensing Overview
    • Windows Server Core Support
    • Windows Server 8
    • Requirements and Installation

    Tools Enhancements
    • Books Online
    • SQL Server 2012 Management Studio
       - Shortcut Schemes
       - Transact-SQL debugging
       - IntelliSense
       - Database Restore
           - Visual Timeline for Point-In-Time Restore
           - Page restore
    • Data-Tier Application Enhancements
    • DTA Enhancements
    • Powershell
    • SQL Server Data Tools

    What’s new for Developers?

    • T-SQL Language Enhancements
       - EXECUTE Statement
       - Ad-hoc Query Paging
       - SEQUENCE Objects
       - THROW statement
       - Enhanced OVER Clause Support
       - Analytic Windowing Functions
    • Metadata Discovery
    • New and Enhanced Query Optimizer Hints
    • New Spatial Features
    • UTF-16 Supplementary Characters (SC) Collations
    • SQL Server Express LocalDB
    • FileTables
    • Full Text Search Improvements
    • Statistical Semantic Search
    • ColumnStore

    What’s new for Administrators?
    • Security Enhancements
       - User-Defined Server Roles
       - Default Schema for Groups
       - SQL Server Audit Enhancements
       - Contained Databases
       - Service Master Key and Database Master Key Encryption changes
    • Scalability and Performance Enhancements
       - Online Index Create, Rebuild, and Drop
       - Adding not NULL columns
       - Partitioning Enhancements
    • High-Availability improvements
       - AlwaysOn SQL Server Failover Cluster Instances
       - AlwaysOn Availability Groups
    • Monitoring Enhancements
       - New and Modified Dynamic Management Views and Functions
       - Extended Events Enhancements
    • Databases on SMB Shares

Predavatelj

  • Matija Lah

    Lah Matija


    SQL Server 2012 for Experienced Developers and DBAs