MBRussell is now a CompTIA Authorized Training Partner
Microsoft Updating Your Skills to SQL Server 2017 (10998)
What You'll Learn
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 Details
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.
Introduction to Microsoft SQL Databases (10985)
What You'll Learn
After completing this course, students will be able to:
- Describe key database concepts in the context of SQL Server 2016
- Describe database languages used in SQL Server 2016
- Describe data modeling techniques
- Describe normalization and denormalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
Course Details
Course Duration: 5 Days
Recommended Prerequisites
This is a foundation level course and therefore only requires general computer literacy.
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.
Administering Microsoft SQL Database Infrastructure (20764)
What You'll Learn
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 Details
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.
Administering Microsoft SQL Server Databases (MS-20462)
What You'll Learn
After completing this course, students will be able to:
- Describe core database administration tasks and tools.
- Install and configure SQL Server 2014.
- Configure SQL Server databases and storage.
- Plan and implement a backup strategy.
- Restore databases from backups.
- Import and export data. Monitor SQL Server.
- Trace SQL Server activity.
- Manage SQL Server security.
- Audit data access and encrypt data.
- Perform ongoing database maintenance.
- Automate SQL Server maintenance with SQL Server Agent Jobs.
- Configure Database Mail, alerts and notifications.
Course Details
Course Duration: 5 Days
Recommended Prerequisites
This course requires that you meet the following prerequisites:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design.
Who Should Attend
- The 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.
- The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
Analyzing Data with Microsoft Power BI (MS-20778)
What You'll Learn
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 Details
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.
Introduction to Microsoft SQL Databases (MS-10985)
What You'll Learn
After completing this course, students will be able to:
- Describe key database concepts in the context of SQL Server 2016
- Describe database languages used in SQL Server 2016
- Describe data modeling techniques
- Describe normalization and de-normalization techniques
- Describe relationship types and effects in database design
- Describe the effects of database design on performance
- Describe commonly used database objects
Course Details
Course Duration: 3 Days
Recommended Prerequisites
This is a foundation level course and therefore only requires general computer literacy.
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. .
Provisioning Microsoft SQL Databases (MS-20765)
What You'll Learn
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 Details
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. .
Design a Data Solution with Microsoft SQL Server (MS-20465)
What You'll Learn
After completing this course, students will be able to:
- Clear depiction of the considerations for consolidating workloads with SQL Server 2014.
- Explanation of considerations for including SQL Server 2014 in a private cloud.
- Effective evaluation of an existing enterprise environment.
- Design and execute Policy-Based Management.
Course Details
Course Duration: 3 Days
Recommended Prerequisites
- 2 years’ or more work experience with relational databases, including:
- Managing databases
- Designing, developing and executing databases
- Understanding of high availability and disaster recovery
- Querying with Transact-SQL
Who Should Attend
The course is primarily designed for individuals whose job is to plan, implement, and manage database solutions. Their core tasks include the following:
- Crafting and executing high availability solutions.
- Designing and executing database infrastructure
- Designing and managing the execution of disaster recovery solutions.
- Designing and carrying out consolidation strategies.
Implementing a Microsoft SQL 2016 Data Warehouse (MS-20767)
What You'll Learn
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 Details
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.