Search our courses

Data Technologies Training

Training courses and workshops delivered by industry experts, courses include Big Data, Applied Data Science, Data Analytics, NoSQL, Hadoop, GDPR, SQL Fundamentals and MySQL.

Our Data training courses can be customised to suit your team’s current skill level and key business objectives. See below or why not Contact Us if you wish to have a bespoke course for your team.

DOWNLOAD OUR eBROCHURE

 

 

AWS

Upcoming schedule: Dublin, Monday 09 December 2019 at 09:00 to Tuesday 10 December 2019 at 17:00 - (Duration: 2 days)

This AWS Advanced Analytics for Structured Data 2 day course provides a technical introduction to the understanding, creation and digital data supply chains for advanced analytics with AWS.

 

In the classroom In the Private Training
Code: GTBD10 Duration: 2 Day

Big Data

Upcoming schedule: Dublin, Monday 09 December 2019 at 09:00 to Tuesday 10 December 2019 at 17:00 - (Duration: 2 days)

This AWS Advanced Analytics for Structured Data 2 day course provides a technical introduction to the understanding, creation and digital data supply chains for advanced analytics with AWS.

 

In the classroom In the Private Training
Code: GTBD10 Duration: 2 Day

This Hadoop Programming on the Hortonworks Data Platform training course introduces the students to Apache Hadoop and key Hadoop ecosystem projects: Pig, Hive, Sqoop, Oozie, HBase, and Spark.

This intensive training course uses lectures and hands-on labs that help students learn theoretical knowledge and gain practical experience of Apache Hadoop and related Apache projects.

In the Private Training
Code: GTBD3H Duration: 5 Days

Starting with the basics, Applied Unsupervised Learning with R explains clustering methods, distribution analysis, data encoders, and features of R that enable you to understand your data better and get answers to your most pressing business questions. 

This course begins with the most important and commonly used method for unsupervised learning - clustering - and explains the three main clustering algorithms - k-means, divisive, and agglomerative. Following this, you’ll study market basket analysis, kernel density estimation, principal component analysis, and anomaly detection. By working through interesting activities, you’ll explore data encoders and latent variable models.

In the Private Training
Code: GTDULR Duration: 2 Days

New course content will be here shortly.

In the Private Training
Code: GTBDSP Duration: 2 Day

This Database Design training course introduces a process for effectively planning and designing a functional, efficient database. Knowing how to plan a relational database is important to the success of the databases you create. Without planning, you cannot possibly know what the database needs to do, or even what information to include in the database. Planning a database is essential and prevents the extra work of fixing data maintenance problems later on.

In the Private Training
Code: GTDDD Duration: 1 Day

The Big Data Foundation certification (BDF) is designed to provide you with hands-on experience in using two of the most popular technologies in Big Data processing – Hadoop and MongoDB. You will get the opportunity to practice installing these two technologies through lab exercises. The exercises expose you to real-life Big Data technologies with the purpose of obtaining results from real datasets from Twitter. This Big Data Foundation Certification training course is designed to provide candidates with a well-rounded understanding of big data. It covers the potential data sources that can be used for solving real business problems and an overview of data mining and the tools used in it. 

In the Private Training
Code: GTBD4 Duration: 2 Days Accreditation: CCC Big Data Foundation Certification

Data Science for Marketing Analytics training course covers every stage of data analytics, from working with a raw dataset to segmenting a population and modeling different parts of the population based on the segments.The course starts by teaching you how to use Python libraries, such as pandas and Matplotlib, to read data from Python, manipulate it, and create plots, using both categorical and continuous variables. Then, you’ll learn how to segment a population into groups and use different clustering techniques to evaluate customer segmentation.

In the Private Training
Code: GTDSMA Duration: 3 Days

