IT Training Courses in Dubai

Course Details

R is one of the most popular languages used by Data Scientists, Researchers, Statisticians & Data Analysts to retrieve, analyze & visualize the data. It is most commonly used in statistical computing, scientific research & data analytics.

Brief Outline of Course

Reading, Writing of Datasets

Passing functions

Installing Packages & Libraries

Discussion on Libraries

Analysing data

Introduction to filters in R

If Else Function in R, For function in R

Statistical Function in R

Data cleaning on R

Create Array in R

Introduction to Machine Learning

Introduction to Packages (dplyr, SQLDF)

Plots in R

Introduction to Machine Learning Algorithms

Types of Machine Learning Algorithms

Data Types in R

Data/Numeric Frames in R

Project

Course Details

Overview

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets!

Learning about the lookup functions in Excel will allow you to match data between databases. VLOOKUP enables you to quickly and easily look for a value down a column of data and return a value from the same row in a different column. Perfect for when working with large tabular data. INDEX and MATCH work in a similar way but provide more flexibility.

Why you should Attend

As an intermediate to advanced level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that.

Areas Covered in the Session

• Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
• Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
• Calculate dates using TODAY, NOW
• Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCANTENATE
• Learn the arguments in the VLOOKUP function
• Understand the importance of absolute references within many lookup functions
• Use VLOOKUP to perform approximate matches
• Simplify multiple-field look-ups with concatenation (combining fields into a single cell)
• Use VLOOKUP to look up data from another workbook
• Learn how VLOOKUP stops looking after it finds an initial match within a list
• Explore why VLOOKUP sometimes returns #N/A instead of a desired result
• Learn about the IFNA function available in Excel 2013 and later
• Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match
• See how the HLOOKUP function enables you to perform horizontal matches
• Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP
• Use the MATCH function to find the position of an item on a list
• Learn the difference between workbook macros and personal macros
• Making your macros available to all your workbooks
• Use the macro recorder to create a macro
• Save a file as a macro enabled excel workbook
• Run a macro
• View the recorded macro in VBA
• Edit the macro

Learning Objectives

• This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application
• Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what are considered the top 10 functions
• Lookup functions in Excel are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most well-known (and most useful) functions in Excel
• Being able to create and edit macros is one of the must have skills for Excel Power Users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. If you've never created macros or used VBA before, this advanced Excel training is for you

Who Will Benefit

• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

Course Details

Advanced Excel Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

SAP Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

Do you face difficult obstacles in your business? How much effort and cost are needed to overcome? You essentially need intelligence to achieve more in less time and less cost. Artificial Intelligence (AI) is a field that create an artificial similar behavior to human intelligence. The AI has gained reputation but is still resembling growing and changing behaviors. In this Anderson training course, you’ll learn the basics of AI and the common applications of AI. AI technology has uses in a variety of industries from decision making, gaming, journalism/ media, to finance, as well as in the business processes, medical diagnosis, and science.

In this Anderson practical training course, delegates will gain skills about the fundamentals and applications of AI, including machine learning, probabilistic reasoning, computer vision, and fuzzy logic and genetic algorithm.

Course Details

Overview

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel. While there are hundreds of functions in available, there are 10 functions that all Excel users should know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these Excel functions can be very important time savers and enhance your ability to create better performing spreadsheets!

Why you should Attend

This webinar will get you started with functions. You will learn not only HOW to use these functions, but WHY they do what they do. Knowing the "why" helps you to do more with Excel. Attendees should have basic knowledge of creating Excel calculations using the basic mathematical operators and know the difference between relative and absolute cell references. This course is for beginner to intermediate Excel users.

Areas Covered in the Session

• Learn many statistical functions including SUM, AVERAGE, MAX, MIN and COUNT
• Use IF and its counterparts COUNTIF, SUMIF, and AVERAGEIF
• Understand VLOOKUP
• Calculate dates using TODAY, NOW and NETWORKDAYS
• Learn many functions to manipulate text once imported including LEFT, RIGHT, LEN, TRIM and CONCANTENATE
• Use IFERROR when errors can't be avoided

Who Will Benefit

• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

Course Details

Foundation Course

The Internet of Things or IoT is a system of interrelated computing devices, mechanical and digital machines, objects, animals or people that are provided with unique identifiers (UIDS)and the ability to transfer data over a network without requiring human-to-human or human-to-computer interaction.

Introduction to the internet of things

Learning about what the internet of things really means Understanding the four main concepts of it. Understanding what are IOT enablers and their characteristics. Understanding application domains and modern applications of iot

IOT Development Boards

Learning about different IOT development boards and their characteristics

 Nodemcu(ESP8266)

