Microsoft Updating Your Skills to SQL Server 2017 (10998)

---

After completing this course, students will be able to:

• Describe key capabilities and components of SQL Server 2017
• Describe new and enhanced features in SQL Server Performance, Availability, and Scalability 
• Describe new and enhanced features in SQL Server data access 
• Describe new and enhanced features in SQL Server reporting and BI 
• Describe new and enhanced features in SQL Server OLAP 
• Describe new and enhanced data analytics features 
• Describe new and enhanced features in SQL Server Cloud deployments
• Describe SQL Server on Linux functionality

  Course Duration: 2 Days

Recommended Prerequisites 

• In addition  to their professional experience, students who attend this training  should already have the following technical knowledge:
• Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2016.
• Familiarity with the Windows Server 2016 operating system and networking.
• Familiarity with Microsoft Office 2016. 
   

Who Should Attend  

• The primary audience for this course is existing database  professionals with experience of SQL Server 2016 who want to update  their skills to SQL Server 2017. 
• The secondary audience is existing SQL Server 2016 MCSAs who want to  prepare for the Upgrade exam for SQL Server 2017 certification.

After completing this course, students will be able to:  

• The approval and verification of users 
• Allow the acquisition of resources to users 
• SQL Server Database re-institution 
• Introduce models and frameworks for data retrieval and restoration 
• Apply and format security procedures for SQL server agent
• Oversee SQL server infrastructure 
• Utilization of Powershell to administer Sql server 
• Add external and share internal information 
• Designate database and server tasks 
• Safeguard critical information through auditing and encryption 
• SQL Server Database reinforcement 
• Manage extensive database through automation 
• Stay up to date with alerts and notices
• Sql server user access detection
• SQL server infrastructure examining and analysis
  
   

  Course Duration: 5 Days

Recommended Prerequisites 

• Operating Microsoft Windows along with awareness of its fundamentals.
• Competent database design skills
• Practical understanding of Transact – SQL and Relation Databases
  
   

Who Should Attend   

Individuals  involved in database management and currently employed in fields where  database administration is a critical operational function are  considered the key audience

for this course.

Content  creators through application development based on sql server databases  are also highly encouraged to take part in this IT ops training too.
 

After completing this course, students will be able to:

• Conducting the Power BI service.
• Explaining how to carry out work with Power BI data.
• Executing Power BI desktop data transformation.
• Connecting directly to data stores.
• Depicting Power BI desktop modelling.
• Depicting the functionality the Power BI mobile app.
• Designing a Power BI desktop visualization.
• Explaining how to collaborate with Excel data.
• Depicting the Power BI developer API.
  
  
  

  Course Duration:  3 Days

Recommended Prerequisites   

• Should be able to work with Microsoft Office applications – mainly Excel.
• General know  how of dealing with business finances to generate revenues and profits  and preference is given for financial accounting.
• Professional understanding of relational databases and reporting.
• Basic information regarding data warehouse schema topology (including star and snowflake schemas).
• Some prior experience with basic programming constructs (such as looping and branching).

Who Should Attend   

This course is specifically designed for SQL Server report creators who are looking for different methods to present data.
 

After completing this course, students will be able to: 

• Provision a Database Server
• Setup SQL Server according to the required task performance
• Provision, relocate and control databases in the cloud
• Improve the performance of SQL Server
• Run Databases and Files (shared)
  
    

  Course Duration:  5 Days

Recommended Prerequisites   

• Fundamental basis of Microsoft Windows operating system and its core operations
• Operating information of Transact-SQL 
• Functional knowledge of relational databases.
• Previous exposure with database design
   
   

Who Should Attend   

 If you want to  become a database professional, this course is ideal for you. You may  also take up this course if you want to learn more about various  database technologies. .
 

After completing this course, students will be able to: 

• Outlining the essential requirements of construction of data warehouse
• Applying a tangible plan for a data warehouse
• Producing store registry
• Detailing critical aspects of data warehousing solution
• Executing a practical design for a data warehouse
• Applying precedence format and specific procedures to ensure an effective control flow
• Jotting down crucial attributes of SSIS
• Clearing SSIS packages of any bugs
• Performing tasks to ensure data quality
• Extending SSIS to incorporate elements
• Detailing BI scenarios
• Carrying out SQL data warehouse on through Azure
• Utilizing SSIS to administer flow of information
• Constructing various bundles with a variety of factors and parameters.
• Recommending ways for a successful application of an ETL solution
• Executing Master Data Services procedures
• Install SSIS projects 
    

  Course Duration:  5 Days

Recommended Prerequisites   

• A complete grasp of MS Windows operations and performance
• Application know how of relational databases
• Past experience of designing databases.
  
  
   
   

Who Should Attend   

 Aspiring  students in the field of database management looking on to achieve  Business Intelligence Developer roles are the key audience for this  comprehensive course. Students will be expected to dig deep into  constructing BI procedures which would also consist of Data Warehouse  implementation, data clarification and ETL.