Processing big data in real time is challenging due to scalability, information inconsistency, and fault tolerance. Big Data Analysis with Python teaches you how to use tools that can control this data avalanche for you. In this course, you’ll learn practical techniques to aggregate data into useful dimensions for posterior analysis, extract statistical measurements, and transform datasets into features for other systems.

In the Private Training
Code: GTDBDAP Duration: 2 Days

Data is one of the most valuable assets that your organization possesses.  Every day you are creating more data and potentially passing up opportunities to harvest that data and use it to accelerate the achievement of your organization’s strategic objectives.  Big Data and Analytics represent an emerging trend around harvesting, analyzing, and capitalizing on the wealth of data that is within the grasp of your enterprise. This Big Data and Analytics for Business Users training course introduces Cloud Computing, Big Data, and the emerging discipline of Data Analytics.  Attention will be given to the three V’s of Big Data: Volume, Velocity, and Variety as well as the fourth V of Value.

In the Private Training
Code: GTBD9 Duration: 1 Day

Upcoming schedule: Dublin, Tuesday 17 December 2019 at 09:00 to Wednesday 18 December 2019 at 17:00 - (Duration: 2 days)

Public Courses coming soon to Stockholm, Copenhagen and Oslo - Register Your Interest here

This Data Science with Python training course provides theoretical and practical aspects of using Python in the realm of Data Science, Business Analytics, and Data Logistics. The coverage of the related core concepts, terminology, and theory is provided as well. This intensive training course is supplemented by a variety of hands-on labs (the list of which is provided at the bottom of this outline) that help attendees reinforce their theoretical knowledge of the learned material.

In the Private Training
Code: GTBDP1 Duration: 2 Day

Over the past few years, R has been steadily gaining popularity with business analysts, statisticians and data scientists as a tool of choice for conducting statistical analysis of data as well as supervised and unsupervised machine learning.
This intensive R Programming Introduction training course helps students learn the practical aspects of the R programming language. The course is supplemented by many hands-on labs which allow attendees to immediately apply their theoretical knowledge in practice.

In the Private Training
Code: GTR1 Duration: 2 Days

Success of many organizations depends on their ability to derive business insights from massive amount of raw data coming from various sources.

This Spark Fundamentals training course offers many engineering improvements over the traditional MapReduce programming model as implemented in Hadoop by providing multi-pass in-memory processing of data which boosts the overall performance of your ETL and machine-learning algorithms.

In the Private Training
Code: GTBDSF Duration: 3 Days

This Applied Data Science and Big Data Analytics intensive training course provides theoretical and technical aspects of Data Science and Business Analytics.  The course covers the fundamental and advanced concepts and methods of deriving business insights from big” and/or “small” data.  This training course is supplemented by hands-on labs that help attendees reinforce their theoretical knowledge of the learned material.

In the Private Training
Code: GTBD7 Duration: 4 Days

This Introduction to Big Data and NoSQL training course provides an introduction to Big Data as well as NoSQL (Not Only SQL) database systems. The fundamental concepts of and ideas behind Big Data / NoSQL technologies are methodically explored and many buzzwords demystified. The course is supplemented by hands-on labs that help attendees reinforce their theoretical knowledge of the subject.

In the Private Training
Code: GTBD1 Duration: 1 Day

Applied Data Visualization with R training course and GGPLOT2 is an open-source package for the R programming language that employs the concept of the Grammar of Graphics to help users build complex and aesthetic visualizations.This course begins by introducing you to basic concepts, such as the Grammar of Graphics and geometric objects. It then goes on to explain these concepts in detail with examples. Once you are comfortable with basics, you can learn all about the advanced plotting techniques, such as box plots and density plots. With this course, you can transform data into useful material and make data analysis interesting and fun.This course perfectly balances theory and exercises. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context.

In the Private Training
Code: GTDDVR Duration: 1 Day

Big Data Certifications

