Oracle Database
About this course
This course of study introduces students to basic relational database concepts. The course teaches students relational database terminology, as well as data modeling concepts, building Entity Relationship Diagrams (ERDs), and mapping ERDs. Oracle SQL Developer Data Modeler is utilized to build ERDs and The Structured Query Language (SQL) is used to interact with a relational database and manipulate data within the database. Oracle Application Express is used utilized to provide practical, hands-on, engaging activities. Leveraging project-based learning techniques, students will create and work with projects which challenge them to design, implement, and demonstrate a database solution for a business or organization.
Curriculum
Module 1: Selecting columns (10 Hours)
- Onboarding | Tables
- Onboarding | Query Result
- Onboarding | Errors
- Onboarding | Bullet Exercises
- SELECTing single columns
- SELECTing multiple columns
- SELECT DISTINCT
- Learning to COUNT
- Practice with COUNT
Module 2: Filtering rows (10 Hours)
- Filtering results
- Simple filtering of numeric values
- Simple filtering of text
- WHERE AND
- WHERE AND OR
- BETWEEN
- Introduction to NULL and IS NULL
- LIKE and NOT LIKE
Module 3: Aggregate Functions (10 Hours)
- Aggregate functions
- Combining aggregate functions with WHERE
- A note on arithmetic
- It's AS simple AS aliasing
- Even more aliasing
Module 4: Sorting, grouping and joins (10 Hours)
- ORDER BY
- Sorting single columns
- Sorting multiple columns
- GROUP BY
- HAVING a great time
- All together now
- A taste of things to come
Reviews
Prerequisites
There are no prerequisites for this course; however, some prior programming language knowledge is helpful.
Course Details
- Course Type Full-time
- Course Location Mira Road, Mumbai
- Fee Offered 15000
- Starting Salary Offered 20000
- Minimum Eligibility 12+
- Employment Opportunities Oracle, Micrasoft etc
Certification
Certification can be a useful tool to add credibility, by demonstrating that your profile meets the expectations of your Industry.
