MasterGrade IT: Data Management Courses

MasterGrade IT: Data Management Courses

Would you like to become a database administrator?

  • Get hands-on experience with SQL Server
  • Build Reports using Reporting Services
  • Migrate your database using Integration Services
  • Implement a data warehouse

What is the aim of our Data Management courses?

A Data Management certification adds tremendous value to database administrators and compliance professionals, as well as storage security. Data Management plays a very important role in any big or small enterprise organization. Our Data Management training course specifically caters for a broad range of technology professionals who need to ensure that business decision makers have secure and timely access to valid data.

Learn about evolving techniques, best practices in Data Management, the capabilities and limitations of certain products, and how to gather information and insight on technology to help with planning.

Querying Microsoft SQL Server 2014

Get Practical hands-on experience with:

  • Learn basic architecture and concepts of Microsoft SQL Server 2014.
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Learn to Query multiple tables
  • Understand Group and aggregate data
  • Implement error handling

Administering Microsoft SQL Server 2014 Databases 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.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.

Implementing A Data Warehouse With Microsoft SQL Server 2014 Course

implement a data warehouse platform to support a BI solution.

  • Implementing a data warehouse
  • Developing SSIS packages for data extraction, transformation, and loading.
  • Enforcing data integrity by using Master Data Services.
  • Manage SharePoint search
  • Cleansing data by using Data Quality Services

Implementing A Data Warehouse With Microsoft SQL Server 2014 Course

implement a data warehouse platform to support a BI solution.

  • Implementing a data warehouse
  • Developing SSIS packages for data extraction, transformation, and loading.
  • Enforcing data integrity by using Master Data Services.
  • Manage SharePoint search
  • Cleansing data by using Data Quality Services

Developing Microsoft SQL Server 2012 Databases Course

Plan, Design, Create ,index and query SQL Server Databases.

  • Introduce the entire SQL Server platform and its major tools.
  • Determine appropriate single column and composite indexes strategies.
  • Design effective non-clustered indexes.
  • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server.
  • Perform basic queries on XML data in SQL Server.

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Course

Learn to write basic Transact-SQL queries for Microsoft SQL Server 2008.

  • Describe the uses of and ways to execute the Transact-SQL language
  • Use querying tool.
  • Group and summarize data by using Transact-SQL.
  • Write queries that retrieve and modify data by using subqueries.

Maintaining a Microsoft SQL Server 2008 Database Course

Gain the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database

  • Plan, install and configure SQL Server 2008 R2
  • Import and export wizards and explain how they relate to SSIS
  • Configure and assign permissions
  • Monitor data by using Dynamic Management Views

Implementing a Microsoft SQL Server 2008 R2 Database Course

Gain the knowledge and skills to implement a Microsoft SQL Server 2008.

  • Create databases and database files.
  • Use XML-related features in Microsoft SQL Server 2008.
  • Implement stored procedures.
  • Implement managed code in the database

Implementing a Microsoft SQL Server 2008 R2 Database Course

Gain the knowledge and skills to implement a Microsoft SQL Server 2008.

  • Create databases and database files.
  • Use XML-related features in Microsoft SQL Server 2008.
  • Implement stored procedures.
  • Implement managed code in the database

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services Course

implement an Analysis Services solution and Analysis Services database

  • Describe how SQL Server Analysis Services can be used to implement analytical solutions.
  • Create multidimensional analysis solutions with SQL Server Analysis Services.
  • Customize an Analysis Services cube.
  • Deploy and secure an Analysis Services database.

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services Course

Learn how to implement an Integration Services solution in an organization.

  • Describe SQL Server Integration Services and its tools.
  • Create an Integration Services package.
  • Implement control flow in an Integration Services package.
  • Debug and implement error handling in an Integration Services package

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services Course

Learn how to implement a Reporting Services solution in an organization.

  • Describe SQL Server Reporting Services and its components.
  • Create a Reporting Services report.
  • Enhance a Reporting Services report
  • Implement subscriptions for reports.
  • Implement custom Reporting Services applications.

Microsoft Access Database Course 2013

Learn how to design and build databases with Microsoft Access.

  • Learn about keys and data types
  • Create relationships between tables
  • Create queries and lookup fields;
  • Learn about and create different types of forms in different ways
  • Create and publish web databases

Updating your Database Skills to Microsoft SQL Server 2012 Course

Gain the knowledge and skills to use new and enhanced capabilities in SQL Server 2012.

  • Describe key new and enhanced features in SQL Server 2012.
  • Use enhanced tools and PowerShell support to manage SQL Server 2012.
  • Use new and enhanced performance capabilities to optimize a SQL Server 2012 database
  • Use SQL Azure

Updating your Business Intelligence Skills to Microsoft SQL Server 2012 Course

Gain the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.

  • Describe key new and enhanced features for BI in SQL Server 2012.
  • Use new and enhanced features in SQL Server Integration Services.
  • Manage data quality by using SQL Server Data Quality Services.
  • Use Power View to create interactive data visualizations