Agenda

Introduction:
We are a group of students, coming from CCCS High School, who are exploring various topics from the computer field and recording our progress on this site built by us.

1. Computer Hardware: disassembling and assembling a computer and studying the main parts.

2. Building Website:

• - Installing JDK 17 and setting up path and environmental variables.
• - Installing webserver tomcat 10.0.2 and setting path and environmental variables, so out site can run locally on our PC.
• - Installing Microsoft VCode for html and jsp code editing.
• - Building website cccs-computerclub structure locally on PC under tomact/webapps.
• - Acquiring domain name cccs-computerclub.com
• - Hosting our site code on web hosting server mochahost, so our site is searchable and available to the public.

2.1. Code Learning:

• 2.1.1. Reading The Web Wizard's Guide to XHTML by Cheryl M. Hughes.
• 2.1.2. Reading The Web Wizard's Guide To Java Script by Steven G. Estella.
• 2.1.3. Building the main webpage, index.jsp, tabs, experimenting with formatting and css styling.
• 2.1.4. Building simple action of sending email with validation rule of reading email input values, checking for ''.'' and '@; and
• displaying a message in a pop up window.
• 2.1.5. Working with media: images and videos.
• 2.1.6. Learning animations.
• 2.1.7. Building Input form.
• 2.1.8. Embedding a Google Map
• 2.1.9. Implementing Google reCAPTCHA.

3. Learning Encryption:

• 3.1. Learn how to encrypt and de-crypt any word using RSA encryption method, first on a piece of paper.
• 3.2. Write a jsp encrypt and de-crypt code using RSA algorithm.

• Note: RSA encryption is a widely used public-key method that secures data transmission using a pair of separate public and private keys It is named after its inventors Ron Rivest, Adi Shamir, and Leonard Adleman, who published it in 1977.
• It's widely used in:

• -Financial Services and Banking.
• -Email and Corporate Communications.
• -E-Commerce and Web Security, specifically in SSL/TLS digital certificates to authenticate web servers and secure customer browsing, login sessions,online transaction.
• -Corporate IT and Enterprise Networks to secure remote access(SSH), VPN connections, and internal/external certificate-based network authentication via Public Key Infrastructure (PKI).
• -Hardware and Access Tokens: RSA principals are embedded in smart cards, cryptographic hardware security modules (HSMs), and RFID/fob authentication devices.

4. Databases:

• 4.1. Installing Oracle client, SQL Developer.
• 4.2. Designing relational database.
• 4.3. Building tables and relate them, altering and modifying it, building constraints.
• 4.4. Creating database objects, views, sequences, indexes, and synonyms.
• 4.5. Inserting data manually into relational tables.
• 4.6. Loading data conditionally using a controller script .ctl.
• 4.7. Learn SQL to retrieve data, write subqueries,write hierarchical queries (walking the tree)
• 4.8. CreateTable joints, inner and outer.
• 4.9. Execute Oracle commands.
• 4.10. Write SQL Functions.
• 4.11. Learn Set Operators (Intersect, Union/Union All, Minus).
• 4.12. Writing Controlling Transactions, commits, rollbacks,locks.
• 4.13. Controlling user access, system privileges, roles,and privileges.
• 4.16. Write PLS/SQL - programming language for Oracle database.
• 4.17. Writing a Cursor with/without parameters, controlling structure:
• -if-then-else statements,
• -loops (for loop, while loop, nested loops),
• -working with composite datatypes,
• -handling exceptions.
• 4.18. Writing a trigger to 'move' or update records.
• 4.19. Writing a stored procedure.

5. Unix, ksh - scripting language:

• 5.1 Write a ksh to read a file, sort records, cut fields, use output of a file as input to another file, select unique data elements form the file, merge files, create maps or hashes, loops, pattern matching, conditions, string manipulation, fork background processes, write functions.

6. Cloud Salesforce - building an app in the cloud:

• 6.1. Sign up for a developer sandbox from Salesforce.
• 6.2. Building an app in the cloud.