Oracle SQL (1Z0-071) Certification Course

The video is in Georgian.

Course Description:

Schedule: Tuesday, Thursday 20:00–22:00 (Tbilisi time, GMT+4)

Course Objective:

• To teach students to code in SQL from zero to an advanced level
• To prepare students for the Oracle 1Z0-071 exam
• To enable graduates to solve complex problems independently using SQL code

---

Course Concept:

• Students are introduced to databases, their structures, architecture and types
• The course is built around extensive hands-on work, in which students can reinforce what they have learned in theory by putting it into practice
• The course also includes self-study assignments (after every lecture) with exercises on the material covered
• The course ends with an exam that closely resembles the Oracle 1Z0-071 exam

---

Tools and Minimum Requirements:

Basic knowledge of information technology.

At least A2-level English (B1 or higher preferred).

No knowledge of mathematics or programming is required to complete the course successfully.

---

Tests and Exam:

• Throughout the course, the second half of every lecture is devoted to hands-on work
• After the lectures, participants receive assignments covering the material studied
• At the end of the course there is a mock exam closely modeled on the Oracle 1Z0-071 exam

---

Course Curriculum:

1. Course introduction & environment setup
2. SELECT statements, restricting & sorting data
3. Single-Row Functions - character, date, numeric & general functions
4. Aggregate functions & grouping data
5. Logical conditions & conversion functions
6. Midterm project
7. Joining tables - JOINS
8. Subqueries - basics, correlated & scalar
9. SET Operators
10. Data manipulation statements - DML Statements
11. Data creation & definition statements - DDL - Creating Tables & Constraints
12. Database objects
13. Security & access management
14. Time zone management
15. Review of the material covered
16. Final project
17. PL/SQL Introduction

Detailed syllabus (PDF, in Georgian)

---

What Will You Know and Be Able to Do After the Course?

• Write SQL scripts and work with databases independently
• Work on reports of intermediate complexity
• Have the knowledge to take and pass the Oracle 1Z0-071 exam
• Be able to start working as a junior reporting manager or junior analyst, or in other positions where working with SQL databases is a must

---

About the Instructor:

Saba Kankia — an experienced data analyst at Bank of Georgia.

Saba has 4+ years of experience working with databases, both SQL and NoSQL.