Avoid scams by dealing locally! Always exchange items and money in person and Never pay in advance. More info
Oracle SQL / PL-SQL Corporate Online Training Services
What is Oracle SQL / PL-SQL?
PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.
PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java.
PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same Datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable.
Oracle SQL / PL-SQL Corporate Online Training Course Content: -
SQL:
1. Introduction to SQL
2. SQL standards
3. Datatypes in Oracle
4. Operators in Oracle
5. about Table Creation
6. Inserting Data
7. Data Retrieval:
8. SELECT statement
9. Column alias, Table alias
10. Clauses in SQL
11. Data filtering using WHERE clause
12. Data Sorting using ORDER BY clause
13. DML Commands (insert, update, delete, merge)
14. DDL commands:
15. Difference between DELETE and TRUNCATE
16. Integrity Constraints:
17. Built - in Functions:
18. Data Aggregation:
19. Group by clause
20. Having clause
21. Cube & Rollup
22. Difference between WHERE and HAVING clause
23. Joins
24. SET operators
25. Pseudo columns
26. ROWID, ROWNUM
27. Subqueries
28. In - line views
29. DCL - Commands
30. Database Security
31. Views
32. Synonyms
33. Indexes
34. Clusters
35. Materialized views
36. Sequences
PL/SQL:
1. Introduction to PL/SQL
2. Advantages of PL/SQL
3. PL/SQL architecture
4. Datatypes in PL/SQL
5. PL/SQL program structure
6. Simple PL/SQL programs
7. Embedding SQL statements in PL/SQL
8. Conditional statements
9. Loops
10. Cursors:
11. Exception Handling:
12. Subprograms:
13. Functions
14. Packages
15. Triggers
Respond to this adAd ID: 3262697
Similar ads:IBM WESB | Websphere Enterprise Service Bus Online Training
We Start New Batch for Every 15 Day, Fast Track On Demand and Group Training Available on Weekend & Weekdays ... Quontra Solutions enables you with the best online training in Selenium testing training with hands-on experienced testing professionals as instructor’s and one to one training by ... Java/J2EE Online training courses are in great demand nowadays owing to the ever growing requirement of the I.T industry regarding hiring of successful Java web developers. Java ... SAP Plant Maintenance Training
Classifying Plant Maintenance from a Business perspective
Definitions
Traditional forms of Organization in Plant ... ComputerTrainingsOnline.com is a world of java training to mentor you to become a professional java developer through our coaching. We offer unique range of IT training to the ... Java is one of the prominent computer programming language. JAVA has consolidated in the areas of web applications compare to other programming languages. With JAVA SE, we can ... QA Online Training Course Advantages:
Advanced level of knowledge of Software Testing and Test Requirement analysis phases and more.
Potentially higher income for being ...
