Course Details

This course is targeted for those who are not from Computer Science Engineering ( CSE) or Information Technology (IT) background. In this course we cover the below subjects to an extent required in order to enable the students to get a good grasp of all that is required for them to be a part of Software Industry. We strictly recommend such students to take this course before taking up any real Software Learning Programs like Java or .NET . You will realize the value of this course once you start the career and you compare yourself with others who haven't gone through this and are struggling with Software Development. If you get the basics right, Software Engineering is the most easiest job.

Basics of Programming
Object Oriented Programming(OOPS)
Algorithms and Data Structures
Software Engineering
Operating Systems
Computer Networks
Computer Architecture and Organization

This course covers all the modules of the .NET including the basics

Object Oriented Programming (OOPS)
Microsoft Visual Studio
C# Language
ASP.NET MVC
Windows Communication Foundation(WCF)
Web API
Windows Presentation Foundation(WPF)

This course covers all the modules of the Java SE and EE and the Spring Framework

Object Oriented Programming (OOPS)
Eclipse IDE
Java Language
Java Standard Edition (JSE)
Java Enterprise Edition (JEE)
Servlets
Spring MVC
Springboot
restful Services
HTML
Javascript
jQuery

This course covers all the topics required for becoming a SQL Server Database Administrator

Relational Database Management Systems (RDBMS)
Microsoft SQL Server Internals
SQL Programming
SQL Server Installation, Maintenance, Administration

This course covers all the topics required for good grip on the Microsoft BI stack(excluding SSAS)

Relational Database Management Systems (RDBMS)
Microsoft SQL Server Internals
SQL Programming
SQL Server Reporting Services (SSRS)
SQL Server Integration Services (SSIS)

This course covers all the topics required for starting a job on Postgresql Database Development

Introduction to PostgreSQL
Getting Started
Postgresql Database Engine installation
pgAdmin Installation
Introduction to pgAdmin 4
PL/PGSQL Basic
SQL Primer
Basic Data Types in PostgreSQL

Numeric
Monetary
Character
Binary
Date/Time
Boolean

Specialised Data Types

Arrays
Enums
XML
JSON

DDL
Constraints
Sequences
DML
Queries
Basics
Joins
CTEs
Indexes
Views
Materialized Views
SQL functions
SQL Operators
Type Conversion
SQL Procedural Language
Declarations
Expressions
Basic Statements
Control Structures
Error Handling
Functions
Trigger functions
Triggers
Cursors
Transaction Management