+353 1 402 9423 | firstname.lastname@example.org
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.
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.
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.
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.
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
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.
Technical ICT learning & mentoring services
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
“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
“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
“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
''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
“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
"Intelligence is the ability to avoid doing work, yet
getting the work done"
Linus Torvalds, creator of Linux and GIT
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
18th - 21st August - Live Online
12th - 15th October - 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
This fast-paced course teaches the essentials of networking and helps to prepare the student for the CompTIA Network+ certification.
Learn about the theoretical and practical aspects of using Python in the realm of Data Science, Business Analytics, and Data Logistics
14th - 16th July - Live Online
Python is a powerful and popular object-oriented programming/scripting language with many high quality libraries.
View All Scheduled Courses
Stay up to date, receive updates on scheduled dates, new courses, offers, and events.
+353 1 402 9423