- Accredited by CPD
- Instant e-certificate
- Fully online, interactive course with audio voiceover
- Self-paced learning and laptop, tablet, smartphone-friendly
- 24/7 Learning Assistance
- Discounts on bulk purchases
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. 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 Introduction
- SQL Environment Setup
- SQL Statement Basics
- GROUP BY Statements
- JOINS
- Advanced SQL Commands / Statements
- Creating Database and Tables
- Databases and Tables
Course Content
53 Lectures 8hr 2min
Course Introduction - 3 lessons
Introduction
Course Curriculum Overview
Overview of Databases
SQL Environment Setup - 3 lessons
MySQL Installation
MySQL Workbench Installation
Connecting to MySQL using Console
SQL Statement Basics - 13 lessons
Overview of Challenges
SQL Statement Basic
SELECT Statement
SELECT DISTINCT
Column AS Statement
COUNT built-in Method usage
SELECT WHERE Clause – Part One
SELECT WHERE Clause – Part Two
SQL ORDER BY Statement
SQL Limit Clause Statement
SQL Using BETWEEN with Same Column Data
How to Apply IN Operator
Wildcard Characters with LIKE and ILIKE
GROUP BY Statements - 6 lessons
Overview of GROUP BY
Aggregation function SUM()
Aggregation MIN() and MAX()
GROUP BY – One
GROUP BY – Two
HAVING Clause
JOINS - 8 lessons
Overview of JOINS
Introduction to JOINS
AS Statement table
INNER Joins
FULL Outer Join
LEFT Outer JOIN
RIGHT JOIN
Union
Advanced SQL Commands / Statements - 5 lessons
Timestamps
EXTRACT from timestamp
Mathematical Functions
String Functions
SUBQUERY
Creating Database and Tables - 11 lessons
Basic of Database and Tables
DataTypes
Primarykey and Foreignkey
Create Table in SQL Script
Insert
Update
Delete
Alter Table
Drop Table
NOT NULL Constraint
UNIQUE Constraint
Databases and Tables - 3 lessons
Creating a Database backup
10a Overview of Databases and Tables
10c Restoring a Database
Final Exam - 0 lessons
No lessons available.
381559 - 0 lessons
No lessons available.