CERTIFICATE IN IT

The purpose of the Diploma in Information Technology is to provide a career-focused professional qualification featuring industry-referenced knowledge, skills and attitudes.

I.Computers, Devices, and the Web

• Computers
• Mobile and Game Devices
• Data and Information
• The Web
• Digital Security and Privacy
• Programs and Apps
• Communications and Networks
• Technology Uses

II.Connecting and Communicating Online: The Internet, Websites, and Media

• The Internet
• Connecting to the Internet
• The World Wide Web
• Types of Websites
• Digital Media on the Web
• Other Internet Services

III.Computers and Mobile Devices: Evaluating Options for Home and Work

• Mobile Computers and Desktops
• Servers
• Terminals
• Supercomputers
• Cloud Computing
• Mobile Devices
• Game Devices
• Embedded Computers
• Ports and Connections
• Protecting Hardware
• Health Concerns of Using Technology

IV.Programs and Apps: Productivity, Graphics, Security and Work

• Programs and Apps
• Productivity Applications
• Graphics and Media Applications
• Personal Interest Applications
• Communications Applications
• Security Tools
• File, Disk, and System Management Tools

V.Digital Security, Ethics, and Privacy: Threats, Issues, and Defenses

• Digital Security Risks
• Internet and Network Attacks
• Unauthorized Access and Use
• Software Theft
• Information Theft
• Hardware Theft, Vandalism, and Failure
• Backing Up
• Wireless Security
• Ethics and Society
• Information Privacy

VI.Office 365 Suite
Microsoft Word

• Getting Started With Word
• Editing Documents
• Formatting Text and Paragraphs
• Working More Efficiently
• Managing Lists
• Adding Tables

Microsoft PowerPoint

• Getting Started with PowerPoint
• Developing a PowerPoint Presentation
• Performing Advanced Text Editing Operations
• Adding Graphical Elements to Your Presentation
• Modifying Objects in Your Presentation
• Adding Tables to Your Presentation
• Adding Charts to Your Presentation
• Preparing to Deliver Your Presentation

Microsoft Excel

• Getting Started
• Entering Data
• Using Formulas
• Working with Constant Values and Formulas
• Formatting Worksheets
• Modifying Columns and Rows
• Editing Workbooks
• Printing Worksheets

VII.Basic Graphic Design

• Knowledge/fundamentals of design theory
• Most common graphic design practices and the thought process behind these principles
• Real-world, applicable projects
• Graphic design fundamentals and how to apply them to your work
• Color theory and how it applies to the world around us, from products and art to branding and advertising
• Typography and its role in visual media
• Layout, user interface and experience design, and composition
• Identity design and the legal side of design

VIII.Web Development

• Introduction Web Development, HTML, HTML5
• Basics of HTML & CSS
• Basics of HTML Forms to Collect Data from Users
• Using CSS3 Styles with div, p, span etc. for Creating Beautiful Web Pages
• CSS3 Media Queries in Detail & Creating fully Responsive Web Pages
• Introduction to BootStrap 4 and Grid System in Detail
• Selecting and Manipulating DOM Elements with jQuery
• Essentials of PHP Programming
• Setting up a Test Bed
• Overview of PHP
• Variables in PHP
• Logical operators
• Numbers in PHP
• Strings in PHP
• Control structures in PHP
• Transferring information between PHP pages
• Introduction to MySql Database
• Setting Development Environment for PHP using Xampp & PhpStorm
• Introduction to Yii 2.0 PHP Framework ( hands-on experience on Basic application )
  • Learn how to install and configure Yii2
  • Setup DB & Create Tables
  • Customize Default Layout
  • Create Controllers and Models
  • Form and Validations
  • User Login / Registration
  • Gii Tool
  • Yii CRUD Functionality
  • Consuming REST Services / REST API using AJAX and JSON
• Essentials of Angular for Creating Modern Web Applications

IX.Mobile Application Development

• Introduction to mobile application development. Limitations, challenges, advantages and design considerations for the mobile platform.
• Introduction to Android studio, a hello world application
• Role of XML in Android apps, layouts, strings, manifest, menu and more
• Working with multi-screen applications, Activities and their working
• Menus, Buttons, Text Fields and other basic user interface elements on Android
• Android Intents and interaction between different applications.
• Broadcasts and Broadcast receivers in Java and their applications
• Internet connected apps, connecting sockets, making web requests and staying connected, downloading photos and text, handling JSON
• Background processing, threads and AsyncTasks in Android
• Android Services and their working, how to make Services talk to the Activities
• Design considerations, working with variety of screen sizes and resolutions
• Signatures, signing apps for app store, basics of Google Play store and publishing, Analytics, Firebase , Ads etc

