• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

22 MySQL courses delivered Live Online

Introduction to Linux Systems Administration (TTLX2220)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This is an introductory-level systems administration course geared for Systems Administrators and users who wish to learn how to how to install, configure and maintain an Enterprise Linux system in a networked environment. Overview This course is about 50% lab to lecture ratio, combining expert instructor-led discussions with practical hands-on skills that emphasize current techniques, best practices and standards. Working in this hands-on lab environment, guided by our expert practitioner, attendees will explore Installing the Linux operating system and configuring peripherals Performing and modifying startup and shutdown processes Configuring and maintaining basic networking services Creating and maintaining system users and groups Understanding and administering file permissions on directories and regular files Planning and creating disk partitions and file systems Performing maintenance on file systems Identifying and managing Linux processes Automating tasks with cron Performing backups and restoration of files Working with system log files Troubleshooting system problems Analyzing and taking measures to increase system performance Configuring file sharing with NFS Configuring Samba for file sharing with the Windows clients Setting up a basic Web server Understanding the components for setting up a LAMP server Implementing basic security measures Linux System Administration is a comprehensive hands-on course that teaches students how to install, configure and maintain an Enterprise Linux system in a networked environment. This lab-intensive class explores core administrative tasks such as: creating and managing users, creating and maintaining file systems, determining and implementing security measures and performing software installation and package management. Linux networking topics include installing and supporting SSH, NFS, Samba and the Apache Web server. Students will explore common security issues, as well as several tools, such as the PAM modules that help secure the operating system and network environment. Upon successful completion of this course, students will be prepared to maintain Linux systems in a networked business environment. Although the course includes installing and configuring a CentOS 7 / RHEL 7 Linux system, much of the course content also applies to Oracle, Ubuntu, Scientific and other current versions of mainstream Linux distributions. Labs include user and group maintenance, system backups and restoration, software management, administration tasks automation, file system creation and maintenance, managing remote access, working with cron, and configuring basic file sharing and Web services, as well as working with system logging utilities such as rsyslog and much more. System Administration Overview UNIX, Linux and Open Source Duties of the System Administrator Superusers and the Root Login Sharing Superuser Privileges with Others (su and sudo Commands) TCP/IP Networking Fundamentals Online Help Installation and Configuration Planning: Hardware and Software Considerations Site Planning Installation Methods and Types Installation Classes Partitions Logical Volume Manager - LVM File System Overview Swap Partition Considerations Other Partition Considerations The Linux Boot Loader: grub Software Package Selection Adding and Configuring Peripherals Printers Graphics Controllers Basic Networking Configuration Booting to Recovery Mode Booting and Shutting Down Linux Boot Sequence The systemd Daemon The systemctl Command Targets vs. Run Levels Modifying a Target Service Unit Scripts Changing System States Booting into Rescue Mode Shutdown Commands Managing Software and Devices Identifying Software Packages Using rpm to Manage Software Using yum to Manage Software Installing and Removing Software Identifying Devices Displaying Device and System Information (PCI, USB) Plug and Play Devices Device Configuration Tools Managing Users and Groups Setting Policies User File Management The /etc/passwd file The /etc/shadow file The /etc/group file The /etc/gshadow file Adding Users Modifying User Accounts Deleting User Accounts Working with Groups Setting User Environments Login Configuration Files The Linux File System Filesystem Types Conventional Directory Structure Mounting a File System The /etc/fstab File Special Files (Device Files) Inodes Hard File Links Soft File Links Creating New File Systems with mkfs The lost+found Directory Repairing File Systems with fsck The Journaling Attribute File and Disk Management Tools Linux File Security File Permissions Directory Permissions Octal Representation Changing Permissions Setting Default Permissions Access Control Lists (ACLs) The getfacl and setfacl commands SUID Bit SGID Bit The Sticky Bit Controlling Processes Characteristics of Processes Parent-Child Relationship Examining Running Processes Background Processes Controlling Processes Signaling Processes Killing Processes Automating Processes cron and crontab at and batch System Processes (Daemons) Working with the Linux Kernel Linux Kernel Components Types of Kernels Kernel Configuration Options Recompiling the Kernel Shell Scripting Overview Shell Script Fundamentals Bash Shell Syntax Overview Shell Script Examples System Backups Backup Concepts and Strategies User Backups with the tar Command System Backup Options The xfsdump and xfsrestore Commands Troubleshooting the System Common Problems and Symptoms Troubleshooting Steps Repairing General Boot Problems Repairing the GRUB 2 Boot Loader Hard Drive Problems Restoring Shared Libraries System Logs and rsyslogd Basic Networking Networking Services Overview NetworkManager Introduction Network Configuration Files Locations and Formats Enabling and Restarting Network Services with systemtcl Configuring Basic Networking Manually Configuring Basic Networking with NetworkManager LAMP Server Basics LAMP Overview Configuring the Apache Web Server Common Directives Apache Virtual Hosting Configuring an Open Source Database MySQL MariaDB PHP Basics Perl CGI Scripting Introduction to System Security Security Overview Maintaining System Security Server Access Physical Security Network Security Security Tools Port Probing with nmap Intrusion Detection and Prevention PAM Security Modules Scanning the System Maintaining File Integrity Using Firewalls Introduction to firewalld The Samba File Sharing Facility Configure Samba for Linux to Linux/UNIX File Sharing Configure Samba for Linux to Windows File Sharing Use the smbclient Utility to Transfer Files Mount/Connect Samba Shares to Linux and Windows Clients Networked File Systems (NFS) Using NFS to Access Remote File Systems Configuring the NFS Server Configuring the NFS Client Exporting File Systems from the NFS Server to the NFS Client

