reed.co.uk Courses

Header

MySql Database Engineer


Skill Success

Summary

Price
Save 81%
£29 inc VAT (was £157)
Offer ends 28 May 2020
Study method
Online, self-paced
Qualification
No formal qualification
Additional info
  • Tutor is available to students
  • Certificate of completion available and is included in the price

2 students purchased this course

Add to basket or enquire

Overview

This course includes lifetime access so you can complete the course at your own speed.

By taking this course today, you will get acquainted with the basic concepts of databases, and will enable you to practically use MySQL servers.

Benefits of taking this course include:

  • Unlimited and lifetime access to the course
  • Learn the course at your own pace
  • Course can be accessed on any platform
  • 24/7 Customer support

Course media

Description

MySQL is one of the most famous systems for managing databases.

The main goal of this course is the acquaintance with the basic concepts of databases. The acquired knowledge will enable you to practically use MySQL servers. Through the lessons, you’ll get a general picture regarding SQL language syntaxes as well as the advanced functionalities of servers.

This is an open code system which means it’s available to everyone that wishes to use it and modify it according to their own specific needs. Apart from the fact this system enables you to manage your daily tasks quickly and efficiently, gaining skills and experience in MySQL will also provide you with a chance at building a successful and lucratively rewarding IT career.

What will I learn from this course?

  • This is an excellent introductory MySQL course, after this course, students will be introduced to the basic and most important concepts of databases.

MySql Database Engineer will cover the following topics:

Section 1 - Lesson 1

  • Introduction To Databases
  • Installation
  • Database Design
  • MySql Workbench

Section 2 - Lesson 2

  • Creating The First Database
  • MySQL – Data Types
  • Primary And Foreign Keys

Section 3 - Lesson 3

  • Introduction To SQL
  • Variables And Operators in MySQL
  • Definition Commands-DDL
  • Select
  • Connecting Data
  • Insert, Update, Delete

Section 4 - Lesson 4

  • Indexes
  • Views
  • Stored Routines
  • Built-in Functions
  • Cursors And Triggers
  • Transactions
  • Users And Access
  • MySql Security
  • Connections
  • Replication
  • Backup And Migration

Who is this course for?

This course is recommended for programmers who want to learn how to manage databases by coding with MySql

Requirements

No prior knowledge is required to take this course.

Career path

This course is recommended for programmers who want to learn database management.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.

Modals

Mobile Navigation