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

-

5 dager 24 000 kr
This course is designed to introduce students to Transact-SQL. [+]
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.   Course goals: 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 complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=20761 [-]
Les mer
5 dager 24 000 kr
This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. [+]
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.    Course goals: After completing this course, students will be able to: Describe reporting services and it’s components Describe reporting services data sources Implement paginated reports Work with reporting services data Visualize data with reporting services Aggregate report data Share reporting services reports Administer reporting services Expand and integrate reporting services Describe mobile reports Develop mobile reports. Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=10990C [-]
Les mer
3 dager 16 000 kr
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. [+]
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. Course goals: After completing this course, students will be able to: Describe the components, architecture, and nature of a BI solution Create a multidimensional database with Analysis Services Implement dimensions in a cube Implement measures and measure groups in a cube Use MDX syntax Customize a cube Implement a tabular database Use DAX to query a tabular model Use data mining for predictive analysis Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=20768 [-]
Les mer
5 dager 24 000 kr
This five-day instructor-led course will teach students to create BI solutions and to implement a Data Warehouse, data flow by using SSIS and an ETL solution. [+]
This five-day instructor-led course will teach students to create BI solutions and to implement a Data Warehouse, data flow by using SSIS and an ETL solution. Students will also learn about data cleansing. Course goals: After completing this course, students will be able to: Describe the key elements of a data warehousing solution  Describe the main hardware considerations for building a data warehouse  Implement a logical design for a data warehouse   Implement a physical design for a data warehouse Create columnstore indexes Implementing an Azure SQL Data Warehouse Describe the key features of SSIS Implement a data flow by using SSIS Implement control flow by using tasks and precedence constraints Create dynamic packages that include variables and parameters Debug SSIS packages Describe the considerations for implement an ETL solution Implement Data Quality Services Implement a Master Data Services model Describe how you can use custom components to extend SSIS Deploy SSIS projects Describe BI and common BI scenarios Read complete course description:https://www.microsoft.com/en-us/learning/course.aspx?cid=20767 [-]
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.