MySQL Database Management
Overview
Description:
The student will learn the basics of relational database systems (MySQL) and the relational modeling model (ERD Model). They will also learn to convert the ERD into a database and understand the types of entities and the relationships between them.
You Will Learn:
- ERD form
- MySQL basics and how to set up the database from scratch.
- Database design.
- Data Normalization
- Types of orders (DDL, DML, DCL, TCL, DQL)
- Writing basic and advanced SQL queries.
- Use indexes to improve performance.
- Stored Procedures, Functions, and Triggers.
- Manage users and implement permissions and security.
Prerequisites:
- Prior knowledge
You might be intersted in
Description: Nuxt is a free and open-source framework with an intuitive and extendable way to create type-safe, performant and production-grade full-stack web applications and websites with Vue.js. In this course,...
Description: Vue.js is one of the most popular JavaScript frameworks used for developing user interfaces and single-page applications. Designed to be scalable and easy to learn, it is an excellent...
Description: This course covers the fundamentals of web development and how to create interactive web pages using HTML, CSS, and JavaScript. It focuses on the basic concepts of each language...
Description: In this advanced course, students will learn how to design and develop web applications and services using Java, with a focus on SaaS and cloud-native concepts. Students will explore...