Sql Basics
Popular DBMS Software,Concepts of RDBMS, Tables,Tuples ,Attributes, Normalization Normalization,NoSQL Databases, Types of NOSQL, Comparision,Types of SQL Commands,Data Definition Language, Create, Drop, Truncate, Alter and Rename Objects,Data Query Language, Select Statements, Data Manipulation Language, DCL and TCL, Grant, Revoke and transaction statements, SQL Data Types, Numeric, Date and TIme, LOB Types , DML Commands,Insert, Update and Delete Statements,DDL Commands,Create and Drop Databases
Sql Integrity and data management
Types of Constraints, Relational Integrity Constraints, Key Constraints, Domain Constraints, Referential Integrity, Primary and Foreign Keys, Application of Indexes,Checking Constraints,Alter Tables, SQL Transactions, ACID Properties, TCL Statements, Start, Commit and Rollback Statements, Auto Commit, SavePoints, Identifier, Rollback and Release, Database Objects, Tables, Creating, Altering and dropping tables
SQL Advanced Concepts
Views, Creating and Dropping Views, Indexes, Types of Indexes, Creating and dropping Indexes, Stored Objects, Types of Stored Objects, Stored Procedures, Create, call and drop stored procedures, Repeat and Leave Statements, Operators and Functions, Joining Tables, Inner Join, Left Join, Right join, Advantages of Procedures, Database Triggers Accessing Database From R and Python, Triggers, Triggers v/s Stored Procedures, Configuration Information, Python Database Access, Read Operations, Insert, Update and Delete, Performing Transactions.