Oracle SQL PLSQL Training Online Tutorial Course
What you'll learn
- Will be creating database
- Will be manipulating database
- Will be able to write programs
Requirements
- No Prerequisite is needed
Description
Oracle SQL PLSQL Training Course (A Prerequisite Course for Oracle Apps Technical Course Learners) with Live Meeting Support to clear your queries on every Sunday. You will receive the meeting link for the support session on every Friday to your Udemy registered mail id through Udemy educational announcement mails.
Topics covered are Introduction to RDBMS, Introduction to SQL, Oracle data types, classification of sql, DDL and DML Commands, DDL and DML Commands Continued, Integrity Constraints, SQL Functions, Character Functions, Number Functions, SQL Functions Continued, Date Functions, Group Functions, Joins, Sub Queries and Clauses, Database Objects, Database Objects Continued, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Looping Structure While and Nested Loops, Looping Structure Continuation, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages.
Who this course is for:
- Any Graduate
Course content
- Preview23:18
- 23:11Oracle data types
- 22:46DDL and DML Commands
- 22:36DDL and DML Commands Continued
- 23:43Integrity Constraints
- 23:56SQL Functions
- 19:45SQL Functions Continued
- 27:33Joins
- 26:41Sub Queries and Clauses
- 23:00Database Objects
- 20:14Database Objects Continued
- 22:44DCL and TCL Commands
Instructor
• As I Deal ONLY with ORACLE RELATED TECHNOLOGIES You Can Expect a Clear and Targeted Concept on all my Courses i Publish.
• Senior Oracle Apps and Fusion Trainer With 12 Yrs Exp on Oracle Apps and 15 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, SQL, PL/SQL and D2K.
• Having 12 years of work experience in Oracle Applications and Fusion in different areas like design, development and implementation of business requirements through direct interaction with customers.
• Worked in Oracle technologies SQL, PL/SQL, Forms 6i& 10g, Reports 6i& 10g both development and support.
• Experience in working with Oracle Utilities like SQL*Loader, Interfaces.
• Having work experience in Financial (AP, GL, AR), Distribution ( OM) and Manufacturing (INV), Purchasing modules in Oracle Applications R12 and Fusion.
• Development and Customization of Reports, Interfaces, Conversions as per client requirements. Having ample knowledge in Procure to Pay & Order to Cash life cycles.
•.Providing training for clients around the globe from USA, UK, Canada, Australia, Newzealand, South Africa, Japan, UAE, Dubai, Saudi Arabia, Kenya, Somalia, India, Singapore and Malaysia.