Description
In this course, you will learn :
- How to Get and Install Oracle.
- Oracle SQL Developer should be downloaded and installed.
- How to Make a Table in Oracle
- Understanding various Oracle statements.
- Data analysis techniques.
- Using aggregate functions, you can aggregate result data.
- Grouping data of any table
- oracle database
- sql oracle
- sql developer
- oracle database
- select statement
Syllabus :
1. Setting up Environment
- Oracle Database Download
- OPENING SQL DEVELOPER
- CREATING CONNECTION
2. Database Operations
- Creating a new table
- Altering an existing Table
- Understanding Primary and Foreign Key
3. Data Manipulation
- Insert data in Table
- SELECT Command
- Updating values in Table
- DELETE data from table
- WHERE Clause
- ORDER BY Clause
- DROP a Table
4. Logical and Mathematical Operation
- Use of AND & OR
- How to use IN and NULL
- Use of LIKE function
- Mathematical Functions
5. Dealing with Characters
- SUBSTR & INSTR Function
- LAPD,RPAD & TRIM Function
- How to CONCATENATE
- LOWER & UPPER Function
- How to replace character in a string
- FETCH FIRST N ROWS ONLY & ROWNUM Function
6. JOINS IN SQL
- JOIN AND ITS TYPE