MySQL Basics
-
SQL
-
Database Introduction - Data, Database, DBMS, DDL, DML, DCL, DCL, TCL
-
Keys, Normalization
-
Employee, Department Tables Creation, Insert, Insert-select
-
Data Types, Operators
-
Alter, Rename, Drop, Commit, Rollback, Savepoint, Update, Delete, Truncate, Grant, Revoke
-
Constraints, Auto Increment
-
Limit, Null, Order By, Where clause, AND, OR, NOT, Like, IN, Between, Not Between, Exists, Any, ALL
-
Aggregate Funtions, Count, Sum, Avg, Group By, Having
-
Joins, Inner join, Left join, Right join, self join, cross join, natural join, Union, Views
-
SQL Queries
-
SQL Basics All Syntax with Examples
-
PL/SQL
-
PL/SQL Introduction, Variables, Stored Procedures, Parameters - IN, OUT, INOUT
-
Conditional Statements, Switch Statement, Looping Statements - While, Functions
-
Triggers, Cursors