Advanced Excel
Analyzing and Visualizing Data with MS Excel (MS 70-779 Cert.)

Analyzing Data with Excel
Consume and Transform Data by Using Microsoft Excel:
Import from data sources
- Connect to and import from databases, files, and folders; connect to Microsoft SQL Azure, Big Data, SQL Server Analysis Services (SSAS), and Power Query; import supported file types; import from other Excel workbooks; link to data from other sources

Perform data transformations
- Design and implement basic and advanced transformations, apply business rules, change data format to support visualization, filter data, format data

Cleanse data
- Manage incomplete data; handle data received as a report; remove unnecessary rows, columns, and data; remove repeating headers


Model Data:
Create and optimize data models
- Manage data relationships, optimize models for reporting, manually enter data, perform Get & Transform, create automatic relationships, create manual relationships

Create calculated columns, measures, and tables
- Create DAX queries, create DAX formulas, create Excel formulas

Create performance KPIs
- Calculate the actual value, calculate the target value, calculate actual to target values

Create hierarchies
- Create date hierarchies, create business hierarchies, resolve hierarchy issues


Visualize Data
Create and manage PivotTables
- Format PivotTables and PivotCharts, format calculated measures, filter data, group and summarize data

Create and manage PivotCharts
- Select a chart type, format calculated measures, filter data; group and summarize data, use slicers

Interact with Power BI
- Import Excel data from Power BI, manipulate Excel data in Power BI

Animations and Motion Graphics
Learn how to model and create simple to complex animations using Iclone, Character Creator, Cinema 4D, Zbrush, Photoshop, and Davinci Resolve.

AUTODESK - CAD & CAM
AutoDESK Certification is designed for engineers. it can be used by engineers to design buildings, electrical, structural and mechanical drawings.

CAD/CAM (computer-aided design and computer-aided manufacturing) refers to computer software that is used to both design and manufacture products.

CAD is the use of computer technology for design and design documentation. CAD/CAM applications are used to both design a product and program manufacturing processes, specifically, CNC machining. CAM software uses the models and assemblies created in CAD software to generate tool paths that drive the machines that turn the designs into physical parts. CAD/CAM software is most often used for machining of prototypes and finished parts.

Our course can be further broken down into the under-listed fields & specialization:
AutoCAD - Drafting & Design
Revit - Structural
Revit - Architectural
Inventor - Mechanical
Civil3D - Infrastructure Design

C# Programming
C# Programming, Build & Deploy modern Desktop & Web Application Using.Net framework

C++
C++ is a general-purpose programming language. It has imperative, object-oriented and generic programming features, while also providing facilities for low-level memory manipulation.C++ is standardized by the International Organization for Standardization (ISO), with the latest standard version ratified.

CISCO CERTIFICATION (CCNA)
The globally respected Cisco certification is in high demand with numerous tracks you can pursue in order to advance your career.

CCNA Certification validates your ability to install, configure, operate and troubleshoot routed & switched networks. CCNA certified professionals can make connections to remote sites via a wide area network (WAN), mitigate basic network security threats, and understand fundamental networking concepts and terminology.
CCNA certification is the tech industry’s most sought-after career credentials in becoming a network administrator or engineer.

CISCO CERTIFICATION (CCNP)
The globally respected Cisco certification is in high demand with numerous tracks you can pursue in order to advance your career.

Professional Certification: CCNP
Cisco Certified Network Professional (CCNP) certification is designed to validate a student's ability to install, configure and troubleshoot the converged local area network (LAN) or wide area network (WAN) consisting of between 100 and 500 nodes. Those professionals who achieve the Cisco CCNP certification will have demonstrated the ability to manage the routers and switches which form the core of the Cisco network, as well as a mastery of the applications which integrate wireless, voice and security in the network environment.
To acquire a CCNP one must possess a CCNA certification.

To earn CCNP Enterprise certification, you pass two exams: one that covers core enterprise technologies and one enterprise concentration exam of your choice, so you can customize your certification to your technical area of focus.

Core exam:
350-401 ENCOR Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR)

