We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS.
Topics Covered
1. Writing Basic SQL SELECT Statements • SQL Overview • Arithmetic Expressions • NULL Value • Column Alias • Concatenation Operator • Literals • Eliminating Duplicate Rows 2. Restricting and Sorting Data • WHERE clause • Logical Operators • SQL Operators • LIKE Operator • AND, OR and NOT Operators • ORDER BY Clause 3. Row Functions • Character Functions • Number Functions • Date Functions • Conversion Functions • General Functions 4. Displaying Data from Multiple Tables • Types of Joins in Oracle • SQL Joins 5. Aggregating Data Using Group Functions • Group Functions • Group By Clause • HAVING Clause 6. Subqueries • Single Row subqueries • Multiple Row Subqueries • Correlated Subqueries 7. Manipulating Data • INSERT Statement • UPDATE Statement • DELETE Statement • MERGE Statement • Transaction Control • Locks 8. Creating and Managing Tables • Data Definition Language • Data Types • CREATE TABLE Statement • ALTER TABLE Statement • Rename an Object • Comments 9. Including Constraints • Primary Constraints • FOREIGN KEY Constraint • NOT NULL Constraint • UNIQUE Constraint • CHECK Constraint • ALTER statement • Dropping a constraint • Disabling Constraints • Enabling Constraints • Cascading Constraints • Viewing Constraints 10. Views • Creating a View • Retrieving Data from a View • Modifying a View • Destroying a View • User?View 11. Other Database Objects • Sequence • Index • Synonyms 12. Controlling User Access • Privileges • System Privileges • Object Privileges • Role 13. Using SET Operators • UNION Operator • UNION ALL Operator • INTERSECT Operator • MINUS Operator 14. Oracle Datetime Functions • Oracle 9i Date time Support • CURRENT_DATE • CURRENT_TIMESTAMP • LOCALTIMESTAMP • DBTIMEZONE and SESSIONTIMEZONE • EXTRACT • FROM_TZ • TO_TIMESTAMP and TO_TIMESTAMP_TZ • TO_YMINTERVAL & TZ_OFFSET
Who should attend
• Freshers to make their career into IT / Software Field. • BPO guys, people who are working in different fields and want to become a DBA.
Pre-requisites
• Computer Fundamentals • Knowledge of programming techniques would be an advantage
What you need to bring
We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course.""
Key Takeaways
• RDMBS knowledge • Way to proceed for the next step which is Oracle DBA. • Way to proceed for PLSQL.