MySQL, SQL and Stored Procedures from Beginner to Advanced

4.3 (2325)
MOOC
Payment
Learning paid
Language
English
Duration
18.5 hours course
Course by Udemy
What will you learn?
Create, query and update databases
Use triggers, views and stored procedures
Understand transactions and database isolation levels.
Understand database users and security.
About the course

This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help you.

Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database.

MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites.

Master Advanced MySQL Features, Starting from the Ground Up

In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, we'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures.

You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool.

By the end of the course you'll understand MySQL's powerful features to a greater level than probably most professional software developers, and you'll have an understanding of SQL that will help you get to grips with any relational database. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.

Program
Introduction
Introducing MySQL
Getting Started
Installing MySQL and the Workbench
Using the Command Line
Creating Tables
Multiple Columns, int and Data Types
Null Values and Not Null
Mysql Storage Engines and Configuration
SQL Modes
Deleting All the Data in a Table
Primary Keys
Requirements
  • You will need to download and install the free MySQL Server Community Edition and the free MySQL Workbench
Lecturers
John Purcell
John Purcell
Software Development Trainer
Platform
/storage/img/providers/udemy.svg
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Rating
4.3
(1114)
(825)
(287)
(79)
(51)
Comments (2325)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.