Why this course?

Description

SQL is a domain – specific language used in programming and designed for managing data held in RDBMS system . This course covers some basic sql concepts like database creation , drop database , table creation and insert queries . It will also help you create some databases for some real-time applications which will help aspiring candidates to kick-start their career in DBMS.

Total Duration: 4 Hrs       Modules : 2              Assignments : 2

Capstone Project : 1

Related Tags: sql , dbms , rdbms.

Module 1: SQL  Introduction, Basic Concepts(2 Hrs)

Module 2: SQL Table , Queries , Applications(2 Hrs)

Module 1: SQL Introduction, Basic Concepts(2 Hrs)
Lesson 1: SQL Introduction(1 Hr)

Overview – RDBMS Concepts – Databases – Syntax – Data Types – Operators - Expressions

Assignment 1: Student Database Management System

Lesson 2: Basic Concepts(1 Hr)

Create Database – Drop Database – Select Database – Rename Database – Rename Database – Show Database – Backup Database 

Assignment 2: Railway Management System

Module 2: SQL Table , Queries , Applications(2 Hrs)

Lesson 3: SQL Table , Queries(1 Hr)

SQL – Create Table – Show Tables – Rename Table – Alter Table – Drop table – Delete Table – Constraints – Insert Query – Update Query – Delete Query – Sorting Results 

Assignment 3: Hospital Management System

Lesson 4: SQL – Applications(1 Hr)

Applications Using SQL

Assignment 4 : Payroll Management  System

Capstone Project : 1

Projects:

Blood Donation Database

Cookie Recipe Database