Oracle SQL + PL/SQL + Python Developer

Students will start coding while learning from reading, presentations, exercises and a final project.  Includes Oracle SQL and programming in Python.  Also includes skills needed to enter the job market as an entry level Oracle programmer or Python programmer.  NOTE: This course must be taken on a PC.  MAC is not compatible.  Dual monitors are helpful but not required.  Software requirements:  PC: Windows 7 or later; latest version of Google Chrome or Mozilla Firefox are preferred.  Microsoft Edge is also compatible.  Adobe Flash Player Adobe Acrobat Reader.  Software must be installed and operational before the course begins.  The instructional materials required for this course are included in the enrollment price; these are available online after payment is received.

1. Create relational databases, tables, queries,views.
2. Practice conditional processing using CASE.
3. Describe PL/SQL, packages, triggers, subprograms.
4. Run Python scripts, sequences, file processing, working with data.
5. Test and debug Python, unicoding and encoding.