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 -20461 course - mastergradeit cape town south afrcia

Querying Microsoft SQL Server 2014 -20461  course - mastergradeit cape town south afrcia
course: 20461

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 - 20462 course - mastergrade it cape town south afrcia
Administering Microsoft SQL Server 2014 Databases Course - 20462 course - mastergrade it cape town south afrcia

Administering Microsoft SQL Server 2014 Databases Course - 20462 course - mastergrade it cape town south afrcia
course: 20462

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 - 20463 course - mastergrade it cape town south afrcia | Data Management
course: 20463

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 - 10776 course - mastergrade it cape town south afrcia | Master data management
course: 10776

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 - 2778  course - mastergradeit cape town south afrcia
course: 2778

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 - 6231 course - mastergradeit cape town south afrcia
Maintaining a Microsoft SQL Server 2008 Database Course - 6231 course - mastergradeit cape town south afrcia


Maintaining a Microsoft SQL Server 2008 Database Course - 6231 course - mastergradeit cape town south afrcia




Maintaining a Microsoft SQL Server 2008 Database Course - 6231 course - mastergradeit cape town south afrcia
course: 6231

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 - 6232 course - mastergradeit cape town south afrcia
course: 6232

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 - 6234 course - mastergradeit cape town south afrcia
course: 6234

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 - 6235 course - mastergradeit cape town south afrcia
course: 6235

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 - 6236 course - mastergradeit cape town south afrcia
course: 6236

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 course - mastergradeit cape town south afrcia

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 - 40008 course - mastergradeit cape town south afrcia
course: 40008

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 - 40009  course - mastergradeit cape town south afrcia
course: 40009

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.