MySQL

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you.

This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data.

The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that`s both informative and engaging.

Curriculum:

• MySQL Workbench Tutorial & MySQL Introduction
• Database Design Tutorial: Learn Data Modeling
• What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples
• What is ER(Entity-relationship) Modeling? Learn with Example
• MySQL DDL and DML
• MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ )
• MYSQL Regular Expressions (REGEXP) with Syntax & Examples
• MySQL Functions & Procedures:String, Numeric, Userdefined, Stored
• MySQL Aggregate Functions Tutorial
• MYSQL - ALTER, DROP, RENAME, MODIFY
• MySQL LIMIT & OFFSET Tutorial with Examples
• MySQL SubQuery Tutorial with Examples
• MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS
• Views in MySQL Tutorial: Create, Join & Drop with Examples
• MySQL INDEXES - Create, Drop & Add Index Tutorial