The Complete Oracle SQL course for Data Analysts -A-Z of SQL

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

Show more