Concentration exams (choose one):
300-410 ENARSI Implementing Cisco Enterprise Advanced Routing and Services (ENARSI)
300-415 ENSDWI Implementing Cisco SD-WAN Solutions (SDWAN300)
300-420 ENSLD Designing Cisco Enterprise Networks (ENSLD)
300-425 ENWLSD Designing Cisco Enterprise Wireless Networks (ENWLSD)
300-430 ENWLSI Implementing Cisco Enterprise Wireless Networks (ENWLSI)
300-435 ENAUTO Implementing Automation for Cisco Enterprise Solutions (ENAUI)

(Source- cisco.com)

Cloud Computing
in simple terms, cloud computing is the delivery of computing services (like servers, databases, networking software, data storage and processing power) on the cloud (over the internet) on pay-as-you-go basis.

The pay-as-you-go basis is known as Infrastructure-as-a-service (IaaS), Platform-as-a-Service or Software-as-a-Service a model where a third-party provider hosts and maintains core infrastructures, platform and software on behalf of a customer, rather than owning these infrastructure, platform or services themselves.

Cloud computing has quickly become a key driving force for organizations and businesses today. Critical Applications are now being moved out of traditional data centres to cloud in a bid to innovate, save cost and increase performance.

.
This course will help you understanding the cloud technology concepts Using either Amazon Web Service (AWS) or Microsoft Azure. There is also a Third Major player - Google Cloud Platform (GCP), but it not as robust and competitive as the first 2 major player. However, google is expected to catchup in coming years.

COMPTIA A+
Our Computer Engineering (Comptia A+) Demonstrate baseline security skills for IT support professionals
Configure device operating systems, including Windows, Mac, Linux, Chrome OS, Android and iOS and administer client-based as well as cloud-based (SaaS) software
Troubleshoot and problem solve core service and support challenges while applying best practices for documentation, change management, and scripting
Support basic IT infrastructure and networking
Configure and support PC, mobile and IoT device hardware
Implement basic data backup and recovery methods and apply data storage and management best practices.

Comptia N+
Our Computer Networking (Comptia N+) Demonstrate baseline networking skills for IT support professionals
Set up and configure computer networks and topology.

CYBER SECURITY & ETHICAL HACKING
Cyber Security experts prevent data from being stolen & misused by malicious attackers, as well as: Discovering vulnerabilities from an attacker so that weak points can be fixed, Implementing a secure network that prevents security breaches, Defending national security by protecting data from terrorists, Protection of data & Helping protect networks.
Government agencies & business organizations are in constant need of Cyber security experts to combat the growing threat to IT security


This course will immerse the students into an interactive environment where they will be shown how to scan, test, hack and secure their own systems. The lab intensive environment gives each student in-depth knowledge and practical experience with the current essential security systems. Students will learn the following:


Introduction to Ethical Hacking
Footprinting and Reconnaissance
Scanning Networks
Enumeration
Vulnerability Analysis
System Hacking
Malware Threats
Sniffing
Social Engineering
Denial-of-Service
Session Hijacking
Evading IDS, Firewalls, and Honeypots
Hacking Web Servers
Hacking Web Applications
SQL Injection
Hacking Wireless Networks
Hacking Mobile Platforms
IoT Hacking
Cloud Computing
Cryptography

Data Analytics
Gain an immersive understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job

Learn key analytical skills (data cleaning, analysis, & visualization) and tools (spreadsheets, SQL, Python programming, Tableau)

Understand how to clean and organize data for analysis, and complete analysis and calculations using spreadsheets, SQL and R programming

Learn how to visualize and present data findings in dashboards, presentations and commonly used visualization platforms

Data Science & Machine Learning with Python
Data Science & Machine Learning with Python Python Programming, pandas, NumPy, matplotlib, seaborn, scikit-learn,
Supervised Learning, unSupervised Learning, Reinforcement Learning

DIGITAL MARKETING
Covered under this Programme are; Introduction to WordPress, Search Engine Optimization & Marketing, Social media Marketing,
Email-marketing, Website Optimization, Google Ad-word, web analytics...

GRAPHICS DESIGN - CREATIVE CAREER
Graphic design takes graphical & textual elements and implements them into multiple types of media.
When you think of graphic design, think of artistic advertisements, Eye-grabbing graphics on software interfaces (websites, desktop & mobile apps), stunningly arranged spreads in magazines, posters, infographics, book covers, product labels, logos, business cards, signs, billboards - the list goes on.

This course will cover the following tools;
CorelDraw, Adobe illustrator & PhotoShop

