• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1594 Courses in Bradford

Oracle database administration

5.0(3)

By Systems & Network Training

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

Oracle database administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

Assertiveness in Action

By Inovra Group

Overview This one day course will provide guidance on how to become more assertive and build self-confidence, which in-turn will help your attendees to achieve greater work effectiveness and productivity, whilst putting them in control of their daily activities and making them more able to overcome stressful work and life situations. Description Being assertive is being able to express yourself with confidence without having to resort to passive, aggressive or manipulative behaviour. By developing assertiveness and becoming aware of our own strengths and weaknesses, we can modify our behaviour for greater effectiveness in social and business interactions. Topics covered: What is Assertiveness? – A series of activities relating to what assertiveness means and, perhaps more importantly, what it means to the participants. My Assertiveness Goals – A chance for the participants to review what they want to get out of the session and where they would like to end up with regard to their approach to assertiveness. How Assertiveness Works – A look at human reactions and the reasoning behind them culminating in an activity that looks at the participants own observations in relation to assertive behaviour. My Assertive Rights – A review of the rights we have as individuals followed by a commitment to the rights by the participants. Taking a Positive Approach – Looking at key methodology, including: – Giving and Receiving Compliments A review of typical responses to compliments and their negative consequences, followed by an opportunity to develop new, positive responses. – Improving Self-Esteem An in-depth review of each individual’s positive aspects. – New Challenges A set of challenges to take participants out of their comfort-zone and into the realm of possibilities. – Effective Communication A look at what makes effective communication, with some modelling of behaviours. Approaching Assertiveness – A look at the four cornerstones of being assertive with an opportunity to practice these behaviours. The Words You Use – Understanding the key areas of effective communication. Covering the areas of; Disclosing Your Feelings, Being Clear, Being Persistent, Empathising and Working Towards a Wise Outcome. Preparing to Be Assertive – A chance to understand and practice a set process of ‘scripting’ in order to develop an effective and natural approach to assertive interactions. Assertive Review – An activity that solidifies the reasoning behind wanting to become assertive, whilst demonstrating that it is not an unachievable outcome. Who should attend Anyone that needs to develop their assertiveness skills and improve communication with others Requirements for Attendees None.

Assertiveness in Action
Delivered In-Person in Wakefield or UK WideFlexible Dates
£800

Level 2 NVQ Diploma in Drilling Operations - Directional Drilling - Drill Rig Operator

By Dynamic Training and Assessments Ltd

Level 2 NVQ Diploma in Drilling Operations - Directional Drilling - Drill Rig Operator

Level 2 NVQ Diploma in Drilling Operations - Directional Drilling - Drill Rig Operator
Delivered In-Person in Nottinghamshire or UK WideFlexible Dates
£695

Business Analysis Fundamentals: In-House Training

By IIL Europe Ltd

Business Analysis Fundamentals: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals to pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). This course teaches participants the overall process of business analysis and where it fits in the bigger picture of the project life cycle and the business context. The course is interactive and combines discussion, active workshops, and demonstrations of techniques. The goal is bottom-line results that cut through the real-world problems facing people seeking to improve the way they operate to develop new and improved systems and products or otherwise deliver results through project performance. What you will Learn At the end of this program, you will be able to: Define the solution scope Work with the development team in the systems testing stage Ensure the solution is usable in the business environment Foundation Concepts Defining the business analyst (BA) function The role of the BA as change agent An introduction to the BABOK® Guide BA roles and relationships through the project life cycle (PLC) Business Analysis Planning and Monitoring Overview of business analysis planning and monitoring (BAP&M) Business analysis planning and monitoring - process and tools Business analysis planning and monitoring - roles and responsibilities Business analysis planning and monitoring - governance, information management, and performance improvement Elicitation and Collaboration Overview of elicitation and collaboration Elicitation and collaboration techniques Requirements Life Cycle Management Overview of requirements life cycle management Requirements life cycle management task details Strategy Analysis Overview of strategy analysis Analyze current state Define future state Assess risks Define change strategy Requirements Analysis and Design Definition Overview of requirements analysis and design definition (RA&DD) The anatomy of requirements RA&DD task descriptions RA&DD techniques Solution Evaluation Overview of solution evaluation Solution evaluation tasks Solution evaluation in development stages Underlying Competencies Overview of underlying competencies (UC) Underlying competencies

Business Analysis Fundamentals: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,495

ProQual NVQ Level 3 Diploma - Plant Maintenance

By Learning for Hire Limited

NVQ Level 3 Plant Maintenance - on-site assessment - we come to you