The Big Data Foundation certification (BDF) is designed to provide you with hands-on experience in using two of the most popular technologies in Big Data processing – Hadoop and MongoDB. You will get the opportunity to practice installing these two technologies through lab exercises. The exercises expose you to real-life Big Data technologies with the purpose of obtaining results from real datasets from Twitter. This Big Data Foundation Certification training course is designed to provide candidates with a well-rounded understanding of big data. It covers the potential data sources that can be used for solving real business problems and an overview of data mining and the tools used in it. 

In the Private Training
Code: GTBD4 Duration: 2 Days Accreditation: CCC Big Data Foundation Certification

Data Science

Starting with the basics, Applied Unsupervised Learning with R explains clustering methods, distribution analysis, data encoders, and features of R that enable you to understand your data better and get answers to your most pressing business questions. 

This course begins with the most important and commonly used method for unsupervised learning - clustering - and explains the three main clustering algorithms - k-means, divisive, and agglomerative. Following this, you’ll study market basket analysis, kernel density estimation, principal component analysis, and anomaly detection. By working through interesting activities, you’ll explore data encoders and latent variable models.

In the Private Training
Code: GTDULR Duration: 2 Days

This Data Science for Solution Architects training course helps Solution Architects and other IT practitioners understand the value proposition, methodology and techniques of the emerging discipline of Data Science.  The class also introduces the students to a number of existing production-ready technologies and capabilities that enable enterprises to build cost-efficient Big Data processing solutions.

In the Private Training
Code: GTBD8 Duration: 4 Days

Data Science Projects with Python training course is designed to give you practical guidance on industry-standard data analysis and machine learning tools in Python, with the help of realistic data. The course will help you understand how you can use pandas and Matplotlib to critically examine a dataset with summary statistics and graphs, and extract the insights you seek to derive. You will continue to build on your knowledge as you learn how to prepare data and feed it to machine learning algorithms, such as regularized logistic regression and random forest, using the scikit-learn package. You’ll discover how to tune the algorithms to provide the best predictions on new and, unseen data.

In the Private Training
Code: GTDSPP Duration: 2 Days

Data Science for Marketing Analytics training course covers every stage of data analytics, from working with a raw dataset to segmenting a population and modeling different parts of the population based on the segments.The course starts by teaching you how to use Python libraries, such as pandas and Matplotlib, to read data from Python, manipulate it, and create plots, using both categorical and continuous variables. Then, you’ll learn how to segment a population into groups and use different clustering techniques to evaluate customer segmentation.

In the Private Training
Code: GTDSMA Duration: 3 Days

Upcoming schedule: Dublin, Monday 09 December 2019 at 09:00 to Tuesday 10 December 2019 at 17:00 - (Duration: 2 days)

This AWS Advanced Analytics for Structured Data 2 day course provides a technical introduction to the understanding, creation and digital data supply chains for advanced analytics with AWS.

 

In the classroom In the Private Training
Code: GTBD10 Duration: 2 Day

Upcoming schedule: Dublin, Tuesday 17 December 2019 at 09:00 to Wednesday 18 December 2019 at 17:00 - (Duration: 2 days)

Public Courses coming soon to Stockholm, Copenhagen and Oslo - Register Your Interest here

This Data Science with Python training course provides theoretical and practical aspects of using Python in the realm of Data Science, Business Analytics, and Data Logistics. The coverage of the related core concepts, terminology, and theory is provided as well. This intensive training course is supplemented by a variety of hands-on labs (the list of which is provided at the bottom of this outline) that help attendees reinforce their theoretical knowledge of the learned material.

In the Private Training
Code: GTBDP1 Duration: 2 Day

This Applied Data Science and Big Data Analytics intensive training course provides theoretical and technical aspects of Data Science and Business Analytics.  The course covers the fundamental and advanced concepts and methods of deriving business insights from big” and/or “small” data.  This training course is supplemented by hands-on labs that help attendees reinforce their theoretical knowledge of the learned material.

In the Private Training
Code: GTBD7 Duration: 4 Days

