SQL Bootcamp

This course gets you started with Database and SQL and takes you to a stage where you understand database concepts and write quality queries.

This is primarily designed for anyone who wants to know what is Database and how to use it either for Data Analysis and Reporting or to store and manipulate business data.

Course Details

Prerequisite	Computer Fundamentals
Theory Fee (Classroom)	Rs. 1500/- (Includes digital course material)
Theory Fee (Online)	Rs. 1500/- (Includes digital course material)
Digital or Physical Certificate Fee	Rs. 200/-
Software Required	SQLite Studio

Detailed Syllabus

Introduction to Database

What is database
Types of databases - Relational and Non-relational
Entities, Tuples, Attributes, Primary Key & Composite Primary key
Foreign Key

Database Management System

What is DBMS
Popular DBMS Software
Components of DBMS - Database, Kernel and Client

Introduction to SQL

What is SQL
ANSI SQL and its versions
Types of SQL Commands

SQLite3

How to install SQLite3
Using SQLite Shell
SQLite Studio 3.3
Creating and connecting to Database

SQL - Creating Tables

How to Create a Table using CREATE TABLE command
Display the structure of table
Alter the structure of table
Inserting rows into tables using INSERT command

SQL - Retrieving Data

SELECT Command
Selection & Projection
Order By Clause
Limit Clause

SQL - Manipulating Data

UPDATE command
DELETE command
Referential integrity
Transaction Management - commit and rollback

Functions

What is a Function
Numeric functions
String functions
Date functions
Misc functions

Grouping & Having

Group/Aggregate functions
Group By Clause
Having Clause

Joining Tables

Join two tables
Inner Join
Outer Join - left & right & full
Join 3 or more Tables

Sub Queries

What is Subquery
Simple Subquery
Multiple Subqueries
Nested Subqueries
Correlated Subquery

Complex Queries

Combine Join & Grouping
Combine Grouping & Subquery
Combine Join & Subquery
Combine all three

Views

What is View
Advantages of Views
Creating & using Views

Index

What is Index
Advantages of Index
Creating and using Index