Learn Online MySQL & Database Design Tutorials for Beginners

Description

In this course, you will learn :

• The intricacies of good database design It will teach you all of the hidden tips and tricks, as well as all of the major concepts of proper database design.
• This course will also teach you SQL, and by the end of it, you will be a SQL power user.
• You will begin with a basic introduction to data storage and progress to storage engines and other tools.
• Discover the MySQL installation and database design processes. Following that are database design, normalisation, structure mapping, keys, and junction tables.
• SQL and Advanced SQL will be taught to you, as well as how to use PHP with MySQL. So, this comprehensive Database course will undoubtedly assist you in becoming a Database Design Guru.

Syllabus :

1. Getting Started With MySQL

• MySQL Windows Installation
• MySQL Linux Installation
• Environment Setup With Xampp
• Using PHPMyAdmin
• MySQL Workbench

 

2. Planning & Design

• Design Principles and Normalization
• Database Design Process
• Mapping Out Our Schema

 

3. Creating A Database

• Create Tables and Columns
• Importing and Exporting
• Creating Relationships
• Create a Junction Table

 

4. SQL Fundamentals

• Command Line and Insert Queries
• Simple Select Queries
• Update and Delete Data
• Aliases and Joins

 

5. Advanced SQL

• Union, Concat and Count
• Using The IN Clause
• Math and Subqueries
• Using Group By

 

6. PHP & MySQL

• PHP Fundamentals
• Template and Database Connect
• Select & Display Using PHP
• Insert Data With PHP
• Update & Delete With PHP

Show more