Week 1:

• Anaconda Installation
• Intro to Jupyter Notebook
• Python Objects & Data Structure
• NumPy & Pandas

Week 2:

• Importing Data in Pandas
• Exploratory Data Analysis (Anomalies, Outliers, Missing Data)
• Data Visualizations (Bar plots, Histogram, Scatter plot, Heat maps)
• Data Visualization libraries Matplotlib and Seaborn
• Data Centricity Measures (Mean, Mode, Median, Variance, Interquartile Range)

Week 3:

• Feature Engineering
• Handling Missing values in EDA
• Supervised vs Unsupervised vs Reinforced Learning
• Hands-on Implementation of Industry Projects

Week 4:

• Train Test Split for Model Training
• Overfitting vs Underfitting
• K Cross Validation
• Hands-on Implementation of Industry Projects

Week 5:

• Linear Regression
• Gradient Descent Optimization
• Classification
• Logistic Regression
• Hands-on Implementation of Industry Projects

Week 6:

• Model Evaluation Metrics
• True Positive and True Negative, False Positive , False Negative.
• Confusion Matrix.
• Precision, Accuracy, Recall, F Measure.
• ROC Curve, AUC, TPR, FPR
• Hands-on Implementation of Industry Projects

Week 7:

• Logistic Regression
• Decision Trees
• Naive Bayes
• Random Forest.
• Hyperparameter Tuning
• Boosting, Bagging
• Multi-Class Classification
• Hands-on Implementation of Industry Projects

Week 8:

• Clustering
• K-Means algorithm
• DBSCAN Algorithm
• Hierarchical clustering
• Hands-on Industry Project Implementation

Week 9:

• Average vs Complete vs Ward linkage
• External Indexes, Adjusted Rand Index
• Hands-on Industry Project Implementation

Week 10:

• Association Rule Mining
• Apriori Algorithm
• Support, Confidence, Lift, Leverage, Conviction
• Hands-on Industry Project Implementation

Week 11:

• Dimensionality Reduction Techniques
• Principal Component Analysis (PCA)
• Hands-on Industry Project Implementation

Week 12:

• Model Deployment Basics
• Flask App Introduction
• Model Deployment on Flask App
• Hands-on Industry Project Implementation
• Data Engineering

Week 13:

• Structured vs Semi-Structured vs Unstructured Data
• Data Quality: Validity, Completeness, Uniqueness, Consistency, Timeliness, Accuracy
• SQL Databases
• ACID Property
• MySQL, PostgreSQL, MySQL workbench, MySQL DML, MySQL DDL
• Aggregations

Week 14:

• Views and indexing
• Database Management System: Types of DBMS
• NoSQL
• CAP Theorem
• Key-Value Pair
• HBase: Document Base

Week 15:

• MongoDB
• Elasticsearch
• Graph Base
• Column Base
• OLTP vs OLAP
• Hands-on Implementation of Industry Projects

Week 16:

• Data Lake
• Data Lake Issues
• Hadoop Setup
• Data Lake on Hadoop
• Data Warehouse
• Row Vs Columnar Storage
• Hands-on Implementation of Industry Projects

Week 17:

• Staging
• ODS
• Data Mart
• Data Cube
• Dimension Modeling: Star Schema and Snowflake Schema, Galaxy Schema
• Slowly Changing Dimension
• Hands-on Implementation of Industry Projects

Week 18:

• Change Data Capture: Timestamp-based CDC, Trigger Based, Log Base
• Staging Area vs Persistent Staging Area
• Hive As Data Warehouse
• Hive Data Definition Language (DDL)
• Hive Data Manipulation Language (DML)
• Data Model: Table, Partition, Bucket
• Hands-on Implementation of Industry Projects

Week 19:

• Hive Map-Side Joins: Plain, Bucket, Sort-Merge
• Aggregation & Functions
• Hadoop: Distributed computing
• Basic Bash Commands
• Map-Reduce: Code example/word count
• Hive / Pig / Impala
• Spark / Flink / Drill / Strom / Sqoop
• Resource Management (YARN)
• Hands-on Implementation of Industry Projects

Week 20:

• ETL vs ELT
• Distributed Computing and Shortcomings of MapReduce
• Spark (python / scala)
• Apache Beam (python/java)
• Pull Based Ingestion
• Push Based Ingestion – Event/Data Driven Pipelines
• Hands-on Implementation of Industry Projects

Week 21:

