MySQL

Course Details

  • Category: Database Management System language
  • Basic Skill: HTML,CSS,& JS,PHP
  • Course Duration: 2 Months

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.

Course Contents

1. Basic Concepts

1.1 Introduction to Databases

1.2 SQL Statements: SELECT

1.3 SQL Syntax Rules

1.4 Selecting Multiple Columns

1.5 DISTINCT and LIMIT

1.6 Sorting Results

1.7 Module 1 Quiz

2. Filtering, Functions, Subqueries

2.1 The WHERE Statement

2.2 Filtering with AND, OR

2.3 IN, NOT IN Statements

2.4 Custom Columns

2.5 Functions

2.6 Subqueries

2.7 LIKE and MIN

2.8 Module 2 Quiz

3. JOIN, Table Operations

3.1 Joining Tables

3.2 Types of Join

3.3 UNION

3.4 The INSERT Statement

3.5 UPDATE and DELETE Statements

3.6 Creating a Table

3.7 NOT NULL and AUTO_INCREMENT

3.8 Alter, Drop, Rename a Table

3.9 Views

3.10 Module 3 Quiz

Practice for Database Management System

1. Start with Basic Programs

  • 1.1 Build a Clothes Recommendation System
  • 1.2 Customer Relationship Management for ISP
  • 1.3 Predict Movie Success through Data Mining
  • 1.4 Fake Review Identification
  • 1.5 Data Mining Implementation for Secure Learning
  • 1.6 Detect Net Banking Phishing
  • 1.7 Predict User Behaviour
  • 1.8 A Chatbot for Students
  • 1.9 Portal for Doctors
  • 1.10 Product Rating System According to Customer Reviews
  • 1.15 Learn More About MySQL byMd Tousif Ahamed.