Course

OVERVIEW

THINKWorks Java FullStack Developer course Designed & Delivered by Head Trainer with over 600 hours of comprehensive, Intensive, Immersive, Edutainment based 360° Skilling program & is a comprehensive one stop solution to pursue your IT career. The Program is designed as a hands-on Real-time project-based learning approach that would empower trainees to enhance their analytical and problem-solving skills by Structuring, Designing, Coding, Testing, Deploying end-to-end FullStack software solutions to real-time scenarios through Modeling & DevOps concepts.

THINKWork’s Java FullStack Developer Program would equip trainees to design & build customer centric solutions on both the client side and the server side that would transform every fresher into a Professional FullStack Developer. The course is designed to enable every trainee as a plug-n-play resource to meet the post-Covid work culture with compatibility towards WFO – Work from office & WFH – Work from home for the varied Job roles of the IT Industry such as Java FullStack Developer, Database Developer, Back-end Developer, Front-end Developer, Trainee Engineer, Associate Software Engineer etc,

Program

Highlights

Trainee Agreement

Industry relevant Course Materials

700+ Hours of Skilling

Personalized workbooks

Edutainment based Tech-Skilling

Realtime projects

Master trending technologies

Daily & weekly assessments

Inaugural: Java as Industry 4.0 Enabler

  • Java’s Might as a Programming Language
  • Relevance of C language in the ultra-modern century

Codification: Classification of Programming Languages

  • Machine Level – 11000101
  • Assembly Level – ADD AX, BX
  • High Level – print(10+12)

Know the past: History of High Level Programming Languages
Matters that matter: Organization of a Computer

  • Memory Hierarchy
  • Object File V/s Executable File

The Rise in computing power: Evolution of Storage Devices and Microprocessors
Be an Architectonic: Architecture of JAVA
The difference that makes a difference:

  • Assembler V/s Compiler
  • Compiler V/s Interpreter

Java Traits: Features of Java
Java’s Dais: Platform Dependency V/s Platform Independency

  • Write Once, Run Anywhere / Everywhere

Where to find? : Installation procedure
Java’s Evolution: Java Version History
Journey of Java: Sun Microsystems, Inc. Acquisition by Oracle Corporation
Dr. Java’s Walk of life: James Gosling’s career path
Breaking the surface:

  • First Java Program: Prototype of main() method – Visibility V/s Accessibility
  • know your commands: Java commands to Compile and Execute
  • nitty-gritty of Java: .class File

Procure inputs:

  • Command Line Arguments
  • Valid Signatures of main() method
  • Streams in Java

Life in an Objectvilla:

  • Object Orientation & it’s Principles
  • Classes and Objects

Voyage to Objectvilla:

  • Design Guesser Game Application
  • Java Documentation (Javadoc)
  • Statically typed V/s Dynamically typed
  • Java Naming Conventions
  • Java Keywords and Identifiers

Data matters:

  • Data types | Variables | Literals | Type Casting
    • Integer data types – byte, short, int, long
    • How real world data is stored in Memory?
    • Overflow V/s underflow
    • Wraparound behavior
    • Binary | Decimal | Hexadecimal | Octal representations
  • Floating point data types – float, double
    • Intro to IEEE
    • BigDecimal class
    • strictfp keyword
  • Character data type
    • ASCII Encoding Format V/s UNICODE Encoding Format
    • UTF – 8 V/s UTF – 16 V/s UTF – 32
    • Escape sequences
  • Boolean data type
  • Implicit V/s Explicit Type Casting – Widening | Narrowing
  • Truncation – Rounding towards Zero
  • Wrapper classes
  • Special symbols in identifiers and literals

Object Genesis: “new” keyword – clone()
Data Wrangle: Value Type Assignment V/s Reference Type Assignment
Scope and Life-time: Local Variables V/s Instance Variables
Modularize your code:

  • Methods
  • Types of Methods
  • Method Overloading
  • Don’t fall for the illusion: Virtual Polymorphism
  • Method Overloading with Type Promotion
  • Overloading of main() method

Data Herd: Arrays

  • Variable Approach V/s Array Approach
  • Types of Arrays
  • Regular V/s Jagged Arrays
  • Array of Objects
  • Control Structures
  • Hate Boilerplate code?: Loops in Java – for | while | do-while | for-each
  • Arrays Programming
  • You don’t have to write it all yourself: java.util.Arrays inbuilt class
  • Programming with Matrices
  • Time Complexity V/s Space Complexity
  • Know when to use: Advantages and Disadvantages of Arrays

Most commonly used objects: Strings

  • Immutable V/s Mutable Strings
  • Memory allocation of Strings
  • Common Operations on Strings – equals() | concat()
  • intern() method
  • Inbuilt methods of String class
  • StringBuffer and StringBuilder classes
  • StringBuffer V/s StringBuilder
  • C Strings V/s Java Strings

Pillars of Object Orientation:

Shield your Data: Encapsulation

  • “private” access modifier
  • Accessors and Mutators
  • Shadowing Problem
  • “this” keyword
  • builder does the setting up: Constructors
  • Types of Constructors
  • Constructor Overloading
  • Constructor Chaining
    • this()
    • super()
  • Singleton Design Pattern
    • Singleton Class

Sharing is caring: “static” keyword

  • Ideal Execution of a Java Program
    • static control flow
    • instance control flow
    • with both static and instance elements
  • Static variables V/s Instance variables – class variables
  • Static methods V/s Instance methods
  • Static blocks V/s Instance blocks
  • Inner classes V/s Nested classes

Know your relationship status: Inheritance – “is-a”

  • “extends” keyword
  • Advantages of Inheritance
  • Rules of Inheritance
  • Types of Inheritance
  • “super” keyword – super V/s super()
  • Sealed classes
  • Constructor chaining in Inheritance
  • Static control flow in Inheritance
  • Types of Methods in Inheritance
  • Method Overriding
  • java.lang.Object class