• Kappa / Lambda Architecture
• Spark: Spark SQL, Spark Streaming, MLib, GraphX, RDD, Transformations,Actions
• Broadcast & Accumulator Variables, Joins
• Apache Kafka: Active Passive, Stream Broker, Publisher/Subscriber
• Data Visualization: Tableau
• Scheduling
• Hands-on Implementation of Industry Projects

Week 22:

• Apache Airflow
• Traditional ETL Approach
• Airflow Concepts
• Hands-on Implementation of Industry Projects

Week 23:

• Security
• Authentication: Knox, Kerberos
• Authorization: Ranger
• Hands-on Implementation of Industry Projects

Week 24:

• Audit: Ranger
• Data at rest/in-motion Encryption: HDFS Encryption / Wire Encryption
• Centralized Administration: Ranger
• Hands-on Implementation of Industry Projects

Text mining intro

• Introduction to Linguistics
• Basic Text Processing
• RegularExpressions
• Spelling Correction
• Edit Distance
• Morphology and Morphological Processing
• Finite State Transducers
• Stemming
• Revision of Probability
• Language Modelling
• Generation
• N-grams
• Smoothing
• Evaluation
• Entropy
• Hands-on Implementation of Industry Projects
• Perplexity
• Noisy Channel Model
• SpellingCorrection
• NaïveBayes
• Text Classification
• Hands-on Implementation of Industry Projects
• Sentiment Analysis
• Evaluation measures
• Named Entity Recognition
• Part of SpeechTagging
• HMMs
• Hands-on Implementation of Industry Projects
• Introduction to Parsing
• CYK Algorithm
• Probabilistic Parsing
• Dependency Parsing
• Semantic relations
• Hands-on Implementation of Industry Projects
• Representation of meaning
• WordNet
• Hands-on Implementation of Industry Projects
• Word senses
• Hands-on Implementation of Industry Projects
• Word Sense Disambiguation
• Hands-on Implementation of Industry Projects
• Question Answering
• Hands-on Implementation of Industry Projects
• Summarization
• Hands-on Implementation of Industry Projects
• Machine Translation
• Hands-on Implementation of Industry Projects

Details

---

This course is specifically designed for students who are yet to join university education. This is an ideal course for school going children. The students should be good in mathematics, reasoning, and logic. They should know the basics of computers, running programs, saving files and some knowledge of algebra and variables is a plus. It covers basic version and will take the students to advance level of Python Programming such as the course has been designed for an advanced independent certification which the students can take on their own after completion of this course. The course then further focuses on Python Libraries of Data Science/Machine Learning. The students will get the knowledge of programming language, like Python, C++, Java or C#, etc.

Details

---

The purpose of the course is to teach students about the overall process of game development. Computer games can be played today on a number of platforms. The course will equip students with the latest techniques using Unity and accompanying tools to develop quality games for PC, Mobile and Console platform.
The summarized course outline will look like below:

Details

---

Week 1	Introduction to the game development life-cycle, the game loop, a brief history of how games have been developed. Basic components of a game Sprites, animations, coordinate systems and handling input for 2D games. Introduction to Unity. Introduction to game physics
Week 2	Introduction to 3D game systems and coordinates. Objects and their transformations that is rotation, scaling, translation and combinations. 3D and 2D vectors and their use. Scenes and cameras, perspective and different type of games with respect to angles. Running games, birds eye view games, racing games and more
Week 3	Object Collusion, Environments and Drawing the world, Particle Systems. Developing first full game, making the game run on PC and mobile phones.
Week 4	Handling lights, particle systems, fire, smoke, water and more. Using Terrains, mountains and landscapes, placing objects like trees, stones and texturing them to create custom worlds.
Week 5	Acquiring assets from online sources, websites, unity store and more. Importing such assets into the unity project and making a sample game.
Week 6	Introduction to game physics, velocity, acceleration, collusion, momentum and how Unity handles it, how can we use game engines to make stunning effects in games. Materials, bounciness, elasticity, chains, ropes and hinges etc.
Week 7	Game optimization and making sure it runs on the target platform. Ways to improve game efficiency without sacrificing a lot of quality.
Week 8	Publishing games on different stores. Monetization models for games. Using advertisements, in app purchases and more
Week 9	Building humanoids for 3d games, 2 legged character design, texturing, optimization and rigging.
Week 10	Creating animations and using the humanoids in 3D/ 2D games

• Hands-on Implementation of Industry Projects

Week 1:

