MCSA: SQL Server 2012/2014 (70-461, 70-462 & 70-463)

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


    MCSA: SQL Server 2012 certificeringen består af 3 eksamener:

    • Querying Microsoft SQL Server 2012 (70-461)
    • Administering Microsoft SQL Server 2012 Databases (70-462)
    • Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

    Vi har hos Skillshouse udviklet et spændende MCSA: SQL Server 2012  kursusforløb, som er kortere end de traditionelle Microsoft kurser, idet vi har skåret lidt teori væk samt de overlap der er på de enkelte kurser. Dvs. du sparer i alt 6 kursusdage.


    Kurset er på i alt 9 dage og indeholder:

    • 3 dages undervisning ”Querying Microsoft SQL Server 2012” inkl. eksamensforberedelse.
    • 3 dages undervisning ”Administering Microsoft SQL Server 2012 Databases” inkl. eksamensforberedelse.
    • 3 dages undervisning ”Implementing a Data Warehouse with Microsoft SQL Server 2012” inkl. eksamensforberedelse.


    Undervisningen er fra 09.00 til 18.00


    Kort fortalt:

    • MCSA: SQL Server 2012 til Halv pris (du sparer mere end 21.500,-)
    • Du sparer 6 kursusdage
    • Eksamens vouchers og vi garanterer beståelse af alle 3 eksamener
    • Alt er inkluderet inkl. autoriseret Microsoft kursusmateriale.
    • Undervisningen foretages af Microsoft Certified Trainer (MCT)
    • Fuld forplejning og selvfølgelig alle de colaer du kan drikke 🙂


    Læs mere om vores unikke Hands-On kursusmetode (i menuen til højre) hvor fokus er på at opnå praktiske færdigheder op ikke lytte til en instruktør forklare udvikling via PowerPoints.

    Nedenstående er link til det officielle MCSA SQL Server 2012 site samt beskrivelser af de enkelte kurser.


    MCSA SQL Server 2012 - official site

     

    OBS: Dette kursus kan betales med 15 Microsoft SA-vouchers og egenbetaling kr. 4.495 eksklusiv moms)

     

     

    Querying Microsoft SQL Server 2012 (70-461)

    This exam is intended for SQL Server database administrators, implementers, system engineers, and developers. with two or more years of experience, who are seeking to prove their skills and knowledge in writing queries. Primary responsibilities may include but are not limited to:

     

    • Apply built-in scalar functions.
    • Apply ranking functions.
    • Combine datasets.
    • Create and alter DML triggers.
    • Create and alter indexes.
    • Create and alter stored procedures.
    • Create and alter tables.
    • Create and alter user-defined functions (UDFs).
    • Create and alter views.
    • Create and modify constraints.
    • Design T-SQL stored procedures.
    • Design views.
    • Implement aggregate queries.
    • Implement data types.
    • Implement error handling.
    • Implement subqueries.
    • Implement the sequence generator
    • Manage transactions.
    • Modify data by using INSERT, UPDATE, and DELETE statements.
    • Modify data by using MERGE statements.
    • Optimize queries.
    • Query and Manage XML data.
    • Query data by using SELECT statements.
    • Return data by using the OUTPUT clause.

    Administering Microsoft SQL Server 2012 Databases (70-462)

    This exam is intended for Database Professionals who perform installation, maintenance and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. Primary responsibilities may include but are not limited to:

     

    • Audit SQL Server instances.
    • Back up databases.
    • Configure additional SQL Server components.
    • Configure SQL Server instances.
    • Configure SQL Server services.
    • Deploy SQL Server.
    • Implement a migration strategy.
    • Implement columnstore indexes.
    • Implement contained databases.
    • Implement HADR (High-Availability and Disaster Recovery solution).
    • Import and export data.
    • Install SQL Server and related services.
    • Maintain a database.
    • Maintain indexes.
    • Manage and configure databases.
    • Manage data partitions.
    • Manage database permissions.
    • Manage database snapshots.
    • Manage logins and server roles.
    • Manage SQL Server Agent alerts.
    • Manage SQL Server Agent jobs.
    • Manage SQL Server Agent operators.
    • Manage SQL Server instances
    • Manage users and database roles.
    • Manage, create, and design log files.
    • Optimize queries.
    • Plan installation.
    • Restore databases.
    • Troubleshoot security.

    Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463)

    The primary audience for this exam is ETL and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Their primary responsibilities may include:

    • Mastering data using Master Data Services
    • Cleansing data using Data Quality Services
    • ETL Package development for data loading/transfer/transformation
    • Data Synchronization
    • One-time data or application migration
    • Ad-hoc data manipulations, transformations
    • Scheduling ETL jobs
    • Managing, configuring and deploying SQL Server Integration Services (SSIS) packages

     


    Varighed

    Dette kursus varer 9 dage

    Kursusmateriale

    Der medfølger kursusmateriale til dette kursus

    Klip på klippekort

    Dette kursus koster 12 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