TOOLS OF RPA

PHP  for Beginners:

PHP is the most popular scripting language on the web. Without PHP Facebook, Yahoo, Google wouldn’t have exist. The course is geared to make you a PHP pro. Once you digest all basics, the course will help you create your very own Opinion Poll application.

What should I know?

Just a full form of PHP would be enough to learn this course. This  is designed for beginners with little or no PHP experience.

Training Syllabus

PHP Fundamentals

  What is PHP? Write your first PHP Program
  XAMPP & Netbeans installation
  Data Types, Variables and Operators
  Comments, Include & Require
  Arrays in PHP

Lets introduce some Logic!

  PHP Control Structures: If else, Switch Case
  PHP Loop: For, ForEach, While, Do While
  How to create PHP strings and why to use strings?
  Functions in PHP
  PHP Forms
  Cookies & Sessions
  File Processing
  Error Handling
  Regular expression

Advance Stuff

  MAIL
  Database Access
  OOPS in PHP
  Using Date
  Security functions
  XML,DOM, Parsers with PHP

Your First PHP project!

  Create an Opinion Poll Application using PHP
  How to create Ajax based PHP application
  MVC Framework : CodeIgniter Example

Check!

  PHP vs JavaScript: Must Know Differences
  PHP Live Project Training
  PHP Interview Questions and Answers

 

 

 

SQL  for Beginners

size=2 width=”100%” align=center>

Databases can be found in almost all software applications. SQL is the standard language to query a database. This course will teach you database design. Also, it teaches you basic to advanced SQL.

What should I know?

The course is designed for SQL beginners. No prior DB experience is required.

Training Syllabus

Database Fundamentals

  What is a database? What is MySQL?
  Introduction to MySQL & MySQL workbench

Database Design

  Introduction To Database Design
  Learn Database Normalization with the help of a case study
  Learn ER Modeling with a Case Study

SQL Basics

  How To Create A Database & MySQL DataTypes
  How to use SELECT in MySQL
  How to query data using Where clause in MySQL
  How to use Insert Into in MySQL
  How to Delete & Update data in MySQL

Data Sorting

  How sorting is done in MySQL using ORDER BY, DESC and ASC
  How to use Group By in MySQL
  How to use Wildcards in MySQL
  Using Regular Expressions & Wild Cards in MySQL

Functions

  Ultimate guide to Functions used in PHP
  How to use Aggregate Function in MySQL

Must Know Stuff!

  All about Null value & Keyword in MySQL
  How to use Auto Increment in MySQL
  How to use Alter, Drop & Rename function in MySQL
  How to use Limit keyword in MySQL

Most Dreaded Topics!

  Using Sub-Queries in MySQL
  How to use Joins in MySQL
  How to use Unions in MySQL
  How to use Views in MySQL
  How to use Index in MySQL

What Next!

  Creating an Application using MySQL
  Oracle MySQL 5.6 Certification with Study Guide
  20 Best SQL Management Tools in 2018
  Top 50 SQL Interview Questions & Answers