Microsoft certification
MCSA Solutions Associate
MCSA - SQL Server 2016
Du har valgt: Sør-Trøndelag


3 treff ( i Sør-Trøndelag ) i MCSA - SQL Server 2016

Oslo 5 dager 22 500 kr
12 Feb
16 Apr
28 May
This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. [+]
The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.    After completing this course, students will be able to: Describe key features of data modelling within business intelligence Describe various report services data sources and how these are configured Create reports with report designer Configure reports with report designer and/or report builder Create SQL Server mobile reports Module 1: Introduction to Business Intelligence and Data Modelling In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite. Lessons Introduction to business intelligence The Microsoft business intelligence platform Introduction to reporting services Lab : Exploring an enterprise BI solution After completing this module, you will be able to: Describe key concepts in business intelligence Describe the Microsoft BI platform Describe key concepts in reporting services Module 2: Reporting Services Data Describe various Report Services data sources and how these are configured. Lessons Data connections Connection strings Datasets Filters and parameters Lab : Configuring a data connection After completing this module, you will be able to: Describe data connections and connection strings Describe filters and parameters Module 3: Implementing reports Create reports with report designer or report builder. Lessons Creating a report with the report wizard Creating a report Showing data graphically in a report Lab : Creating a report After completing this module, you will be able to: Create a report using the report wizard Show data graphically Module 4: Configuring reports This module describes how to configure reports with report builder or report designer. Lessons Implementing filters and parameters Implementing sorting and grouping Publishing a report Lab : Create and Publish reports that include parameters After completing this module, you will be able to: Implement filters and parameters Implement sorting and grouping Publish a report Module 5: Creating Mobile Reports This module describes how to create SQL Server mobile reports. Lessons Overview of SQL Server mobile reports Preparing data for mobile reports Mobile report publisher Lab : Mobile reports After completing this module, you will be able to: Describe SQL Server mobile reports Prepare data for mobile reports Publish mobile reports Read the official course description here  [-]
Les mer
Oslo Bergen Og 1 annet sted 5 dager 22 500 kr
29 Jan
05 Feb
05 Feb
The course will very likely be well attended by SQL power users who are not necessarily database-focused; namely, report writers, business analysts and client application... [+]
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.    After completing this course, students will be able to: Describe key capabilities and components of SQL Server 2016. Describe T-SQL, sets, and predicate logic. Write a single table SELECT statement. Write a multi-table SELECT statement. Write SELECT statements with filtering and sorting. Describe how SQL Server uses data types. Write DML statements. Write queries that use built-in functions. Write queries that aggregate data. Write subqueries. Create and implement views and table-valued functions. Use set operators to combine query results. Write queries that use window ranking, offset, and aggregate functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Read the official course description here  [-]
Les mer
Oslo 5 dager 22 500 kr
26 Feb
16 Apr
18 Jun
Upgrading Your Skills to Windows Server 2016 MCSA [+]
This five-day, instructor-led course explains how to implement and configure new Windows Server 2016 features and functionality. This course is for information technology (IT) professionals who want to upgrade their technical skills from Windows Server 2008 or Windows Server 2012 to Windows Server 2016. This course presumes a high level of knowledge about previous Windows Server technologies and skills equivalent to the Microsoft Certified Solutions Associate (MCSA): Windows Server 2008 or Windows Server 2012 credential.   This course is not a product-upgrade course, detailing considerations for migrating and upgrading students’ specific environment to Windows Server 2016. Rather, this course provides updates to students' existing Windows Server knowledge and skills, as they pertain to Windows Server 2016. [-]
Les mer

Lukk Denne siden benytter seg av informasjonskapsler (cookies).
Du kan fortsette å bruke siden som vanlig hvis du godtar dette. Les mer om bruk av informasjonskapsler i vår personvernerklæring.