27235 Courses delivered Online

Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!

ABOUT THIS VIRTUAL INSTRUCTOR LED TRAINING (VILT) This Virtual Instructor Led Training (VILT) course presents advanced methodologies that implement demand response and energy conservation programs in light of the integration of new technologies, regulatory changes and the accelerated penetration of renewable energy resources. This VILT course provides examples and case studies from North American and European jurisdictions covering the operational flexibilities on the demand side including requirements for new building codes to achieve zero net energy. The course describes a public agency's goals and objectives for conserving and otherwise reducing energy consumption and managing its demand for energy. This course presents the demand response implemented for economics and system security such as system balancing and relieving transmission congestion, or for system adequacy. The course also presents the principal attributes of conservation programs and the associated success criteria. In a system with increased penetration of renewable resources, demand response provides flexibility to system operators, helping them to maintain the reliability and the security of supply. Demand response is presented as a competitive alternative to additional power sources, enhancing competition and liquidity in electricity markets. The unique characteristics are discussed from a local, consumer centric and also from a system perspective bringing to life the ever changing paradigm for delivery energy to customers. Interoperability aspects and standards are discussed, as well as the consumer centric paradigm of Transactive Energy with IOT enabled flexibilities at system level, distribution networks and microgrids. The VILT course introduces the blockchain as a new line of defense against cyber threats and its increasing application in P2P transactions and renewable certificates. Our trainer's industry experience spans three decades with one of the largest Canadian utilities where she led or contributed to large operational studies and energy policies and decades of work with IEEE, NSERC and CIGRE. Our key expert also approaches to the cross sectional, interdisciplinary state of the art methodologies brings real life experience of recent industry developments. Training Objectives * Innovative Digital Technologies * How systems Facilitate Operational Flexibility on the Demand Side * The Ecosystem of Demand Side Management Programs * Advanced Machine Learning techniques with examples from CAISO * Regulatory Policy Context and how to reduce regulatory barriers * Industry Examples from NERC and ENTSO * Relevant Industry standards: IEEE and IEC * Manage Congestion with Distributed Operational Flexibilities: Grid to Distribution Controls; examples from NERC (NA) and ENTSO (Europe) * Grid solutions with IEC 61850 communication protocols * Decentralized grid controls * The New Grid with accelerated V2G and Microgrids * How DSM is and will be applied in Your System: Examples and discussions Target Audience * Regulators and government agencies advising on public energy conservation programs * All professionals interested in expanding their expertise, or advancing their career, or take on management and leadership roles in the rapidly evolving energy sector * Energy professionals implementing demand side management, particularly in power systems with increased renewable penetration, to allow the much needed operational flexibility paramount to maintaining the reliability and stability of the power system and in the same time offering all classes of customers flexible and economical choices * Any utility professional interested in understanding the new developments in the power industry Course Level * Basic or Foundation Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your first expert course leader is a Utility Executive with extensive global experience in power system operation and planning, energy markets, enterprise risk and regulatory oversight. She consults on energy markets integrating renewable resources from planning to operation. She led complex projects in operations and conducted long term planning studies to support planning and operational reliability standards. Specializing in Smart Grids, Operational flexibilities, Renewable generation, Reliability, Financial Engineering, Energy Markets and Power System Integration, she was recently engaged by the Inter-American Development Bank/MHI in Guyana. She was the Operations Expert in the regulatory assessment in Oman. She is a registered member of the Professional Engineers of Ontario, Canada. She is also a contributing member to the IEEE Standards Association, WG Blockchain P2418.5. With over 25 years with Ontario Power Generation (Revenue $1.2 Billion CAD, I/S 16 GW), she served as Canadian representative in CIGRE, committee member in NSERC (Natural Sciences and Engineering Research Council of Canada), and Senior Member IEEE and Elsevier since the 90ties. Our key expert chaired international conferences, lectured on several continents, published a book on Reliability and Security of Nuclear Power Plants, contributed to IEEE and PMAPS and published in the Ontario Journal for Public Policy, Canada. She delivered seminars organized by the Power Engineering Society, IEEE plus seminars to power companies worldwide, including Oman, Thailand, Saudi Arabia, Malaysia, Indonesia, Portugal, South Africa, Japan, Romania, and Guyana. Your second expert course leader is the co-founder and Director of Research at Xesto Inc. Xesto is a spatial computing AI startup based in Toronto, Canada and it has been voted as Toronto's Best Tech Startup 2019 and was named one of the top 10 'Canadian AI Startups to Watch' as well as one of 6th International finalists for the VW Siemens Startup Challenge, resulting in a partnership. His latest app Xesto-Fit demonstrates how advanced AI and machine learning is applied to the e-commerce industry, as a result of which Xesto has been recently featured in TechCrunch. He specializes in both applied and theoretical machine learning and has extensive experience in both industrial and academic research. He is specialized in Artificial Intelligence with multiple industrial applications. At Xesto, he leads projects that focus on applying cutting edge research at the intersection of spatial analysis, differential geometry, optimization of deep neural networks, and statistics to build scalable rigorous and real time performing systems that will change the way humans interact with technology. In addition, he is a Ph.D candidate in the Mathematics department at UofT, focusing on applied mathematics. His academic research interests are in applying advanced mathematical methods to the computational and statistical sciences. He earned a Bachelor's and MSc in Mathematics, both at the University of Toronto. Having presented at research seminars as well as instructing engineers on various levels, he has the ability to distill advanced theoretical concept to diverse audiences on all levels. In addition to research, our key expert is also an avid traveler and plays the violin. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

