Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Database Querying, Administration and Warehousing, on Microsoft SQL Server 2012: Microsoft Certified Solutions Expert (MCSE) Data Platform Compliant (Paris)

By: HRODC Postgraduate Training Institute


06 - 10 Mar, 2017  5 days

Follow Event



By the conclusion of the specified learning and development activities, delegates will be able to:

  • Demonstrate their ability to analyse collected performance data;
  • Illustrate how they authorise users to access particular objects;
  • Indicate how they would provide authorisation for users to execute a code;
  • Demonstrate their knowledge of database maintenance and how to automate the process;
  • Demonstrate an automation of SQL Server Management;
  • Back up databases and transaction logs;
  • Capture activity using SQL Server Profiler and Extended Events Profiler;
  • Capture and manage performance data;
  • Conduct pre-installation stress testing for SQL Server;
  • Configure credentials;
  • Configure database mail;
  • Configure operators, alerts and notifications;
  • Configure permissions at the schema level;
  • Configure Proxy accounts;
  • Configure SQL Server Services;
  • Construct and execute dynamic SQL with EXEC and sp_executes;
  • Create and manage transactions with transaction control language statements;
  • Create dynamic packages that include variables and parameters;
  • Create simple inline table-valued functions and write queries against them.
  • Lecturers;
  • All Others who are desirous in obtaining cutting-edge for improving the effectiveness of their decision-making, within the context of simple, functional, divisional and matrix structures, and their hybrids.

This Training Course is designed for:

  • Database Administrators;
  • SQL Server Administrators;
  • General Server Administrators;
  • Computer Encoders;
  • Microsoft SQL Server 2012 Administrators;
  • Microsoft SQL Server 2012 Warehousing Administrators;
  • Users of Transact SQL (T_SQL);
  • SQL Server Installers;
  • Microsoft SQL Server 2012 Installers;
  • Microsoft SQL Server 2012 Professionals;
  • SQL Server Management Studio Administrators;
  • Information Systems Professionals;
  • Information Systems Consultants;
  • Microsoft Certified Database Administrators (MCDBA) – SQL Server 2000 Databases – who wish to update to Microsoft SQL Server 2012;
  • Those who have an interest in relational database and SQL Servers;
  • All others who aspire to administer, configure and manage Microsoft SQL Server 2012.
Paris Mar 06 - 10 Mar, 2017

+44 7736147507; +44 1902 763607; +44 2071935906

Related Courses
Contract Management and Administration: Maximising Financial and Operational Performance Course - Diploma Postgraduate (London) Contract Management and Administration: Maximising Financial and Operational Performance Course - Diploma Postgraduate (London)

5 days, 10 - 14 Apr, 2017 

2017-04-10 12:04:00
United Kingdom

HRODC Postgraduate Training Institute

This Contract Management and Administration Training Course is designed for: Executives; Directors; Contract managers; Contract and Subcontract Administrators; Purchasing Professionals; Sales ...

Women in Management Intensive Women in Management Intensive

3 months, 21 days, 01 May - 21 Jul, 2017 

2017-05-01 12:05:00
South Africa

HRODC Postgraduate Training Institute

After this women in the workplace (double credit) training program participant will understand Gender disparity in organisations Factors affecting women in the workplace Occupational segregation and ...

Participant will learn the following at the end of this authorization for expenditure (AFE) concepts, contexts and applications - exploration and acquisition, drilling contract, tangible drilling, ...

Modern Quality Systems Course - Diploma Postgraduate (Malaysia) Modern Quality Systems Course - Diploma Postgraduate (Malaysia)

5 days, 15 - 19 May, 2017 

2017-05-15 12:05:00

HRODC Postgraduate Training Institute

This modern quality systems course is designed for: Quality Managers Project Managers Production Managers Production Supervisors Product Engineers Inspectors Line Leaders Production Operators Those ...