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
Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX INTRODUCTION TODAX CREATING OBJECTS WITHDAX CONTEXT AND RULES OF EVALUATION VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS GETTING STARTED IMPLICIT MEASURES ADDING QUICK MEASURES WORKING WITH DAX DATA TYPES . DOING BASIC MATH USING LOGIC IN YOUR CALCULATIONS USING THE IF() FUNCTION NESTED IF() USING THE SWITCH() FUNCTION ADVANCED SWITCH() LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() AGGREGATING AND SUMMARIZING DATA THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL CONTEXT DEFINED DATA MODELING BASICS INTRODUCTION TO DIMENSIONAL MODELING RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE LOOKING UP DATA WITHOUT USING RELATIONSHIPS MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS THE DAX ITERATOR FUNCTIONS USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME PERFORMING DATE CALCULATIONS WORKING WITH DATE TABLES GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION DEFINING CUSTOM OPERATING PERIODS YTD, QTD, AND MTD CALCULATIONS CUSTOM TO-DATE CALCULATIONS FINDING YEAR-OVER-YEAR CHANGE FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE CONTROLLING VISIBILITYOF YOUR MEASURES USING WHAT-IF PARAMETERS ADDING BANDING USING DAX TO PROVIDE ROW-LEVEL SECURITY
Classes from A1 to C2 level of the CEFR (Common European Framework of Reference for Languages). A1 - A2 Beginners Let’s start learning French! With this course you will learn the basic elements and key phrases of the French language from the very beginning. You might know a few words and expressions already, but what about making your visit more authentic by interacting with people once you are there? The exercises and activities in this course will build your confidence with useful expressions, pronunciation, grammar practice, verb drills (present tense of most common verbs) and speaking/listening activities, games and quizzes will be included along the way. The syllabus: French language sounds are unique, so you need to know how to pronounce each sound correctly. This course will aim not only at building your confidence when speaking French but also to sound French! Greetings, formal and informal address; how to introduce yourself/ introduce others, ask for something in cafés and restaurants, giving/exchange details, understanding numbers and prices, talking about jobs and family, where you live; asking and understanding directions and other basic vocabulary when going around shopping; you will also learn some cultural traits and fun facts about French people. B1 - B2 Intermediate Now that you know some French, why not improve your language skills further?The intermediate course is structured around grammar activities (such as prepositions, combined articles and pronouns), verb drills (past tenses, progressive forms, future tense), comprehension activities, short stories, common idiomatic expressions, games and quizzes. The syllabus: describing people, booking hotels, booking accommodation online and via emails, more about numbers, describing places, expressing admiration, enquiring about services such as public transport; talking about homes, finding a house; expressing likes and dislikes, shopping (markets), buying shoes and clothes, expressing preferences, writing invitations, giving your opinion, making suggestions, buying tickets, understanding directions, describing situations in the past; making plans for the future. C1 - C2 Advanced The advanced course is designed for students who already know French but want to take their knowledge further in order to hone their skills in all aspects of the language learning. With the advanced course, the student will have the opportunity to learn the grammar and vocabulary acquired with the intermediate course, but more in depth with more listening and practical activities and role play. The focus of this course is to prepare the student to live in a French speaking country. The teaching approach will also include a variety of newspapers articles (short at the beginning and longer articles as the student progresses further). The articles are used as conversation topics in order to hone vocabulary and grammar skills. Short videos from trusted resources will also be used for speaking practice during the class to boost fluency and to learn new common expressions. This course may include writing tasks about specific topics which the student will discuss during the class with the teacher. The syllabus: Includes talking about saying what you have done recently using a variety of verbs and expressions, referring to events in the past using the imperfect tense and the past tense, understanding the weather forecast, making suggestions, understanding and giving instructions, comparing things, giving reasons, solving problems, discussing preferences, asking for and giving advice, talking about holidays, making plans for the future. French school support tuition. We provide help to students who need support with homework in order to pass their exams. Ad hoc extra activities and grammar notes can be provided to revise and consolidate the notions acquired at school. Help with short essay writing and proof reading also available. Online French classes: The online classes are delivered via Skype and classes can be for individuals and for small groups. We can prepare you for DELF B1 (Diplôme d’études en langue Française).
These groups are for children who can already write a whole story with a beginning, middle and end. Children will enhance their writing skills, learn how to edit and improve their writing, expand their vocabulary and experiment with figurative language techniques. We will compose fiction of various genres, as well as deepening our knowledge of non-fiction text types and poetry – all in a fun and creative way! 5 children maximum fully interactive weekly 55 minute lessons qualified, expert teacher optional homework set weekly additional resources set via online classroom lesson recordings for absent students written progress reports three times per year Classes are £90 per month. Variety of times and dates available. Enquire to find out more!
CWISA training course description This CWISA course covers wireless technologies with reference to IoT. It examines from an IoT perspective how wireless works, and is an excellent introduction to IoT for the wireless engineer. Topics range from wireless technologies, RF, to mobile networks, IoT, and security. What will you learn Describe wireless networking and IoT technologies. Explain basic RF communications. Plan wireless solutions. Describe how to implement wireless solutions. Use best practices in implementing wireless solutions. CWISA training course details Who will benefit: Anyone working with IoT technologies. Prerequisites: RF fundamentals. Duration 4 days CWISA training course contents Introduction to wireless technologies History of wireless, radio waves and frequencies, wireless technologies and related components, common components of wireless solutions, LAN networking requirements, Network security, Implementing wireless solutions, staging, documentation, security updates, Industry organizations, IEEE, compatibility and certification groups. Wireless network use cases Wireless BANs, Wireless PANs, Wireless LANs, Wireless MANs, Wireless WANs, Wireless sensor networks, New network driver-Internet of Things, IoT for industry (IIoT), IoT for connected vehicles, Residential environments, Retail, Education (K12), Higher education, Agriculture, Smart cities / Public access, Health care, Office buildings, Hospitality, Industry, Stadiums, arenas, and large public venues. Planning wireless solutions Identifying use cases and applications, common wireless requirements and constraints, performing a wireless system design, selecting and evaluating design parameters. RF communications RF wave characteristics, RF propagation behaviours, RF signal metrics, fundamentals of wireless modulation. other wireless carriers, common frequency bands. Radio frequency hardware Hardware levels, basic RF hardware components (circuit board level), RF link types (use category). RF device types. Mobile communications networks Mobile networks, LTE, 5G, Use cases. Short-range, low-rate, and low-power networks RF and speed, RF and range, RF and power, 802.11, 802.15.4, Bluetooth, LoRa (Long range) / LoRaWAN, ZigBee, 6LoWPAN, NB-IoT and LTE-M. Wireless sensor networks What is a Wireless Sensor Network (WSN)? WSN applications, Sensors and actuators, WSN architectures, Planning a WSN. Internet of Things (IoT) Internet of Things (IoT) defined, IoT history and its definition revisited, one more comment on the definition of IoT, IoT verticals, Oil & Gas, IoT structure/ architecture basics, IoT connected objects. Securing wireless networks Confidentiality, integrity and availability, Privacy, non-repudiation, authenticity & safety, Importance of authentication in wireless networks, Key cryptographic technologies & concepts, Authentication methods, Authorisation, OAuth 2.0 authorisation framework, monitoring. Troubleshooting wireless solutions Proper solutions design, designing and implementing wireless solutions, basic installation procedures, general configuration considerations, troubleshooting and remediation, troubleshoot common problems in wireless solutions. Programming, scripting and automation What is an API? categories of APIs, common API communication methods, choosing a language, why are we integrating systems? Application & integration architectures. Data structures & types, XML, YAML, API types.
Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.
Build a rewarding career in content design Build a rewarding career in content design with a globally recognised, industry-approved qualification. Get the mindset, the confidence and the skills that will help you stand out in a rapidly growing industry. Why take this course: Be in demand. Certified qualifications will help you stand out in a fast-growing industry Build a career with impact. Design content experiences that will influence users worldwide Broaden your opportunities. Optimise your skills to get hired at leading companies Get qualified. Earn a university credit-rated certification approved by industry leaders Gain the confidence you need to succeed. Our mentors, career advisors and student community will support you all the way University credit-rated, industry-approved Our content design course is credit-rated by Glasgow Caledonian University and has been reviewed and endorsed by leaders in the tech industry. It covers everything you need to become a certified content design professional. Study method Online, self-paced Duration 10 weeks Access to content 12 months Qualification Professional Certificate in Content Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description In this Professional Certificate in Content Design course you will learn: An introduction to content design. Understand what content design is and the role of a content designer. Principles of good content design Learn the core principles of content design and why it matters. Voice, tone and style Learn how voice, tone, and style can create a cohesive product experience. Understanding your users Uncover your audience's goals and content needs. Writing for interfaces Learn to write microcopy for buttons, notifications and other UI elements. The product mindset Develop a product mindset by learning about product design systems and tools. Testing content Learn how to test, evaluate and improve your content. AI for content design Learn how to use AI tools to become a more effective content designer. Working in content design Learn how to be the content champion within your organisation. Support at every step From day one, you’ll be part of a lively community of tutors, mentors and fellow students that support each other along the way. Student Success team Our friendly and responsive team will help you stay on track and keep you accountable. Course mentor Your course mentor is an expert content designer who brings years of practical insight. Student community Collaborate, share tips and build connections on our lively student Slack channels. Who is this course for? Writers and journalists who want to enhance their skills for the digital world UX and UI designers who want to become more rounded professionals Content designers looking for a formal qualification that validates their expertise Digital marketers who need content design skills to succeed in their roles Anybody with a writing, content or design background looking for a creative tech job Requirements Background You don’t need experience in design or technology to enrol in our courses. To get the most value from this course, you will need some experience in writing and a genuine interest in words and language. Commitment You do need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. English language To take this course, you should be fluent in verbal and written English. If English is not your first language, you should have a proficiency of C1 as defined by the CEFRL (Common European Framework of Reference for Languages).
Windows PowerShell training course description This course is intended for IT Professionals who are already experienced in general Windows Server and Windows Client administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of Windows PowerShell, or any scripting language, is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Exchange Server, SharePoint Server, SQL Server, System Center, and others. What will you learn Work with Windows PowerShell pipeline. Query system information by using WMI and CIM. Work with variables, arrays, and hash tables. Write advanced scripts in Windows PowerShell. Administer remote computers. Use advanced Windows PowerShell techniques. Windows PowerShell training course details Who will benefit: IT professionals. Prerequisites: Supporting Windows Server Duration 5 days Windows PowerShell training course contents Getting started with Windows PowerShell Overview and background of Windows PowerShell, Understanding command syntax, Finding commands. Hands on Configuring Windows PowerShell console & ISE application. Hands on Finding and running basic commands, Using the About files. Cmdlets for administration Active Directory administration cmdlets, Network configuration cmdlets, Other server administration cmdlets. Hands on Windows Administration. Creating and managing Active Directory objects, Configuring network settings on Windows Server, Creating a web site. Working with the Windows PowerShell pipeline Understanding the pipeline, Selecting, sorting, and measuring objects, Filtering objects out of the pipeline, enumerating objects in the pipeline, Sending pipeline data as output. Hands on Using the pipeline. Selecting, sorting, and displaying data. Hands on Filtering objects. Hands on Enumerating objects. Hands on Sending output to a file. Exporting user information to a file. Understanding how the pipeline works Passing the pipeline data, Advanced considerations for pipeline data. Hands on Working with pipeline parameter binding. Predicting pipeline behaviour. Using PSProviders and PSDrives Using PSProviders, Using PSDrives. Hands on Using PSProviders and PSDrives Creating files and folders on a remote computer, Creating a registry key for your future scripts, Create a new Active Directory group. Querying system information by using WMI and CIM Understanding WMI and CIM, Querying data by using WMI and CIM, Making changes with WMI/CIM. Hands on Working with WMI and CIM. Querying information by using WMI, Querying information by using CIM, Invoking methods. Working with variables, arrays, and hash tables Manipulating variables, arrays and hash tables. Hands on Working with variables, Using arrays, Using hash tables. Basic scripting Introduction to scripting, Scripting constructs, Importing data from files. Hands on Basic scripting. Setting a script, Processing an array with a ForEach loop, Processing items by using If statements, Creating a random password, Creating users based on a CSV file. Advanced scripting Accepting user input, Overview of script documentation, Troubleshooting and error handling, Functions and modules. Hands on Accepting data from users. Querying disk information from remote computers, Updating the script to use alternate credentials, Documenting a script. Hands on Implementing functions and modules. Creating a logging function, Adding error handling to a script, Converting a function to a module. Administering Remote Computers Using basic Windows PowerShell remoting, Using advanced Windows PowerShell remoting techniques, Using PSSessions. Hands on Using basic remoting. Enabling remoting on the local computer, Performing one-to-one remoting, Performing one-to-many remoting. Hands on Using PSSessions. Using implicit remoting, Managing multiple computers. Using background jobs and scheduled jobs Using background jobs, Using scheduled jobs. Hands on Using background jobs and scheduled jobs. Starting and managing jobs, Creating a scheduled job. Using advanced Windows PowerShell techniques Creating profile scripts, Using advanced techniques. Hands on Practicing advanced techniques. Creating a profile script, Verifying the validity of an IP address, Reporting disk information, Configuring NTFS permissions, Creating user accounts with passwords from a CSV file. Hands on Practicing script development (optional)
Duration 2 Days 12 CPD hours Overview Effectively manage team dynamics in remote and virtual teams Leverage communication technologies to the benefit of your remote and virtual teams Identify the specific skills required for managing remote and virtual teams Evaluate the impact of culture and language on your team?s performance The business model of managing remote and hybrid teams is constantly evolving. Managing remote teams?a rarity just a few years ago?is now a common occurrence. Working virtually offers unique advantages and challenges. But how do you best leverage these benefits while overcoming impediments? This workshop will teach you to adjust your management style to successfully improve communication, foster connections, increase productivity, and develop remote and virtual teams. Focused on practical skills, this workshop includes activities to apply these techniques and drive results. Defining the Characteristics of the Remote and Hybrid Workforce Understanding the remote vs. hybrid workplace Managing relationships, communication, and tasks Meeting your needs and your team?s needs Management Requirements for Remote Leadership Moving from reactive to proactive Understanding team member?s unique situations Keeping everyone informed Innovating with virtual teams Managing work outputs Overseeing separated team members Defining and building relationships with stakeholders Building and Strengthening Team Dynamics Creating team identity Forming remote and virtual teams Managing the storming process Getting to norming and performing Creating and governing with ground rules Tracking team performance Setting expectations and providing feedback Making Technology Work for You Communicating with and coordinating your team Avoiding the technology trap Developing effective communication across various mediums Choosing the right technology platform The Impact of Culture and Separation Recognizing cultural characteristics and differences Building cultural knowledge Managing across time zones Respecting non-working time