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

France

06 - 10 Mar, 2017  5 days

Follow Event

  

GBP

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
Managing Internal and External Cultural Diversity Course Managing Internal and External Cultural Diversity Course

5 days, 07 - 11 Aug, 2017 

2017-08-07 12:08:00
United Kingdom

HRODC Postgraduate Training Institute

By the conclusion of the established learning activities of Managing Internal and External Cultural Diversity Course, the participant will be able to: Develop a working definition of ...

Advanced Procurement and Contract Management Course - Diploma Postgraduate (Paris) Advanced Procurement and Contract Management Course - Diploma Postgraduate (Paris)

5 days, 24 - 28 Apr, 2017 

2017-04-24 12:04:00
France

HRODC Postgraduate Training Institute

This Training Course is designed for: Procurement Officers; Purchasing and Procurement Professionals; Project Managers and Team Members;  Financial Managers; Accountants; Budget Officers; ...

Advanced Engineering Drawing and Design Advanced Engineering Drawing and Design

26 days, 04 - 29 Sep, 2017 

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

HRODC Postgraduate Training Institute

  By the conclusion of the specified learning and development activities, delegates will be able to demonstrate a heightened understanding of the following concepts and issues: Part 1 – ...

Business and Organisational Analysis Course - Diploma Postgraduate (London, UK) Business and Organisational Analysis Course - Diploma Postgraduate (London, UK)
On going

6 days, 24 - 29 Apr, 2017 

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

HRODC Postgraduate Training Institute

By the conclusion of the specified learning and development activities, delegates will be able to: Define, describe and analyse the nature of an organisation; Distinguish between formal and ...