Essentials of Information Technology

Below is the syllabus for Essentials of Information Technology:-

Unit I:

Problem-Solving Techniques: Introduction to problem-solving, Computational problem and its classification – Logic and its types, Introduction to algorithms and flowchart, Searching algorithms: linear search, binary search, and sorting algorithms: insertion, quick, merge and selection sort, Introduction, and classification to Data Structures, Basic Data Structures: array, stack, and queue.

Unit II:

Programming Basics: Identifiers, variables, data types, operators, control structures, type conversion, casting, arrays, strings

Object-Oriented Concepts fundamentals: class & object, instance variables & methods, access specifiers, reference variables, parameter passing techniques, constructors, this reference, static, and command-line arguments

Introduction to UML: Use case diagrams – Class diagrams

Unit III:

Relationships: aggregation, association, Inheritance, types of inheritance, Static Polymorphism: method overloading, constructor overloading, Dynamic polymorphism: method overriding, abstract, interface, introduction to packages Industry Coding Standards and Best Practices, code tuning & optimization, clean code & refactoring

Focus Area 2: Relational Database Management System

Unit IV:

RDBMS- data processing, the database technology, data models, ER modeling concept, notations, converting ER diagram into a relational schema, Logical database design, normalization (1NF, 2NF, and 3NF)

SQL: DDL statements, DML statements, DCL statements, Joins, Subqueries, Views, Database design Issues, SQL fine-tuning

Books on Java

Java™: The Complete Reference, Seventh Edition. Herbert Schildt
Programming with Java 3e A Primer by E Balagurusamy
Introduction to Java Programming by K. Somasundaram, Jaico Publishing House; 1 edition

Books on RDBMS, Oracle, MYSQL

Fundamentals of Database Systems, with E-book (3rd Edition) by Shamkant B. Navathe, Ramez Elmasri, Published January 15th, 2002 by Addison Wesley Longman
MySQL by Paul DuBoisNew Riders Publishing
Murach’s MySQL Paperback – 2012, by Joel Murach , Publisher: Shroff/Murach (2012)
SQL: The Complete Reference by James R. Groff, Paul N. Weinberg, Published March 1999 by McGraw-Hill Companies
Schaum’s Outline of Fundamentals of Relational Databases by Ramon Mata-Toledo, Published November 15th, 2000 by McGraw-Hill

Below is the link to download Essentials of Information Technology notes.