Pre-Onboarding Learning - Java
Student Handbook
Program Overview
Full Stack Prep-up
Learning Guide
To equip pre-onboarding candidates with foundational skills in Java programming, SQL with MySQL enabling them
to build simple applications, understand backend data operations.
Java Track
Learning Reference Details
• Reference 1: Programming Fundamentals using Java
• Reference 2: Database Programming with SQL
Program Highlights
• Learn thru Cognizant Skill spring platform
• Practice with online code editors and tools
Program Highlights
Program Highlights
Program Highlights
Program Highlights
Program Highlights
Program
1 Highlights
Reference 1 – Programming Fundamentals using Java
Objective
To introduce learners to the foundational concepts of programming using Java, focusing on problem-
solving, logical thinking, and object-oriented principles. This course prepares learners to write, debug,
and understand basic Java programs and sets the stage for full-stack development.
Key Learning Outcomes
By the end of this course, learners will be able to:
• Understand the structure and syntax of Java programs.
• Apply control structures and loops to solve problems.
• Use object-oriented programming concepts such as classes, objects, inheritance, and
polymorphism.
• Handle exceptions and perform basic file operations.
• Utilize collections for data management.
Topics Covered
• Introduction to Java and the JVM
• Variables, Data Types, and Operators
• Control Flow: Conditional Statements and Loops
• Object-Oriented Programming (OOP)
• Exception Handling
• Collections Framework
• File I/O and Streams
Open-Source Learning References
Courses Reference Links Source
Core Java Java Programming for [Link]
Beginners – Full Course
Tools & Resources
• Online IDEs: Online Java IDE, Programiz Java Compiler
• Learning Platforms: Javatpoint, GUVI, Oracle Java Tutorials
• Quiz Platforms: GitHub Java Quiz Apps, Savsoft Quiz
2
Reference 2 - Database Programming with SQL
Objective
To introduce learners to the fundamentals of relational databases and SQL programming. This course
focuses on data modeling, query writing, and data manipulation using ANSI SQL with MySQL,
enabling learners to interact with databases effectively and securely.
Key Learning Outcomes
By the end of this course, learners will be able to:
• Understand relational database concepts and schema design.
• Write SQL queries to retrieve, filter, and sort data.
• Perform data manipulation operations (INSERT, UPDATE, DELETE).
• Use joins to combine data across multiple tables.
• Apply aggregate functions and group data meaningfully.
• Work with basic transactions and constraints.
Topics Covered
• Introduction to Databases and RDBMS
• SQL Syntax and Query Structure
• SELECT, WHERE, ORDER BY, GROUP BY
• Joins: INNER, LEFT, RIGHT, FULL
• INSERT, UPDATE, DELETE Operations
• Aggregate Functions: COUNT, SUM, AVG
• Transactions and Constraints
Open-Source Learning References
Courses Reference Links Source
RDBMS Relational DBMS Course – [Link]
Database Concepts, Design &
Querying Tutorial
SQL SQL For Web Developers - [Link]
Complete Database Course
Tools & Resources
• Online IDEs: SQLSandboxes, SQL Practice Online, SQL Playground
• Learning Platforms: SQLBolt, W3Schools SQL, Khan Academy SQL
• Quiz Platforms: Flask Quiz App, OnlineExamMaker
3
FAQs
1. Where can I practice Java coding?
You can use free online IDEs such as:
• Online Java IDE
• Programiz Java Compiler
2. Are there quizzes to test my Java knowledge?
Yes! You’ll find links to open-source quiz platforms and GitHub-based quiz apps to test your
understanding of Java, SQL, and Web UI concepts.