DIPLOMA IN ORACLE DATABASE COURSE
Course Duration : 4 Months
SQL fundamental concepts and syllabus.
- Listing The Features Of Oracle Database 10g/11G/12C
- Discussing The Basic Design, Theoretical And Physical Aspects Of A Relational Database.
- Describing The Development Environments For SQL
- Describing Oracle SQL Developer, Describing The Data Set Used By The Course.
- SDLC(SOFTWARE DEVELOPMENT LIFE CYCLE).
- ERD(ENTITY RELATIONSHIP DESIGN).
- PROJECT ALLOCATION.
- IMPLEMENTATION OF PROJECTS USING SQL PLSQL.
- Listing The Capabilities Of SQL SELECT Statements Like Projection Selection And Join.
- Generating A Report Of Data From The Output Of A Basic SELECT Statement.
- Using Arithmetic Expressions In The SELECT Statement.
- Using Column Aliases And Naming Column In Report.
- Using Concatenation Operator, Literal, Alternative Quote Operator, And The DISTINCT Keyword.
- Displaying The Table Structure Using The DESCRIBE Command.
- Writing Queries With A WHERE Clause To Limit The Output Retrieved Using The Comparison Operators And Logical Operators.
- Describing The Rules Of Precedence For Comparison And Logical AND Conditional Operators.
- Writing Queries With An ORDER BY Clause To Sort The Output.
- Sorting Output In Descending And Ascending Order.
- Using The Substitution Variables.
- Differentiating Between Single Row And Multiple Row Functions.
- Manipulating Strings Using Character Functions Like SUBSTR,INSTR,LENGTH,LOWER ,UPPER,TRIM Etc.
- Manipulating Numbers With The ROUND, TRUNC And MOD Functions.
- Performing Arithmetic With Date Data Types.
- Manipulating Dates With The Date Functions.
- Describing Implicit And Explicit Data Type Conversion.
- Using The TO_CHAR, TO_NUMBER, And TO_DATE Conversion Functions.
- Nesting Multiple Functions Single Row And Multiple Row Functrions.
- Applying The NVL, NULLIF, And COALESCE Functions To Data.
- Using Conditional IF THEN ELSE Logic In A SELECT Statement.
- Decode Function.
- Using The Aggregation Functions In SELECT Statements To Produce Meaningful Reports.
- Using AVG, SUM, MIN, And MAX Function.
- Handling Null Values In A Group Function.
- Creating Queries That Divide The Data In Groups By Using The GROUP BY Clause.
- Creating Queries That Exclude Groups Of Date By Using The HAVING Clause.
- Difference Between HAVING Clause And WHERE Clause.
- Writing SELECT Statements To Access Data From More Than One Table.
- Viewing Data That Does Not Meet A Join Condition By Using Outer Joins.
- Joining A Table By Using A Self Join.
- Creating Cross Joins(Cartesian Product).
- Using A Subquery To Solve A Problem.
- Executing Single-Row And Multiple Row Sub-Queries.
- Using Group Functions In A Sub-Query.
- Using The IN,ANY And ALL Operator In Multiple-Row Sub-Queries.
- Describing The SET Operators.
- Using UNION, UNION ALL, INTERSECT, And MINUS Operator.
- Using The ORDER BY Clause In Set Operations.
- DML INSERT ,UPDATE DELETE Statement.
- Using DROP And TRUNCATE Statements.
- Saving And Discarding Changes With The COMMIT And ROLLBACK Statements.
- Read Consistency.
- Database Objects.
- Creating Tables Using The CREATE TABLE Statement And Describing The Data Types.
- Types Of Constraints.
- Creating A Table Using A Subquery.
- Altering And Dropping A Table.
- Copying Data Using Subquery.
- Creating, Modifying, And Retrieving Data From A View Object.
- Performing Data Manipulation Language (DML) Operations On A View.
- Dropping A View.
- Creating, Using, And Modifying A Sequence.
- Creating Indexes.
- Creating Synonyms.
- SQL FUNDAMENTAL II
- Introduction.
- Course Prerequisites.
- Human Resources (HR) Schema.
- Review Of Using Oracle SQL Developer.
- SQL Statements In SQL*Plus.
- Review Of Vital Concepts Of SQL Fundametal I.
- Control User Access.
- Identify The System And Object Privileges.
- Create Users And Altering User.
- Grant System And Objects Privileges.
- Create And Grant Privileges To A Role.
- Altering Your Password.
- Revoke Object And System Privileges.
- Management Of Schema Objects.
- Add, Modify, And Drop,Defer A Column And Constraints.
- Enable And Disable A Constraint.
- Create And Remove Indexes.
- Create A Function-Based Index.
- Perform Flashback Operations Using FLASHBACK Command.
- Create An External Table By Using ORACLE_LOADER And By Using ORACLE_DATAPUMP.
- Manage Objects With Data Dictionary Views.
- What Is The Data Dictionary Views.
- USER_OBJECTS And ALL_OBJECTS Views.
- View Table And Column Information, Constraint Information.
- Query The Dictionary Views For View, Sequence, Index And Synonym Information.
- Add A Comment To A Table.
- Manipulate Large Data Sets.
- Retrieve Data Using A Subquery.
- Insert Data Using A Subquery As A Target.
- Use The WITH CHECK OPTION Keyword On DML Statements For View.
- List The Types Of Multitable INSERT Statements.
- Identify Multitable INSERT Statements.
- Merge Rows In A Table Using MERGE Command.
- How To Track Changes In Database Transactions.
- Data Management In Different Time Zones.
- The CURRENT_DATE, CURRENT_TIMESTAMP, And LOCALTIMESTAMP Functions.
- Describe DBTIMEZONE And SESSIONTIMEZONE In Timestamp.
- List The Differences Between DATE And TIMESTAMP Data Types.
- Identify The INTERVAL Data Types Year To Month And Day To Seconds.
- Use TO_TIMESTAMP, TO_YMINTERVAL, And TO_DSINTERVAL,EXTRACT FUNCTIONS.
- Retrieve Data Using Subqueries.
- Multiple-Column Subqueries With Types Pairwise And Nonpairwise.
- Correlated Subqueries.
- Insert,Update And Delete Rows Using Correlated Subqueries.
- Use The EXISTS And NOT EXISTS Operators.
- Use The WITH Clause In SQL.
- Regular Expression Support.
- Meta Characters With Regular Expressions.
- Perform A Basic Search Using The REGEXP_LIKE Function With Operator.
- Find Patterns Using The REGEXP_INSTR Function With Operator.
- Extract Substrings Using The REGEXP_SUBSTR Function With Operator.
- Replace Patterns Using The REGEXP_REPLACE Function With Operator.
- Hierarchical Retrival In SQL:
- Top Down And Bottom Up Approach.
- Connect By Clause.
- Start With Clause.
- Difference Between Connect By And Where Clause.
- ROLLUP AND CUBE Grouping Operator.
- GROUPING Function.
- Concanated Grouping With Grouping Sets.
- Composite Grouping.