IT FUNDAMENTAL - IT for BEGINNERS
The study covers introduction to computing which comprises the hardware (e.g. this is everything physically present in a computer: the keyboard, the screen, and the case where the actual computer resides all constitute hardware) and software (e.g. operating system, which provides a user interface and some basic commands), Microsoft Suite (Microsoft Word, Excel & PowerPoint), Typing skills, Introduction to web design, Navigating the internet & introduction to Graphics.

This course is designed for students who have no background knowledge in computer but interested in knowing about I.T.

ITIL
ITIL(IT-service management) Stands for Information Technology Infrastructural Library which is owned by OGC (Office Of Government Commerce ) UK.
ITIL outlines an extensive set of management processes and procedures to help support businesses in achieving high financial quality, as well as high values in IT operations, provision of Quality IT services with guidance on the processes and facilities needed to support them.

JAVA
Java is a powerful general-purpose programming language. It is used to develop desktop and mobile applications, big data processing, embedded systems, and so on. Java runs on 3 billion devices worldwide, which makes Java one of the most popular programming languages. Java is; Object Oriented, Platform Independent, Simple, Secure, Architecture-neutral, Portable, Robust, Multithreaded, Interpreted, High Performance, Distributed & Dynamic.


Get the skills you need and learn the fundamentals of the Java programming language by enrolling in the Java SCJP training course. This course prepares you for certification as well as gives you a comprehensive overview of programming with Java. Earning this credential proves that you are a programmer who clearly understands the structure and basic syntax of Java programming and that you are able to create Java technology applications.

MATLAB & SIMULINKS
MATLAB® is a high-level language and interactive environment for numerical computation, visualization, and programming. Using MATLAB, you can analyze data, develop algorithms, and create models and applications. The language, tools, and built-in math functions enable you to explore multiple approaches and reach a solution faster than with spreadsheets or traditional programming languages, such as C/C++ or Java™.

You can use MATLAB for a range of applications, including signal processing and communications, image and video processing, control systems, test and measurement, computational finance, and computational biology. More than a million engineers and scientists in industry and academia use MATLAB, the language of technical computing.

Mobile Application Development
Mobile application development skill has become essential in recent times, with Android and iOS applications at the fore of this skill set. This has made developer to create a cross platform approach to building mobile app, as against the old tradition of developing Android and iOS separately. Today, organizations and employers are saving resources by adopting a a cross-platform approach to mobile application development, this and lots more brought about Flutter vs React Native.

Flutter is Google

M_o_R® Certification
What is Management of Risk (M_o_R®)?

M_o_R (Management of Risk) is a generic framework for the management of risk across all parts of an organisation - strategic, programme, project and operational. It incorporates all the activities required to identify and control the exposure to any type of risk, positive or negative, which may have an impact on the achievement of your organisation's business objectives.

Almost every organisational decision has an upside and a downside involving some degree of risk. Aimed at everyone who has ever made an important decision, M_o_R is a robust yet flexible framework that allows organisations to assess risk accurately time and time again.

M_o_R is intended to help organisations to put in place effective frameworks for taking informed decisions about risk. The guidance provides a route map for risk management, bringing together recommended approaches, checklists and pointers to more detailed sources of advice on tools and techniques.

M_o_R covers a wide range of topics, including business continuity management, security, programme/project risk management and operational service management. These topics are placed in the context of an organisational framework for the management of risk.

M_o_R (Management of Risk) Qualifications

There are two M_o_R qualification levels:
M_o_R Foundation and M_o_R Practitioner.

M_o_R Foundation Qualification
M_o_R Foundation level is suitable for any organisation or individual seeing the need for guidance on a controlled approach to identifying, analyzing and managing risk at strategic, programme, project and operational perspectives.

M_o_R Practitioner Qualification
M_o_R Practitioner is the highest M_o_R level qualification and is aimed at anyone working within a corporate governance environment that has responsibilities for identifying, assessing, planning, or managing risks, or reporting on risk management activities across the organisation.


M_o_R is part of the Global Best Practice portfolio.

Source: www.management-of-risk.com

ORACLE DATABASE ADMINISTRATION (OCA)
Oracle is the largest business software company in the world, with more than 500,000 customers in more than 145 countries including a large percentage of Nigeria telecoms, banking and Oil sectors, which is why knowledge about Oracle programs are valuable to a professional's IT career.

