Oracle SQL training Bangalore| Oracle 11g/12c SQL training institute DTecH


Oracle Sql Training institute Bangalore | Oracle 11g/12c SQL

Oracle 11g SQL Training

sql training institute bangalore, oracle sql  training course, best oracle sql  training institute in bangalore, sql  training bangalore, sql developer training bangalore, oracle 11g sql course, oracle 11g sql training, oracle 12c sql training

In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. 

 Contact: 08041501359, 7259893449

About the Instructor:

DTecH Certified  & well experienced real time trainers. 
100% money back guarantee if you don’t like the training.

Audience:

Freshers and beginners who are new to SQL
Business Analysts 
BCom, MCom graduates
Candidates from Non IT Background
Candidates from Finance sector

Duration: 8-12 Sessions, 8-10 days, 2-3 hrs per day

Availability: Weekdays 8AM & 10AM, Weekends 8AM, 11AM, 2PM

Training mode:  Live Instructor led training

Course materials: 

Both course & lab materials provided.

Software Setup & Lab: 

Will provide access our Oracle Server for Lab sessions.
Support provided to install on student laptops.

Prerequisites:

Familiarity with data processing concepts and techniques.

Course Topics

Download Oracle SQL training detailed syllabus here 

 MAIN TOPICS

 

1. SQL SELECT Statement
2. WHERE Conditions
3. Arithmetic Operators
4. Concatenation Operator
5. Logical Operators
6. Sorting (Order by)
7. SQL Functions
8. Single row functions
9. Aggregate / Group functions
10. Group by Clause
11. ORACLE Join Operations
12. Using Sub queries
13. DML - INSERT, UPDATE, DELETE
14. TCL - COMMIT, ROLLBACK
15. DDLs – CREATE, ALTER,
16. DROP, TRUNCATE
17. SYNONYMS
18. SEQUENCES
19. INDEXES
20. Quote (q) Operator
21. ORDER BY For NULLs
22. Positional Sorting
23. Substitution Variables
24. RR Date Format
25. Datatype Conversion Functions
26. CASE vs DECODE
27. Group Functions and Null Values
28. Where vs Having
29. Nesting Group Functions
30. SQL99 Join - Natural Joins
31. Correlated Sub Queries
32. Set Operators
33. Savepoint - Partial Rollback
34. Constraints
35. Read-Only Tables
36. Complex Views
37. DML Operations on a View
38. WITH CHECK OPTION
39. Function based Indexes

 

Download Oracle SQL training detailed syllabus here

Call us to talk about your training requirements:
+91 (80) 4150 1359, +91 7259893449