Promoting Talents
24/05/2023
PAMKE CYBER CAFE IS LOCATED IN SHERIKAT BESIDE DANDY HOTEL.
Here are the short courses we offer;
INTRODUCTION TO PROGRAMMING USING PYTHON.
-Operations, conditions, and control flow
- In-built data structures
-Functions and modules
- File input and output
-Object orientation with classes and objects
-Error and exception handling
-Modules and packages
-Third party packages and installation.
-Final Project
Web application development using PHP/PYTHON
-Local server Installation and Configuration
-Connecting Web App to Mysql database
-Developing forms and validating form fields
-Validating user inputs
-Creating user sessions
-Modularizing web application
-Designing user access roles
-Implementing web system using CRUD
-Generating customized reports
-Manipulating database data using data tables
-Putting together complete web application
-Performing web application PEN testing
-Final project
3. WEBSITE DESIGN
-Platform Installation
-Downloading and installation of WP Ocean Template
-Building website pages using elementor
-Setting permlinks
-Increasing size of upload files and populating media library
-Using Mastery slider
-Configuration of contact forms and management of users
-Installation of All-in-one migration
-Configuration of security applications
-Migrating and hosting website
-Final Project
4. WEB HOSTING
-Domain registration
-Control panel management
-File upload and management
-Email configuration & management
-Database administration (management and backup using automated tools)
-Installation of web security certificates (SSL)
5. MICROCOMPUTER APPLICATIONS
-Advanced Microsoft Access Database
-Overview of access interface
-Fundamentals of Access Objects
-Working with Table Data
-Creating Tables in Access Database
-Implementing relationships
-implementing select queries
-summarizing data in access queries
-Working with Access Action queries
-Querying multiple Tables with Query Joins
-Parameter Queries, Building Data Entry Forms and Working with Form Data
-Form Controls, Formatting Options and Building Switchboard
-Interacting with Queries through Forms
-Building Access Report
-Creating Calculated Controls & Advanced Group Options
-Overview of Microsoft Access VBA
-Access VBA SUB Procedures and Functions
-Understanding and Working with Access Objects with VBA
-Foundational VBA Programming Concepts
-Working with Access Recordset Object & Debugging Access VBA Code
-Final Project
6. ADVANCED MICROSOFT EXCEL
-Excel Introduction
-Excel Fundamentals
-Entering and Editing Text and Formulas
-Working With Basic Excel Functions
-Modifying and Excel Worksheet
-Formatting Data in an Excel Worksheet
-Inserting Images and Shapes into an Excel Worksheet
-Creating Basic Charts in Excel & Printing an Excel Worksheet
-Working With Excel Templates
-Working with an Excel List & Excel Data Validation
-Importing and Exporting Data & Excel PivotTables
-Working with Excel’s PowerPivot Tools
-Working with Large Sets of Excel Data & Working with conditional functions
-Implementing Lookup Functions & Working with Text-Based Functions
-Auditing and Excel Worksheet & Protecting Excel Worksheet and Workbooks
-Gaining Mastery of “What If?” Tools
-Automating Repetitive Tasks with Macros
-Introduction to Excel VBA & Using Macro Recorder Tool
-VBA Concepts & Logic Statements
-Moving Beyond the Basics and into VBA
-Preparing & Cleaning Up Data with VBA
-Using VBA to Automate Formulas & Working with VBA User Forms
-Importing Data from Text Files
-Final Project
7. DATA SCIENCE
-Data Science
-Introduction to Data Science
-Definition of Data
-Database Table
-Python Data Science Libraries
-DataFrame
-Functions
-Data Preparation
ii. DATA SCIENCE MATHEMATICS
-Linear Functions
-Plotting Functions
-Slope and Intercept
iii. DATA SCIENCE STATISTICS
-Statistics Overview
-Percentiles
-Standard Deviation
-Variance & Correlation
-Correlation Matrix
-Correlation vs Causality
iv. DATA SCIENCE INTERMEDIATE
-Linear Regression
-Regression Table
-Regression Info
-Regression Coefficients
-Regression P-Value
-Regression R-Squared
-Linear Regression Case