Carbon is Diamond: Polymorphism

  • Runtime Polymorphism / Dynamic Method Dispatch
  • Tight coupling V/s Loose coupling
  • Type Casting between objects
  • Upcasting V/s Downcasting
  • Advantages of Polymorphism
  • Runtime polymorphism with Data members
  • Benefits of Polymorphism
  • Static Binding V/s Dynamic Binding
  • instanceof operator
  • Method Hiding
  • Variable Arguments (Varargs)

Refashion the accessibility: Access modifiers – public | protected | default | private

  • Packages in Java
  • Modules in Java
  • Rules of Overriding

Has-A Relationship: Aggregation and Composition

  • Delegation Model

Everything need not make sense at the top level: Abstraction

  • Abstract classes
  • Concrete methods V/s Abstract methods
  • Advantages of Abstraction
  • “final” keyword
  • Java Enums
  • java.lang.Math class
  • Static import

Raise your standards: Interfaces

  • “implements” keyword
  • Rules governing the use of Interfaces – Marker Interface
  • Inheritance with Interfaces
  • “extends” with “implements”
  • Static and Default methods in Interfaces
  • Private methods in Interfaces
  • Functional Interfaces
  • Lambda Expressions
  • Factory Design Pattern
  • Annotations

Regex Anatomy: Regular Expressions in Java
Risky Behavior: Exception Handling

  • try-catch-finally blocks
  • Different ways of Handling an Exception
  • Multiple catch blocks
  • Exception Object Propagation
  • Exception Hierarchy
  • Checked V/s Unchecked Exceptions
  • “throw” V/s “throws” keyword
  • Error V/s Exception
  • Custom Exceptions
  • Nested try-catch
  • try with resources
  • “final” V/s “finally” V/s “finalize”
  • Exception handling with Overriding

Invisible threads are the strongest ties: Multithreading

  • Thread class methods
  • Single-threaded Approach V/s Multi-threaded Approach
  • Different ways to achieve Multithreading
    • By extending Thread class
    • By implementing Runnable interface
  • Impact of invoking run() explicitly
  • Executing multiple tasks simultaneously using a single run() method
  • Exception Handling in a Multi-Threaded Environment
  • time-trial: Race Condition
  • The Not-So-Evil Thread: Daemon Threads
  • Benefits and Limitations of Multithreading
  • join() and isAlive()
  • Thread Safety: “synchronized” keyword- Semaphore | Monitor
  • Thread Life Cycle
  • stand-off: Dead locks
  • Cooperation: Inter-Thread Communication
    • wait()
    • notify()
    • notifyAll()
  • Thread V/s Process
  • ThreadGroup
  • ThreadLocal variable
  • “volatile” keyword

Cut the Clutter: Garbage Collection

  • Different ways to run Garbage Collector

With great power comes great responsibility: Collections

  • Collections Framework
    • ArrayList class
    • Array V/s ArrayList
    • LinkedList class
    • add() V/s offer()
    • peak() V/s poll()
    • ArrayDeque class
    • PriorityQueue class
    • TreeSet class
    • HashSet class
    • Hashing
    • LinkedHashSet class
  • Collections Hierarchy
  • Boxing and Unboxing
  • Accessing mechanisms – Iterator
  • Legacy classes and interfaces
  • Fail fast V/s Fail safe
  • Sorting objects
    • Comparator interface
    • Comparable interface
  • More intuition: Generics
  • Inbuilt methods of Collections class

Pair with your key:Map

  • Map hierarchy
  • HashMap class
  • LinkedHashMap class
  • TreeMap class
  • Collection Views

Data Compression: JAR Files
Make a Connection: Input-Output in Java

  • Files and I/O
    • FileInputStream and FileOutputStream
    • FileWriter and FileReader
    • FileInputStream V/s FileReader
  • BufferedWriter and BufferedReader
  • Inbuilt File class methods
  • Standard I/O Streams
  • PrintWriter

Persistence always wins: Serialization and Deserialization

    • Serializable interface
    • ObjectOutputStream and ObjectInputStream
    • BufferedOutputStream and BufferedInputStream
    • Selective Serialization
        • “transient” keyword
        • Externalizable interface
        • Serializable interface
    • Serializable V/s Externalizable
    • Secure Hash Algorithm

Your network is your net worth:

  • Networking
  • 1-Tier V/s 2-Tier V/s 3-Tier V/s N-Tier Architecture
  • Socket Programming
    • One way communication
    • Two way communication

Punctuality is the first step towards success: Date and Time API

Java Database Connectivity (JDBC)Inception of JDBC:

  • Introduction
  • JDBC Architecture with key interfaces

Thin is the great middleman:

  • Types of Drivers

Employ Java on data tanks:

  • Oracle, MySQL, PostgreSQL databases
  • ways of adding JARs to Eclipse

Make a statement and make an impact:

  • Statement
  • PreparedStatement
  • CallableStatement

Different Avatars of output:

  • ResultSet
  • Read Only ResultSet
  • Updatable ResultSet
  • Forward Only ResultSet
  • Scrollable ResultSet

It is the nature of the self to manifest itself:

  • Metadata

Swim out of your little pond:

  • Connection Pooling
  • Basic Connection Pooling
  • Apache DBCP
  • HikariCP
  • C3P0

Invest in property:

  • Properties File in JDBC

Alone we can do so little; together we can do so much:

  • Batch Processing

Validate a Transaction:

  • ACID Properties

A knee-jerk reaction:

  • Triggers

Load Data:

  • ResourceBundle

Always a sweet deal:

  • Transactions and Savepoint

Function Arsenal:

  • Stored Procedures

Large Object Types:

  • Handling Blob and Clob

JEE Introduction to JEE SERVLETS Business class flight to Jakarta:

  • Introduction to Servlets
  • Stand-Alone Applications V/s Enterprise Applications