Introduction to Linux Systems Administration (TTLX2220)
Delivered OnlineFlexible Dates
Price on Enquiry

SQL Intermediate Course, 3 Days

4.6(12)

By PCWorkshops

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements. Hands-on, Practical SQL course. You will get the PCWorkshops SQL Course Certificate. Max 4 people per course, to keep it personalised.

SQL Intermediate Course, 3 Days
Delivered OnlineFlexible Dates
£600

Online Options

Show all 283

MySQL Course Intermediate, 3 DAYS

4.6(12)

By PCWorkshops

Practical MySQL Course Intermediate, to leave you fully conversant with queries, DML and DDL statements. Hands-on, Practical MySQL Course Intermediate. PCWorkshops MySQL Course Intermediate Certificate. Max 4 people per course, we keep it personalised.

MySQL Course Intermediate, 3 DAYS
Delivered OnlineFlexible Dates
£600

MySQL Database Development Mastery

By Packt

This course will help you to get familiarized with the concepts of MySQL Server and MySQL Workbench needed for database development and management. From basic SQL queries and statements to handling relationships and aggregate functions, you will learn all that you need with the help of real-time activities.

MySQL Database Development Mastery
Delivered Online On Demand4 hours 19 minutes
£37.99

The Complete MySQL Developer Course

By Packt

MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications

The Complete MySQL Developer Course
Delivered Online On Demand9 hours 16 minutes
£119.99

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

By Packt

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL
Delivered Online On Demand10 hours 52 minutes
£26.99

Using MySQL Databases with Python

By Packt

Explore the quick and easy way to learn the MySQL Database with Python

Using MySQL Databases with Python
Delivered Online On Demand2 hours 2 minutes
£137.99

Basic MySQL Online Course

By Course Cloud

Course Overview Master MySQL by learning all the web development skills for creating complex, high-quality web databases. The Basic MySQL Online Course covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field.  This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market. This best selling Basic MySQL Online Course has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic MySQL Online Course is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic MySQL Online Course is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Basic MySQL Online Course is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic MySQL Online Course, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic MySQL Online Course will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic MySQL Online Course to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Basic MySQL Online Course
Delivered Online On Demand
£319

Complete MySql

By Course Cloud

The comprehensive Complete MySql has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Complete MySql today, and learn from the very best the industry has to offer! This best selling Complete MySql has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete MySql is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Complete MySql is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Complete MySql is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Complete MySql, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Complete MySql will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Complete MySql to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Complete MySql
Delivered Online On Demand
£25

PHP & MySQL Web Development & OOP Coding

By Course Cloud

Course Overview Become a PHP & MySQL pro by learning all the web development features for creating websites. The PHP & MySQL Web Development & OOP Coding course covers everything you need to know to master PHP programming and gain valuable industry skills. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for complete beginners.  Through this in-depth training course, you will familiarise with all the features of MySQL, and learn best practices for cross platform development, taught by an expert in the field. If you are looking to kickstart a career in programming or computer science, then this course will equip you with up-to-date skills that will ensure you gain a competitive edge in the job market. This best selling PHP & MySQL Web Development & OOP Coding has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth PHP & MySQL Web Development & OOP Coding is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The PHP & MySQL Web Development & OOP Coding is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The PHP & MySQL Web Development & OOP Coding is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the PHP & MySQL Web Development & OOP Coding, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the PHP & MySQL Web Development & OOP Coding will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the PHP & MySQL Web Development & OOP Coding to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

PHP & MySQL Web Development & OOP Coding
Delivered Online On Demand
£319

MySQL Database Development

By Course Cloud

The comprehensive MySQL Database Development has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the MySQL Database Development today, and learn from the very best the industry has to offer! This best selling MySQL Database Development has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth MySQL Database Development is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The MySQL Database Development is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The MySQL Database Development is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the MySQL Database Development, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the MySQL Database Development will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the MySQL Database Development to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

MySQL Database Development
Delivered Online On Demand
£25