DESCRIPTION: Web writing and regular writing are different styles of writing.  You need to learn the specific writing style which is appropriate for web writing. You need to consider various factors to be able to do web writing. Web writing is not limited to just content writing. It could extend to writing blogs and web copywriting. Since you need to follow a unique style and type of content in web writing, learning how to write blogs and web copywriting will be helpful if you chose to have a career in web writing. Both these skills will be taught through this advanced diploma in web writing. You will learn the necessary skills, knowledge and information of Web Writing in this course.  WHO IS THE COURSE FOR? * Professionals, businessmen, and entrepreneurs who are into web writing * People who have an interest in blogs and copywriting ENTRY REQUIREMENT: * This course is available to all learners, of all academic backgrounds. * Learners should be aged 16 or over to undertake the qualification. * Good understanding of English language, numeracy and ICT are required to attend this course. ASSESSMENT:   * At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. * Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. CERTIFICATION: * After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. * PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. WHY CHOOSE US? * Affordable, engaging & high-quality e-learning study materials; * Tutorial videos/materials from the industry leading experts; * Study in a user-friendly, advanced online learning platform; * Efficient exam systems for the assessment and instant result; * The UK & internationally recognised accredited qualification; * Access to course content on mobile, tablet or desktop from anywhere anytime; * The benefit of career advancement opportunities; * 24/7 student support via email. CAREER PATH: The Advanced Diploma in Web Writing is a useful qualification to possess, and would be beneficial for the following careers: * Blogger * Blog Marketing and Promotions Specialist * Copywriter * Entrepreneur * Marketing Manager * Social Media Specialist * Social Content Creator * Web Writer. Writing Blogs What is Creative Blogging? 00:30:00 Researching Demands For Your Passion 01:00:00 Setting Up Your Blog 01:00:00 Your Blog Content 01:00:00 Turn Your Blog Into a Money Making Machine 01:00:00 Getting a Swarm of Traffic to your Blog 01:00:00 Web Copywriting Why Writing Copy for the Web is Different 00:15:00 Visitors Are The Most Important 00:30:00 Plan in Order to Succeed 00:30:00 How to Write an Effective Copy for the Web 00:30:00 How to Find the Effective Keywords and the Keyword Phrases 00:15:00 Keep it Short and Elegant 00:30:00 Other Essential Components for Good Copywriting 01:30:00 Get a Headline that Grabs 00:15:00 How to Write a Headline 00:15:00 Test the Tones of Your Headlines 00:15:00 Make Your Text Links Look Alike 00:30:00 Be Positive from the Beginning till the End 00:30:00 Conclusion 00:15:00 Copywriting That Sells Introduction 00:30:00 Structure 01:00:00 Headlines 01:00:00 Tone of voice 01:00:00 Online style 01:00:00 Reassurance 01:00:00 Reading strategies 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam-Advanced Diploma in Web Writing 00:30:00 Final Exam Final Exam-Advanced Diploma in Web Writing 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