Internet App:

  • Web Application Architecture
  • HTTP Protocol and HTTP Methods
  • Web Server and Web Container

Design is intelligence made visible:

  • Design Patterns for Web Application
    • MVC – 1 (Page-Centric Architecture)
    • MVC – 2 (Servlet-Centric Architecture)
  • Static and Dynamic Response
  • Download and Configure Dynamic-Web Project
  • Manual Deployment (CATALINA_HOME)
  • Eclipse Auto-deployment

First class service:

  • Servlet Interface
  • GenericServlet & HttpServlet
    • doGet() and doPost()

Inception to termination:

  • Servlet Life Cycle
  • ServletConfig and ServletContext

Chain of helping hands:

  • Servlet Chaining

Servlet-browser communication:

  • sendError()
  • setHeader()
  • sendRedirect()

Web-component communication:

  • forward() and include()
  • HttpServletResponse.sendRedirect() V/s RequestDispatcher.forward()
  • Session Management

What you seek is seeking you:

  • Session Tracking Mechanisms
  • HttpSession
  • Cookies
  • URL-Rewriting
  • Hidden-Form Fields

Take a selfie with the filters:

  • Filters

Open ears are better than a closed mind:

  • Listeners and Wrappers

Spyware, malware… beware:

  • Web-Security

The right server for the right job:

  • Deploying web applications in application servers
    • Apache Tomcat
    • Oracle WebLogic Server
    • JBoss / WildFly
    • GlassFish
  • Server-based Connection Pooling

File sharing:

  • File Uploading and File Downloading

JSP Architecture:

  • Working of JSP Engine (JASPER)
  • JSP Lifecycle
  • JSP Directives
  • JSP Page Directive
  • JSP include Directive
  • JSP Taglib Directive

Scriptwriters of Java:

  • JSP Scripting Elements
  • Declarations
  • Scriplets
  • Expressions

The pursuit of happiness is internal:

  • JSP Implicit Objects

You’re allowed to set boundaries:

  • JSP Scopes
  • Page scopes
  • Request scopes
  • Session scopes
  • Application scopes

Lights, Camera, Action:

  • JSP actions
  • Standard Actions
  • Custom Actions

Jakarta has a price tag:

  • Tags in JSP

Bespoke tailoring:

  • Custom Tags
  • Exception Handling in JSP

JSTL Introduction to JSTL See the able, not the label:

  • Different Tags in JSTL
  • Core Tags
  • Function Tags
  • XML Tags
  • SQL Tags
  • Formatted Tags

Beauty without expression is Boring: Expression Language

  • Introduction
  • EL Implicit Objects
  • EL Functions

Maven Tool

  • Maven Build Cycle
  • Archetype of Maven
  • Importance of Project Object Model File (pom.xml)
  • Integration of Maven with Eclipse
  • Commands of Maven to Run
    • Stand-Alone Application
    • Web Application
  • Integrating Maven with Embedded Server (Tomcat)

IDEs:

  • Eclipse
  • NetBeans
  • IntelliJ

Tools and Frameworks Hibernate Architecture should speak of its time and place, but yearn for timelessness:

  • Introduction
  • Features of Hibernate
  • Hibernate Architecture
  • Setting up Hibernate Development Environment
  • The transformation begins with the transaction: Hibernate Transactions
  •  Connection Pooling in Hibernate
  • Fed up of operating on tables and columns? HQL
  • HQL V/s SQL Operations
  • When you change the way, you look at things, the things you look at change: Hibernate Configuration with annotations
  •  Hibernate CRUD Features: Create, Read, Update, Delete & Bulk Operations
  • Ideas are the primary key for your success: Primary Key Generation Algorithms
  • The object-relationships are the hallmark of fine mapping: Hibernate Advanced Mappings
    • One to One
    • One to Many
    • Eager V/s Lazy Loading
    • One to Many – Unidirectional
    • Many to Many

Maven You’re either the one that creates the automation or you’re getting automated:

  • Introduction
  • Architecture of Project Management tool
  • Pom.xml
  • Different types of Plugins
  • Maven root folder
  • Commands

The more centralized the power, the less compromises need to be made in architecture:

  • Dependency Management
  • Dependency Jar Configuration
  • Dependency Scopes
  • Archetype in Maven
  • JDBC application using Maven
  • Servlet application using Maven

Log4j Capture the moments of today that will wow your hearts tomorrow

  • Introduction
  • Features of Log4j
  • Configuration
  • Basic Application
  • Appenders
  • Log4j in web applications

JUNIT Quality is not an act, it is a habit

  • Unit Testing
    • Manual Testing
    • Automated Unit Testing
    • Limitations
  • Annotation of Junit
  • Application with Maven tool
  • Assert

Spring

  • It’s exciting to go on a vacation to Jakarta during Spring: Introduction to Spring
  • The main thing is to make history, not to write it: History of Spring
    • Spring 1x
    • Spring 2.x
    • Spring 3.x
    • Spring 4.x
    • Spring 5.x
  • No winter lasts forever, no spring skips its turn: Spring Core Applications
  • Mr. Bean has a unique capability to represent many objects as one: Bean
    • Definition of Bean
    • Types of Beans
    • XML
    • Java Based
    • Annotations Based
    • Bean Life Cycle
    • Bean
  • Success is implicit in hard work as gravitation is implicit in mass: AutoWiring
  • It’s not about having the right opportunities. It’s about handling the opportunities right:   Event Handling using Springs
  • Every act is an ‘Expression’ of one’s self: Spring Expression Language
  • Spring with JDBC
  • Energy and Persistence conquer all things: Spring ORM
    • Need of spring ORM
    • Spring + hibernate
    • Spring + JPA
    • Annotations
    • Spring DataJPA
  • The essence of love is concern: Spring AOP
  • Either it’s a good deal or no deal: Spring Transaction
  • Let the model replicate, controller command and view display: Spring MVC
    • Introduction
    • First web Application
    • Annotations in Spring MVC
    • Abstract Controller Class
    • Spring MVC Tag Library
  • Emails are calm and ‘composed’: Spring Mail
  • Authentication validates Reality: Spring Security
  • Spring Rest
  • Just run: SpringBoot
