adams-academy-logo
Explore Courses
Get Certificate
Discover Careers
More

The Complete MySQL Server from Scratch: Bootcamp

(2 students)

This course includes:

07:45:00 hours

CPD Accreditation

52 units

Full lifetime access

Access on mobile and TV

Certificate of completion

Share:
Training Express
Course Publisher

Training Express

Key Concepts Covered by This Free Course:

  • Setting up MySQL environments and understanding SQL statement basics
  • Grouping and aggregating data with GROUP BY statements
  • Understanding JOINS for data consolidation
  • Advanced SQL commands and statements for complex data manipulation
  • Creating databases and tables for efficient data organisation
  • Managing databases and tables for data integrity and security

Course Overview:

Take your data management skills to the next level with The Complete MySQL Server from Scratch: Bootcamp. This comprehensive course will provide you with a thorough understanding of MySQL and SQL, from setting up environments to advanced data manipulation techniques. The engaging modules teach you how to create and manage databases and tables, group and aggregate data, and utilise JOINS for data consolidation. You'll also gain experience in advanced SQL commands and statements for complex data manipulation tasks. By the end of the course, you'll have the skills and knowledge needed to manage data and ensure data integrity and security efficiently.

Course Benefits:

Invest in your career with The Complete MySQL Server from Scratch: Bootcamp. This course provides a valuable opportunity to develop in-demand skills and open up new career opportunities. By mastering MySQL and SQL, you'll be able to contribute to the success of data-driven organisations and positively impact your career prospects. In addition to boosting your skills and knowledge, this course also offers flexible learning options, enabling you to study at your own pace and fit your learning around your schedule. With lifetime access to course materials, you can refresh your knowledge and stay up-to-date with the latest MySQL trends and practices.

Career Path:

  • Database Administrator: Responsible for managing and maintaining database systems, ensuring data accuracy, security, and performance.
  • Data Analyst: Responsible for collecting, analysing, and interpreting complex data sets to identify patterns, trends, and insights.
  • Business Intelligence Developer: Responsible for designing and developing BI solutions, including data warehouses, ETL processes, and reporting tools.
  • Software Developer: Responsible for developing software applications that interact with database systems, utilising MySQL for data manipulation and retrieval.
  • Data Scientist: Responsible for designing and implementing data-driven solutions, including statistical models and machine learning algorithms.
Course content

Course Introduction

Introduction

00:04:00

Course Curriculum Overview

00:05:00

Overview of Databases

00:10:00

MySQL Installation

00:16:00

MySQL Workbench Installation

00:09:00

Connecting to MySQL using Console

00:09:00

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

Overview of GROUP BY

00:06:00

Aggregation function SUM()

00:09:00

Aggregation MIN() and MAX()

00:06:00

GROUP BY – One

00:09:00

GROUP BY – Two

00:12:00

HAVING Clause

00:05:00

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

Timestamps

00:12:00

EXTRACT from timestamp

00:10:00

Mathematical Functions

00:12:00

String Functions

00:22:00

SUBQUERY

00:13:00

Basic of Database and Tables

00:06:00

DataTypes

00:11: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:10:00

Drop Table

00:05:00

NOT NULL Constraint

00:08:00

UNIQUE Constraint

00:09:00

Creating a Database backup

00:12:00

10a Overview of Databases and Tables

00:05:00

10c Restoring a Database

00:07:00

Complete This CPD Accredited Course & Get Your Framed Certificate!

vector

Certify Your Skills

A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.

Stand Out From The Crowd

Add your Adams Certification to your resume and stay ahead of the competition.

Advance in Your Career

Share your Adams Certification with potential employers to show off your skills and capabilities.

Certificate Promo

About Course Publisher

Training Express
Training Express

189 Courses

Training Express is a leading course provider, established by a dedicated team of experts working across the UK. We deliver accredited certification and training to UK businesses looking to improve organisational performance. Our comprehensive courses cover a broad range of sectors and industries, with a focus on promoting high standards of food hygiene, business wellbeing and safety in the workplace.

Adams Academy Logo

At Adams Academy, we're reinventing the online learning landscape by creating an immersive global platform with a wide range of engaging and top-notch courses. Our thriving learner and course provider community accommodates many interests and academic levels, building a culture where curiosity flourishes and potential is awakened.

Beaufort House, 15 St Botolph Street, London EC3A 7BB
Adams Learning facebook profile - /adamsacademylive
Twitter
Instagram
Linkedin
Google
Youtube
Youtube

© 2023 Adams Academy Inc. All rights reserved.