• Introduction to Cloud Computing
• Cloud Computing Deployment Models
• Cloud Delivery/Service Models
• Linux Basics
• Introduction to AWS Services
• Introduction to AWS
• Hands-on Implementation of Industry Projects
• Elastic Compute Cloud (EC2) Essentials
• EC2 Instances
• Elastic Block Store (EBS)
• Elastic Load Balancer (ELB)
• Auto Scaling
• Hands-on Implementation of Industry Projects
• Simple Storage Service (S3)
• Identity and Access Management (IAM)
• Hands-on Implementation of Industry Projects
• Route 53
• Cloud Watch
• Hands-on Implementation of Industry Projects
• Simple Notification Services (SNS)
• Hands-on Implementation of Industry Projects
• Simple Queue Service (SQS)
• Hands-on Implementation of Industry Projects
• Simple Email Services (SES)
• Hands-on Implementation of Industry Projects
• Relational Database Service (RDS)
• Hands-on Implementation of Industry Projects
• Cloud Front
• Hands-on Implementation of Industry Projects
• Use cases
• Hands-on Implementation of Industry Projects

 

Details

---

The aim of this SEO training course is to improve and enhance the technical knowledge of the students
and the job seekers on the search engine optimization.

Introduction to Search Engine Optimization

– Introduction to SEO
– Importance and Upcoming Trends of SEO
– How Search Engines Work?
– How Google works with your website
– Life Cycle Of SEO
– What Are Keywords?
– Types of Keywords
– Trends Monitoring and Rising Keywords as per your business/services category
using Google Trends
– Find out the keyword popularity according to region in Google Trends
– Know the average monthly searches of your keyword(s) using Google Keyword
Planner
– Use Google Keyword Planner to extract related keywords
– Criteria to finalize the list of keywords

ON-Page SEO

– How to write effective Title, Meta Description and Meta Keywords
– CTR – Click Through Rate
– Only being Top Ranked is not enough
– Heading Tags
– Why Content is KING?
– Keyword Placement in Content
– How the web content guidelines transform over the years?
– Google Panda ( The Latest Content Writing Guidelines)
– Keyword density
– keyword stuffing (Over Optimization)
– HTML Tags, an SEO should know
– Image optimization
– Internal links
– URL/Permalinks
– The detailed discussion on User Experience and Navigation
– Implementation Redirect 301
– Why Robots.txt
– Role of a sitemap and how to create
– Anatomy of a SEO friendly Website

(Google Search Console AKA GOOGLE WEBMASTERS TOOLS)

– Introduction To Google Webmasters Tools
– Setting Up Google Search Console
– Adding property to Search Console
– Verification
– Enable Email Notifications
– Sitemap submission to Google
– Search Appearance -> HTML Improvement (Google Bot findings about your web
pages)
– Search Traffic Report -> The most important report
– Google Index ->Index Status
– Crawl -> Fetch As Google
– Robots.txt tester
– Critical Messages about your website

OFF-Page SEO

– How to write effective Title, Meta Description and Meta Keywords
– In Depth Discussion About OFF Page SEO
– What Google says about backlinks?
– How to get backlinks?
– Link popularity
– Detailed explanation of Google Penguin
– How Google checks the “naturality” of the back links?
– Linking building according to the guidelines of Google Penguin
– Types and methods of link building
– Do-follow VS no-follow links
– Link Building Platforms

Google Analytics

– Introduction To Google Analytics
– Setting up Google Analytics
– Dashboard statistics
– Real Time Reporting
– Predefined Reports
– How to create Custom Reports
– Goals
– Filters
– Google AdWords Linking With Google Analytics

Details

---

The aim of this Google Ads course is to improve and enhance the technical knowledge of the students and the job seekers on the Google Ads.

Introduction to Ads

• Paid Search vs. Organic Search
• The Psychology of Search

Benefits & Features of Ads

• Relevance, ROI, Reach
• Targeting
• Ranking
• Costs & Payments
• Search vs. Display
• Reporting & Performance Metrics

Account Management

• Navigation
• Account Structure
• LAB: Create a Google Ads account

Campaign Management

• Components of a Campaign
• Creating a Campaign
• Campaign settings
• Editing a Campaign
• LAB: Campaign Creation: Develop a campaign for you business that includes targeted Ad Groups, keywords, and ad text to help you get the best Quality Score.

Ad Group Management

• Creating Ad Groups
• Editing Ad Groups
• Monitoring
• Best Practices

Keywords Research & Selection

• Researching and identifying keywords and keyword phrases
• Review match types
• Discussing negative keywords
• Aligning keywords with ad groups
• LAB: Keyword Research: Finding the top keywords for your company

Ad Formats

• Text Ads
• Image Ads
• Video Ads
• Mobile Ads
• Rich Media Display Ads
• Creating Enticing Ads
• Testing New Ads
• Best Practices