ProQual NVQ Level 3 Diploma - Plant Maintenance
Delivered In-Person in Oswestry or UK WideFlexible Dates
£1,200

ProQual NVQ Level 2 Diploma - Plant Maintenance

By Learning for Hire Limited

NVQ Level 2 Plant Maintenance - on site assessment - we come to you

ProQual NVQ Level 2 Diploma - Plant Maintenance
Delivered In-Person in Oswestry or UK WideFlexible Dates
£1,200

BBC micro:bit Coding Workshop

By Code Created (Coding Workshops for Schools)

For pupils aged 9 - 16 | Delivered in UK Schools by Real World App and Games Developers Our micro:bit Workshop teaches your class about the micro:bit, making some apps and games with them during the workshop (we bring our own micro:bits too if your school doesn't yet have any!). We’ll introduce them to MakeCode, the coding language that the micro:bit uses, and teach them the fundamentals of coding before we work on some really fun projects! For older students, we can even use Python with the micro:bit!

BBC micro:bit Coding Workshop
Delivered In-Person in Bristol or UK WideFlexible Dates
£350 to £450

Upstream Decarbonization: Strategies & Measures towards Lowering Emissions

By EnergyEdge - Training for a Sustainable Energy Future

About this training Decarbonization of the Upstream Oil & Gas sector has previously been based on inter-fuel competition. Market actions were seen as the most effective method for reducing the level of emissions. However, the pace of decarbonization is now being led by government policy acting in concert with a coalition of stakeholders such as investors and consumers. The primary focus of this pathway is on the management of carbon emissions to both mitigate and adapt to climate change. Some energy analysts have forecast that global production of oil and natural gas will have to decline annually by 4 to 6 percent in order to meet the global target of Net Zero Emissions by 2050. Oil and gas producers face a difficult challenge in deciding upon the strategy and measures that will best achieve targets set for them while maintaining supply, attracting investments and accessing markets. This 2-day training course will provide participants with an understanding of the strategies and measures for decarbonizing the Upstream Oil and Gas sector within the framework of measures implemented by individual governments through their respective commitments to reduce emissions to achieve their National Determined Contribution under the Paris Agreement. This course offers a unique opportunity to understand the rapidly increasing issues confronting the industry as well as the options for the management of carbon emissions to comply with corporate as well as national policies and the implementation of measures for controlling, reporting and verification. Training Objectives Upon completion of this course, participants will be better equipped to participate in the implementation of measures for the management of carbon emissions in the following areas: Implementation of measures for reducing carbon emissions Establishing systems for monitoring and reporting carbon emissions Evaluating the commerciality of discoveries Reviewing and strategizing future field development plans Meeting Environmental Obligations Target Audience This course has been specifically designed for professionals involved in the international oil and gas industry, whether employed a field operator, national oil company, or government. It offers a unique opportunity to rapidly increase your understanding of the issues confronting the industry as well as the options for the management of carbon emissions to comply with corporate as well as national policies and the implementation of measures for controlling, reporting and verification. Staff with the following roles will find this course particularly useful: Corporate Planners Project Engineers Financial Analysts Environmental Specialists Legal Advisors Regulatory & Compliance Officers Course Level Basic or Foundation Trainer Your expert course leader is an international legal expert in petroleum law who has been listed in the Guide to the World's Leading Energy and Natural Resources Lawyers. In his thirty years of practice, he has been the lead negotiator and acquisitions advisor for oil and gas companies in the US and the Asia-Pacific. These transactions have included both upstream (licences and leases) and downstream (refineries and pipelines) assets. He has been appointed as Distinguished Visiting Professor in Oil and Gas at the University of Wyoming and Honorary Professor at the Centre for Energy, Petroleum & Mineral Law & Policy (CEPMLP) at Dundee University. 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

Upstream Decarbonization: Strategies & Measures towards Lowering Emissions
Delivered in Internationally or OnlineFlexible Dates
£2,149 to £2,499

Manual Handling Awareness (On-Site)

4.9(182)

By You Can Do It .Training

This course will make delegates aware of the regulations regarding the moving and handling of...

Manual Handling Awareness (On-Site)
Delivered In-Person in Stoke on Trent or UK WideFlexible Dates
£532

CITB Health & Safety Awareness (On-Site)

4.9(182)

By You Can Do It .Training

This CITB HSA course highlights potential hazards when on a construction site.

CITB Health & Safety Awareness (On-Site)
Delivered In-Person in Stoke on Trent or UK WideFlexible Dates
£790