SBI SO SYLLABUS 2017 recent information SBI updated November 18, 2017

SBI SO Syllabus 2017 for Specialist Officers Cadre. SBI SO SYLLABUS 2017 find all essential information and latest updates on SBI SO SYLLABUS 2017 which are verified and updated here on November 18, 2017 all details on recent event of SBI SO SYLLABUS 2017 is updated here up-to this minute and be the first person to discover SBI SO SYLLABUS 2017 and make use of the ample official links provided in SBI SO SYLLABUS page.

Last modified:18-11-2017

Know all about SBI SO Syllabus here. Grasp new updates of SBI SO Syllabus.SBI SO Syllabus is important for interview preparation.Here Subject wise as well as Topic wise SBI SO Syllabus is provided in this article.

SBI SO Syllabus

Here detailed SBI SO Syllabus is prescribed here for the candidate's verification. The selection process mainly consists of interview and the candidates should have technical knowledge with the required experience from the Bank.The main topics are provided below 
 

SBI SO Syllabus for Database Management System

The Important and maximum number of Questions are asked in the particular topic.The subtopics are provided below

Unit 1 -Basic Database concepts:

  • 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 are 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

  • Data Models: 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 Cooperative Processing
  • Peer- to – Peer processing, Application components, Transaction management.

Unit 2 - Relational Database Model

  • 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 a Primary key constraint, Unique, Check constraint strong Entity, Weak Entity.
  • Normalisation: Introduction – Purpose of Normalisation
  • Definition of Functional Dependency (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.

Unit 3 - 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, Subqueries.
  • 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.

Unit 4 - Advantages of views

  • Views: Introduction – Advantages of views – The Create View Command, Updating Views, Views, and Joins, Views and Subqueries – Dropping Views.
  • Sequences: Creating Sequences, Altering Sequences, Dropping Sequences.
  • Index Types, Creating 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.

Unit 5 - Exceptional Handling

  • 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.

 

SBI SO Syllabus for Data communication and Networking

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • Data Communication: Components of a data communication  
  • Data flow simplex – half duplex – full duplex; Networks – Definition – Network criteria –
  • Types of Connections: Point to point-multipoint; Topologies: Star, Bus, Ring, Mesh, Hybrid – Advantages and Disadvantages of each topology.
  • Types of Networks: LAN – MAN – WAN – CAN – HAN – Internet – Intranet –Extranet, Client-Server, Peer To Peer Networks.
  • Transmission Media: Classification of transmission media – Guided – Twisted Pair, Coaxial, Fibre optics; Unguided – Radio waves – Infrared – LOS – VSAT – cabling and standards.
  • Network devices: Features and concepts of Switches – Routers (Wired and Wireless) – Gateways.
  • Network Models: Protocol definition – standards – OSI Model – layered architecture – functions of all layers.
  • Data Link Layer: Framing & its methods, Flow Control, Error control. DLL Protocol, Piggybacking & Pipelining. MAC Sublayer, Media access control for LAN & WAN, collision, IEEE 802 standards for LAN & MAN & their comparison. Ethernet, Wireless LANs, Broadband Wireless, Bluetooth.
  • Network Layer: Routeing, Congestion Control Algorithms, IP protocol, IP Addresses, Comparative study of IPv4 & IPv6, Mobile IP.
  • Transmission Control Protocol (TCP) – User Datagram Protocol, Data Traffic, Congestion Control and Quality of Service.
  • Network Security: Cryptography, Message Security, Digital Signature, User Authentication, Key Management, Security Protocols Internet, DNS, SMTP, FTP, HTTP, WWW, Virtual Terminal Protocol.

SBI SO Syllabus for Operating System

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • Introduction to System Programs & Operating Systems, Buffering & Spooling, Types of Operating System.
  • File concepts, access methods, free space managements, allocation methods, directory systems, protection, organization, real time sharing & implementation issues.
  • Process: Concept, Process Control Blocks (PCB), Scheduling criteria Preemptive & Non-Preemptive process scheduling, Scheduling algorithms, algorithm evaluation, multiple processors real-time scheduling, threads, critical section problem, semaphores, and classical problems of synchronization.
  • Memory Hierarchy, logical and physical address space, swapping, contiguous and non-contiguous allocation, paging, segmentation, Concepts of virtual memory, Cache Memory Organization, demand paging, page replacement algorithms, allocation of frames, thrashing, demand segmentation.
  • Distributed operating system:-Types, Design issues, File system, Remote file access, RPC, RMI, Distributed Shared Memory(DSM), Basic Concept of Parallel Processing & Concurrent Programming.
  • Security & threats protection: Security violation through Parameter, Computer Worms & Virus, Security Design Principle, Authentications, Protection Mechanisms.

SBI SO Syllabus for Software Engineering

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • The Software Product and Software Process Models, Software Process customization and improvement.
  • Requirement Elicitation, Analysis, and Specification Functional and Non-functional Requirements, Validation, Traceability.
  • Software Design, Architectural Design, User Interface Design, Function-oriented Design, SA/SD Component Based Design, Design Metrics.
  • Software Analysis and Testing, Software Test Process, Testing Levels, Test Criteria, Test Case Design, Test Oracles, Test Techniques, Black-Box Testing.
  • Software Maintenance & Software Project Measurement: Software Configuration Management (SCM), Re-engineering, Reverse Engineering. Project Management Concepts, Feasibility Analysis, Project and Process Planning, Resources Project Scheduling and Tracking,

SBI SO Syllabus for Compiler Design

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • Introduction to Compiler, Phases and passes, Bootstrapping, Implementation of lexical analyzers, LEX: lexical analyzer generator, Input buffering, Recognition of tokens, Error handling.
  • Basic Parsing Techniques: Parsers, Shift-reduce parsing, operator precedence parsing, top-down parsing, predictive parsers, LR parsers, an automatic parser generator
  • Syntax directed definitions, L-attributed definitions, Syntax directed Translators, Intermediate code.
  • Symbol Tables, Run-Time Administration, simple stack allocation scheme, storage allocation in a block structured language, Code Optimization and Code Generation.
  • Parsing control statements, syntax diagrams, Error Recovery, Interpreting control statements, parsing programs, procedures and Functions.

SBI SO Syllabus for Data Structure 

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • Basic Terminology, Data types, and its classification, Array Definition, Representation and Analysis of Arrays, Single and Multidimensional Arrays.
  • Stack, Array Implementation of the stack, Linked Representation of Stack, Queue, Array and linked implementation of queues, Circular queues, D-queues and Priority Queues. Linked list, Generalised linked list
  • Basic terminology, Binary Trees, Complete Binary Tree, Extended Binary Trees, Array and Linked Representation of Binary trees.
  • Internal and External sorting, Insertion Sort, Bubble Sort, Selection Sort Quick Sort, Merge Sort, Heap Sort, Radix sort, Searching & Hashing: Sequential search, binary search, Hash Table, Hash Functions.
  • Introduction, Sequential Representations of Graphs, Adjacency Matrices, Traversal, Connected Component and Spanning Trees, Minimum Cost Spanning Trees.

SBI SO Syllabus for Computer Organisation and Microprocessor

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • Computer System: Basic Computer Operation, Machine Instructions, Addressing Modes, DLX Architecture.
  • Computer Configuration, Memory, Organization, Memory Architecture, and Interface, DMA, Synchronization.
  • Microprocessor As A CPU– types of Microprocessor, Microcomputers, Computer Languages, Flags, Program Counter(PC), Stack Pointer, OP Code Format.

SBI SO Syllabus for object oriented Programming (OOPS)

The Important and maximum number of Questions are asked on the particular topic.The subtopics are provided below.

  • General concept OOPS– Object, Classes, Data Abstraction, Encapsulation, Inheritance, Polymorphism, Methods and Messages, Dynamic Binding.
  • Features, Advantages, and Applications of OOPS.
  • Aggregation and Association, Generalization, Multiple Inheritance.
Exam NameRelated Articles

SBI CLERK RESULT

Click Here

SBI PO

Click Here

SBI PO ADMIT CARD

Click Here

SBI CLERK

Click Here

SBI PO SYLLABUS

Click Here

SBI PO EXAM DATE

Click Here

SBI PO RESULT

Click Here

SBI CLERK SYLLABUS

Click Here

SBI CLERK ADMIT CARD

Click Here

SBI CLERK CUT OFF

Click Here

SBI CLERK EXAM DATE

Click Here

SBI PO CUT OFF

Click Here

SBI SO

Click Here

SBI SO ADMIT CARD

Click Here

SBI SO RESULT

Click Here

SBI Recruitment

Click here

Free Job Alert to your Email

सरकारी नौकरी अब हिंदी में



FreshersLive - No.1 Job site in India. Here you can find latest 2017 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.