Course Details

What You Will Learn?

1. Introduction to sql

·         1.1 Data

·         1.2 Database

·         1.3Database management system (dbms)

·         1.4Relational database management system (rdbms)

·         1.5 Table

2. Datatypes

·         2.1. Char(size) datatype

·         2.2. Varchar(size) datatype

·         2.3. Varchar2(size) datatype

·         2.4. Date datatype

·         2.5. Number(precision,[scale]) datatype

·         2.6. Large objects

§  2.6.1. Character large objects

§  2.6.2. Binary large objects

3.operators

·         3.1. Arithmetic operators

·         3.2. Logical operators

·         3.3. Concatenation operator

·         3.4. Relational operator

·         3.5. Comparision operator

·         3.6. Special operator

§  3.6.1.in

§  3.6.2.not in

§  3.6.3. Between

·         3.7. Sub query operators

§  3.7.1. Any

§  3.7.2. All

§  3.7.3. Exists

§  3.7.4. Not exists

4. Sql languages

·         4.1. Data defination language (ddl)

·         4.2. Data manipulation language (dml)

·         4.3. Data control language (dcl)

·         4.4. Transition control language (tcl)

·         4.5. Data query language (dql)

5. Constraints

·         5.1. Unique constraints

·         5.2. Not null constraints

·         5.3. Check constraints

·         5.4. Primary key constraints

·         5.5. Foreign key constraints

6. Joins

·         6.1. Cartesian join (or) cross join

·         6.2. Inner join (or) equie join

·         6.3. Outer join

·         6.3.1. Left outer join

·         6.3.2. Right outer join

·         6.3.3. Full outer join

·         6.4. Self join

·         6.5. Natural join

7. Clauses

·         7.1. Group by clause

·         7.2. Having clause

8. Aggregate functions

9. Sub query

·         9.1. Single row sub query

·         9.2. Multi row sub query

·         9.3. Nested sub query

10. Triggers

11. Views

12. Indexes

13. Stored procedures

14. Normalization and de normalization