253 MySQL courses

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

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.

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

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

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.

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.

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.

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.

COURSE OVERVIEW Learn how to Install and configure NGINX on Ubuntu step-by-step. Includes MySQL, PHP, PhpMyAdmin, WordPress & SSL integration. NGINX is one of the most powerful Web Server technologies in the world. In this course, you will learn how to install NGINX on a DigitalOcean droplet or any virtual server of your choice, with complete step-by-step guidance. It also covers key topics such as the differences between Apache & NGINX, configuring DNS one files, and creating a database for WordPress. This practical training course is a great introduction to NGINX and other open source software, ideal for students interested in web development and web design. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis. This best selling Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu, 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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 Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu 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 FOUNDATION TRAINING COURSE DESCRIPTION The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. WHAT WILL YOU LEARN * Create, alter and drop a MySQL database. * Write SQL statements. * Use SQL expressions and functions. * Create and alter tables, indexes and views. * Use transactions. * Grant and revoke access privileges. * Export and import data. MYSQL FOUNDATION TRAINING COURSE DETAILS * Who will benefit: Anyone who needs to access and work with a MySQL Database. * Prerequisites: An understanding of databases and exposure to information technology in general would be useful. * Duration 3 days MYSQL FOUNDATION TRAINING COURSE CONTENTS * Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. * Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. * Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. * LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. * Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. * Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. * Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. * Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. * Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. * Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. * Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. * Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.