Introduction to DBMS, What is a Database, What is Management System, Different views of data, Advantages and disadvantages of RDBMS,Introduction to SQL,Sub language of SQL (DDL, DML, DQL/DRL, TCL & DCL).
What is a database table?, How do we create tables?, How do we insert Data?, How to retrieve/select data?, How do we delete data?, How do we update data?
Logical operators, Between operators, In operator, Pattern matching operators.
Detailed coverage of DDL (Data definition language):CREATE, ALTER, DROP, TRUNCATE, RENAME.
MySql Functions, Aggregate functions,Scalar functions (String functions, date related, numeric related, conversion function, null related functions.),Group by, order by, having clause.
Integrity constraints (column and table level). Different types of constraints.
Inner Join, Left Join, Right join and full join.
Triggers, Procedures, Functions, Views and ACID properties.
Normalization (1NF, 2NF, 3NF & BCNF).