Scribd
Upload
2 views2 pages

Basic MySQL Database Programming Course

The BASIC MYSQL DATABASE PROGRAMMING course is designed for beginners and focuses on practical database handling with real-life query practice and daily assignments. It covers essential topics such as MySQL installation, database creation, data manipulation, and basic SQL queries including joins and aggregate functions. The course concludes with a revision and assessment, including a mini project to reinforce learning.

Uploaded by

anupamgajol
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Basic MySQL Database Programming Course

The BASIC MYSQL DATABASE PROGRAMMING course is designed for beginners and focuses on practical database handling with real-life query practice and daily assignments. It covers essential topics such as MySQL installation, database creation, data manipulation, and basic SQL queries including joins and aggregate functions. The course concludes with a revision and assessment, including a mini project to reinforce learning.

Uploaded by

anupamgajol
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

BASIC MYSQL DATABASE PROGRAMMING

COURSE

Course Highlights
 Beginner Friendly
 Practical Database Handling
 Real-life Query Practice
 Daily Assignments

Course Modules Outline


Module 1: Introduction to Databases & MySQL

 What is Database
 DBMS vs RDBMS
 Features of MySQL

Module 2: MySQL Installation & Tools

 MySQL Installation
 MySQL Workbench
 Connecting to Database

Module 3: Database & Table Basics

 Creating Database
 Creating Tables
 Data Types
 Constraints (Primary Key, Not Null, Unique)

Module 4: Insert, Update & Delete Data

 INSERT Statement
 UPDATE Statement
 DELETE Statement

Module 5: Select Queries

 SELECT Statement
 WHERE Clause
 AND / OR
 LIKE Operator

Module 6: Sorting & Filtering Data


 ORDER BY
 LIMIT

Module 7: Aggregate Functions (Basic)

 COUNT
 SUM
 MIN / MAX

Module 8: Joins (Basic)

 INNER JOIN
 LEFT JOIN
 RIGHT JOIN

Module 9: Subqueries & Views (Basic)

 Subqueries
 Creating Views
 Using Views

Module 10: Revision & Assessment

 Query Practice
 Mini Project
 Final Assessment

You might also like