0% found this document useful (0 votes)
6 views6 pages

Java, SQL, Web UI & Cloud Programming Guide

Uploaded by

abinaya.v
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views6 pages

Java, SQL, Web UI & Cloud Programming Guide

Uploaded by

abinaya.v
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

CLUSTER 1 — Java + SQL + Web UI (HTML/CSS/JS)

Section 1: Web UI (MCQ)

HTML

●​ Structure of HTML Doc


●​ HTML 5 Features
●​ Block vs Inline Elements
●​ Basic tags
●​ Forms & Inputs
●​ Tables
●​ Semantic HTML

CSS

●​ Inline/External CSS
●​ Selectors
●​ Box Model
●​ Position Property
●​ Flexbox
●​ Basic responsive design

JavaScript

●​ Variables (let/var/const)
●​ Data Types
●​ Operators
●​ Functions & Scops
●​ Loops
●​ Functions
●​ Arrays & Objects
●​ DOM Manipulation
●​ Events
●​ JSON
●​ Promises & Asyncn
●​ Basic output prediction
Section 2: ANSI SQL (MySQL syntax)

●​ DDL / DML
●​ DCL
●​ TCL
●​ Constraints (PK, FK, UNIQUE, CHECK)
●​ SQL Functions (COUNT, SUM, AVG, MIN, MAX)
●​ WHERE, GROUP BY, HAVING, ORDER BY, DISTINCT
●​ SELECT queries
●​ SQL Operators (IN, BETWEEN, LIKE)
●​ Joins (INNER, LEFT, RIGHT, FULL*)
●​ Subqueries
●​ Views
●​ Indexes​

Section 3: Coding (Java Programming)

●​ JVM, JRE, JDK


●​ Object-Oriented Programming
○​ Class, Object
○​ Inheritance
○​ Polymorphism
○​ Encapsulation
○​ Abstraction​

●​ Constructors
●​ Arrays & Collections
●​ Control Flow (if, loops, switch)
●​ This & Super
●​ Exception Handling
●​ String & immutable Handling
●​ Access Modifiers
●​ Static vs Instance
●​ Wrapper Classes
Section 4: DSA (Java Programming)

●​ Arrays & Strings


●​ Searching & Sorting
●​ Linked List
●​ Stack & Queue
●​ Recursion

CLUSTER 2 — Python + SQL + Cloud + Web UI

Section 1: Web UI (MCQ)

Same as the Cluster 1

Section 2: ANSI SQL (MySQL)

Same as the Cluster 1

Section 3: Coding (Python Programming)

●​ Data type
●​ Operators, Input & Output
●​ Conditional Statements and Loops
●​ Functions, Lambda & Modules
●​ OOP (class, objects, inheritance, polymorphism)
●​ File Handling
●​ Modules & Libraries
●​ Exception Handling​

Section 4: Cloud (MCQ)


●​ Data Structures (lists, tuples, sets, dictionaries)
●​ Stack, queue, linked list concepts
●​ Searching & sorting basics
●​ Basic problem‑solving patterns

Section 5: Cloud (MCQ)

Cloud Fundamentals (ONLY for Cluster 2)

●​ What is Cloud?
●​ Service Models (IaaS, PaaS, SaaS)
●​ Deployment Models (Public, Private, Hybrid)
●​ Virtualization
●​ Basic Cloud Providers (AWS, Azure, GCP)
●​ Compute, Storage, Database Services
●​ Cloud benefits: scalability, reliability, cost

CLUSTER 3 — C# + SQL + Web UI (HTML/CSS/JS)


Section 1: Coding (C# Programming)

●​ Variables & Data Types


●​ Control Flow
●​ Loops
●​ Arrays & Collections
●​ String Manipulation
●​ Functions & Methods
●​ Exception Handling
●​ Object-Oriented Programming
○​ Class, Objects
○​ Inheritance
○​ Polymorphism
○​ Encapsulation
Section 2: ANSI SQL (MySQL)

➡ Same SQL syllabus as Cluster 1 & 2.​

Section 3: Web UI (MCQ)

➡ Same Web UI syllabus across all clusters

Cognizant GenC – Cluster Focus Areas


Cluster-1 Focus Areas (Java + JS + HTML/CSS + DSA)

Topic Focus Notes


(%)
HTML & 10–15% Very basic questions: structure, tags, selectors, box
CSS model, simple flexbox, media queries
JavaScript 15–20% Basics + DOM manipulation + functions + array
methods + simple coding problems
Core Java 40–45% OOP concepts, exception handling, collections, strings,
methods, static vs instance, project discussion
Java DSA 25–30% Arrays, strings, recursion, stack/queue, linked list
concepts, simple coding problems
Cluster-2 Focus Areas (Python + SQL + HTML/CSS +
Cloud + DSA)
Topic Focus Notes
(%)
HTML & CSS 5–10% Only very basic structure, tags, selectors, box model,
simple flexbox
ANSI SQL 20–25% SELECT queries, joins, group by, having, subqueries;
often simple problem statements
Python (Core 40–45% Core Python, OOP concepts, exception handling, file
+ OOP) handling, modules, built-ins
Python DSA 20–25% Lists/arrays, strings, recursion, stack/queue, linked list
basics, simple coding problems
Cloud Basics 5–10% Very basic questions: IaaS/PaaS/SaaS, deployment
models, benefits, compute/storage/networking

Key Takeaways

●​ Cluster-1: Main focus is Java + Java DSA (~65–75%), web scripting


(JS/HTML) is minimal.
●​ Cluster-2: Main focus is Python + Python DSA (~60–70%), SQL gets good
weight (~20–25%), web & cloud are minor (~10–15%).
●​ Prepare coding questions in Java for Cluster-1 and Python for Cluster-2.

You might also like