SQL --- Basic Syllabus

1. Introduction to SQL(pronounced SEQUEL) full form Structured Query Language
2. Create Table Statement
3. Insert, Update and Delete
4. Select Statement
1. Use of Where clause
2. Relational Operators <, >, <=,>=,<>,=
3. IN, BETWEEN, AND, OR, NOT
4. Nested Queries
5. Aggregate Queries max,min,sum,avg,count. Use of group by and having
6. Queries from more than one table
7. Joins--- Inner, Left, Right and Outer
8. Union, Union All, Minus, Intersect
9. Order By and ROWNUM
5. Keys--- Primary, Unique and Foreign
6. Normalization--- 
1. First Normal Form
2. Second Normal Form
3. Third Normal Form
4. Fourth Normal Form
5. BCNF
6. Fifth Normal Form
7. Check Constraints
8. Dates.
9. Revision and Assignments

1. 
   

Contact us for software training, education or development