Details
Oracle SQL also known as structured query language is a database language to manage data in relational databases. SQL provides an easy and efficient way to access and maintain data. 3RI Technologies provides best SQL training in Pune. Our SQL training course in Pune gives you the understanding of database entity, data normalization and the basic functions which is been used in any DBMS. Oracle SQL is one of the best available DBMS which is further separated into two different tracks i.e. PLSQL in development track and DBA in Administration track. It is useful for any Programmer or Tester to get a better understanding of their work and technology.
- 100 % Placement Assistance
- Resume Preparation
- Interview Preparation
- Missed Sessions Covered
- Multiple Batches
- Flexible Timings
- Practice Course Material
- Assistance will be provided for Oracle certification.
- Basic Computer Fundamental Skills
- 40 Hours
- Individuals who want to become DBA
Outline
- Writing Basic SQL SELECT Statements
- SQL Overview
- Arithmetic Expressions
- NULL Value
- Column Alias
- Concatenation Operator
- Literals
- Eliminating Duplicate Rows
- Restricting and Sorting Data
- WHERE clause
- Logical Operators
- SQL Operators
- LIKE Operator
- AND, OR and NOT Operators
- ORDER BY Claus
- Row Functions
- Character Functions
- Number Functions
- Date Functions
- Conversion Functions
- General Functions
- Displaying Data from Multiple Tables
- Types of Joins in Oracle
- SQL Joins
- Aggregating Data Using Group Functions
- Group Functions
- Group By Clause
- HAVING Clause
- Subqueries
- Single Row subqueries
- Multiple Row Subqueries
- Correlated Subqueries
- Manipulating DataManipulating Data
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- MERGE Statement
- Transaction Control
- Locks
- Creating and Managing Tables
- Data Definition Language
- Data Types
- CREATE TABLE Statement
- ALTER TABLE Statement
- Rename an Object
- Comments
- 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 Constraint
- Views
- Creating a View
- Retrieving Data from a View
- Modifying a View
- Destroying a View
- User‐View
- Other Database Objects
- Sequence
- Index
- Synonyms
- Controlling User Access
- Privileges
- System Privileges
- Object Privileges
- Role
- Using SET Operators
- UNION Operator
- UNION ALL Operator
- INTERSECT Operator
- MINUS Operator
- 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
3RI Technologies is an ISO 9001:2015 certified training center in Pune, providing software courses to students and IT professionals. Established in 2010, our focus has always been to deliver the industry level trainings to students and get them placed in the industry.
Our highly experienced trainers are professionals working in the IT industry and are committed to help students and professionals to develop their skills. Being a renowned leader in the training industry, 3RI technologies has been delivering best classroom trainings on various skillsets like Selenium, Hadoop , SAP, AWS, DevOps,Java and other programming languages as well. We also deliver corporate trainings as per your customized requirements. Having 2 training institutes in Pune, Pimple Saudagar and Deccan, our classrooms are well equipped providing high end infrastructure to students.
