Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.
Work Breakdown Structures It's amazing how often project managers begin the project planning process by making an outlined list of every task they believe will be required to complete a project and then proclaim they have created the work breakdown structure (WBS) for the project. The result is a list of hundreds, or even thousands of tasks, many of them having durations of a few days or a few hours. Essentially, what they have done is create a 'to do' list, which they then use as a 'checklist' to measure progress. This approach leads to, and even encourages, micromanagement of the resources working on the project without consideration of more critical aspects of project management such as: requirements management, risk management, procurement management, estimating, scheduling, executing, and controlling. Further, it makes it impossible to see the big picture, at levels of detail, in keeping with the needs of sponsors, clients, project and functional managers, team leaders, and project performers. Join us for this exciting program and learn how to use the WBS to make better-informed business decisions. What You Will Learn You will learn how to: Describe the need for a project WBS Describe the WBS role in the project Gain practical experience in the development, decomposition, and use of the WBS Determine the appropriate level of detail in the WBS. Explain how the WBS integrates with project requirements, risk, procurement, estimating, scheduling, and overall project execution. Provide the basic tools to enhance efficient re-use of key information in your future projects Foundation Concepts Key definitions History of the WBS Importance of the WBS Overall structure Terminology Other breakdown structures WBS tools WBS & Scope Project scope management processes Specification of the project objectives WBS design based on project deliverable WBS decomposition process and 'The 100% rule' Work Packages and Control Accounts WBS & Risk Risk management planning and WBS Risk identification to enhance the WBS Risk analysis and the WBS Risk responses and updating the WBS Implementing risk response and Monitoring risks and the WBS WBS & Estimating Use of WBS in the estimating process Components and work packages Sizing and algorithmic estimates WBS & Scheduling Component Scheduling - High-Level Milestones WBS activity decomposition WBS elements dependencies Work Package Level Schedules Responsibility assignment matrix WBS & Execution and Control Earned Value Management and tracking of work performance Progress reports, forecasts, and corrective and preventive actions used to manage work performance Necessary information to close out a project
Certified ScrumMaster®: In-House Training This course covers Scrum and the principles and tools required to be an effective ScrumMaster. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of Scrum to different situations. At the end of the course, you will receive membership to the Scrum Alliance for two years and, following completion of an online test, will become a Scrum Alliance Certified ScrumMaster®. Our Certified Scrum Trainers pay the initial, two-year membership fee for each student who successfully completes our Certified ScrumMaster® course. This membership fee also covers the cost of the CSM Test. A link to the test will be sent to you following your course. The CSM test has a passing score of 37 out of 50 questions within a 60-minute timeframe. You will have two attempts within 90 days after you receive your welcome e-mail to pass the test at no cost. After two attempts or 90 days, you will be charged $25 for each additional attempt. What you will Learn At the end of this program, you will be able to: Provide a clear understanding of the fundamental principles of Scrum Use the principles, practices, and tools required to be an effective ScrumMaster Make effective decisions regarding the application of the Scrum framework to different situations, including: Practical, project-proven practices The essentials for getting a project off on the right foot How to write user stories and structure your product backlog How to help both new and experienced teams be more successful How to successfully scale Scrum Tips and tricks from the instructor's many years of using Scrum in a wide variety of environments Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Agile Principles Lean Principles Process control models Incremental and Iterative development Shifting the focus on product management Overview of the Scrum process The Team Dedicated cross-functional teams T-shaped people Sprint Planning Team capacity Facilitating the Sprint Planning meeting The Sprint backlog Sprint Burndown chart Scrum Roles and Responsibilities The team and building effective teams ScrumMaster responsibilities Product Owner responsibilities The Scrum project community What happens to traditional roles in Scrum? Scrum Meetings Daily Scrum Reviews Retrospectives Product Backlog and User Stories Product backlog characteristics User stories Getting your first backlog Getting backlog items ready Slicing User stories Estimation for Forward Planning Why comparative estimation works Planning poker Affinity estimation Release Planning and Tracking Progress Velocity Release planning Tracking release progress Scaling Scrum Scrum of Scrums Scaling the product backlog Scaling across a program and business areas Distributed teams
Certified ScrumMaster® This course covers Scrum and the principles and tools required to be an effective ScrumMaster. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of Scrum to different situations. At the end of the course, you will receive membership to the Scrum Alliance for two years and, following completion of an online test, will become a Scrum Alliance Certified ScrumMaster®. Our Certified Scrum Trainers pay the initial, two-year membership fee for each student who successfully completes our Certified ScrumMaster® course. This membership fee also covers the cost of the CSM Test. A link to the test will be sent to you following your course. The CSM test has a passing score of 37 out of 50 questions within a 60-minute timeframe. You will have two attempts within 90 days after you receive your welcome e-mail to pass the test at no cost. After two attempts or 90 days, you will be charged $25 for each additional attempt. What you will Learn At the end of this program, you will be able to: Provide a clear understanding of the fundamental principles of Scrum Use the principles, practices, and tools required to be an effective ScrumMaster Make effective decisions regarding the application of the Scrum framework to different situations, including: Practical, project-proven practices The essentials for getting a project off on the right foot How to write user stories and structure your product backlog How to help both new and experienced teams be more successful How to successfully scale Scrum Tips and tricks from the instructor's many years of using Scrum in a wide variety of environments Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Agile Principles Lean Principles Process control models Incremental and Iterative development Shifting the focus on product management Overview of the Scrum process The Team Dedicated cross-functional teams T-shaped people Sprint Planning Team capacity Facilitating the Sprint Planning meeting The Sprint backlog Sprint Burndown chart Scrum Roles and Responsibilities The team and building effective teams ScrumMaster responsibilities Product Owner responsibilities The Scrum project community What happens to traditional roles in Scrum? Scrum Meetings Daily Scrum Reviews Retrospectives Product Backlog and User Stories Product backlog characteristics User stories Getting your first backlog Getting backlog items ready Slicing User stories Estimation for Forward Planning Why comparative estimation works Planning poker Affinity estimation Release Planning and Tracking Progress Velocity Release planning Tracking release progress Scaling Scrum Scrum of Scrums Scaling the product backlog Scaling across a program and business areas Distributed teams
SAFe® DevOps: In-House Training This course provides a comprehensive overview for understanding the DevOps skills needed to accelerate time-to-market by improving the flow of value through the Continuous Delivery Pipeline. You will map the current value stream through the delivery pipeline from idea to cash and identify practices that will eliminate bottlenecks to flow. The course will build an understanding of the complete flow of value from Continuous Exploration to Continuous Integration, Continuous Deployment, and Release on Demand. What you will Learn After attending the class, attendees should be able to: Explain how DevOps enables strategic business objectives Apply a CALMR approach to DevOps to avoid automating broken processes Understand how successful DevOps requires continuous exploration, continuous integration, continuous deployment, and the ability to release to end users on demand Incorporate continuous testing and continuous security into the delivery pipeline Use value-stream mapping to measure flow and identify bottlenecks in the end-to-end delivery process Select DevOps skills and tools strategically for the fastest, most compelling results Prioritize DevOps solutions and investments for the greatest economic benefit Design and implement a multi-phased DevOps transformation plan tailored to their organization Work with all roles and levels in the organization to continually optimize the value stream Introducing DevOps Mapping your Continuous Delivery Pipeline Gaining alignment with Continuous Exploration Building quality with Continuous Integration Reducing time-to-market with Continuous Deployment Delivering Business Value with Release on Demand Taking action
SAFe® DevOps This course provides a comprehensive overview for understanding the DevOps skills needed to accelerate time-to-market by improving the flow of value through the Continuous Delivery Pipeline. You will map the current value stream through the delivery pipeline from idea to cash and identify practices that will eliminate bottlenecks to flow. The course will build an understanding of the complete flow of value from Continuous Exploration to Continuous Integration, Continuous Deployment, and Release on Demand. What you will Learn After attending the class, attendees should be able to: Explain how DevOps enables strategic business objectives Apply a CALMR approach to DevOps to avoid automating broken processes Understand how successful DevOps requires continuous exploration, continuous integration, continuous deployment, and the ability to release to end users on demand Incorporate continuous testing and continuous security into the delivery pipeline Use value-stream mapping to measure flow and identify bottlenecks in the end-to-end delivery process Select DevOps skills and tools strategically for the fastest, most compelling results Prioritize DevOps solutions and investments for the greatest economic benefit Design and implement a multi-phased DevOps transformation plan tailored to their organization Work with all roles and levels in the organization to continually optimize the value stream Introducing DevOps Mapping your Continuous Delivery Pipeline Gaining alignment with Continuous Exploration Building quality with Continuous Integration Reducing time-to-market with Continuous Deployment Delivering Business Value with Release on Demand Taking action
Work Breakdown Structures: In-House Training It's amazing how often project managers begin the project planning process by making an outlined list of every task they believe will be required to complete a project and then proclaim they have created the work breakdown structure (WBS) for the project. The result is a list of hundreds, or even thousands of tasks, many of them having durations of a few days or a few hours. Essentially, what they have done is create a 'to do' list, which they then use as a 'checklist' to measure progress. This approach leads to, and even encourages, micromanagement of the resources working on the project without consideration of more critical aspects of project management such as: requirements management, risk management, procurement management, estimating, scheduling, executing, and controlling. Further, it makes it impossible to see the big picture, at levels of detail, in keeping with the needs of sponsors, clients, project and functional managers, team leaders, and project performers. Join us for this exciting program and learn how to use the WBS to make better-informed business decisions. What You Will Learn You will learn how to: Describe the need for a project WBS Describe the WBS role in the project Gain practical experience in the development, decomposition, and use of the WBS Determine the appropriate level of detail in the WBS. Explain how the WBS integrates with project requirements, risk, procurement, estimating, scheduling, and overall project execution. Provide the basic tools to enhance efficient re-use of key information in your future projects Foundation Concepts Key definitions History of the WBS Importance of the WBS Overall structure Terminology Other breakdown structures WBS tools WBS & Scope Project scope management processes Specification of the project objectives WBS design based on project deliverable WBS decomposition process and 'The 100% rule' Work Packages and Control Accounts WBS & Risk Risk management planning and WBS Risk identification to enhance the WBS Risk analysis and the WBS Risk responses and updating the WBS Implementing risk response and Monitoring risks and the WBS WBS & Estimating Use of WBS in the estimating process Components and work packages Sizing and algorithmic estimates WBS & Scheduling Component Scheduling - High-Level Milestones WBS activity decomposition WBS elements dependencies Work Package Level Schedules Responsibility assignment matrix WBS & Execution and Control Earned Value Management and tracking of work performance Progress reports, forecasts, and corrective and preventive actions used to manage work performance Necessary information to close out a project
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com
About this Training Course This five-day training course will cover aspects of FPSO operations with an emphasis on management of safety. A background of the methodology used to generate the various safety plans and codes used in the operational safety case will be covered. The course will also review general operational guidelines in the offshore environment to ensure that the operations are completed as designed. This will include offtake operations and maintenance processes for the plant and vessel as well as a session on subsea. Training Objectives To enable participants to obtain an in-depth understanding of FPSO operations, safety and maintenance: Provide a broad overview of how an FPSO operation is set up and established in the field Grasp the various methods used to moor the production units Analyse information and methods required to establish the operation according to local and international regulations. Assess the methods used to calculate the safety parameters and requirements to construct an approved valid safety case Explore conditions to monitor during operations with regards to safety and structure Inspect various types of hazards associated with production and produced materials Review regular and emergency operational maintenance requirements Examine cyclones and weather events causing disconnection Comprehend manning, training requirements and operations including cargo Case studies and Exercises: The training course uses real life examples and case studies to explain the setup, preparation, implementation and operational activities required to successfully complete FPSO operations from a safety and maintenance perspective. This will allow the application of participants' newly-acquired knowledge. Case studies also stimulate independent thinking and discussion among the participants. Case Studies The case studies proposed for this course will include: A group exercise to consider what is the minimum requirement for the production of a safety case Generic plan for the development of a maintenance management system using computer software systems (e.g. Amos) Construction of a UWILD plan to include scope and potential tendering requirements Quizzes The various quizzes can be expanded or arranged to suit the group/interests and topics covered but will generally include the following topics: Mooring types and location where they are primarily used Safety cases Safety management systems Process hazards and mitigation UWILD components and regulations Operations management Offtake operations Target Audience The course is generally aimed at personnel who are involved in FPSO operations as either offshore crew or onshore support team members. This course will also greatly benefit the following groups but not limited to: Process engineers Surveyors Facility engineers Naval architects Operations engineer Health, Safety, Environment (HSE) specialists and managers Maintenance engineers Course Level Intermediate Training Methods The training course is presented in an interactive workshop format that allows for discussion. The course will be delivered through analysis of case studies and running examples of problems. Course Duration: 5 days in total (35 hours) The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training comprises of information supplemented by visual activities including photographs from various operations and videos of operational and safety activities. Interaction verbally will be necessary to achieve the best learning outcome from the materials. Course timings and breaks 0830 - Registration 0900 - Start of training 1030 - Morning break 1045 - Training recommences 1230 - Lunch break 1330 - Training recommences 1515 - Afternoon break 1530 - Training recommences 1700 - End of training Trainer Your expert course leader has been involved in the Oil and Gas industry for over 28 years in several different roles commencing as a second deck officer on FPSO's and moving through the industry from deck officer to Master, OIM and Field Superintendent. He has also been in charge of semisubmersible and fixed production platforms as field superintendent before moving ashore into senior management roles. On completion of industry specific activities, he moved to teaching roles at South Tyneside Maritime College in the department of marine and simulation and presented live courses to maritime students from cadet to Master. Prior to returning to Perth in March 2019, he was training manager for a subsidiary of Gaz Transport and Technigaz of France. He has a Master Class 1 certificate with endorsements for hazardous cargoes and a Graduate Certificate in Business Administration as well as multiple course certificates required to operate FPSO's, platforms and semisubmersible facilities. He has been involved in the preparation of national standards for Safety Cases (Australia); Designing and structural setup of competency-based training systems in South East Asia. He was also involved in the development of minimum standards, competency profiles position based and preparation and implementation of training plans to ensure competency in the local staff in Asian operations. He was part of the development team for minimum standards of offshore safety in Australian offshore operations including the implementation of the Common Safety Training Program (CSTP). He was also involved in implementing training plans for both simulator and classroom based courses in LNG operations and cargo tank design and construction. Highlighted work experience: Premier Petroleum Myanmar Ltd Petronas Carigali Newfield Australia (Cartier) Pty Ltd: FPSO Jabiru Venture FPSO Challis Venture Onshore OIM Australian FPSO Management Pty. Ltd. 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
Overview This one day Building Better Work Habits training course has been developed for everyone in your organisation who may struggle with their own personal effectiveness. They may not have control of their own workload or blame others as to why they’re not achieving certain tasks and projects. Alternatively, it might be that high performers want to understand how they can organise themselves in a new way to give themselves more stretch in their roles. The training course will help the learners build self-awareness and will highlight the important parts of working smarter to achieve end goals. Description We are all busy, and sometimes it seems we do not have enough hours in the day to complete deadlines and projects. It can then eat into our home life, meaning we often end up stressed, or in worst-case scenarios, unwell (both physically and mentally). The reason behind this is often how we work day to day, as opposed to others giving us work at the last minute. These training course materials have been designed to help your participants work more effectively for the long term. This isn’t about how to manage a diary or emails, but rather look closely to see what are the blockers which get in the way of success. These small changes in day to day work will have a dramatic impact in both productivity and personal effectiveness. Topics covered: Productivity: the science bit – A chance to explore what we mean by being productive and how that helps us build better work habits, as well as the opportunity to look at some of the science behind myths and bad habits we’ve probably already formed. Includes a link to a YouTube video. Procrastination, why put off to tomorrow what we can do today! – Participants will explore what we procrastinate about, how we procrastinate in our own lives, and what we can do about it! Eat That Frog – An introduction to Brian Tracy’s book “Eat that frog” and how it can help us improve our working habits. Includes a link to a YouTube video. Eat That Frog: Thinking on Paper – A chance to put into practice some of Brian Tracy’s methods and how to use them in our real lives Eat That Frog: Rocks, Pebbles and Sand – Taking our goal setting further, we explore Covey’s methodology around prioritising our tasks. Eat That Frog: The Pareto Principle – The final part of the “Eat that Frog” section looks at how effective we in terms of how we spend our day Prioritising: how do we spend our day? – Participants explore how proactive they are, and what the danger might be in letting a situation rule their time Prioritising: The Priority Matrix – Taking the Rock, Pebbles and Sand methodology further, participants explore what truly is urgent and what is important in our day to day Prioritising: Company Performance Tensions – We may know what our own personal objectives are, however, our business objectives have certain tensions that could impact these. How can we balance these two different objectives to ensure we’re successful day to day? What’s my mindset? – Sometimes we can get in the way of our own successes and plans due to our mindset; utilising Carol Dweck’s work, it is a chance to reflect on our own mindsets when we’re building new work habits. Includes a link to a YouTube video. What’s my mindset? Energy Cycles – Our energy can impact our mindset and how productive we are. A chance to look at what gives us energy, and how we can work more effectively depending on where our energy levels might be Who should attend Anyone interested in understanding in being more effective at work. Requirements for Attendees None.