SBI SO SYLLABUS

SBI SO SYLLABUS 2019 latest important updates with clear and detailed SBI SO SYLLABUS information are provided here, Candidates can check all essential details of SBI SO SYLLABUS 2019 instantly here and Through this SBI SO SYLLABUS schedule, candidates can make the strategy for the Preparation of exam. Direct Official Link for each recent Updates on SBI SO SYLLABUS is Provided in this Page. Find recent news of SBI SO SYLLABUS 2019 verified on 19 August 2019.
Last Updated: September 27,2017 11:55 AM
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.

Take your Free Mock Test

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.

Interview schedule related Articles

Result related Articles

IIM RANCHI RESULT AIIMS RESULT ICMR RESULT NHB ASSISTANT MANAGER RESULT NABARD RESULT ESIC RESULT FCI RESULT BPSC RESULT DELHI UNIVERSITY RESULT UPSC Result CSIR UGC NET RESULT JMI RESULT UPSSSC RESULT RRB JE RESULT MAHAGENCO RESULT MIZORAM PSC RESULT UNION BANK SO RESULT JSSC RESULT NF RAILWAY RESULT SBI SPECIALIST CADRE OFFICER SCO FINAL RESULT OSSC RESULT HSSC STENOGRAPHER RESULT SBI SO RESULT CALCUTTA HIGH COURT RESULT IHBT RESULT MPSC FOREST SERVICE RESULT IRCON RESULT IDBI ASSISTANT MANAGER RESULT NLC RESULT HARYANA POST GDS RESULT IDBI EXECUTIVE EXAM RESULT IIT GUWAHATI RESULT NIT RESULT TAMILNADU POSTAL CIRCLE GDS RESULT TAMILNADU POSTAL CIRCLE GDS RESULT ODISHA POSTAL GDS RESULT NORTH EASTERN POSTAL GDS RESULT RAJASTHAN GDS RESULT HINDUSTAN COPPER TRADE APPRENTICE RESULT HINDUSTAN COPPER LIMITED RESULT MIZORAM UNIVERSITY RESULT NHM UP RESULT MAHARASHTRA FOREST GUARD RESULT MAZAGON DOCK LIMITED RESULT KUK CLERK RESULT MALABAR CANCER CENTER RESULT RSMSSB RESULT ONGC NON EXECUTIVE RESULT ICFRE RESULT OMC RESULT RVUNL TECHNICAL HELPER RESULT RIMS RANCHI RESULT RAILWAY ICF TRADE APPRENTICE RESULT IIFT RESULT MPPGCL RESULT MEGHALAYA HIGH COURT RESULT LIC ADO RESULT RSMSSB LAB ASSISTANT RESULT EESL RESULT HAL RESULT JPSC CIVIL JUDGE PRELIMS RESULT NATA RESULT IBPS RRB RESULT LIC AAO RESULT MAIDS JUNIOR RESIDENT RESULT RSMSSB AGRICULTURE SUPERVISOR RESULT CBSE UGC NET RESULT HSSC FIRE STATION OFFICER RESULT DBSKKV RESULT RRB NTPC ADMIT CARD UP BTC DELED RESULT NATIONAL INSTITUTE OF PATHOLOGY RESULT IIT DHARWAD EXECUTIVE TECHNICAL ASSISTANT RESULT SPSC STAFF NURSE RESULT IIT PATNA RESULT REPCO BANK RESULT MP HIGH COURT CIVIL JUDGE MAINS EXAM RESULT MPSC RESULT FOR SALE TAX INSPECTOR NTA ICAR RESULT FOR AIEEA AICEA CBSE 10TH RESULT SBI Clerk Result ECIL RESULT AAI RESULT NVS RESULT OJEE RESULT NEET RESULT RRB RESULT CTET RESULT JEE MAIN RESULT RAJASTHAN BOARD RBSE 10TH 12TH CBSE CLASS 12TH RESULT NAGALAND BOARD NBSE CLASS 10TH 12TH RESULT NATIONAL PROJECT IMPLEMENTATION UNIT BSTC RESULT PSEB 12TH RESULT PUNJAB SCHOOL EDUCATION BOARD RBSE 12TH RESULT RAJASTHAN BOARD 12TH RESULT JAC JHARKHAND BOARD 10TH 12TH RESULT HBSE HARYANA BOARD 12TH RESULT MH CET RESULT RRB ALP RESULT DAVV RESULT BSEB 12TH RESULT BIHAR BOARD 12TH RESULT CLASS 12TH RESULT MP BOARD RESULT AKTU Result (UPSEE Results) UP BOARD RESULT IBPS CLERK RESULT IBPS SO RESULT IBPS PO RESULT TRB PG RESULTS WBJEE RESULT VMOU RESULT SSC CGL RESULT SSC CHSL RESULT SBI PO Result RBI GRADE B RESULT RBI ASSISTANT RESULT NDA RESULT KVPY RESULT KEAM RESULT JIPMER RESULT COMEDK UGET RESULT CLAT RESULT CSJM RESULT BSNL RESULT BSEB BIHAR BOARD CLASS 10TH RESULT BCECE RESULT AP POLYCET RESULTS AIBE RESULT JEE ADVANCED RESULT IGNOU RESULT DSSSB RESULT GATE RESULT TAMIL NADU BOARD CLASS 10TH 12TH RESULT TAMILNADU MBBS RANK LIST

Admit Card related Articles

