Name: Petroleum Geochemistry in Petroleum Exploration
Price: 2399 GBP
Availability: InStock

Redhill

<h3>MySQL for developers training course description</h3>
 This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. 
 
				<h5>What will you learn</h5>
				<ul>
				 
 <li>Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database.</li>
<li>Use advanced features of the MySQL Client.</li>
<li>Use advanced data types.</li>
<li>Manage the structure of databases and tables.</li>
<li>Manage and using indexes.</li>
<li>Write complex SQL query statements.</li>
<li>Use advanced SQL expressions.</li>
<li>Use advanced SQL functions.</li>
<li>Perform advanced Insert, Update, Delete, Replace and Truncate Operations.</li>
<li>Use user variable syntax and properties.</li>
<li>Import and export data from within MySQL.</li>
<li>Import and export data from the command line.</li>
<li>Perform complex joins to access multiple tables.</li>
<li>Perform complex subqueries.</li>
<li>Create, manage and us views.</li>
<li>Use prepared statements.</li>
<li>Create and use stored routines.</li>
<li>Create and use triggers.</li>
<li>Obtain database metadata.</li>
<li>Optimize queries.</li>
<li>Work with the main storage engines.</li>
<li>Debug MySQL applications.</li>

 </ul>
 <h5>
 MySQL for developers training course details </h5>
				<div>
					<div>
						<ul>
							<li> Who will benefit: </li>
							
 MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course.
 
							<li>Prerequisites:</li>
							
							MySQL foundation 
 
							<li>Duration</li>
							
 5 days
 
							
 
 
						</ul>
					</div>
				</div>
 <h3>MySQL for developers training course contents</h3>
 <ul>
 <li>Introduction </li>
Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions.

<li>Client/server concepts </li>
MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options
 Hands on Using client/server

<li>The MySQL client program </li>
Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities.
 Hands on Using the MySQL client program

<li>Data types </li>
Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options.
 Hands on Using data types 

<li>Identifiers </li>
Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names
 Hands on Using identifiers

<li>Databases </li>
Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command
 Hands on Using databases

<li>Tables and indexes </li>
Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata.
 Hands on Creating, altering and dropping tables/indexes

<li>Querying for data </li>
The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause.
 Hands on Querying for data

<li>SQL Expressions and functions </li>
Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions.
 Hands on Using expressions and functions

<li>Updating data </li>
Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements.
Exercise: Inserting, updating, replacing and deleting data

<li>Connectors 	</li>
MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached.

<li>Obtaining database metadata </li>
What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage.
 Hands on Obtaining database metadata

<li>Debugging 	</li>
Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility.
 Hands on Debugging

<li>Joins </li>
Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another.
 Hands on Coding joins

<li>Subqueries 	</li>
Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes.
 Hands on Coding subqueries

<li>Views </li>
Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views.
 Hands on Using views

<li>Import and Export </li>
Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options.
 Hands on Importing and exporting

<li>User variables and prepared statements </li>
Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors.
 Hands on Using variables and prepared statements

<li>Introduction to stored routines </li>
Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security.
 Hands on Writing simple stored routines

<li>Stored routines - program logic </li>
The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops.
 Hands on Writing stored routines with program logic

<li>Stored routines - exception handlers and cursors </li>
Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking.
 Hands on Writing stored routines with program logic

<li>Procedures with parameters </li>
Creating procedures with parameters, Calling Procedures With Parameters.
 Hands on Writing stored routines with parameters

<li>Functions 	</li>
What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses.
 Hands on Writing functions

<li>Triggers </li>
Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges.
 Hands on Writing triggers

<li>Basic optimizations </li>
Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization.
 Hands on Making use of basic optimizations

<li>More about indexes </li>
Indexes and joins
 Hands on Investigating indexes and joins
				
 </ul>

Systems & Network Training

Network & Security

Network Engineer

MySQL for developers

General Admission

Kuala Lumpur

