Search our courses

SQL

LAMP

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

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 Training in SQL Server 2018 Integration Services course will enable delegates to master SQL Server Integration Services. Delegates also will be able to import and export data using a variety of formats, including Excel spreadsheets and CSV files. The course will cover using the SSIS designer to copy and transforms data.

In the Private Training Virtual Training 
Code: GTPLSQLI Duration: 1 Day

MySQL

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

This Training in SQL Server 2018 Integration Services course will enable delegates to master SQL Server Integration Services. Delegates also will be able to import and export data using a variety of formats, including Excel spreadsheets and CSV files. The course will cover using the SSIS designer to copy and transforms data.

In the Private Training Virtual Training 
Code: GTPLSQLI Duration: 1 Day

Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This Training in SQL Server Business Intelligence course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects. The course will also include the new features in SQL Server B.I. 2018. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore it is not necessary to know the SQL Server itself.

In the Private Training Virtual Training 
Code: GTPLSQL Duration: 5 Days

4 Top Takeaways from the Course:

    Make your existing data work harder for you
    Get the right report to the right person
    Create eloquent reports from raw data
    Improve communication inside and outside your organisation

In the Private Training Virtual Training 
Code: GTPLSQLS Duration: 2 Days

New

This Training in SQL Server 2018 Integration Services course will enable delegates to master SQL Server Integration Services. Delegates also will be able to import and export data using a variety of formats, including Excel spreadsheets and CSV files. The course will cover using the SSIS designer to copy and transforms data.

In the Private Training Virtual Training 
Code: GTPLSQLI Duration: 1 Day

Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This Training in SQL Server Business Intelligence course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects. The course will also include the new features in SQL Server B.I. 2018. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore it is not necessary to know the SQL Server itself.

In the Private Training Virtual Training 
Code: GTPLSQL Duration: 5 Days

4 Top Takeaways from the Course:

    Make your existing data work harder for you
    Get the right report to the right person
    Create eloquent reports from raw data
    Improve communication inside and outside your organisation

In the Private Training Virtual Training 
Code: GTPLSQLS Duration: 2 Days

SQL

Developers, analysts and business users need to quickly analyse large amounts of data, get insight into that data, retrieve hidden knowledge inside it, and report against various data sources professionally and effectively. This Training in SQL Server Business Intelligence course will enable them to do this with SQL Server Business Intelligence. The 5 day course will cover the SQL Server components and tools used for B.I. projects. The course will also include the new features in SQL Server B.I. 2018. Reporting Services, Analysis Services and Integration Services will be explored and worked with. Components of Business Intelligence in SQL Server are completely independent from the SQL Server databases, so they can be used over any data sources. Therefore it is not necessary to know the SQL Server itself.

In the Private Training Virtual Training 
Code: GTPLSQL Duration: 5 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

4 Top Takeaways from the Course:

    Make your existing data work harder for you
    Get the right report to the right person
    Create eloquent reports from raw data
    Improve communication inside and outside your organisation

In the Private Training Virtual Training 
Code: GTPLSQLS 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

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

This Training in SQL Server 2018 Integration Services course will enable delegates to master SQL Server Integration Services. Delegates also will be able to import and export data using a variety of formats, including Excel spreadsheets and CSV files. The course will cover using the SSIS designer to copy and transforms data.

In the Private Training Virtual Training 
Code: GTPLSQLI Duration: 1 Day

SQL Fundamentals

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

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

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

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

12th - 15th October - Live Online

16th - 19th November - Live Online

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 and Big Data Analytics

Coming Soon

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

29th September - 1st October-  Live Online

20th - 22nd October  -  Live Online

10th - 12th November -  Live Online

24th - 26th November -  Live Online          

                                                                                      15th - 17th December -  Live Online

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