Learn about ESP8266 Different types of Deep sleep modes and how to use them. Learning onboard components on the nodemcu(ESP8266) development board

ESP8266 on Arduino IDE

Installing Esp8266 Board on Arduino IDE. Understanding Basic Arduino Code. Coding ESP8266 DHT11 Web Server. Learning the basic principle of Relay and working with esp8266.

Basic Electronics

Learning Basic electronics such as how to use the Digital Multimeters. What is voltage, current and many more. Creating and coding ESP8266 Weather Station(Project 1)

IOT Communication Protocols

Learn about different iot communication protocols such as BLE, WIFI, LORA, and many others Work with I2C LCD Display. ESP WiFiManager.

IOT Cloud Platforms and Introduction to Node-red

Learn about different iot cloud platforms Introduction to Node-red Sending weather station data to things board and creating a dashboard (Project 2) Sending weather station data to Node-red and creating a dashboard (Project 3)

Advance Temperature monitoring Project (Project 4)

Adding an LCD and Alert system to our already made weather station project

ESP8266 Multisensor Shield with Node-red (Project 5).

RFID Door Security System using Node-red (Project 6).                                                

Course Details

Artificial Intelligence (AI) is transforming the world and is becoming a revolution in this information age. The world now seeks intelligent interactive, real-world applications capable of making generic decisions over explicit programming. Through this course, students learn the concepts of AI and implement their techniques to solve real-world problems. FSEai opts for a top-down approach on learning AI, where the students-built applications before diving deep into the core mathematical concepts. Our trainers are international speakers and authors, worked with various prominent companies and are state-of-the-art educators. Also, Mr. Sherin Thomas is our lead educator and visionary of FSEai who is a major contributor to the deep learning community. This is a foundation course of FSEai for understanding the basic concepts of machine learning and deep learning, through live demonstrations of developing solutions to real-world problems

 Introduction to AI Theory & Python Programming

Introduction to Artificial Intelligence: Concepts, Terminology, Domains & Applications Setting up the environment with Anaconda and Jupyter notebook, Google Collab Getting started with Python coding Beginners guide to Git and Terminal Usage

 Machine Learning Regression

Types of Machine Learning: Concepts & Applications Predicting Boston House Prices with Linear Regression using NumPy Graphical visualization using Matplotlib & Seaborn

 Machine Learning Classification

Logistic Regression with Pandas Loss Function & Optimization Support Vector Machines (SVM)

Deep Learning Concepts

Machine Learning vs Deep Learning Introduction to Neural Networks Make your Fizz Buzz game using neural networks and NumPy Backpropagation concepts PyTorch: Tensors, AutoGrad & use a case in optimization Fizz Buzz game using neural networks and tensors

 Domain-based Application (Any application based on duration)

Real-time face recognition application Object detection application Automatic In-Out register for Parking lot using number plate recognition Document Scanner application Calculation of size of objects from images Gesture recognition application Sentiment Analysis using NLP

Course Details

About QuickBooks:

QuickBooks is an accounting software package developed and marketed by Intuit. QuickBooks products are geared mainly toward small and medium-sized businesses and offer on-premises accounting applications as well as cloud-based versions that accept business payments, manage and pay bills, and payroll functions.

Eligibility:

12th pass student (commerce/ arts/ science) can join this course

Minimum accounting knowledge

For whom the course is?

Those who want to take accounting as their profession and want to work in QUICKBOOKS

The outcome of the course:

After the course, one will be able to maintain books of accounts in QUICKBOOKS and work as an accountant and prepare all reports.

Important Course Outlines:

Contents to be covered

Introduction to QUICKBOOKS, Company Creation & Modification

Chart of Accounts, Creating Group, Ledger and Inventory Items, Cost Centers & Categories

Configuration of VAT in the QUICKBOOKS

Purchase and Sales Invoicing, Debit & Credit Notes, Orders Processing, Payments

Case study-with inventory and without inventory-preparation of TB, PL & BS

Project costing, Cost Centers, Cost Categories and Expenses tracking

Stocks group, Stocks categories, Stock items, Stock reports generation

All Types of Voucher Entries, Adjusting and Closing Entries, Bank Reconciliations

Fixed Assets Accounting and Reports

Sales and Profits Analysis, Ageing Reports of Vendors and Receivables

Inventory-Entries, Ageing and other Reports, Ageing Reports of Vendors and Receivables

Profit and Loss and Balance Sheet and Cash Flow Preparation

3 test/practice sessions

VAT return filing from QuickBooks

Job Opportunities for QUICKBOOKS with VAT Experience:

Can join as Accountant and Accounts Executive, can manage the VAT Accounting and Return Filing

Class Timing:

Let’s fix it as per your convenience after you meet the trainer

Separate timings can be arranged according to the convenience of the students

Our Training Approach:

Course Completion Certificate (KHDA certificate at extra cost)

Course materials and hand-outs

Mock tests, Case studies with simulations

Training in small batch for personalized attention

Training by Qualified professionals and Subject Matter Experts

Why Choose ELEGANT?

Our training starts from Basic yet in detail

Cost effective yet best quality

Each course by certified & qualified and subject matter experts

Flexible timings-evenings and weekends

Course Details

Programming Languages Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

Social Media Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

MS-Office Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

Excel Advanced Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

Programming Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

AutoCAD Civil 3D software is a design and documentation solution for civil engineering that supports building information modeling (BIM) workflows. By learning to use AutoCAD Civil 3D, you can improve project performance, maintain consistent data, follow standard processes, and respond faster to change.

Civil 3D allows is used to create three-dimensional (3D) models of land, water, or transportation features while maintaining dynamic relationships to source data such as grading objects, break lines, contours, and corridors. As an industry-leading building information modeling (BIM) solution, Civil 3D is well known in the civil engineering community and widely used on a variety of infrastructure projects both large and small.

THE AUTOCAD CIVIL 3D INTERFACE

• Product Overview
• AutoCAD Civil 3D Workspaces
• AutoCAD Civil 3D User Interface
• AutoCAD Civil 3D Tool space
• AutoCAD Civil 3D Panorama
• AutoCAD Civil 3D Templates, Settings, and Styles

PROJECT MANAGEMENT

• AutoCAD Civil 3D Projects
• Sharing Data
• Using Data Shortcuts for Project Management

PARCELS

• Lines and Curves
• Introduction to Parcels
• Creating and Editing Parcels by Layout Overview
• Creating and Editing Parcels
• Renumbering Parcels
• Parcel Reports
• Parcel Labels
• Parcel Tables

SURVEY

• Survey Workflow Overview
• Introduction to the Survey Tool space
• Survey Figures
• Points Overview
• Point Settings
• Creating Points
• Description Key Sets
• Importing Survey Data
• Point Groups
• Reviewing and Editing Points
• Point Reports

SURFACES

• Surface Process
• Surface Properties
• Contour Data
• Other Surface Data
• Break lines and Boundaries
• Surface Editing
• Adjusting Surfaces through Surface Properties
• Surface Analysis Tools
• Surface Labels
• Surface Volume Calculations
• Surface Analysis Display

ALIGNMENTS

• Roadway Design Overview
• AutoCAD Civil 3D Sites
• Introduction to Alignments
• Alignments Layout Tools
• Alignment Properties
• Labels and Tables

PROFILES

• Profiles Overview
• Create a Profile View Style
• Create Profiles from Surface
• Create Profile View Wizard
• Finished Ground Profiles
• Create and Edit Profiles

CORRIDORS

• Assembly Overview
• Modifying Assemblies
• Creating a Corridor
• Corridor Properties
• Designing Intersections
• Corridor Surfaces
• Corridor Section Review and Edit
• Corridor Visualization

GRADING

• Grading Overview
• Feature Lines
• Grading Tools
• Modifying AutoCAD Civil 3D Grading

PIPE NETWORKS

• Pipes Overview
• Pipes Configuration
• Creating Networks from Objects
• The Network Layout Toolbar
• Network Editing
• Annotating Pipe Networks
• Pressure Pipe Networks

QUANTITY TAKE OFF/SECTIONS

• Sample Line Groups
• Section Volume Calculations
• Pay Items
• Section Views

PLAN PRODUCTION

• Plan Production Tools
• Plan Production Objects
• Plan Production Object Edits
• Creating Sheets
• Sheet Sets

APPENDIX A ADDITIONAL INFORMATION

• Opening a Survey Database
• Design Data
• Autodesk Vault Overview

Course Details

Accounting Software Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

We train Tally, Quickbooks, Peachtree

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

#Microsoft #Word, #Microsoft Word, # Microsoft Excel, #Excel, #Microsoft, #MS EXCEL, # Lookups, Advanced Data Management, #data, #management, #Documenting and #Auditing, #Advanced Formatting, #Charts, #Advanced Charting, #MS POWER POINT, # MS ACCESS, #MS office, #Basics, #Advance Level

Course Details

The AAPC CPC (American Academy of Professional Coders Certified Professional Coder) exam consists of 150 multiple-choice questions. Test takers have 5 hours and 40 minutes to complete the exam. Unlike many other certification exams, the CPC exam is an open book exam. In fact, test takers must bring copies of the ICD-10, CPT and HCPCS manuals to the exam.

