GET THIS COURSE AND 2500+ OTHERS FOR ONLY £49 FIND OUT MORE

Home
Curriculum

The Complete MySQL Server from Scratch: Bootcamp Course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This The Complete MySQL Server from Scratch: Bootcamp Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it.

To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills.

The training materials of this course are available online for you to learn at your own pace and fast-track your career with ease.

Sneak Peek

Who should take the course

Anyone with a knack for learning new skills can take this The Complete MySQL Server from Scratch: Bootcamp Course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this The Complete MySQL Server from Scratch: Bootcamp Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Course Curriculum

The detailed curriculum outline of our The Complete MySQL Server from Scratch: Bootcamp Course is as follows:

The Complete MySQL Server from Scratch: Bootcamp

Course Curriculum

Course Introduction
	Introduction	00:04:00
	Course Curriculum Overview	00:05:00
	Overview of Databases	00:10:00
SQL Environment Setup
	MySQL Installation	00:16:00
	MySQL Workbench Installation	00:09:00
	Connecting to MySQL using Console	00:09:00
SQL Statement Basics
	Overview of Challenges	00:04:00
	SQL Statement Basic	00:16:00
	SELECT Statement	00:09:00
	SELECT DISTINCT	00:05:00
	Column AS Statement	00:12:00
	COUNT built-in Method usage	00:11:00
	SELECT WHERE Clause – Part One	00:05:00
	SELECT WHERE Clause – Part Two	00:11:00
	SQL ORDER BY Statement	00:08:00
	SQL Limit Clause Statement	00:09:00
	SQL Using BETWEEN with Same Column Data	00:11:00
	How to Apply IN Operator	00:11:00
	Wildcard Characters with LIKE and ILIKE	00:11:00
GROUP BY Statements
	Overview of GROUP BY	00:06:00
	Aggregation function SUM()	00:09:00
	Aggregation MIN() and MAX()	00:05:00
	GROUP BY – One	00:09:00
	GROUP BY – Two	00:12:00
	HAVING Clause	00:05:00
JOINS
	Overview of JOINS	00:04:00
	Introduction to JOINS	00:04:00
	AS Statement table	00:03:00
	INNER Joins	00:14:00
	FULL Outer Join	00:11:00
	LEFT Outer JOIN	00:08:00
	RIGHT JOIN	00:08:00
	Union	00:07:00
Advanced SQL Commands / Statements
	Timestamps	00:12:00
	EXTRACT from timestamp	00:10:00
	Mathematical Functions	00:12:00
	String Functions	00:22:00
	SUBQUERY	00:13:00
Creating Database and Tables
	Basic of Database and Tables	00:06:00
	DataTypes	00:10:00
	Primarykey and Foreignkey	00:06:00
	Create Table in SQL Script	00:13:00
	Insert	00:11:00
	Update	00:07:00
	Delete	00:04:00
	Alter Table	00:09:00
	Drop Table	00:05:00
	NOT NULL Constraint	00:08:00
	UNIQUE Constraint	00:09:00
Databases and Tables
	Creating a Database backup	00:12:00
	10a Overview of Databases and Tables	00:05:00
	10c Restoring a Database	00:07:00