Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training 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

By: HRODC Postgraduate Training Institute, A Postgraduate-Only Institution

France

05 Aug - 06 Sep, 2019  2 month, 2 day

Follow Event

  

GBP 25,000

By the conclusion of the specified learning and development activities of Database Querying Programme, 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.
Durban; Dubai; London;Kuala Lumpur; Amsterdam; Paris; Brussels Aug 05 - 06 Sep, 2019
GBP 25,000.00 + 1,250.00 (VAT)(The course cost does not include living accommodation. However, delegates are treated with the following: Continuous snacks throughout the Event Days; Hot Lunch on Event Days; City Tour; Hand-outs; Stationery.)
(Convert Currency)

Ms. Michelle +442071938392; +447487877573; +639368309409

We offer very attractive discount for groups of 3 and more people, from the same organisation, taking the same course. Courses are delivered in over 30 Cities including Miami, London, Dubai, Kuala Lumpur, Paris, Milan.
Prof. Dr. R. B. Crawford
NST PPC Advert
Related Courses
International Humanitarian and Human Rights Law: National, Regional and International Human Rights Practices, Conventions and Law Course International Humanitarian and Human Rights Law: National, Regional and International Human Rights Practices, Conventions and Law Course
On going

3 months, 21 days, 11 Mar - 31 May, 2019 

2019-03-11 12:03:00
United Kingdom

HRODC Postgraduate Training Institute, A Postgraduate-Only Institution

This international humanitarian and human rights law: national, regional and international human rights practices, conventions and law course is designed for: Human rights workers Humanitarian ...

The Legal Parameter of Real Estate Management Course - Diploma Postgraduate The Legal Parameter of Real Estate Management Course - Diploma Postgraduate

5 days, 09 - 13 Sep, 2019 

2019-09-09 12:09:00
United Kingdom

HRODC Postgraduate Training Institute, A Postgraduate-Only Institution

By the conclusion of the specified learning and development activities, the participant will be able to demonstrate a heightened understanding of the following concepts and issues: International ...

Evaluating the Performance of Industrial Investments Course - Diploma Postgraduate Evaluating the Performance of Industrial Investments Course - Diploma Postgraduate

5 days, 24 - 28 Jun, 2019 

2019-06-24 12:06:00
United Kingdom

HRODC Postgraduate Training Institute, A Postgraduate-Only Institution

By the conclusion of the specified learning and development activities of Industrial Investments Performance Evaluation Course, delegates will be able to: Calculate Return on Investment (ROI) using ...

Research Project: Design, Conduct and Report Course Research Project: Design, Conduct and Report Course

12 days, 19 - 30 Aug, 2019 

2019-08-19 12:08:00
United Arab Emirates

HRODC Postgraduate Training Institute, A Postgraduate-Only Institution

By the conclusion of the specified learning and development activities for Research Project: Design, Conduct and Report Course, participants will be able to: Design a research project, ...