Associate Certification
Oracle Database Administration OCA
1. Oracle database SQl Fundamentals: This course covers a variety of topics including language functionality enhancements, executing dynamic SQL, performance improvement enhancements, language usability enhancements, coding trigger enhancements, data warehousing enhancements, and SQL Developer enhancements.
2. Oracle Database Administration Workshop 1 :This course will give you a strong foundation in the basics of administering Oracle 11g including how to install and configure an Oracle database, manage users, manage storage structures, monitor performance, implement database security, and implement backup and recovery.

ORACLE DATABASE ADMINISTRATION (OCP)
Oracle is the largest business software company in the world, with more than 500,000 customers in more than 145 countries including a large percentage of Nigeria telecoms, banking and Oil sectors, which is why knowledge about Oracle programs are valuable to a professional's IT career.

Professional Certification
Oracle Database Administration OCP
1. Oracle Database Administration Workshop II : Oracle Database Administration II course explores database architecture and ASM, configuring for recoverability, the RMAN recovery catalog, configuring backup specifications, creating backups, user-managed recovery, recovering with RMAN, using RMAN to duplicate a database, Tablespace Point-in-Time recovery concepts, Flashback technology, diagnostics, memory management, database performance, resource management, Segment Advisor, the Scheduler, and globalization.

ORACLE DATABASE ADMINISTRATION OCA + OCP (COMPLETE MODULE)
Why Oracle Database 12c?
Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities for breakthrough analytical performance. Additional database innovations deliver new levels of efficiency, performance, security, and availability. Oracle Database 12c comes in two editions to fit your business needs and budget: Enterprise Edition and Standard Edition 2.

Plug Into the Cloud

Plug Into the Cloud icon
Consolidate databases into database clouds and manage them as one to improve efficiency and simplify administration.


The Oracle Database 12c is a high-performance, enterprise-class database. According to Oracle, this is "the first database designed for the cloud." Oracle Database 12c also introduces 500 new features to the database, most notably pluggable databases and multitenant architecture. The Oracle Database 12c release 12.0.1.2 also features the Oracle Database 12c In-Memory, an optional add-on that provides in-memory capabilities. The in-memory option makes Oracle Database 12c the first Oracle database to offer real-time analytics.

PDMS
This course is targeted at Drafters, Designers, Engineers, Middle Management Executives and those who wish to acquire knowledge in using the PDMS for plant design the program covers PDMS Design Database Hierarchy, Navigation in PDMS, Creation of equipment and PDMS primitives, Construction of Light Gas Unit, Creation of vessels, pumps, heat exchangers, Creation of platform & ladders, Creation of pipe work.

PRINCE2 / PMP PROJECT MANAGEMENT
This Course is a Combined PMP and PRINCE2 Project Management Methodology.

Project Management is a fundamental skill.
Every aspect of every professional role can be considered part of project management
There are many methods and certifications in the world of project management, but PRINCE2 and PMP are the most sought after

The differences between PRINCE2 and PMP
The key difference is that while PRINCE2 is a methodology, PMP is considered a body of knowledge.

The PRINCE2 method can guide and tell you how to proceed with your projects. To help you achieve your goals, it also provides templates that you can use or adapt to your projects and the needs of your organization.

PMP on the other hand, provides a framework, a body of project management knowledge.
It can provide you with a range of techniques and tools that you can apply according to your needs.

This means that PMP certification certifies the mastery of Project Management skills and techniques, while the PRINCE2 certification certifies the ability to manage the project in a controlled manner following the PRINCE2 method.



PRINCE2 (Projects In Control Environment)
PRINCE2 is an integrated project management method that provides a set of processes and issues applicable to the management of a project from start to finish. PRINCE2 provides a model of what needs to be done, who needs to do it, and when it needs to be finished.
PRINCE2 was developed by the UK Office of Government Commerce (OGC) in 1996 and is a registered trademark of Axelos. The current version is the PRINCE2 6th Edition.

PMP (Project Management Professional)
PMP, which stands for Project Management Professional, is a standard, a

PYTHON
Python is a powerful general-purpose programming language. It is used in Web development Back-end (or server-side), Mobile app development, Desktop app, Game development, Embedded application, Machine Learning & Data science - Processing big data, performing mathematical computations, writing system scripts, creating software prototypes and so on.