ASSAM POLICE Admit Card BRLPS Admit Card DSSSB Admit Card VMC Admit Card TNPSC GROUP 4 Admit Card HSSPP Admit Card TASMAC JUNIOR ASSISTANT Admit Card BIHAR NHM CHO Admit Card RCF ENGINEER Admit Card IOCL Admit Card OPSC Admit Card BPSC Admit Card WBPSC ICDS SUPERVISOR Admit Card BIHAR POLICE Admit Card EPFO Admit Card ARUNACHAL PRADESH POLICE Admit Card NIELIT Admit Card MPIDC Admit Card RPSC Admit Card PASHUSAVARDHAN VIBHAG Admit Card CG VIDHAN SABHA Admit Card NLC Admit Card JKSSB Admit Card OTET Admit Card MARKFED PUNJAB Admit Card CWC VARIOUS POST DV Admit Card ALLAHABAD HIGH COURT Admit Card UPSC Admit Card TN POLICE Admit Card PPSC SENIOR ASSISTANT Admit Card IDBI Admit Card SBI CLERK Admit Card APPSC HALL TICKET Admit Card IBPS RRB Admit Card KARNATAKA BANK Admit Card MSRTC Admit Card UPPRPS SUB INSPECTOR ASI CLERK ACCOUNTS Admit Card SSA CHANDIGARH TGT Admit Card KURUKSHETRA UNIV CLERK Admit Card INDIAN ARMY WOMEN SOLDIER GD Admit Card WEST BENGAL POLICE Admit Card INDIAN ARMY TERRITORIAL ARMY OFFICER Admit Card APPSC FOOD SAFETY OFFICER HALL TICKET Admit Card APPSC HALL TICKET Admit Card AIIMS Admit Card SSC MTS Admit Card NIMHANS Admit Card RRB PARAMEDICAL Admit Card NABARD Admit Card RRB Admit Card SSC CHSL Admit Card CTET ADMIT CARD IBPS CLERK Admit Card SSC CGL Admit Card CBSE UGC NET Admit Card IGNOU Admit Card IGNOU HALL TICKET Admit Card JIPMER Admit Card SBI PO Admit Card TNPSC GROUP 2A Admit Card NDA Admit Card JEE MAIN Admit Card RRB Group D Admit Card IBPS SO Admit Card GATE Admit Card RBI ASSISTANT Admit Card KVPY Admit Card IBPS PO Admit Card RBI GRADE B Admit Card WBJEE Admit Card BSTC Admit Card ORDNANCE FACTORY Admit Card IES Admit Card CSIR UGC NET Admit Card SBI SO Admit Card BCECE Admit Card BSNL Admit Card JEE ADVANCED Admit Card

Exam related Articles

SOUTH INDIAN BANK EXAMS TN TRB EXAM DATE AP GRAMA WARD SACHIVALAYAM EXAM DATE RRB JE EXAM DATE UP POLICE EXAM ICAI CA CPT EXAM SIKKIM PSC EXAM DATE SSC GD CONSTABLE GATE RSMSSB EXAM RRB NTPC EXAM DATE RPSC EXAM DATE OPSC EXAM DATE MP VYAPAM BSF EXAM DATE OPSC ASSISTANT DIRECTOR RESEARCH EXAM DATE SBI PO HTET RRB NTPC RAILWAY EXAM BSF NAINITAL BANK CLERK EXAM DATE MPPSC Exam SBI SO JKPSC EXAM SSC MTS EXAM CSBC BIHAR POLICE EXAM CBSE 10TH BHU Exam DRDO CEPTAM CLAT Exam BANK OF BARODA SPECIALIST OFFICER SO ICSE ISC EXAM IBPS PO CBSE 12TH AP EAMCET ITPB Exam LIC AAO KEAM BITSAT NEET SBI CLERK AFCAT Exam VITEEE CTET UPSC TS EDCET HNGU HSSC HARYANA SSC EXAM WBSCVT EXAM INDIAN NAVY EXAM IBPS CLERK SSC CGL KVS Exam IBPS UPSC CMS COMBINED MEDICAL SERVICE EXAM RBI GRADE B CAT Exam JEECUP UP POLYTECHNIC UPTET WBSSC WEST BENGAL SCHOOL SERVICE COMMISSION WBJEE KTET Exam DTE MAHARASHTRA KVPY IBPS SO JEE MAIN ICMAI Exam BCECE OJEE ASRB EXAM COMEDK UGET AP POLYCET IES EXAM CSIR UGC NET RAJASTHAN POLICE EXAM MAHARASHTRA CET DU ADMISSION AIBE Exam SSC CHSL AWES APS CSB EXAM JEE ADVANCED IBPS RRB NVS EXAM CBSE UGC NET NRHM EXAM TS EAMCET TSPSC AEE Exam MAT Exam TOEFL XAT EXAM APTET VMOU Exam SYNDICATE BANK EXAMS RAJASTHAN PTET DMRC EXAM BSER REET EXAM DELHI TIS HAZARI COURT EXAM POWERGRIDINDIA PGCIL EXAMS JIPMER SET Exam RBI ASSISTANT TNPSC GROUP 4 EXAM HPTU Exam GSECL Exam AIIMS Exam AMIE KPCL UPCATET NDA EXAM TNEA Exam AP ICET MAT EXAM MANAGEMENT APTITUDE TEST NIFT Exam PUNJAB BOARD PSEB 10TH 12TH TNHB EXAM MCGM BMC EXAM

Important Dates related Articles

Answer key related Articles

Application Form related Articles

Syllabus related Articles

General related Articles

Cut off related Articles

Sample Papers related Articles

Exam Pattern related Articles

Counselling related Articles















FreshersLive - No.1 Job site in India. Here you can find latest 2019 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.

Current Affairs 2019 Yearly PDF @ Rs.499 Only
BUY NOW
RRB Mock Test Series @ Rs.49 Only || 1,000+ Questions
Buy Now