MySQL

MySQL

2013★★★★★(4.5)• 31 students enrolled• 23k views
Instructor
Instructor
Professor Mohammed Safder Ali
Course language
English
Category
SQL
Instructor
Instructor
Professor Mohammed Safder Ali
Course language
English
Category
SQL
To gain complete access, login with gmail or outlook, no need of signup. click here

COURSE DETAILS

This course is designed to provide a comprehensive understanding of MySQL, a robust open-source relational database management system. Participants will delve into the fundamental concepts of database design, querying, optimization, and administration, gaining hands-on experience to master this powerful tool.

WHAT YOU'LL LEARN

✓Database Fundamentals: Principles of relational databases, data modeling, normalization, and ER diagrams.
✓Data Definition & Manipulation: DDL commands for creating/altering structures and DML for managing data.
✓SQL Basics: Querying from scratch — CRUD operations, joins, subqueries, and views.
✓Advanced Querying: Indexing, stored procedures, triggers, and transactions.
✓MySQL Installation & Config: Set up MySQL instances, manage users, permissions, and security.

REQUIREMENTS

Skills in understanding elementary-level English.

COURSE CONTENT

∨Chapter 1 - Course Introduction
1 lecture
Live SQL Training
∨Chapter 2 - Introduction to Software Applications
9 lectures
Application Software Software Development Life Cycle Database Components Database Platforms GUI tools for SQL Development Tansy Cloud Business Application Assignment: Analyzing Zoom Business Application Assignment - Analyzing Facebook Social Application Assignment: Analyzing WhatsApp Mobile Application
∨Chapter 3 - Database Tables, Columns and Rows
5 lectures
Database Table ROWs and COLUMNs SQL Assignment - List Tables and Columns - Company Management System Assignment - List Tables and Columns - Student Management System
∨Chapter 4 - Setup Sample Database
2 lectures
MySQL Query Editor Database Hosting
∨Chapter 5 - DDL (Data Definition Language)
12 lectures
CREATE TABLE ALTER TABLE DROP TABLE Data Types JSON Data Type NUll vs NOT NULL CHECK Constraint DEFAULT Constraint UNIQUE Constraint AUTO INCREMENT SQL DDL ASSIGNMENT1 - Company Management System DDL ASSIGNMENT2 - Student Management System
∨Chapter 6 - DML (Data Manipulation Language)
8 lectures
INSERT SELECT INTO UPDATE UPSERT DELETE TRUNCATE DML ASSIGNMENT1 - Company Management System DML ASSIGNMENT2 - Student Management System
∨Chapter 7 - DQL (Data Query Language)
44 lectures
SELECT * WHERE Clause LIMIT DISTINCT ORDER BY BETWEEN Operator CONCAT IN Operator NOT IN Operator IS NULL Operator IS NOT NULL Operator 'AND' and 'OR' Operators '>' and '<' Operator (greater than, less than) '< >' or '!=' Operator (not equal) '=' (equal to) Operator LIKE Operator NOT LIKE Operator EXISTS, ANY and ALL Clause SQL Aliases GROUP BY HAVING Clause COUNT, SUM, AVG, MIN, MAX Functions CASE statement INNER JOIN LEFT JOIN RIGHT JOIN UNION and UNION ALL PIVOT Sub Queries GROUP RANK JSON SELECT Arithmetic Operators Comparison Operators Logical Operators STRING functions DATE functions NUMERIC functions SQL Execution Order CAST COALESCE DQL ASSIGNMENT1 - Company Management System DQL ASSIGNMENT2 - Student Management System DQL ASSIGNMENT3 - SQL Logic for Dashboard Reporting in a Company Management System DQL Assignment 4 - MySQL Logic for Dashboard Reporting in a Student Management System
∨Chapter 8 - RDBMS Concepts
15 lectures
What is RDBMS Primary Key Foreign Key Cardinality Normalization Second Normal Form Third Normal Form Business key, Natural key and Candidate Key Surrogate Key Database Index Index Types Structured VS Unstructured ERD (Data Model) SQL ERD Data Model Assignment - Company Management System SQL ERD Data Model Assignment - Student Management System
∨Chapter 9 - Advanced Topics
6 lectures
Database View MySQL Stored Procedure DB Function DB Trigger Common Table Extensions (CTE) SQL Window Functions
∨Chapter 10 - Projects
2 lectures
Final Capstone Project 1: Company Management System in MySQL Final Capstone Project 2: Student Management System in MySQL
∨Chapter 11 - SQL Certifications
1 lecture
SQL certifications

STUDENT REVIEWS

No Review Found

TAGS

No Tag Found

COURSE VIDEOS