Over the past few years, R has been steadily gaining popularity with business analysts, statisticians and data scientists as a tool of choice for conducting statistical analysis of data as well as supervised and unsupervised machine learning.
This intensive R Programming Introduction training course helps students learn the practical aspects of the R programming language. The course is supplemented by many hands-on labs which allow attendees to immediately apply their theoretical knowledge in practice.

In the Private Training
Code: GTR1 Duration: 2 Days

GDPR

The EU General Data Protection Regulation (GDPR) is new legislation that provides a single, harmonised data privacy law for the European Union. The GDPR will replace the current Directive and will be directly applicable from 25 May 2018 in all Member States. The GDPR will affect every organisation that processes EU residents' personally identifiable information (PII). The EU General Data Protection Regulation (GDPR) training course also imposes obligations on companies to not only document and safeguard information on identifiable living persons but companies must also be able to evidence compliance
With the increasing risk of data breaches and cyber-attacks, the GDPR aims to prevent the loss of personal data by improving data security for all individuals living in EU member states.

In the Private Training
Code: GTGDPR Duration: 1 Day Intensive Workshop

Hadoop

This Hadoop Programming on the Hortonworks Data Platform training course introduces the students to Apache Hadoop and key Hadoop ecosystem projects: Pig, Hive, Sqoop, Oozie, HBase, and Spark.

This intensive training course uses lectures and hands-on labs that help students learn theoretical knowledge and gain practical experience of Apache Hadoop and related Apache projects.

In the Private Training
Code: GTBD3H Duration: 5 Days

This Apache Hadoop Training Hadoop Programming on the Cloudera Platform training course introduces the students to Apache Hadoop and key Hadoop ecosystem projects: Pig, Hive, Sqoop, Impala, Oozie, HBase, and Spark.

This intensive training course uses lectures and hands-on labs that help students learn theoretical knowledge and gain practical experience of Apache Hadoop and related Apache projects.

 

In the Private Training
Code: GTAH1 Duration: 5 Days