Course Details

CPC Course: A Certified Professional Coder (CPC) is an individual of high professional integrity, who has passed a coding certification examination sponsored by the American Academy of Professional Coders. The examination consists of questions regarding the correct application of CPT, HCPCS procedure and supply codes and ICD-10-CM diagnosis codes used for billing professional medical services to insurance companies. Certified Professional Coder (CPC) is the first line of defense against noncompliance and down-coding for any medical provider. Certified coders help prevent legal difficulties and ensure providers receive full reimbursement in a timely manner.

Course Details

Social Media Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend

Course Details

Red Hat Enterprise Linux supports and powers software and technologies for automation, cloud, containers, middleware, storage, application development, microservices, virtualization, management, and more. Linux plays a major role as the core of many of Red Hat's offerings.

Red Hat engineers help improve features, reliability, and security to make sure your infrastructure performs and remains stable—no matter your use case and workload.

 COURSE CONTENTS

⦁ Red Hat System Administration I

Red Hat System Administration I (RH124) equips you with Linux® administration "survival skills" by focusing on foundational Linux concepts and core tasks. You will learn how to apply command-line concepts and enterprise-level tools, starting you on your journey toward becoming a full-time Linux system administrator.

CONTENT SUMMARY

⦁ Introduction to the command line

⦁ Managing physical storage

⦁ Install and configure software components and services

⦁ Establish network connections and control firewall restrictions

⦁ Monitor and manage running processes

⦁ Manage and secure files and file systems

⦁ Administer users and groups

⦁ Review the system log files and journal for issues

⦁ Troubleshoot problems and analyze systems with Red Hat Insights

⦁ Remotely manage systems with SSH and the Web Console.

⦁ Red Hat System Administration II

Red Hat System Administration II (RH134) builds upon and lends context to the foundational knowledge established in Red Hat System Administration I (RH124). This follow-on course demonstrates more detailed use cases for Red Hat® Enterprise Linux®, preparing you for the Red Hat Certified System Administrator exam (EX200). This course is based on Red Hat Enterprise Linux 8.

  CONTENT SUMMARY

⦁ Install Red Hat Enterprise Linux using scalable methods

⦁ Access security files, file systems, and networks

⦁ Execute shell scripting and automation techniques

⦁ Manage storage devices, logical volumes, and file systems

⦁ Manage security and system access

⦁ Control the boot process and system services.

Course Details

Microsoft Exchange Server 2016 is the latest iteration of the Exchange Server messaging platform and is tentatively scheduled for release in the latter half of 2015. Exchange 2016 combines the mailbox and Client Access Server (CAS) roles, which should allow for simpler designs and architecture.

Microsoft Exchange enables email to be delivered directly to a server. It works by sending the emails back to your individual workstations in which your staff can access. Small and medium-sized companies can achieve three benefits from using Microsoft Exchange.

COURSE CONTENT

⦁ Installation, Storage, and Compute with Windows Server 2016.

⦁ Networking with Windows Server 2016.

⦁ Identity with Windows Server 2016.

⦁ Upgrading Your Skills to MCSA: Windows Server 2016.

⦁ Securing Windows Server 2016.

⦁ Implementing a Software-Defined Datacenter.

Course Details

A firewall is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules. A firewall typically establishes a barrier between a trusted internal network and untrusted external network, such as the Internet.

There are three basic types of firewalls that are used by companies to protect their data & devices to keep destructive elements out of network, viz. Packet Filters, Stateful Inspection and Proxy Server Firewalls.

CONTENTS

⦁ Firewall Planning and Design

⦁ Developing a Security Policy

⦁ Firewall Configuration Strategies

⦁ Packet Filtering

⦁ Working with Proxies and Application - Level Firewalls

⦁ Authenticating Users

⦁ Encryption and Firewalls

⦁ Choosing a Bastion Host

⦁ Setting Up a Virtual Private Network

⦁ Building Your Own Firewall

⦁ Ongoing Administration

Course Details

Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.

· Easy to use

· Flexible

· Cost-Effective

· Reliable

· Scalable and high-performance

· Secure.

CONTENTS

1. Fundamentals of Cloud Computing

2. Infrastructure & Networking

3. Storage

4. Elastic Load Balancers

5. Identity & Access Management

6. Relational Databases

7. Domain Name System

8. Aws Lambda and API

9. Building Scalable Application

10. Devops

11. Monitoring

Course Details

Microsoft Excel Advanced Training for Corporate or Individual, Al Barsha, Mall of Emirates Now!

Two hours per session 2-3 times in a week Fast Track: 5-7 days training with a dedicated trainer Flexible training in morning, afternoon and evening weekdays & weekend