HTML/CSS The language of the web getting to Know HTML
  • Front End
  • Internet Architecture
  • Client-Server Architecture
  • WWW,URL ,HTTP and DNS
  • The language of the web getting to Know HTML
  • Versions of HTML
  • Features of HTML
  • Basic Structure of HTML
Know the Basics with Basic Tags & its Properties
  • Basic Tags
  • Heading Tags
  • Element V/s Tag
  • Attributes
  • Introduction to CSS and its properties
Format and Align the text on web
  • Aligning the elements on a webpage
  • Formatting the elements on a webpage
  • Internal & External CSS
  • Text Properties
  • Block Level  and Inline Elements
Meet the Media Multimedia
  • Aligning the elements on a webpage
  • Formatting the elements on a webpage
  • Internal & External CSS
  • Text Properties
  • Block Level  and Inline Elements
Connect the webpages
  • Relative path/Absolute path
  • Target attributes and Images as a Link:
  • Link states
  • Text decoration and display properties
  • Download attribute
  • Bookmarking with id.
Categorize web using Lists
  • Unordered list
  • Ordered List
  • Descriptive list
  • Nested Lists
Outline the web using IFRAMES (Window inside a Window)
  • Creating IFrames
  • Linking Iframes
Disecting the web with CSSBOX
  • Padding , Margin , Border
Positioning of elements on the web
  • positioning
Getting Tabular with Tables
  • Creating Tables
  • Spanning Rows & Columns
  • RowGroup & ColGroup
Aligning web using square & rectangles
  • Creating Grid Layout
Pretending as Web Elements
  • Psuedo Elements
Interactive web
  • Creating Forms
  • Text box , radio button , Drop down box
  • Field set, Legend
Advanced Web Construction with Semantic Elements
  • Headers and footers
  • Navigation and main
  • Section and article
  • Main and aside
  • Figure and figcaption
Arranging Elements
  • Relative & Position properties & Layout
Movement of Elements
  • Animate
  • Transform properties
  • KeyFrames
To pull oneself up by his bootstraps. Introduction & Installation
  • Bootstrap Elements
  • Bootstrap Forms
Keeping & Managing Web on Server
  • Hosting of webpage
JAVASCRIPT Lets Meet Action web
  • Introduction to JavaScript
  • History of JavaScript
  • Architecture
  • Version of JavaScript
  • Basic Program
  • Installation of Node.js
Know your Data using Variables and Datatypes
  • Creating Variables
  • Scripts think in datatypes-Datatypes
  • Primitive Datatypes
  • Non-Primitive DataTypes
Make a note for all codes
  • Single Line Comments
  • MultiLine Comments
Giving Cautions with POPups
  • Alert box
  • Confirm box
  • Prompt Box
Control structures
  • Conditionals
  • If Else Statements
  • Switch
  • Loops : At the risks of repeating itself
  • for
  • While
  • Do while
  • For-of
  • For-in
  • For-each
  • Jump to JUMP
  • Break
  • Continue
  • Labelled statement
Operators & Expressions
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operations
  • Bitwise Operators
  • Assignment Operators
  • Ternary Operators/Conditional Operators
  • Operators Precedence Rule
Wire the text
  • Creation of Strings
  • String Built -In Methods
Measure
  • Number Built-In Methods
Ordering items in Show
  • Creation of Arrays
  • Arrays Built-In Methods
Reduce , Reuse and Recycle with Functions
  • Declaring Functions
  • Function Expression
  • Anonymous Functions
  •  IIFE
  • Arrow Functions
  • Call back Functions
Scope and Hoisting
  • Lexical Environment
  • Global Variables
Classes &Objects
  • Literal Approach
  • Object.create()
  • Built-In Constructors.
BOM Currying , Closures Advanced Concepts with Action
  • Asynchronous Coding
  • Promises
Good Scripts Gone Wrong
  • Types of Errors
  • Try, Catch and Finally
Slicing and Dicing HTML with DOM
  • DOM Accessing Elements
  • DOM Events , Creating Elements
  • DOM –  Reg Expressions
  • Validate the web form’s data-Form  Validation
Query with Action
  • Introduction to jQuery
  •  Events Handlers
Lets Build Application using JavaScript ANGULAR Let Understand an Angle of Frontend with Angular
  • Introduction
  • History of Angular
  • Installation of angular
  • Angular CLI
  • Version of Angular
  • Angular Js V/s Angular
Type the Script with Typescript
  • Introduction to TypeScript
  • TypeScript V/S JavaScript
  • Declaring Variables & datatypes using TypeScript
Transforming Multiple Pages into Single Page
  • Angular Folder Structure
  • Creation of Components
  • Using Multiple Components
Bind the Data with Data Binding
  • Data Binding Introduction
  • Types Of Data Binding
Direct the Single Page
  • Working with Class ,Styles and Directives
Web Forms
  • Template Driven Forms
  • TDF Validations
  • Reactive Forms
  • Reactive Forms Validation
Services
  • Creating Service
  • Injecting Service to Applications
Parent child communication
  • Creation & using Input Decorators
  • Creation & using Output Decorators
Setting the Path
  • Routing
  • WildCard Route
JSON Transmit data on web using HTTP
    Get, post , put and delete methods