Overview of MySql Masterclass Join our MySql Masterclass course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The MySql Masterclass course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The MySql Masterclass course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! This MySql Masterclass Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this MySql Masterclass. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the MySql Masterclass course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This MySql Masterclass is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education. Requirements You don’t need any educational qualification or experience to enrol in the MySql Masterclass course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this MySql Masterclass Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

MySql Masterclass
Delivered Online On Demand13 hours 22 minutes
£11.99

Educators matching "MySQL"

Show all 21
StayAhead Training

stayahead training

From a single person on a scheduled course to large scale training projects StayAhead Training have the expertise and experience to help. Established since 1992, StayAhead Training is recognised as one of the leading independent IT Training specialists in the UK and the first choice provider of UNIX, Linux, Oracle, Red Hat, Java, Web Development, MySQL, PHP, Perl, ITIL, and Business Analysis training for many of UK's largest organisations. With 7 UK training centres located in London, Bristol, Birmingham, Leeds, Manchester, Sunderland, and Edinburgh, StayAhead offer a range of scheduled, tailored and onsite training. Courses are based on traditional classroom based Instructor Led Training, with Virtual Training also available. What we do With a formidable reputation for quality and expertise within the UNIX, Oracle, Linux, Red Hat, Java, MySQL, Web Development, Business Analysis and ITIL arena, StayAhead Training enjoy an enviable position amongst the top IT Technical training organisations in the UK. The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX and HP-UX courses. The Linux curriculum covers general Linux plus specific SUSE, LPI & Red Hat training courses. The Oracle curriculum also has depth with courses available for DBA's, Developers and End Users. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Java, Oracle PL/SQL Developer and Oracle DBA. The Web Development & Java curriculum goes from strength to strength with courses available in HTML & CSS, Javascript, jQuery and Java progamming. Our flexibility comes from developing our own independent courses, including high quality course material that is not only written to support the learning process but can also act as a helpful reference guide on the delegates return to work. A high level of practical work with a guaranteed workstation per delegate re-enforces the learning process.

Acornford Technical Services

acornford technical services

London

Effective Solutions for Small Business Social Media Shortcuts Useful Links Our Partners Home Oracle MySQL MS SQL Server IBM DB2 StayAhead Contact Us Shopping Cart HomeAbout UsOracle TrainingContact Us Acornford Technical Services Ltd © 2012 | Terms and Conditions Share on FacebookShare on TwitterHead start for IT Professionals As an IT consultancy we offer an experienced DBA resource to compliment your support staff, who can provide complex technical advice or simply add an extra pair of hands during staff shortages during the holiday season, peaks of activity, or special projects for example. We specialize in providing technical training for the database subject mater experts. Most of our courses are in the form of classroom training. We also able to offer courses that are tailored made for you. Our experienced trainers can build a bespoke course and materials to meet your needs. We offer free advise for appropriate licensing, aiming to reduce the cost and maximize return on investment, while retaining legal compliance. Database Administration Technical Training for the Database SME Licensing Rationalization The ‘Container’ database feature of the Oracle 12c Database is generating a fair amount of interest as well as a range of new features in Oracle Grid Infrastructure. The ‘Container’ database with the Multitenant option addresses the data consolidation issues that were difficult to address in the previous versions and not easily solved using the virtualization. The course curriculum covers the general database administration and thorough run through the new features and new behaviours of the Oracle 12c Database engine.

Mend The Gap

mend the gap

0.0(4)

Winscombe

Our mission is to help individuals and communities to mend the widening gap between cultures, races, generations and people of different wealth for current and future generations.Naftali Manddy Onchere is the CEO of Mend the Gap and is responsible for the day to day running and management of the organisation in consultation with David Seabright, Francis Montagu and James Nzala. Naftali brings more than 26 years’ experience in project and organisational management in the UK and overseas. He has a BSc Honours degree and is a former teacher and qualified trainer. He has served as a Director at Tolerance International UK, ACORD UK, Motivation Charitable Trust UK; Programme Manager at Netherlands Foreign Service and ETC East Africa Consultants BV; etc. He has extensive experience with youth, intergenerational and inter-cultural work and training both in the UK and in Eastern Africa. James Musau Nzala James Nzala is the Let Us Connect Programme Co-ordinator in Kenya. He has a BSc IT degree and is qualified in advanced web design (PHP, MySQL database, CSS & JavaScript coding), software and hardware trouble shooting and repair, IT-user training, and network building and management. Ben Ferguson Ben was one of the first to pioneer gap year experiences in Kenya with Mend the Gap. Since then he has become a long term volunteer and brings a wealth of business and hospitality experience to the organisation. He looks after our communications and relationships with our business partners. Nicholus Ole Murero Nick is Rifts Valley Co-ordinator for Mend the Gap in Kenya. Simon Ole Kerempe Simon is the Projects Officer for Mend the Gap in Narok, Kenya.