MYSQL PERFORMANCE & TUNING TRAINING COURSE DESCRIPTION This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. WHAT WILL YOU LEARN * Develop a monitoring and tuning plan * Use server configuration and status variables. * Identify and improve problem queries. * Make efficient use of indexes. * Monitor and size memory caches and locks. * Tune the MyISAM and InnoDB storage engine. * Evaluate the use of partitioning for performance. MYSQL PERFORMANCE & TUNING TRAINING COURSE DETAILS * Who will benefit: Anyone who wishes to monitor and tune MySQL performance. * Prerequisites: Delegates must have a working knowledge of MySQL Database Administration * Duration 3 days MYSQL PERFORMANCE & TUNING TRAINING COURSE CONTENTS * Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. * MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. * Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. * Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. * Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. * Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. * Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. * The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. * Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. * Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. * Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. * Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

ORACLE DATABASE 12C ADMIN TRAINING COURSE DESCRIPTION This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. WHAT WILL YOU LEARN * Administer an Oracle database instance. * Monitor an Oracle database. * Configure the Oracle network environment. * Create and manage database storage structures. * Manage users, profiles, privileges and roles. * Manage undo data and temporary segments. * Monitor and resolve lock conflicts. * Maintain database security. * Implement database auditing. * Monitor the performance of the Database. * Load and unload data. * Use the job scheduler. * Configure a database for backup and recovery. ORACLE DATABASE 12C ADMIN TRAINING COURSE DETAILS * Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. * Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. * Duration 5 days ORACLE DATABASE 12C ADMIN TRAINING COURSE CONTENTS * Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. * Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. * Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. * Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. * Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. * Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. * Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. * Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. * Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. * Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. * Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. * Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ * Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. * SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. * Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. * Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. * Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. * Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. * Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability * Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

ABOUT THIS TRAINING COURSE Time is money in the oil business. Drilling time is big money. Whether in a technical, managerial or supporting role, you are a valuable asset to ensuring that project delivery targets are met and profits are realised. As drilling activities continue, professionals like you must grasp the language and technology of drilling operations in order to maximise expenditures throughout the producing life of a well. Drilling equipment and procedures have a unique language that must be conquered for maximum benefit. Clear and understandable explanations of drilling rig equipment, procedures, and their complex interactions provide an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. Drilling Essentials will help you de-mystify activities around the rig and well planning. It will explain the fundamentals of drilling with an emphasis on key areas such as logistical considerations, costing, and analysis of drilling contracts. Understand the urgency of drilling requests, know more about the cost implications of drilling-related problems, and understand the risks involved in a drilling contract. With the course director's drilling knowledge and skills, this is your opportunity to explore and understand important drilling concepts, principles, and technology which are presented in a reader-friendly format and illustrated with examples. As a non-drilling professional, you too can grow with the drilling industry with a deeper understanding of the critical role you play in contributing to its success! Training Objectives By attending this industry fundamentals Virtual Instructor Led Training (VILT) course, you will be better able to: * Understand drilling terminology & drilling processes for completing onshore & offshore wells * Appreciate major cost components of drilling operations and its impact for better project planning and management * Better visualise major drilling equipment and their technical functions to promote a deeper understanding of the logistical and technical considerations * Gain valuable insights on the drilling industry with a synopsis of recent technology developments that impact the drilling process Target Audience This Virtual Instructor Led Training (VILT) course has been developed for new engineers and forward-looking executives in the following fields who are interested in enhancing their knowledge and awareness of the drilling process for increased productivity & contribution to the team they're supporting: * Accounting * Commercial * Finance & Administration * General Management * Logistics * Procurement * Tender Contract * Administration * E & P IT * Finance * Joint Ventures * Materials Planning * Sourcing * Training * Business Development * Estimation & Proposal * HSE * Legal * Planning & Budgeting * Supply Chain * Drilling Fluids Organisational Impact Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

