Training & Internship Programs

Full-Stack web developement training program

Certification Course

Full Stack - PHP-MYSQL-HTML-CSS-JAVASCRIPT-JQUERY-AJAX-BOOTSTRAP

Duration: 60 Hours

Fees: Call +91 8149913390

For Students : 10% Discount/-

Limited Participants Count (Max 10), 

so that everyone will get personal attention to their queries.

Course Content:

  1.     New Domain Registration,
  2.     Hosting website,
  3.     Professional emails setup,
  4.     DNS Settings,
  5.     Database Design,
  6.     HTML, CSS, jQuery, Javascript, Ajax, PHP, MYSQL, Bootstrap
  7.     Payment Gateway integration,
  8.     SMS gateway integration,
  9.     Email Integration,
  10.     Learn all concepts with a real life project: Design and developement of an E-commerce system from scratch.

Prerequisites to attend the course:

    Basics of any programming language like C

TRAINER PROFILE

Ketan Pachpande

Founder, Gigasoft Technologies 

10+ Years of Software industry experience as Developer. 

7000+ Hours of Teaching experience.

Education: Computer Science Engineer 

MTech: IIT Kharagpur 

BTech: VJTI, Mumbai  

REGISTER NOW
SQL training program | (Beginner to Advance)

Certification Course

STRUCTURED QUERY LANGUAGE

Duration: 15 Hours

Fees: Call +91 8149913390

For Students : 10% Discount/-

Limited Participants Count (Max 10), 

so that everyone will get personal attention to their queries.

Course Content:

  1. Introduction to SQL – What and Why
  2. Setup
  3. DBMS Concepts before we start SQL
    • Database
    • Relations or Tables
    • Keys: Primary and Foreign Key
    • Indexing
  4. DB and Table Operations:
    • CREATE DATABASE - creates a new database
    • ALTER DATABASE - modifies a database
    • CREATE TABLE - creates a new table
    • ALTER TABLE - modifies a table
    • DROP TABLE - deletes a table
    • CREATE INDEX - creates an index (search key)
    • DROP INDEX - deletes an index
  5. CRUD Operations for Data Manipulation
    • Create - INSERT INTO
    • Read - SELECT
    • Aliases, CONCAT
    • Update - UPDATE
    • Delete – DELETE
  6. Where Clause
    • AND, OR and NOT operators
  7. Order by – For sorting the result set
  8. NULL values
  9. TOP and LIMIT
  10. Min, Max, Avg, Count, Sum
  11. Like, wildcard: %, for string matching
  12. IN, Between for selecting the range of values
  13. Foreign Key
  14. Joins : Inner, left, right, full 
  15. Group by
  16. having

Prerequisites to attend the course:

    None

TRAINER PROFILE

Ketan Pachpande

Founder & Product Architect, Gigasoft Technologies 

10+ Years of Software industry experience as Developer. 

7000+ Hours of Teaching experience.

Education: Computer Science Engineer 

MTech: IIT Kharagpur 

BTech: VJTI, Mumbai  

Download Brochure
REGISTER NOW