IBPS Specialist Officer Study Material Pdf - 2017-2018 StudyChaCha

Go Back   2017-2018 StudyChaCha > StudyChaCha Discussion Forum > General Topics




  #1  
Old November 13th, 2017, 05:22 PM
Unregistered
Guest
 
Posts: n/a
Default IBPS Specialist Officer Study Material Pdf

My brother has completed MCA Degree and he has applied for IBPS Specialist Officer Examination for IT Officer Post. He wants study material to start preparation. So is there anybody who will provide study material for IBPS Specialist Officer Exam for IT Officer Post?
Reply With Quote
  #2  
Old November 14th, 2017, 10:52 AM
Educhamp's Avatar
Super Moderator
 
Join Date: May 2011
Location: Delhi
Posts: 33,119
Default Re: IBPS Specialist Officer Study Material Pdf

As you want study material for IBPS Specialist Officer Examination for IT Officer Post, so here I am providing syllabus of this Exam as study material:

IBPS Specialist Officer Exam Syllabus for IT Officer:

Reasoning Ability:

Seating Arrangement
Inequality
Input - Output
Verbal Reasoning
Data Sufficiency
Order and Ranking
Distance and Direction
Syllogism
Puzzles
Alphanumeric series
Blood Relations

English Language:
Reading Comprehension
Sentence Improvement/ Correction
Para Jumbles
Para / Sentence Completion
Spotting Errors
Fill in the blanks
Cloze Test

Quantitative Aptitude:
Data Interpretation
Data Sufficiency
Quadratic Equations
Simplification / Approximation
Number Series
Mensuration
Miscellaneous Topics ( Average, Profit & Loss, Simple and Compound Interest, Time & Work, Time & Distance, Partnership, Ratio & Proportion, Problem on Ages, Probability etc.

General Awareness:
Sports
Culture
International Economy
Geography
Indian Constitution
Budget & Five Years Plans
Marketing
Financial News
Science & Technology
Memorandum of Understanding
Appointments & Companies Mergers
History
General Politics
Scientific Research
Countries and Capitals
Indian Economy
Awards & Honors Sports
Bills – New & Amendments
Agriculture
UNO

IT Officer Syllabus:
Database Management System
Data Communication and Networking
Operating System
Software Engineering
Data Structure
Computer organization and microprocessor
Object Oriented Programming

Database Management System
File Based Data Management – Disadvantages of file system
Database systems – Need for Database, Advantages of using a database
Characteristics of data in a database – Functions of DBMS, Components of a database, Comparison between Database and file-processing systems
Data dictionary – Data abstraction, Data independence – Logical and Physical data independence
Architecture: Overall Architecture of DBMS
Three level architecture – Hierarchical, Networking, Relational Data Models (E-R Model, E-R Diagrams, EER Model), Advantages and Disadvantages of each model.
Advanced Concepts: Introduction to Data warehousing and Data mining – Different types
Client/Server Technology: Client – Server – Distributed and Co-operative processing – Peer- to – Peer processing – Application components – Transaction management.
Relational Structure – Characteristics of Relational Database Model – CODD’s rules – Tables (Relations), Rows (Tuples), Domains, Attributes, Extension, Intention.
Keys: Candidate Key, Primary Key, Foreign Key, Super Keys, Unique Keys.
Data Constraints: Referential Integrity Constraints, Entity Integrity Constraints, Constraints like Primary key constraint, Unique, Check constraint strong Entity, Weak Entity.
Normalization: Introduction – Purpose of Normalization – Definition of Functional Dependence (FD) Relational database Design, – Normal forms: 1NF, 2NF, 3NF, BCNF, 4Nf and 5 NF.
Database Administration: DBA Tasks – DBA Tools – User Privileges – Performance monitoring and tuning – Query tracing – Backup and Recovery
Introduction to SQL: Advantages of SQL – Invoking SQL*PLUS, The Oracle Data-types, Data Definition Language (DDL), Data Manipulation language (DML), Data Control Language (DCL), Data Query Language ( DQL) and all related commands.
Queries using Group by and Order by clause & Join: Querying a Single Table, Ordering results, grouping the results, Joins, Types of Joins, Sub queries.
Operators: Logical, Value, Syntax and Query expression operators – Set operators.
Functions: Character, Arithmetic, Date and time, Group and Miscellaneous Functions, Commit, Rollback, Savepoint.
Format models: Character, Numeric & Date Format models.
Views: Introduction – Advantages of views – The Create View Command, Updating Views, Views and Joins, Views and Sub queries – Dropping Views.
Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.
Indexes: Index Types, Creating of an Index: Simple Unique and Composite Index, Dropping Indexes.
Snapshots: Creating a Snapshot, Altering Snapshot, Dropping a Snapshot.
Introduction to PL/SQL: The PL/SQL Syntax, The PL/SQL Block Structure, Fundamentals of PL/SQL, Advantages of PL/SQL data Types.
Control Structure: Conditional Control, Iterative Control, Sequential Control.
Exception handling: Predefined Exception – User defined Exception.
Cursors: Implicit and Explicit Cursors
Procedures: Advantages – Creating – Executing and Deleting a Stored Procedure.
Functions: Advantages – Creating – Executing and Deleting a Function.
Database Triggers: Use of Database Triggers – How to apply database Triggers – Types of Triggers – Syntax for Creating Trigger – Deleting Trigger.

Download complete syllabus here……………
__________________
Answered By StudyChaCha Member
Reply With Quote
Sponsored Links






















Other Discussions related to this topic
Thread
IBPS Specialist Officer Vacancy
IBPS Specialist Officer Fees
Age Criteria for IBPS Specialist Officer
IBPS Specialist Officer HR
IBPS Specialist Officer Cut Off
About IBPS Specialist Officer
IBPS Specialist Officer Syllabus For Agriculture Field Officer
Difference between IBPS PO and IBPS Specialist Officer
IBPS Specialist Officer QA
IBPS Specialist Officer Study Material For IT Officer Scale 1
Free Download Study Material for IBPS Specialist Officer
IBPS Specialist Officer III Cut Off
IBPS Specialist Officer Syllabus for EEE
IBPS SBI Specialist Officer
IBPS Specialist Officer IT Officer Syllabus
Reasoning For IBPS Specialist Officer
IBPS Specialist Officer Free Study Material
IBPS Specialist Officer Syllabus For It Officer Scale 1 PDF
IBPS Technical Officer Study Material
SBI Specialist Officer Study Material






Have a Facebook Account? Ask your Question Here



Reply


Forum Jump


All times are GMT +6.5. The time now is 04:00 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0 PL2

1 2 3 4 5 6 7 8 9