MCSE SQL Server 2012: DATA PLATFORM (70-464 / 70-465)

    Interesseret i dette kursus? Send os en forespørgsel.
    Register your interest now


    SkillsHouses uddannelsesforløb "MCSE SQL Server 2012: Dataplatform er for dig som er MCSA SQL Server 2012 certificeret og som gerne vil opgradere din viden og certificering til det højeste niveau, nemlig MCSE: Dataplatform. 

    Certificeringen beviser dit brede sæt af færdigheder i opbygningen og administrationen af virksomhedsrelaterede dataløsninger - det værende sig både lokale miljøer og cloud miljøer.

    Uddannelsesforløbet indeholder 2 kurser inkl. 2 certificeringer:

    Developing Microsoft SQL Server 2012 Databases (70-464) 
    Designing Database Solutions for Microsoft SQL Server 2012 (70-465)

    Efter endt 70-464 kursus vil du have opnået følgende nye kompetencer:

    • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types.
    • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL.
    • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints.
    • Determine appropriate single column and composite indexes strategies.
    • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure.
    • Read and interpret details of common elements from execution plans.
    • Design effective non-clustered indexes.
    • Design and implement views
    • Design and implement stored procedures.
    • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses.
    • Design and implement functions, both scalar and table-valued.
    • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency.
    • Use both traditional T-SQL error handling code and structured exception handling.
    • Design and implement DML triggers
    • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
    • Store XML data and schemas in SQL Server.
    • Perform basic queries on XML data in SQL Server.
    • Work with the GEOGRAPHY and GEOMETRY data types
    • Implement and query a full-text index

    Efter endt 70-465 kursus vil du have opnået følgende nye kompetencer:

    • Design a data compression strategy
    • Design a database model
    • Design a Full-Text Search strategy
    • Design a high-availability solution 
    • Design a maintenance strategy for database servers
    • Design a management automation strategy
    • Design a migration, consolidation, and upgrade strategy
    • Design database, schema, and object security parameters
    • Design for business requirements
    • Design for concurrency
    • Design for High Availability
    • Design for implicit and explicit transactions
    • Design instance-level security configurations
    • Design physical database and object placement
    • Design policies
    • Design scalable database solutions

     


    Varighed

    Dette kursus varer 6 dage

    Kursusmateriale

    Der medfølger kursusmateriale til dette kursus

    Klip på klippekort

    Dette kursus koster 8 klip på dit klippekort.

    Forplejning

    Fuld forplejning (Morgenmad, frokost, eftermiddagskage samt kaffe og sodavand ad libitum)

    Beståelsesgaranti

    Fuld beståelsesgaranti er inkluderet i prisen - Læs mere her

    Practice Tests

    Med i prisen hører MeasureUp Practice Test

    Remote adgang

    Du har i alt adgang til din kursus-pc i 3 uger