Microsoft certification
MCSA Solutions Associate
Du har valgt: MCSA - SQL Server 2014
Nullstill
Filter
Ferdig

-

4 treff i MCSA - SQL Server 2014

Sorter på søkerangering, kursnavn, pris, sted, kursdato


Oslo 5 dager 22 500 kr
08 May
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is th... [+]
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers. At Course CompletionAfter completing this course, students will be able to: Write SELECT queries Query multiple tables Sort and filter data Describe the use of data types in SQL Server Modify data using Transact-SQL Use built-in functions Group and aggregate data Use subqueries Use table expressions Use set operators Use window ranking, offset and aggregate functions • Implement pivoting and grouping sets Execute stored procedures Program with T-SQL Implement error handling Implement transactions   [-]
Les mer
Oslo 5 dager 22 500 kr
29 May
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 20... [+]
Kursinnhold About this CourseThis course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Audience ProfileThis course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include: •Implementing a data warehouse. •Developing SSIS packages for data extraction, transformation, and loading. •Enforcing data integrity by using Master Data Services. •Cleansing data by using Data Quality Services. At Course CompletionAfter completing this course, students will be able to: •Describe data warehouse concepts and architecture considerations. •Select an appropriate hardware platform for a data warehouse. •Design and implement a data warehouse. •Implement Data Flow in an SSIS Package. •Implement Control Flow in an SSIS Package. •Debug and Troubleshoot SSIS packages. •Implement an ETL solution that supports incremental data extraction. •Implement an ETL solution that supports incremental data loading. •Implement data cleansing by using Microsoft Data Quality Services. •Implement Master Data Services to enforce data integrity. •Extend SSIS with custom scripts and components. •Deploy and Configure SSIS packages. •Describe how BI solutions can consume data from the data warehouse. Kurset fører til eksamn 70-463. [-]
Les mer
Oslo 5 dager 22 500 kr
03 Apr
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching indiv... [+]
Kursinstruktør Ernst Rijk Ernst has been working in IT since 2000 as a database administrator, database developer and trainer, specialized in Microsoft SQL Server. Since 2007 he has been partner in designing, implementing and maintaining SQL Server Infrastructures for mainly mid-size and large companies. Ernst also deliver basic- and advanced training for Microsoft Partners for Learning Solutions throughout the world. He also has been working on SQL Server hands-on labs, as a proctor on Microsoft TechEd’s, as a community member and working on a project-basis for Microsoft.     Kursinnhold About this CourseThis five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Audience ProfileThe primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. At Course CompletionAfter completing this course, students will be able to: •Plan and install SQL Server. •Describe system databases, the physical structure of databases, and the most common configuration options related to them. •Explain the concept of the transaction log and the SQL Server recovery models and implement different backup strategies that are available with SQL Server. •Back up SQL Server databases. •Restore SQL Server databases. •Import and export data by using wizards, the bulk copy utility, and data-tier applications. •Work with SQL Server security models, logins, users, and contained databases. •Work with server roles and database roles. •Use permissions to secure resources. •Use SQL Server audit and Transparent Data Encryption. •Work with SQL Server Agent to configure and execute jobs. •Implement SQL Server Agent security, proxy accounts, and credentials. •Configure database mail, alerts, and notifications. •Create database maintenance plans. •Use SQL Server Profiler, SQL Trace, and Distributed Relay. •Use Distributed Management Views and configure data collection. Kurset fører til eksamen 70-462 [-]
Les mer
Oslo 5 dager 27 500 kr
27 Mar
05 Jun
Få kompetansen til å designe og administrere større database med SQL Server både lokalt og i skyen. På denne SQL Server 2014 Boot Campen går man gjennom 2 kurs på ... [+]
MålMålet for denne Boot campen er å oppnå en Data Platform MCSE SertifiseringKurset tar for seg en komprimert versjon av disse to kursene.20464 Developing Microsoft SQL Server 2014 Databases20465 Designing Database Solutions for Microsoft SQL Server  Målgruppe Database Administratorer og utviklere som skal designe og administrere SQL Server løsninger, og som ønsker å oppnår en MCSE Data Platform sertifiseringen.  Inkludert i priser får du følgendeOffisiell Microsoft kursdokumentasjonSertifiseringseksamen 70-464 og 70-465Kurslabber som er tilgjengelig i 2 uker etter at kurset er avsluttet.  - See more at: http://www.bouvet.no/Kurs/Kurskalender/Microsoft/SQL-server/SQL-Server-2014-MCSE-Data-Platform-Bootcamp/#sthash.XvNOJB7L.dpuf [-]
Les mer