<section style="color: rgb(33, 37, 41); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(33, 37, 41);"><h2 style="color: rgb(62, 57, 52); box-sizing: border-box;" fr-original-style=" color: rgb(62, 57, 52);">About this Training Course</h2>This 5-day advanced level course focuses on the methods and applications of petroleum geochemistry for source rock, maturity, and fluids (oil and gas) evaluation.The course will equip the participants with key guidelines on source rock evaluation to determine the type of organofacies and deposition environment, maturity, as well as predict the variety and quality of hydrocarbons that have been generated from each type of source rock. It also provides guidelines on how to characterise subsurface fluids, including oil condensate and gas; refine petroleum systems, and predict fluids quality.The lectures and exercises are designed to improve the participants&rsquo; understanding on how to characterise source rocks and fluids, using bulk, molecular and isotopic tools that facilitate their understanding. Some examples of topics include source rock screening analysis, optical (maturity) analysis, gas chromatography (GC), gas chromatography-mass spectrometry (GC-MS), biomarkers, isotopes and chemometrics to identify oil families, perform oil-oil and oil-source rock correlations. The exercises will illustrate how geochemistry can be used to assist explorationists in the de-risking block and basin petroleum evaluation.</section><section style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><a data-toggle="collapse" href="https://petroedgeasia.net/training/petroleum-geochemistry-in-petroleum-exploration/#collapseOne" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINING OBJECTIVES</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">Upon completion of this course, the participants will be able to:<ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Understand the fundamentals of source rock, oil, and gas geochemical analysis, including their interpretive pitfalls.</li><li fr-original-style="" style="box-sizing: border-box;">Discuss various geochemical techniques, e.g. sampling, preparation, TOC determination, Rock-Eval pyrolysis and microscopy, including interpretive pitfalls.</li><li fr-original-style="" style="box-sizing: border-box;">Understand how to interpret source rock data, including source rock richness, potential and type, and how to distinguish between different types of source rocks, their kinetics and quality (e.g. oil- versus gas- prone source rocks).</li><li fr-original-style="" style="box-sizing: border-box;">Explain what type and quality of hydrocarbons can be predicted from each type of source rock.</li><li fr-original-style="" style="box-sizing: border-box;">Learn the different maturity tools used in geochemistry and how to interpret and use maturity data to evaluate thermal history of source rocks and calibrate thermal history of sedimentary basins.</li><li fr-original-style="" style="box-sizing: border-box;">Examine the different geochemical techniques used for the fluids (oil and gas samples), including interpretive pitfalls.</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to perform oil-oil and oil-source rock correlations.</li><li fr-original-style="" style="box-sizing: border-box;">Understand how to assess post-migration fluid alterations (e.g., evaporative fractionation, biodegradation, geo-chromatography, and other reservoir alteration processes).</li><li fr-original-style="" style="box-sizing: border-box;">Develop an understanding on how gas samples can be evaluated.</li><li fr-original-style="" style="box-sizing: border-box;">Demonstrate how geochemistry can be used to assist explorationists in their de-risking block and basin petroleum evaluation.</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/petroleum-geochemistry-in-petroleum-exploration/#collapseTwo" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TARGET AUDIENCE</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">The course is designed for geochemists, geologists, exploration geologists and petroleum systems analysts but could also benefit engineers, project coordinators and managers who would like to apply this branch of petroleum geology to prospect appraisal, exploration, and field development.PrerequisitesThe participants should have knowledge of basic chemistry and geology. Experience in exploration will also be useful.</div><a data-toggle="collapse" href="https://petroedgeasia.net/training/petroleum-geochemistry-in-petroleum-exploration/#collapsecl" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">COURSE LEVEL</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Intermediate</li></ul></div><a data-toggle="collapse" href="https://petroedgeasia.net/training/petroleum-geochemistry-in-petroleum-exploration/#collapseFive" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">TRAINER</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">Your Expert Course Instructor is a Petroleum Geochemist with over 32 years of professional experience in the oil and gas industry. He is an expert on petroleum geochemistry for exploration and production development strategies. He is skilled in geochemical interpretation and specializes in the integration of all types of geochemical data from source rocks and fluids (oil and gas), having delivered training courses to many operators and service companies worldwide.Between 2011 and 2020, he worked for Fugro-Robertson and CGG UK Services (Robertson) as Chief Geochemist and Senior Geochemical Advisor. Prior to that, Your Expert Course Instructorwas Senior Geochemist with Fugro-Robertson for over five years. He worked extensively on a variety of single and multi-disciplinary projects worldwide, including the North Sea UK and Norway, Gulf of Mexico, Belize, Guatemala, Honduras, the North and South Atlantic margins, North and East Africa, the Middle East, Pakistan, India, Thailand, Mongolia, Australia and New Zealand.He started his career as a Petroleum Geochemist, working for Sonatrach, focusing on the major Paleozoic basins (Berkine, Illizi, Oued Mya, Tindouf, Bechar), across the Saharan platform in Algeria.He developed and maintained a high quality and competitive geochemistry business during his employment with Fugro-Robertson and CGG UK Services. He oversaw the petroleum geochemistry discipline and was responsible for sustaining business development and project management. He was also involved in the development of workflows, innovation, data quality control (QC), mentoring and training internal and external staff, project supervision, and technical / peer review for all the geochemical projects. Currently, he is a Principal Consultant.He holds MSc and PhD degrees in Petroleum Geochemistry and was a graduate of the University of Newcastle Upon Tyne, United Kingdom. He is the author of several publications and has been invited to present his findings and research at international meetings.</div><a data-toggle="collapse" href="https://petroedgeasia.net/training/petroleum-geochemistry-in-petroleum-exploration/#collapseCS" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);">POST TRAINING COACHING SUPPORT (OPTIONAL)</a><div data-parent="#accordion" fr-original-style="" style="box-sizing: border-box;">To further optimise your learning experience from our courses, we also offer individualized &ldquo;One to One&rdquo; 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. <a href="mailto:info@asiaedge.net?subject=Request%20for%20further%20information%20regarding%20post%20training%20coaching%20support" target="_blank" rel="noopener" style="color: rgb(0, 123, 255); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(0, 123, 255);">Request for further information about post training coaching support</a>&nbsp;and fees applicable for this.</div></section>

EnergyEdge - Training for a Sustainable Energy Future

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

Educators providing Courses in Edinburgh

Courses matching "alterations"

MySQL for developers

By Systems & Network Training

Petroleum Geochemistry in Petroleum Exploration

By EnergyEdge - Training for a Sustainable Energy Future

Search By Location