Sql syllabus

SQL syllabus

1. ================
Introduction
================

 Introduction
 What Database?
 What is table?
 What is tuple?
 Flavors & Vendors of databases?
 Who is DBA?
 Who is Database Design and Database Architecture?


=================
SQL in detailed
=================

 SQL Commands Classification
 SQL SELECT
 SQL DISTINCT
 SQL WHERE
 SQL AND OR
 SQL IN
 SQL BETWEEN
 SQL Wildcard
 SQL LIKE
 SQL ILIKE
 SQL ORDER BY
 SQL GROUP BY
 SQL HAVING
 SQL ALIAS
 SQL AS
 SQL SELECT UNIQUE
 Playing with SQL

=================
Joins
=================
 SQL JOIN
 SQL INNER JOIN
 SQL OUTER JOIN
 SQL LEFT OUTER JOIN

2.  SQL CROSS JOIN
 SQL INSERT INTO
 SQL INSERT INTO SELECT
 SQL UPDATE
 SQL DELETE FROM
 SQL INTO


=============
Advanced SQL
=============
 SQL UNION
 SQL UNION ALL
 SQL Inline View
 SQL INTERSECT
 SQL MINUS
 SQL LIMIT
 SQL TOP
 SQL Subquery
 SQL EXISTS
 SQL CASE
 SQL DECODE
 SQL AUTO INCREMENT
 SQL IDENTITY
 SEQUENCE & NEXTVAL
 SQL Functions
 SQL Average
 SQL COUNT
 SQL MAX
 SQL MIN
 SQL SUM
 SQL ROUND
================
String Functions
==============
 SQL CAST
 SQL CONVERT
 SQL CONCATENATE
 SQL SUBSTRING
 SQL INSTR
 SQL TRIM
 SQL LENGTH
 SQL REPLACE
 SQL TO_DATE

3.  SQL ROWNUM
=============
Date Functions
===============

 SQL CREATE TABLE
 SQL Data Types
 SQL View
 SQL CREATE VIEW
 SQL Index
 SQL CREATE INDEX
 SQL DROP TABLE
 SQL TRUNCATE TABLE
 SQL USE
 SQL CREATE DATABASE
 SQL DROP DATABASE

================
SQL CONSTRAINT
================
 NOT NULL Constraint
 DEFAULT Constraint
 UNIQUE Constraint
 CHECK Constraint
 PRIMARY KEY
 FOREIGN KEY
 SQL ALTER TABLE
 Add Column
 Modify Column
 Rename Column
 Drop Column
 Add Index
 Drop Index
 When to Create Index
 Add Constraint
 Drop Constraint
 SQL NULL
 SQL ISNULL Function
 SQL IFNULL Function
 SQL NVL Function
 SQL Coalesce Function
 SQL NULLIF Function
 COALESCE VS NULL IF
 SQEUENCE

4. ===============
Dive Deep in to SQL
=================
 Temporary table creation/delete
 Rank
 Comments
 Explain and Describe
 JSON and JSONB , HStore data type in Postgresql
 Functions in SQL
 Database Performance tuning ( Testing SQL Queries Performance)
 Soft Delete
 Log table (Audit table)
 Industry Terminologies in SQL
 SQL Keywords Review
 Best practices in SQL ( Developer & Tester perspective)




Tasks:

 Create database for a software company(Suggested).
 Daily boost the database with the new table created and constraint
added.
 Create Queries Repository on the database
 Testing with load of data (performance testing)
 Tuning the database to give us better result
 Normalization and De-Normalization( When to do it)