|
Course Content
1. Introduction to RDMS Concept
2. Introduction to SQL Concept
3. Getting Started SQL with MySQL and Oracle
4. Getting information about database and table
5. Keywords, Operators, Data types
6. Types of Statements (DML, DCL, DDL, TCL)
7. Basic SQL Queries
8. Grouping an set operation on data
9. Aggregate and scalar functions
10. Join and Types of Join
11. Some pseudo columns, constraints, views
12. Some of the best practices to be followed in optimize queries
13. References
Contact:
Visit our web site: www.iqdistlearn.com, Email-iqti1n@yahoo.com.com.
Integrated Quality Training Institute
M-17, 6th Main Road,
HAL 3rd Stage,
Jeevan Bima Nagar,
Bangalore – 560075,
Karnataka.
Mob: 9844172104, 9964216879, Ph: 08025285476.
Rekha, Amit
|
