|
Course Content
DAY TOPICS
1 1. Data in the Database (FRONTEND and BACKEND).
2. How to extract data from a table.
3. Entities and relationships.
4. Oracle database structures.
5. Data types in SQL
2 6. SELECT statement
7. JOINS
8. WHERE clause
3 9. GROUPING
10. ORDER BY
11. Aggregate Functions.
4 12. Other string and conversion functions.
• TO_CHAR ()
• TO_DATE ()
• DECODE
• NVL ()
• UPPER ()
• LOWER ()
5 13. KEYWORDS (IN, HAVING, LIKE, EXISTS, NOT EXISTS) and WILDCARD characters.
6
14. SUBQUERY’s and types of subqueries.
15. SET OPERATIONS.
7 16. CREATE TABLE statement.
17. CONSTRAINTS
• PRIMARY KEY
• FOREIGN KEY
• CHECK
• NOT NULL
• UNIQUE
18. DDL, DML, DCL statements.
8 19. ALTER statements
20. VIEWS
21. DATE and TIME DATATYPES in Oracle
Target audience will be fresh graduates, graduates who are pursuing programming career and future BAs who will be required to do data analysis preferably on CRM and financial reports based systems.
This course is also suited for Business Analysts working on Business Intelligence systems.
Contact:
Integrated Quality Training Institute
M - 17, 6th Main road,
HAL 3rd Stage,
Jeevan Bheema Nagar,
Bangalore – 560 075,
Karnataka.
Visit our web site, www.iqtiedu.com, Email- info@iqtiedu.com
Mob: 9844172104, 9964216879, and PH: 08025285476
|