Targeting & Placements

• Google Search Network
• Google Properties
• Google Display Network
• Mobile Targeting
• Keyword Targeting
• Language & Location Targeting
• Placement Targeting
• Location Extensions

Bidding & Budgets

• Setting & Managing Bids
• Setting & Managing Budgets
• Impacts on Ranking
• Best Practices

Ads Policies

• Editorial & Format Policies
• Content Policies
• Link Policies
• Trademark & Copyright Policies
• Ad Approval Issues

Ad & Site Quality

• Quality Score
• How It’s Determined
• Landing Page & Site Quality
• Best Practices
• LAB: Writing Better Ads: Hands-on, mini-workshop on writing more compelling ad text

Performance Monitoring & Conversion Tracking

• How Google Measures Performance
• Troubleshooting

Optimization Performance

• Benefits & Goals
• Targeting Tools
• Account Optimization Tools
• Tracking Tools
• Optimizing Keywords
• Optimizing Ad Text
• Optimizing Targeting
• Optimizing Display Ads
• Optimizing Ad Scheduling, Serving and Position
• Optimizing Landing Pages & Sites
• LAB: Campaign Optimization: Practice analyzing campaigns in order to find how to get the most out of the budget, the campaign, the Ad Groups, and the ads.

Details

---

The goal of this training is to educate and train users in the rapidly-expanding field of Social Media. This curriculum includes 06 modules, covering social media overviews, strategies for spreading your campaigns around, and using every tool and tactic at your disposal to gain eyeballs and attention to your Website & other Social Media Platforms.

During Module Training Course Participants Will Learn:

• Introduction to Social Media!
• How Social Media is changing marketing practices?
• Increase audience reach and boost
• Learn how to use Facebook, Twitter, LinkedIn, Pinterest and Google+ in your social media
• Social Media Strategy Implementation
• Choosing the right social media sites and tools for your needs and the best tactics to use
• How to create and setup a highly effective and optimized profile that people will love
• How to reach and connect with the people you want to meet
• How to measure the effectiveness of your social media marketing
• How to use Social Media to attract top paying, high-end clients

With Social Media Fast Track, participants will discover how forward-thinking, savvy people, business owners and leaders turn social media sites like Facebook, Twitter, LinkedIn, Pinterest & Instagram into one of their most valuable resources, and how participants can too.

Module 1: Social Media Basics

• How can you use social media for marketing?
• Types of Social Media!
• Social Media Marketing Glossary
• Setting up Profiles and Pages
• Social Media Goals and Strategies
• Successful Social Media Case Studies

Module 2: Facebook Basics

• Learn how to set up your profile
• Understand the difference between friends and followers and the importance of choosing the right username

Advanced Facebook Strategies

• How to start and create a page
• Introduction to the 4-Phase Profit System
• Understanding page settings
• How to increase your Facebook page reach
• How to Create an Active & Engaged Facebook Community & Content that drive sales to your Business

Module 3: Twitter Basics

• Introduction to Twitter
• What is Twitter & why you should use it

Advanced Twitter Strategies

• Establish Your Twitter Presence
• How to use Twitter for Business and Marketing
• How to get more retweets on Twitter
• Discover how measure your Twitter strategy using monitoring tools

Module 4: LinkedIn Basics

• Introduction to LinkedIn
• How to find and add connections

Advanced LinkedIn Strategies

• LinkedIn for Business
• LinkedIn Marketing Tips
• Transform your LinkedIn Profile into a Marketing Tool

Module 5: Instagram Basics

• Introduction to Instagram
• What is Instagram & why you should use it
• How other businesses are using Instagram

Advanced Instagram Strategies

• How to improve your Instagram Marketing’
• Best Instagram Hashtags for Business
• Super & Simple ideas for What to post on Instagram
• Discover how measure your Instagram strategy using monitoring tools

Module 6: Pinterest Basics

• Introduction to Pinterest
• What is Pinterest & why you should use it
• How other businesses are using Pinterest

Advanced Pinterest Strategies

• Pinterest Marketing
• How to use Pinerest to create loyalty and trust clients
• Pinterest Contest
• Insights Pinterest Statistics

After completing Fast Track course, participants will be able to:

• Develop a plan and strategy to effectively implement Social Media
• Build connections and gain new customers
• Choose the right Social Media tools to achieve business objectives
• Establish and build quality Facebook Business Page
• Increase audience reach and boost sales
• Position yourself as a leader in your industry and Subject Matter Expert
• Will be expert in how to minimize your time investment and maximize your ROI