Module 1 : RDBMS Concepts and Data Modeling/Database design Know your relationship framework:

  • Introduction to Data
  • Requirements of RDBMS
  • Relational Model
  • What is a Data Model?
  • Steps involved in the development of Data Model
  • Goals of Conceptual Data Modeling
  • Conceptual Database Design
  • Database design process
  • Entity relationship model
  • Main Elements of an Entity-Relationship Diagram
  • Entities
  • Sub type, super type
  • Regular or Strong & Weak entities (Independent and dependent entities)
  • Entity Instances
  • Identifying and Modelling Entities
  • Relationships
  • Modelling Relationships
  • Defining a Relationship
  • Types of relationships
  • Minimum and maximum relationships
  • Attributes
  • Finding Attributes
  • Meaningful Components for Attributes
  • Different diagrammatic Conventions

Visualize data both ways, top-down and bottom-up:

  • Transformation of entity relationship model into relational schema
  • Logical Database Design
  • Top-Down approach – E/R Modeling technique
  • Bottom-Up approach – Normalization
  • Differentiate between the above two approach
  • Relational database design and update anomalies

Test your relationship with entities:

  • Discussion of case study on E/R modelling
  • Execution of case study

Normalize datum relationships:

  • Normalization
  • Appreciate the need for normalization
  • Functional Dependencies
  • Loss-less decomposition
  • Various forms of Normalization
  • I Normal form
  • II Normal form
  • III Normal form

Codify normalization:

  • Boyce Codd Normal form (BCNF)
  • Discussion of case study on Normalization
  • Execution of case study

Michael Widenius’s daughter’s Structured Query Language:

  • Introduction to MySQL
  • MySQL Tools to Access Data

Module 2: SQL

  • Classification of SQL – DDL, DML, DCL, TCL
  • Schema Objects – List of schema, usages and Conventions.
  • RDBMS Data types in General.

Table is the go-to guy for queries:

  • MySQL Data types
  • Identify the major structural components of the MySQL Database
  • Table manipulation – Creating, Inserting Data into tables
  • Write SELECT statements that include queries

You hear and you forget. You see and you remember. You do and you understand:

  • Hands on practice session
  • Lab exercises

The harder the climb, the better the view:

  • Using metadata
  • Retrieve row and column data from tables with the SELECT statement
  • Run data manipulation statements (DML) to update data in the tables
  • Viewing the data – Restricting, Organizing, Grouping

Integrity reveals beauty:

  • Returning top rows
  • Auto Increment
  • Integrity constraints
  • Domain integrity constraints
  • Entity integrity constraints
  • Referential integrity constraints

Witness how the world changes, table by table:

  • Self referential integrity constraints
  • Querying Data dictionary – Querying system tables for Tables, Constraints
  • ‘Group by’ clause and ‘Having’ clause
  • SQL Functions
  • Single row functions

One call, that’s all it takes:

  • Number functions, Character functions, Date functions, miscellaneous functions, Conversion Functions
  • Group functions
  • Creating and altering the structure and constraints of the table

When one is willing and eager, the God joins in:

  • Temporary tables
  • Joins – Equi-join, non-equi join,
  • Outer joins, Left Outer join, Right Outer join.Self join
  • CROSS JOIN, NATURAL JOIN, USING, ON

Set goals, operate on them, and express success:

  • Set operators
  • CASE expressions
  • Lab exercises
  • Hands on practice session

I have a small query:

  • Queries – Complex
  • Sub Queries
  • Writing Single-Row and Multi-Row Sub-queries
  • Describing and Explaining the Behaviour of Sub-queries when NULL values are retrieved
  • Using Regular Expressions
  • Write multiple-column sub-queries

Believe you can and you’re halway there:

  • Correlated Sub-Queries
  • Introduction to other Schema Objects
  • Lab exercises
  • Hands on practice session

Make a transaction and make a transformation:

  • Views – Concepts, Features, Definition, Creation, Join views updateable rule
  • Manipulating and Altering Views
  • Transactions and Transactional Statements, TCL

Never stop looking up:

  • Indexes
  • Purpose of indexes
  • Classification of indexes
  • Examples of indexes
  • Creating and dropping indexes
  • Querying the data dictionary

Know the rules well:

  • SQL Tuning – overview
  • Order of execution of SELECT statements
  • Rules for writing SELECT statements
  • Rules for writing join statements – to improve performance
  • Concepts of Privileges and Role
  • DCL – Data Control Language – Grant and Revoke

If you can’t find the key to success, pick the lock:

  • Concurrency and Locking Mechanism
  • Types of Locks – Implicit and Explicit locking
  • Levels of Lock
  • Lab exercises
  • Hands on practice session

Functions are kept in the storeroom: Module 3: Stored Routines

  • Advantages of Stored Routines
  • Managing Stored Routines
  • Procedural extensions to standard SQL
  • Delimiter
  • Flow control
  • Loops
  • WHILE
  • LOOP
  • REPEAT

Cursor is a wonderful workplace:

  • Cursors
  • Error handling
  • Stored Procedures
  • Calling or executing a Procedure
  • DROP PROCEDURE
  • Modification
  • Metadata
  • Lab exercises
  • Hands on practice session

Information is the new currency:

  • Show Function / Procedure Status
  • INFORMATION_SCHEMA.ROUTINES
  • INFORMATION_SCHEMA.PARAMETERS

You’ll never pull the trigger:

  • Managing Triggers
  • Creating Triggers
  • Drop Triggers
    • Metadata
    • Show Create Trigger
    • Show Triggers
    • INFORMATION_SCHEMA.TRIGGERS
  • exercises
  • Hands on practice session

Become an event planner:

  • Events
  • Managing Events
    • Create Event
    • Alter Event
    • Drop Event
  • Metadata
    • SHOW CREATE EVENT
    • SHOW EVENTS
  • INFORMATION_SCHEMA.EVENTS

Greatness is a lot of small things done well, stacked up on each other: Stack Data Structure

  • At the outset: Stack – An Intro
  • Chaos was the law of nature; Order was the dream of man: Stack Principle(LIFO)
  • Push your achievements; Pop your worries: Operations on Stack
    • Push – Orderly insertion
    • Pop – LIFO deletion
    • Display – get a sneak peek
  • Analysis shall prevent paralysis: Time Complexity of Stack operations
  • Learning without application is just entertainment: Programming applications of Stack Data Structure
    • Global Stack
    • Local Stack
    • Expression evaluation
    • Search operations
    • Reverse operations
    • Verify balanced parenthesis