Available Options:
1. Python for Cyber Security Introduction to Python Programming, Cryptography and Network Programming.
2. Python for Data Science Python Programming & Libraries for Data Visualization
3. Python Programming, Python for Web Development and MySQL

Python for Cyber Security
Cyber Security experts prevent data from being stolen & misused by malicious attackers, as well as: Discovering vulnerabilities from an attacker so that weak points can be fixed, Implementing a secure network that prevents security breaches, Defending national security by protecting data from terrorists, Protection of data & Helping protect networks.
Government agencies & business organizations are in constant need of Cyber security experts to combat the growing threat to IT security

Python for Data Science
NumPy, Pandas, Matplotlib, SCiPy, SCiKit, Anaconda, Python etc

STATISTICAL ANALYSIS SYSTEM(SAS)
SAS (Statistical Analysis System) is the leader in business analytics software and services, and the largest independent vendor in the business intelligence market. With innovative business applications supported by an enterprise intelligence platform. SAS helps 44,000 organizations improve performance and deliver values by making better decision faster.

SAS has many business solutions and products available for:
• Industries
• Small to Midsize Business
• Analytics
• Business Intelligences
• Compliance
• Customer Relationship Management
• Data Integration
• Financial Intelligence
• Foundation Tools
• Fraud Prevention & Detection
• Human Capital Intelligence
• IT Management
• OnDemand Solutions
• Performance Management
• Risk Management
• Supply Chain Intelligence
• Sustainability Management and lots more

SAS PROGRAMMER
SAS Programmers use our powerful, fourth generation language to access data from a variety of sources. They use SAS code to manage data and perform queries and reports. SAS code can be stored and made available for repeated use throughout the organization on the SAS®9 Intelligence Platform.

Some of SAS business solutions and products;
Customer Relation Management, Fraud Prevention & Detection, Data Integration, Financial Intelligence, IT Management, Business Intelligence, Performance Management, Risk Management, Supply Chain Intelligence, Sustainability Management & lots more.

UI/UX Design
Design user interface and user experience with Figma and Adobe XD, Intro to UI/UX, User Research, Information Architecture, Interaction Design, Wireframing and Prototyping, Visual Design, Usablity, Testing, Portfolio Development

Web App & Mobile App (IOS & Android)
Html, CSS, Bootstrap, JavaScript, React, Github/Git, Node.js & MySQL React-Native, NodeJs API

WEB DESIGN (FRONT-END DEVELOPMENT)
Web design refers to both the aesthetic portion (the look & feel) of the website and it’s usability.
Web designers as those who transform an idea or a story into a visually appealing design and use their layout to build the user experience throughout the whole website. They design the website’s look and feel.

Front-end developers use three main languages; Hypertext Markup Language (HTML), Cascading Style Sheets (CSS), and JavaScript (JS) & Bootstrap. With these languages, a developer is able to create a full-fledged website. From the main design layout, to inserting images, applying different types of typography and font families, implementing animations, the flow of different pages, form interfaces, and more.

Web Development (Asp.Net Full-Stack)
Html, CSS, Bootstrap, JavaScript, JQuery, C# & MSSQL/SQLite (MS 480 & 486 Cert.)

WEB DEVELOPMENT (PHP FULL-STACK)
Web developers as those who turn the designs into a interactive web Application. Web developers uses web languages and software tools to develop the design and functionality of a website application. Note that our full-stack web development course is a combination of both the front-end(Web design tools) and back-end development tools(Server Side programming & Databse technology).
As a web developer, you would be able to build a fully working website application, build the interface, and interaction between the back-end of the website and the user.

Back-end developers are those who control the server data and requests. Usually a website Application requires back-end services if it contains dynamic data. This means, for example, users submitting a user form with personal data (such as user account registration), online application form or saving an article for your blog.

Generally, if the website requires data to be saved, it means that it would also need a database. Database connections are made possible by a direct connection from the server itself. Thus, a back-end developer uses a server language such as PHP and database such as MySQL to save and retrieve data, and also writes database queries using SQL.

Wordpress
Domain & Hosting.
Installation of Wordpress.
Theme & Plugins.
Content Marketing & SEO.
Blog Creation & Widget Configuration.