SQL Database Bootcamp

Structured Query Language, abbreviated as SQL, is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

Now- a- days, it is consider one of the most demandable tools and it is an obvious skill to become the Data Scientist.

Course Outline:

Class 1: Why Study SQL? Introduction to Database; SQL as a declarative language; Data Definition Language (DDL); Data Manipulation Language (DML); Data Control Language (DCL); Transaction Control Language (TCL); SQL SETUP and Installation
Class 2: Relational Database Essentials; Databases VS Spreadsheets; Primary key; Foreign key; Unique key; Null Values and Relationship between database.
Class 3: Creating a Database; Introduction to Data Types; Integer, Fixed and Floating-Point Data Types, Other Data Types. Creating a Table and integrate Databases and Tables (Exercise)
Class 4: Primary Key Constraint; Unique key Constraint; Default Key Constraint; Not value Key Constraint; Store Database
Class 5: SQL Select Statement: SELECT - FORM, Where, or, and. Operation Precedence; In-Not In; Like - Not like; Wildcard Characters; BETWEEN…AND
Class 7: IS NOT NULL – IS NULL; Other Comparison Operations; SELECT DISTINCT;
Introduction to Aggregate Function- ORDER BY; GROUP BY; Using Aliases; HAVING; WHERE vs HAVING; LIMIT;
Class 8: SQL INSERT, Update and Delete Statement
Class 9: SQL Aggregate Functions: Count (); Sum (); Avg (); Min (); Max ().
Class 10: SQL Joins: left, right, inner, and outer Join
Class 11: SQL Subqueries - SQL Subqueries with IN nested inside WHERE, with EXISTS-NOT EXISTS; Select and Form
Class 12: Handle Stored Procedure; Stored procedures; Stored procedures with Input Output Parameter
Class 13: Types of MySQL Variables – Local, Session and Global Variable; MySQL Triggers and Indexes
Class 14: MySQL Case Statement with different Practice

To get admitted knock us in our Facebook page.