Lecture

Here is a summary of the lectures conducted previously.

1. Oracle Database SQL

Learn about SQL, a language for handling RDBs, primarily focusing on Oracle Database.

1. Basic concepts of DBMS
2. SELECT, FROM, WHERE clauses and various operators
3. BETWEEN A AND B clause, LIKE clause and wildcards, set operators, is null operator, INTERSECT operator
4. dual table, functions, single-row functions, upper, lower, initcap, replace, substr, length, etc.
5. Single-row functions, date data, etc.
6. Multi-row functions (sum, avg, max, min, count), grouping (group by, cube, rollup)
7. Join
8. Subquery, DML, DDL

2. Python Basic

Learn the basics of Python and the essentials needed for coding.

1. Programming languages, Python overview, variables, operators
2. Data structures: list, tuple, set, dictionary
3. Conditional statements, loops
4. Functions 1
5. Q&A session, Functions 2
6. Classes, inheritance
7. Modules