LEVEL 7 DIPLOMA IN HUMAN RESOURCE MANAGEMENT - PATHWAY TO MA HUMAN RESOURCE MANAGEMENT DEGREE Level 7 Diploma in Human Resource Management (QCF) – 6 - 8 Months Credits: 120 Credits The Level 7 Diploma in Human Resource Management qualification enables learners to progress into or within employment and/or to work toward a relevant Master’s Programme with advanced standing. This programme is a Pathway programme to M.A. Human Resource Management Degree  -------------------------------------------------------------------------------- COURSE DETAILS Assessment: Assignments The objective of the Level 7 Diploma in Human Resource Management qualification is to provide learners with the skills and understanding in human resource management (HRM) that align with good strategic decision making to maintain organizations’ competitive advantage. Learners acquire knowledge through an integrated approach of theory in human resource management and practice using real-time activities. Successful completion of this qualification will develop learners’ strategic human resource management and leadership skills and their ability to focus on the requirements of implementing an organization’s strategy. -------------------------------------------------------------------------------- ACCREDITATION All MSBM courses are accredited by the relevant partners and awarding bodies.  Please refer to MSBM accreditation [https://msbm.org.uk/about-msbm/accreditation] in about us for more details. -------------------------------------------------------------------------------- UNIVERSITY PROGRESSION University Top-up On completion of this course, students have the opportunity to complete a Master's degree programme from a range of UK universities. The top-up programme can be studied online or on campus. The top-up comprises the final 60 credits which consist of either a dissertation or a dissertation and one module. (The course tuition fee listed above does NOT include the top-up fees) University Progression Click here to see University routes and fee information for progression. [http://www.msbm.org.uk/learning-with-msbm/masters-top-up-fees] -------------------------------------------------------------------------------- ENTRY REQUIREMENTS For entry onto the Level 7 Diploma in Human Resource Management leading to the MA Human Resource Management qualification, learners must possess: * An honours degree in related subject or UK level 6 diploma or equivalent overseas qualification i.e. Bachelors Degree or Higher National Diploma        OR * Mature learners (over 25) with at least 5 years of management experience if they do not possess the above qualification (this is reviewed on a case by case basis) -------------------------------------------------------------------------------- WORKSHOPS Workshops are conducted by live webinars for all online students. -------------------------------------------------------------------------------- VISA REQUIREMENTS There is no Visa requirement for this programme.

ORACLE SQL ADVANCED TRAINING COURSE DESCRIPTION The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. WHAT WILL YOU LEARN * Retrieve data using correlated subqueries, in-line views and multi-column subqueries. * Use the WITH Clause. * Inserting and Updating Rows Using Complex Subqueries * Create Hierarchical Queries. * Use ROLLUP, CUBE and GROUPING SETS group by enhancements. * Implement the GROUPING and GROUPING_ID functions. * Manage large data sets. * Insert data conditionally and unconditionally. * Merge Rows in a Table. * Create TIMESTAMP and INTERVAL Datatypes. * Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. * Use regular expressions and implement related functions. * Manage objects with the data dictionary. * Manage schema objects. * Perform flashback operations. * Create and using external tables. * Control user access to database objects. ORACLE SQL ADVANCED TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. * Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. * Duration 2 days ORACLE SQL ADVANCED TRAINING COURSE CONTENTS * Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. * Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. * Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. * Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. * Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. * Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. * Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. * Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. * Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. * Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

  European Data Protection   Principles of Data Protection in Europe covers the essential pan-European and national data protection laws, as well as industry-standard best practices for corporate compliance with these laws. Those taking this course will gain an understanding of the European model for privacy enforcement, key privacy terminology and practical concepts concerning the protection of personal data and trans-border data flows.   The training is based on the body of knowledge for the IAPP's ANSI-accredited Certified Information Privacy Professional/Europe (CIPP/E) certification program. Privacy Programme Management   Principles of Privacy Management is the how-to training on implementing a privacy program framework, managing the privacy program operational lifecycle and structuring a knowledgeable, high-performing privacy team. Those taking this course will learn the skills to manage privacy in an organisation through process and technology-regardless of jurisdiction or industry.   The Principles of Privacy Program Management training is based on the body of knowledge for the IAPP's ANSI-accredited Certified Information Privacy Manager (CIPM) certification programme. Make a difference in your organization and in your career. The CIPM designation says that you're a leader in privacy program administration and that you've got the goods to establish, maintain and manage a privacy program across all stages of its lifecycle.  ABOUT THIS COURSE   Delivered in a modular format, this four day course covers   Days 1 & 2   * Module 1: Data Protection Laws Introduces key European data protection laws and regulatory bodies, describing the evolution toward a Harmonised European Legislative Framework.  * Module 2: Personal Data Defines and differentiates between types of data-including personal, anonymous, pseudo-anonymous and special categories.  * Module 3: Controllers and Processors Describes the roles and relationships of controllers and processors.  * Module 4: Processing Personal Data Defines data processing and GDPR processing principles, Explains the application of the GDPR and outlines the legitimate bases for processing personal data. *  Module 5: Information provision Explains controller obligations for providing information about data processing activities to data subjects and Supervisory Authorities.  * Module 6: Data Subjects 'Rights Describes data subjects' rights, applications of rights and obligations controller and processor.  * Module 7: Security or Processing Discusses considerations and duties of controllers and processors for Ensuring security of personal data and providing notification of data breaches.  * Module 8: Accountability Investigates accountability requirements, data protection management systems, data protection impact assessments, privacy policies and the role of the data protection officer.  * Module 9: International Data Transfers Outlines options and obligations for transferring data outside the European Economic Area, Decisions adequacy and appropriateness safeguards and derogations.  * Module 10: Supervision and Enforcement Describes the role, powers and procedures or Supervisory Authorities; the composition and tasks of the European Data Protection Board; the role of the European Data Protection Supervisor; and remedies, liabilities and penalties for non-compliance.  * Module 11: Compliance Discusses the applications of European data protection law, legal bases and compliance requirements for processing personal data in practice, employers-including processing employee data, surveillance, direct marketing, Internet technology and communications and outsourcing.    Days 3 & 4   * Module 1: Introduction to privacy program management Identifies privacy program management responsibilities, and describes the role of accountability in privacy program management.  * Module 2: Privacy governance Examines considerations for developing and implementing a privacy program, including the position of the privacy function within the organization, role of the DPO, program scope and charter, privacy strategy, support and ongoing involvement of key functions and privacy frameworks.  * Module 3: Applicable laws and regulations Discusses the regulatory environment, common elements across jurisdictions and strategies for aligning compliance with organizational strategy.  * Module 4: Data assessments Relates practical processes for creating and using data inventories/maps, gap analyses, privacy assessments, privacy impact assessments/data protection impact assessments and vendor assessments.  * Module 5: Policies Describes common types of privacy-related policies, outlines components and offers strategies for implementation.  * Module 6: Data subject rights Discusses operational considerations for communicating and ensuring data subject rights, including privacy notice, choice and consent, access and rectification, data portability, and erasure and the right to be forgotten.  * Module 7: Training and awareness Outlines strategies for developing and implementing privacy training and awareness programs.  * Module 8: Protecting personal information Examines a holistic approach to protecting personal information through privacy by design.  * Module 9: Data breach incident plans Provides guidance on planning for and responding to a data security incident or breach.  * Module 10: Measuring, monitoring and auditing program performance Relates common practices for monitoring, measuring, analyzing and auditing privacy program performance PREREQUISITES   There are no prerequisites for this course but attendees would benefit from a review of the materials on the IAPP SITE [https://iapp.org/] WHAT'S INCLUDED?   1 years membership of the IAPP Breakfast, Lunch, mid-morning and afternoon snacks, teas, coffees Official Study Guides* Official Participant Guides* Official Exam Q&A's* Both exam fees * In electronic format for Live Online and hard copy for Classroom delegates     WHO SHOULD ATTEND?   This course is suitable for aspiring Data Protection Officers, as well as Information Security Managers, Lawyers, Data Managers, Analysts and Risk Teams. PROVIDED BY OUR GUARANTEE   * We are an approved IAPP Training Partner. * You can learn wherever and whenever you want with our robust classroom and interactive online training courses. * Our courses are taught by qualified practitioners with a minimum of 25 years commercial experience. * We strive to give our delegates the hands-on experience. * Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. * Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. * Our Promise: Pass first time or 'train' again for FREE. *FREE training offered for retakes - come back within a year and only pay for the exam.

Enhance your knowledge in petroleum geochemistry with EnergyEdge's course on petroleum exploration. Enroll now!