iOS development companies in Pune...
Collaborate with us to transform your ideas into reality, harnessing the power of ios development in pune. join the rank...
Pune
Thanks for notify us about Ad ID : 269183.
Our team will review and take appropriate action in next 24 hours. We look forward for your continuous support.
Thanks & Regards
Zamroo Team
Seller Type
Type
Duration: 30 Hours
Prerequisites
• No as such prerequisites are required.
• Familiar with database concept is advantageous.
Course Contents
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
Collaborate with us to transform your ideas into reality, harnessing the power of ios development in pune. join the rank...
Pune
Internxt is an open-source, zero-knowledge, fully end-to-end encrypted cloud storage suite based on absolute privacy and...
Pune
Safeshare.tv is a platform that allows its users to watch and share videos from youtube, vimeo, and more, without ads an...
Pune
Plesk is the only web hosting control panel you\'ll ever need to build, secure and run websites and applications in the ...
Pune