This Apache Hadoop for Systems Administrators training course covers the essentials of deploying and managing an Apache™ Hadoop® cluster. The course is lab intensive with each participant creating their own Hadoop cluster using either the CDH (Cloudera's Distribution, including Apache Hadoop) or Hortonworks Data Platform stacks. Core Hadoop services are explored in depth with emphasis on troubleshooting and recovering from common cluster failures. The fundamentals of related services such as Ambari, Zookeeper, Pig, Hive, HBase, Sqoop, Flume, and Oozie are also covered. The course is approximately 60% lecture and 40% labs.

In the Private Training
Code: GTBD2 Duration: 3 Days

LAMP

MySQL Administration and Development training course is the open source community’s most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs.  This course covers MySQL 5.0.

In the Private Training
Code: GTLP7 Duration: 4 Days

This MySQL Administration training course teaches the configuration, security management, administration, backup and restore, and optimization of MySQL databases.

In the Private Training
Code: GTLP6 Duration: 3 Days

In this PHP and MySQL training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.

In the Private Training
Code: GTLP2 Duration: 5 Days

MS SQL Server

Upcoming schedule: Cork, Monday 16 December 2019 at 09:00 to Tuesday 17 December 2019 at 17:00 - (Duration: 2 days)

This instructor-led 2-day SQL Fundamentals training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

In the Private Training
Code: GTPL72 Duration: 2 Days

MySQL

This MySQL Administration training course teaches the configuration, security management, administration, backup and restore, and optimization of MySQL databases.

In the Private Training
Code: GTLP6 Duration: 3 Days

MySQL Administration and Development training course is the open source community’s most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs.  This course covers MySQL 5.0.

In the Private Training
Code: GTLP7 Duration: 4 Days

In this PHP and MySQL training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.

In the Private Training
Code: GTLP2 Duration: 5 Days

New

Data Science Projects with Python training course is designed to give you practical guidance on industry-standard data analysis and machine learning tools in Python, with the help of realistic data. The course will help you understand how you can use pandas and Matplotlib to critically examine a dataset with summary statistics and graphs, and extract the insights you seek to derive. You will continue to build on your knowledge as you learn how to prepare data and feed it to machine learning algorithms, such as regularized logistic regression and random forest, using the scikit-learn package. You’ll discover how to tune the algorithms to provide the best predictions on new and, unseen data.

In the Private Training
Code: GTDSPP Duration: 2 Days

Data Science for Marketing Analytics training course covers every stage of data analytics, from working with a raw dataset to segmenting a population and modeling different parts of the population based on the segments.The course starts by teaching you how to use Python libraries, such as pandas and Matplotlib, to read data from Python, manipulate it, and create plots, using both categorical and continuous variables. Then, you’ll learn how to segment a population into groups and use different clustering techniques to evaluate customer segmentation.

In the Private Training
Code: GTDSMA Duration: 3 Days

The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. This Microsoft® Power BI® Data Analysis Professional training course software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

In the Private Training
Code: GTDBIA Duration: 2 Days

New course content will be here shortly.

In the Private Training
Code: GTBDSP Duration: 2 Day

This Predictive Analytics Educational Hack training course covers the four steps of the Pathway to Predictive Analytics and culminates, on the Friday, with a day long hack, combining everything you’ve learned in order to solve a predictive analytics problem. Each group will then present their methodology and findings to the class.

In the Private Training
Code: GTPAEH Duration: 5 Days

This Pathway to Predictive Analytics – Step 2 Statistics training course, classroom and lab based training, expands upon the foundational training to introduce you to the world of predictive analytics via statistics.

In the Private Training
Code: GTPPA Duration: 1 Day

This Predictive Analytics Landscape training course is a level set for executives, managers and business owners, who need to understand the impact that Artificial Intelligence, Machine Learning and Predictive Analytics will have on their business.

In the Private Training
Code: GTPAL Duration: 1 Day

Upcoming schedule: Dublin, Monday 09 December 2019 at 09:00 to Tuesday 10 December 2019 at 17:00 - (Duration: 2 days)

This AWS Advanced Analytics for Structured Data 2 day course provides a technical introduction to the understanding, creation and digital data supply chains for advanced analytics with AWS.

 

In the classroom In the Private Training
Code: GTBD10 Duration: 2 Day

Starting with the basics, Applied Unsupervised Learning with R explains clustering methods, distribution analysis, data encoders, and features of R that enable you to understand your data better and get answers to your most pressing business questions. 

This course begins with the most important and commonly used method for unsupervised learning - clustering - and explains the three main clustering algorithms - k-means, divisive, and agglomerative. Following this, you’ll study market basket analysis, kernel density estimation, principal component analysis, and anomaly detection. By working through interesting activities, you’ll explore data encoders and latent variable models.

In the Private Training
Code: GTDULR Duration: 2 Days

This Database Design training course introduces a process for effectively planning and designing a functional, efficient database. Knowing how to plan a relational database is important to the success of the databases you create. Without planning, you cannot possibly know what the database needs to do, or even what information to include in the database. Planning a database is essential and prevents the extra work of fixing data maintenance problems later on.

In the Private Training
Code: GTDDD Duration: 1 Day

This Pathway to Predictive Analytics Foundation Step 1 Foundation training course combines classroom and lab based exercises that will give you all the foundational knowledge you need to start your predictive analytics journey.

In the Private Training
Code: GTPAF Duration: 1 Day

Applied Data Visualization with R training course and GGPLOT2 is an open-source package for the R programming language that employs the concept of the Grammar of Graphics to help users build complex and aesthetic visualizations.This course begins by introducing you to basic concepts, such as the Grammar of Graphics and geometric objects. It then goes on to explain these concepts in detail with examples. Once you are comfortable with basics, you can learn all about the advanced plotting techniques, such as box plots and density plots. With this course, you can transform data into useful material and make data analysis interesting and fun.This course perfectly balances theory and exercises. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context.

In the Private Training
Code: GTDDVR Duration: 1 Day

Upcoming schedule: Dublin, Tuesday 17 December 2019 at 09:00 to Wednesday 18 December 2019 at 17:00 - (Duration: 2 days)

Public Courses coming soon to Stockholm, Copenhagen and Oslo - Register Your Interest here

This Data Science with Python training course provides theoretical and practical aspects of using Python in the realm of Data Science, Business Analytics, and Data Logistics. The coverage of the related core concepts, terminology, and theory is provided as well. This intensive training course is supplemented by a variety of hands-on labs (the list of which is provided at the bottom of this outline) that help attendees reinforce their theoretical knowledge of the learned material.

In the Private Training
Code: GTBDP1 Duration: 2 Day

Expanding on the Step 2 training, this classroom and labs based session introduces you to the world of Machine Learning.

In the Private Training
Code: GTPPA3 Duration: 1 Day

Expanding on the Step 3 training, this classroom and labs based session introduces you to the world of Deep Learning.

In the Private Training
Code: GTPPA4 Duration: 1 Day

Predictive Analytics

This Predictive Analytics Landscape training course is a level set for executives, managers and business owners, who need to understand the impact that Artificial Intelligence, Machine Learning and Predictive Analytics will have on their business.

In the Private Training
Code: GTPAL Duration: 1 Day

This Pathway to Predictive Analytics Foundation Step 1 Foundation training course combines classroom and lab based exercises that will give you all the foundational knowledge you need to start your predictive analytics journey.

In the Private Training
Code: GTPAF Duration: 1 Day

This Predictive Analytics Educational Hack training course covers the four steps of the Pathway to Predictive Analytics and culminates, on the Friday, with a day long hack, combining everything you’ve learned in order to solve a predictive analytics problem. Each group will then present their methodology and findings to the class.

In the Private Training
Code: GTPAEH Duration: 5 Days

Expanding on the Step 3 training, this classroom and labs based session introduces you to the world of Deep Learning.

In the Private Training
Code: GTPPA4 Duration: 1 Day

This Pathway to Predictive Analytics – Step 2 Statistics training course, classroom and lab based training, expands upon the foundational training to introduce you to the world of predictive analytics via statistics.

In the Private Training
Code: GTPPA Duration: 1 Day

Expanding on the Step 2 training, this classroom and labs based session introduces you to the world of Machine Learning.

In the Private Training
Code: GTPPA3 Duration: 1 Day

Python

Data Science Projects with Python training course is designed to give you practical guidance on industry-standard data analysis and machine learning tools in Python, with the help of realistic data. The course will help you understand how you can use pandas and Matplotlib to critically examine a dataset with summary statistics and graphs, and extract the insights you seek to derive. You will continue to build on your knowledge as you learn how to prepare data and feed it to machine learning algorithms, such as regularized logistic regression and random forest, using the scikit-learn package. You’ll discover how to tune the algorithms to provide the best predictions on new and, unseen data.

In the Private Training
Code: GTDSPP Duration: 2 Days

Upcoming schedule: Dublin, Tuesday 17 December 2019 at 09:00 to Wednesday 18 December 2019 at 17:00 - (Duration: 2 days)

Public Courses coming soon to Stockholm, Copenhagen and Oslo - Register Your Interest here

This Data Science with Python training course provides theoretical and practical aspects of using Python in the realm of Data Science, Business Analytics, and Data Logistics. The coverage of the related core concepts, terminology, and theory is provided as well. This intensive training course is supplemented by a variety of hands-on labs (the list of which is provided at the bottom of this outline) that help attendees reinforce their theoretical knowledge of the learned material.

In the Private Training
Code: GTBDP1 Duration: 2 Day

This Data Wrangling with Python training course starts with the absolute basics of Python, focusing mainly on data structures. It then delves into the fundamental tools of data wrangling like NumPy and Pandas libraries. You’ll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python. This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you’ll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool.  The course will further help you grasp concepts through real-world examples and datasets.

In the Private Training
Code: GTDDWP Duration: 2 Days

This Data Wrangling with Python training course starts with the absolute basics of Python, focusing mainly on data structures. It then delves into the fundamental tools of data wrangling like NumPy and Pandas libraries. You’ll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python. This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you’ll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool.  The course will further help you grasp concepts through real-world examples and datasets.

In the Private Training
Code: GTDDWP Duration: 2 Days

Processing big data in real time is challenging due to scalability, information inconsistency, and fault tolerance. Big Data Analysis with Python teaches you how to use tools that can control this data avalanche for you. In this course, you’ll learn practical techniques to aggregate data into useful dimensions for posterior analysis, extract statistical measurements, and transform datasets into features for other systems.

In the Private Training
Code: GTDBDAP Duration: 2 Days

Processing big data in real time is challenging due to scalability, information inconsistency, and fault tolerance. Big Data Analysis with Python teaches you how to use tools that can control this data avalanche for you. In this course, you’ll learn practical techniques to aggregate data into useful dimensions for posterior analysis, extract statistical measurements, and transform datasets into features for other systems.

In the Private Training
Code: GTDBDAP Duration: 2 Days

Data Science Projects with Python training course is designed to give you practical guidance on industry-standard data analysis and machine learning tools in Python, with the help of realistic data. The course will help you understand how you can use pandas and Matplotlib to critically examine a dataset with summary statistics and graphs, and extract the insights you seek to derive. You will continue to build on your knowledge as you learn how to prepare data and feed it to machine learning algorithms, such as regularized logistic regression and random forest, using the scikit-learn package. You’ll discover how to tune the algorithms to provide the best predictions on new and, unseen data.

In the Private Training
Code: GTDSPP Duration: 2 Days

SQL

This Introduction to MySQL Databases training course teaches the configuration, security management, administration, backup and restore, and optimization of MySQL databases.

In the Private Training
Code: GTLP6L Duration: 3 Days

This Introduction to SQL Programming training course is an introduction to the SQL database language. After this course the student will be able to use SQL to define, manipulate and control access to their data. The course thoroughly covers SQL syntax and facilities.The course begins with a general introduction to databases, including the principles of relational databases. Data retrieval is discussed in depth, covering all of the pertinent features of SQL, including joins. Data Manipulation Language is covered, including inserting, updating and deleting data. Transaction control and locking is discussed. Data Definition Language is covered, including creating, altering and dropping tables, and the use of integrity constraints. Views and indexes are covered.

In the Private Training
Code: GTPL7 Duration: 3 Days

In this SQL Querying training course you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries, using JOINs to combine data from multiple tables, summarizing query results, using advanced filtering, and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction.

In the Private Training
Code: GTDSQLQ Duration: 1 Day

Upcoming schedule: Cork, Monday 16 December 2019 at 09:00 to Tuesday 17 December 2019 at 17:00 - (Duration: 2 days)

This instructor-led 2-day SQL Fundamentals training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

In the Private Training
Code: GTPL72 Duration: 2 Days

MySQL Administration and Development training course is the open source community’s most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs.  This course covers MySQL 5.0.

In the Private Training
Code: GTLP7 Duration: 4 Days

In this PHP and MySQL training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.

In the Private Training
Code: GTLP2 Duration: 5 Days

SQL Fundamentals

In this PHP and MySQL training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. The class also covers SQL basics.

In the Private Training
Code: GTLP2 Duration: 5 Days

In this SQL Querying training course you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries, using JOINs to combine data from multiple tables, summarizing query results, using advanced filtering, and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction.

In the Private Training
Code: GTDSQLQ Duration: 1 Day

Upcoming schedule: Cork, Monday 16 December 2019 at 09:00 to Tuesday 17 December 2019 at 17:00 - (Duration: 2 days)

This instructor-led 2-day SQL Fundamentals training course is designed for students new to writing SQL queries. A typical student will need to learn SQL to build applications or to generate business reports. For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

In the Private Training
Code: GTPL72 Duration: 2 Days

This Introduction to MySQL Databases training course teaches the configuration, security management, administration, backup and restore, and optimization of MySQL databases.

In the Private Training
Code: GTLP6L Duration: 3 Days

This Introduction to SQL Programming training course is an introduction to the SQL database language. After this course the student will be able to use SQL to define, manipulate and control access to their data. The course thoroughly covers SQL syntax and facilities.The course begins with a general introduction to databases, including the principles of relational databases. Data retrieval is discussed in depth, covering all of the pertinent features of SQL, including joins. Data Manipulation Language is covered, including inserting, updating and deleting data. Transaction control and locking is discussed. Data Definition Language is covered, including creating, altering and dropping tables, and the use of integrity constraints. Views and indexes are covered.

In the Private Training
Code: GTPL7 Duration: 3 Days

Technical ICT learning & mentoring services

Private Team Training

Our instructors are specialist consultants with vast real world experience and expertise allowing them to design and deliver client-focused courses for your organisation.

Learn more about our Private Team Training

What Our Clients Say

“I particularly liked the heavy hands on sessions that went on with the training. Other than that, really liked Mark's training style. His experience in the field really shines through.”

 

Docker - GTDK1

Feb ‘19

“Instructor's ability to demonstrate new features that are not part of the course help show his mastery as well as prepare us for changes in the technology. Great work.

 

Using Docker & Kubernetes in Production - GTK8SG

Oct ‘18


“This course was an excellent insight into the Cloud Service Management world and equips me with the tools to go back to my company and build upon it.”

 

Cloud Service Manager - GTC13

Jan ‘19

 

''Fantastic course, looking forward to applying this in my work and home life. Excellent, practical approach, very motivational. I think the entire company should attend training.''

 

Being Agile in Business - GTBAB

Sept '19

“Excellent instructor. You can tell he really understands the concepts he's presenting and is very passionate about his work. He answered every question we asked and presented the course in an interesting and involving manner.”

 

Spring Boot Development - GTIT40

Nov ‘18

"Intelligence is the ability to avoid doing work, yet
getting the work done"

Linus Torvalds, creator of Linux and GIT

Technical ICT learning & mentoring services

About GuruTeam

GuruTeam is a high-level ICT Learning, Mentoring and Consultancy services company. We specialise in delivering instructor-led on and off-site training in Blockchain, Linux, Cloud, Big Data, DevOps, Kubernetes, Agile, Software & Web Development technologies. View our Testimonials

Download our eBrochure
Our Accreditation Partners

 

  •  
  •  
  •  
  •  
  •  

 

 

 

 

 

Upcoming Courses

Kubernetes Administration

16th - 19th December - Dublin

This Kubernetes Administration Certification training course is suitable for anyone who wants to learn the skills necessary to build and administer a Kubernetes cluster

Learn More

CompTIA Network+ FastTrack

Coming Soon

This fast-paced course teaches the essentials of networking and helps to prepare the student for the CompTIA Network+ certification.

Learn More

Applied Data Science with Python

17th - 18th December - Dublin

Learn about the theoretical and practical aspects of using Python in the realm of Data Science, Business Analytics, and Data Logistics

Learn More

Introduction to Python 3

Coming Soon

Python is a powerful and popular object-oriented programming/scripting language with many high quality libraries.

Learn More

Newsletter

Stay up to date, receive updates on scheduled dates, new courses, offers, and events.

Subscribe to our Newsletter