A programmer, even if he is alone, forms an orderly queue of one: Queue Data Structure

  • Precursory: Queue – An Intro
  • Why is there a ‘ueue’ in ‘Queue’?: Queue Principle (FIFO)
  • Keep your vision at the front of the queue and your fears at the rear: Operations on Queue
    • Insert – Orderly insertion
    • Delete – FIFO deletion
    • Display – get a sneak peek
  • Be the one for the queue. Not in the queue: Types of Queues
    • Ordinary Queue
    • Circular Queue
    • Priority Queue
    • Double-ended Queue
  • Analysis keeps repetitive mistakes away: Time Complexity of Queue operations
  • Edutainment is learning with application: Programming applications of Queue Data Structure
    • Global Queue
    • Local Queue
    • Search operations
    • Reverse operations

Good works are links that form a chain of love: Linked List Data Structure

  • Preface: Linked List – An Intro
  • Though your thoughts are dispersed; but they’re linked: Linked List on primary memory (RAM)
  • Links make a difference: Linked List Vs Arrays
  • One link in a chain explains the infinite chain: Operations on Linked List
    • Insert operation
      • at front
      • at rear
      • at mid
      • at given position
    • Delete operation
      • at front
      • at rear
      • at mid
      • at given position
    • Display – get a sneak peek
  • Design the nodes for your bucket list: Types of Linked List
    • Singly Linked List
    • Doubly Linked List
    • Circular Linked List
    • Circular-doubly Linked List
  • Time isn’t the main thing. It’s the only thing: Time Complexity of Linked List operations
  • Programmers don’t fall in love, they just “link” with someone: Programming applications of Linked List Data Structure
    • Stack using Linked List
    • Queue using Linked List
    • Search operations
    • Reverse operations
    • Cycles in Linked List

From little seeds, grow mighty trees: Tree Data Structure

  • Foundation: Tree – An Intro
  • Phraseology: Tree terminologies
  • Though branches grow in different directions, their roots remain as one: Tree on primary memory (RAM)
    • Tree Data Structures on Arrays
    • Tree Data Structures on Linked List
  • Little things make a big difference: Array Trees Vs Linked List Trees
  • Be like a tree and let the dead leaves drop: Operations on Tree
    • Insert operation
    • Delete operation
    • Display
    • Search operation
    • Sort operation
  • There are different ways you can climb a tree: Tree traversals
    • Pre-order traversal
    • In-order traversal
    • Post-order traversal
  • Ancient trees are precious: Types of Trees
    • Binary Tree
    • Complete Binary Tree
    • Almost Complete Binary Tree
    • Binary search Tree
    • AVL Tree
    • Red-Black Tree
    • B Tree
    • B+ Tree
  • Storm make trees take deeper roots: Programming applications of Tree Data Structure

Life is a graph between learning Vs time: Graph Data Structure

  • Inception: Graph – An Intro
  • There are no x & y axes to this graph; there are nodes and edges: Graph terminologies
  • Disconnect to connect: Graph on primary memory (RAM)
    • Graph Data Structures on 2D – Arrays
    • Graph Data Structures on Linked List
  • Strength lies in differences; not in similarities: Graph Data Structure Vs Tree Data Structure
  • Cover the earth, before it covers you: Graph traversals
    • Breadth first search (BFS)
    • Depth first search (DFS)
  • Don’t count the edges, make the vertices count: Types of Graphs
    • Trivial Graph
    • Simple Graph
    • Multi Graph
    • Complete Graph
    • NULL Graph
    • Labeled Graph
    • Digraph
  • An algorithm is like a recipe; Graph is the ingredient: Programming applications of Graph Data Structure
    • Prim’s Algorithm
    • Kruskal’s Algorithm
    • Dijkstra’s Algorithm
    • Warshal’sAlgoirthm
    • Floyd’s Algorithm
    • Knapsack
    • TSP
    • N-Queen’s problem

Build trees with a heap of hope: Heap Data Structure

  • Establishment: Heap – An Intro
  • When you visualize, then you materialize: Heap on primary memory (RAM)
    • Heap Data Structures on Arrays
    • Heap Data Structures on Linked List
  • A heap of bricks is not yet a house: Operations on Heap
    • Insert operation
    • Delete operation
    • Heapify
  • Get maximum effect from minimum effort: Types of Heap
    • Min Heap
    • Max Heap
  • When you’re sorted, life will surely be: Programming applications of Heap Data Structure
    • Heap sort

As long as one keeps searching, the life is sorted:  Searching and Sorting Algorithms

  • Bubble Sort
  • Selection Sort
  • Insertion Sort
  • Merge Sort
  • Quick Sort
  • Counting Sort
  • Radix Sort
  • Bucket Sort
  • Heap Sort
  • Shell Sort
  • Linear Search
  • Binary Search

An algorithm must be seen to be believed: Important General Algorithms

  • Huffman Coding
  • Job Sequencing
  • Tower of Hanoi
  • Bellman ford Algorithm
  • Horspool’s Algorithm

Curiosity begins as an act of analysis: Analysis of Algorithms & Asymptotic Notations

  • Order of growth using limits
    • Best case efficiency
    • Worst case efficiency
    • Average case efficiency
  • Asymptotic Notations
    • O (Big-Oh) notation
    • Ω (Omega) notation
    • Θ (Theta) notation
  • Properties of Asymptotic Notations
  • Problems on Asymptotic Notations
  • Analysis of all Algorithms under Data Structures
  • Solid square-rectangle-triangle
  • Hollow square-rectangle-triangle
  • Patterned Alphabets A-B-C-D
  • Universal Pattern
  • Horizontally & Vertical alignment
  • Play with Number Patterns
  • Pascal’s triangle
  • Floyd’s triangle
  • Binary pattern
  • Spiral number patterns
  • Factor-number-count-sum.
  • Play with loops
  • Get-in and Get-Out
  • Staircase
  • Are you Prime? What’s your range?
  • Twin primes.
  • Factorials Long & Small.
  • Fibonacci – Number & Member
  • Perfect Square
  • Strong Number
  • ArmStrong Number
  • Harshad Number
  • Friday the 13th
  • Library Fine
  • Plus – Minus
  • Merged Arrays
  • Zig-Zag Arrays.
  • Left Rotation
  • Diagonal Difference
  • Birthday Cake Candles
  • Mini-Max Sum
  • Magic Number
  • Ranking without Sorting
  • Symmetric Array
  • Array Union & Intersection
  • Apples & Oranges
  • Slower Matrix
  • Very Angry Professor
  • Kangaroo Jumps
  • Mark your Toys
  • Love the Ice-Cream Parlour
  • My Drawing Book
  • Rank your Ability
  • CamelCase
  • Deadend SpecialCase
  • My Mars Exploration
  • String within String
  • String – split – count –
  • String – frequency – manipulation
  • Designer PDF viewer
  • Making Anagram
  • Anagram
  • My Funny String
  • Gem Stones
  • Alternating Characters
  • Longest Palindrome
  • Palindrome Everywhere
  • Future Palindrome
  • Convert your Time
  • Counting Valleys
  • My Love-Letter Mystery
  • Caesar Cipher: Encryption
  • Our Common Child
  • Keep Recurring
  • Pattern-Matcher   Class
  • Our Quantifiers
  • My Mobile Number
  • Your Mail-ID
  • His Strong Password
  • Regex
  • My Game of Thrones
  • Gmail Login
  • Your Contact List
  • Let’s Count Pairs
  • Quicker Maths – Be a Mathmagician Tools to help a magician
    • Multiplication tricks
    • Squares and Square roots
    • Cubes and Cubes roots
    Number Theory – I- Game of Numbers Rules of Games
    • Types of numbers
    • Face value and Place value
    Must Follow practices
    • Factorization
    • Divisibility Rules
    Number Theory – II – Mystery ends and Logic Starts Praise the logic
    • Unit Digit Concept
    • Zero’s Concept
    • Remainder Theorem
    • LCM and HCF
    Series- Don’t Sweat
    • Number Series
    • Letter Series
    Percentages- Down the rabbit hole Strate-JI
    • Conversions
    • Percentage increase and decrease
    • Successive Percentage
    Profit and Loss- Greased Lightning Win-Win situation conditions
    • Profit and Loss percentage
    • Discounts
    • Marked price
    • Successive discounts
    Time Speed and Distance -Down to the wire – Be cautious
    • Conversions
    • Proportionality Concept
    Speed thrills but kills
    • Average Speed
    • Relative Speed
    Problems on Trains- Mirage Boats and Streams- Drawing a blank Coding Decoding- Barking up the wrong tree Ratios, Proportions and Variations- Hard Pill to swallow Partnerships – Hands down Averages- It’s not rocket science Don’t miss this science
    • Weighted Average
    Mixtures and Alligations- It isn’t over till the fat lady sings
    • Rule of Alligation
    • Repeated Dilutions
    Blood Relations- Beating around the bush Time and Work- Close but no cigar Mode of earning money
    • Individual Work
    • Group Work
    Pipes and Cisterns- Be positive
    • Positive Work
    • Negative Work
    Simplification – Drive me nuts Set Theory- Get the ball rolling Dive into the world of diagrams
    • Venn Diagrams
    Syllogisms and Directions- Really Silly Permutations and Combinations – I – Paint the town red Rules of painting
    • Basics of Permutations and Combinations
    • Principle of Counting
    • Number Permutation
    • Code Permutation
    • Word Permutation
    Permutations and Combinations – II Selection of colors for painting
    • Circular Permutations
    • Combinations
    • Handshake Concept
    Probability – Take a chance
    • Coins Concept
    • Dice Concept
    • Playing Cards
    • Marbles Concept
    • Calendar Concept
    Cubes, Clocks and Calendars – Think while you blink
    • Leap Year Concept
    • Odd days concept
    • Finding the day of the given date
    Simple Equations and Problems on Ages- Cut to the chase Data Interpretation – I – Fool me once, shame on you- Be aware of these mentioned mirages
    • Tabular Method
    • Graphical Method
    • Pie charts
    • Bar Graphs
    • Line Graphs
    Data Interpretation – II- Drop the ball
    • Caselet Form
    • Radar/Web Based
    • Missing Data Interpretation
    Races and Games- Game theory Simple Interest and Compound Interest. – One stone two birds Geometry-I- An arm and a leg
    • Properties of 2 D figures
    • Properties of 3 D figures
    • Area and Perimeter
    Geometry-II- Burst your bubble
    • Distance formula and Section formula
    • Slope and equation of the slope
    • Interior angles of the convex polygon
    • Area of Major and Minor Segments
    Geometry-III- Utilize the skills Skills bank
    • In-center and Centroid
    • Length of the median
    • Generation of Pythagorean Triplets
    Mensuration – A piece of Cake Data Sufficiency- Fish out of water Seating Arrangements- Torchlight Beam of light
    • Linear Arrangements
    • Circular Arrangements
    • Rectangular Arrangements
    • Floor Arrangements
    Reflection of light
    • Selection
    • Double Line Mapping
  • Strengthen your basics of grammar
    Parts of Speech I
    • Noun
    • Pronoun
    • Verb
    • Adjective
    Parts of Speech II
    • Adverb
    • Preposition
    • Conjunction
    • Interjection
    Want to catch up with timelines – Master Tenses
    Tenses I
    • Simple Present
    • Present Continuous
    • Present Perfect
    • Present Perfect Continuous
    Tenses II
    • Simple Past
    • Past Continuous
    • Past Perfect
    • Past Perfect Continuous
    Tenses III
    • Simple Future
    • Future Continuous
    • Future Perfect
    • Future Perfect Continuous
    Stuck while speaking – Enhance your Vocabulary
    Vocabulary I
    • Phonetics
    • Homophones
    • Homonyms
    • Synonyms & Antonyms
    Vocabulary II
    • Root Words
    • Silent Letters
    • Prefixes & Suffixes
    • Etymology and Jargons
    Learn to organize the content
    Jumbled Paragraphs
    • Introspection
    • Finding Cues
    • Discourse Markers
    Writing a note to people – Beware of the tone
    Direct and Indirect Speech
    • Direct and Indirect distinctions
    • Word Conversions
    • Clause Inversions
    • Change of Tense
    Active and Passive Voice
    • Active and Passive Distinctions
    • Subject and Object Understanding
    • Sentence Inversions
    • Change of Tense
    Get a glimpse of relationship between subject and verb
    Subject Verb Agreement I
    • Rules 1-9
    Subject Verb Agreement II
    • Rules 10-18
    Subject Verb Agreement III
    • Rules 19-27
    Making errors in sentences – This topic helps you to stop that
    Spotting Errors I
    • Errors in Articles
    • Errors in Compound nouns
    • Errors in Prepositions
    Spotting Errors II
    • Errors in Verbs
    • Errors in Spelling
    • Errors in Punctuations
    Want use catchy phrase to impress – Here we go
    Idioms and Phrases
    • Commonly used Idioms
    • Phrasal Verbs
    Learn to email – very important aspect in connecting with client
    Email Writing
    • Rules for writing Effective Emails
    • Sample Emails
    Require help in process documents?
    Paragraph Writing
    • Rules for writing Effective Paragraphs
    • Sample Paragraphs
    Helps in comprehending project documents
    Reading Comprehension I
    • Skimming
    • Scanning
    • Discourse Analysis
    Reading Comprehension II
    • Lexical and Contextual Meanings
    • Building Concentration
    • Sample Passages
  • How to impress in few golden minutes – ELEVATOR PITCH
    • Giving self-introduction to Technical Manager & Human Resource Manager
    Do you know how to sit in the interview room?
    • Let us learn NON-VERBAL COMMUNICATION
    • Facial Expressions
    • Body movement & Posture
    • Gestures
    • Eye contact
    • Touch
    • Space
    • Voice
    JUST A MINUTE
    • Tips & Tricks to clear the JAM round.
    PERSONAL GROOMING & HYGIENE
    • Groom someone as something
    VIRTUAL ETIQUETTE
    • Improvise your virtual etiquette & crack your interviews.
    • Virtual Etiquette hacks every profession should know.
    JOB DESCRIPTION & SKILL BASED ANALYSIS
    • Match your talent with the JD & catapult in your career curve.
    • Customized resume according to JD.
    RESUME DRAFTING
    • Create a resume which will always appear in top 10 list of ATS.
    • Customized resume for every opportunity.
    VIDEO RESUME
    • Grab the attention of your recruiter through video resume.
    GROUP DISCUSSION
    • Group discussion tips you should know.
    • Be the master of Group Discussion and crack any interview.
    TIME MANAGEMENT
    • Master your time management master your life.
    • Get better results in every area of yours by effective time management.
    GOAL SETTING
    • Stick to proper goal setting process and watch your dreams come true.
    SWOT Analysis
    • Do SWOT analysis and make better choices in life
    TEAM BUILDING
    • Win championship with teamwork & collaboration.
    WORKPLACE ETIQUETTE
    • Good workplace manners will ace up career ladder.
    STRESS MANAGEMENT
    • Overcome your stress and get better results.
    EMOTIONAL INTELLIGENCE
    • Be a self-empowered leader by mastering emotional intelligence.

  • Modeling-a fantasy word
    • I’m UML
    • Moral code of Modeling
    • Object Oriented Modeling
    • Conceptual Model of UML
    • Structural Diagrams
    • Behavioral Diagrams
    • UML Architecture

    A never-ending joyful Journey

    • Introduction
    • Need of DevOps
    • DevOps V/s SDLC
    • Advantages of DevOps
    • DevOps Lifecycle
    • DevOps WorkFlow
    • DevOps V/s Agile
    • DevOps Principles
    • DevOps Engineer
    • DevOps Automation Tools

    An open friend

    • Introduction to Jenkins
    • Continuous Integration with Jenkins
    • Jenkins Architecture
    • Installing Jenkins
    • User Management
    • Setting up CI/CD for Project
    • Build Delivery Pipeline
    • Create a pipeline script to deploy an application over the Tomcat server
    • Configure SCM in Jenkins

    Dream in the sky

    • Why Cloud
    • Introduction to Cloud Computing
    • Why DevOps on Cloud?

    Nothing is in Control

    • Introduction
    • Installation
    • Commands with Git
    • Introduction to GitLab
    • Git Branching & Merging
    • Git clone
    • Staging
    • Code Review
    • Merging Changes
    • Repository & Push Code on GitLab
Tools and Technologies

Case Studies

& Projects

The central theme of projects at THINKWorks is to transit from Problem-space to Solution-space using Modeling & DevOps. You would Plan, Analyse, Design, Model, Code, Test, Integrate & Deploy end-to-end FullStack software solutions in line with IT Industry best practices. Our 7 Capstone Java FullStack projects would provide you with the right hands-on exposure to implement Efficient, Robust, Optimized, Clean Code. Acquire professional expertise in implementing the application layer, presentation layer, logical layer & database layer. Empowered with Analytical & Problem-solving skills, deliver customer centric Web based solutions to real-time scenarios on both Client side & Server side.

Have Queries?