My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
Advertisements
|
Bsc(it) 5th semester Syllabus Punjab technical university
Posted Date: 17 Dec 2007 Resource Type: Articles/Knowledge Sharing Category: Syllabus
|
Posted By: pankaj rana Member Level: Bronze
Rating:  Points: 1
|
|
|
SEMESTER : 5
BSI-501 WEB TECHNOLOGIES-II
Getting Started with Active Server Pages :- What are Active Server Pages ? (Understanding the Client Server Model, How ASP differs from Client-Side Scripting Technologies); Running ASP Pages (Setting Up Personal Web Server, Setting Up Internet Information Server, Using ASP without IIS or PWS); Creating You First ASP Pages.
Dissecting You First ASP Script :- Understanding ASP Scripts (What Does Response.Write Do ?, The <%=Shortcut, What’s with the <%@ LANGUAGE=VBSCRIPT%>?, Writing ASP Code Without Using <%…%>, Comments, Line Continuation Character); What You ASP Script Returned to the Browser; The ASP Process.
Working with Variables :- What is a Variable?; Data Types; Integer; Floating-Point Numbers (String, Date, Boolean, Currency, Object, What Are Variant Variables?. What Does It Mean to Declare a Variable?, Why Use Explicit Declarations in VBScript?, How Do You Name a Variable?, Constants, Arrays, How Do You Determine Your Variable’s Type?); VB Script Operators (Assignment Operators, Mathematical Operators, Subtraction, Multiplication , Division, Integer Division, Modulus, Exponentiation, Negation Concatenation, Comparison Operators, Logical Operators).
Understanding VBScript Control Structures :- What Is a Control Structures; Types of Controls (Conditional Logic, Looping Logic, Branching Logic); Control Structure Examples (Conditional Logic Controls, Looping Logic Controls, Branching Logic Controls).
Using VBScript’s Built-In Functions :- Typecasting Variables (What is Typecasting and Why Should I Typecast?, How to Typecast Your Variables); Formatting Functions; Math Functions; Date Functions (Working with Date Values, Breaking Down Date Values); String Functions; Other Functions.
Working with Objects :- What are objects?; The Building Blocks of Objects (Properties, Methods, Instances of Objects); Built-in ASP Objects (Response Objects, Request Object, Application Object, Session Object, Server Object, ObjectContext Object, ASPError Object); Collections; Working with Objects; Events.
Using the Response Object :- What is the Response Object; Dissecting the Response Object (Sending HTML to the Browser, Buffering ASP Pages, Sending the User to Another Page, Cookies, Caching Your ASP Pages).
Communicating with the User :- Receiving Information from the User (What are Forms?, Creating Forms, Designing Forms, Submitting Forms, Reading Form Values from an ASP Page); Using Advanced Form Techniques (Revisiting the ACTION Property, Client-Side Form Validation); Using the Different Form Fields (Text Boxes, List Boxes, Check Boxes, Radio Buttons, Choosing your Checkboxes and Radio Buttons).
Collecting the Form Information :- Retrieving the Results of a Form (Using the Request Object); Using the Querystring to Send Information,
Working with the Request Object :- Accessing the HTTP Headers (Useful HTTP Headers, Reading the HTTP Headers with Request. ServerVariables); Accessing the Environment Variables (Useful Environment Variables, Reading the Environment Variables Using Request. ServerVariables); Using Cookies (What are Cookies?, How to Read Cookies Using the Request Object, How to Write Cookies Using the Response Object, Advantages and Disadvantages ofUsing Cookies.
Maintaining Persistent Information on the Web :- It’s a Fact: The Web Is Stateless (Ways to Maintain State); The Session Object (Using Session Variables, Pitfalls of Session Variables, Session Variables Without Cookies); The Application Object (Using Application Variables, Pitfalls of Application Variables); Initializing Application and Session Variables (Creating a Global. asa File).
Debugging You ASP scripts and Handling Errors :- Debugging Your ASP Scripts (Debugging Fatal Bugs, Debugging Nonfatal Bugs); Handling ASP Errors Gracefully (Using the Err Object, Using the ASPError Object); Handling Non-ASP Errors Gracefully.
Using Databases :- What Are Relational Databases ?(Common Relational Databases); Why Use Databases ?; Working with Databases Using ASP.
Reading from a Database Using ASP :- Databases and ASP (Communicating with a Database Using ActiveX Data Objects (ADO)); Connecting to a Database (The Connection Object, Using a System DSN, Using a DSN-less Connection, Opening the Connection, Closing the Connection, Properties of the Connection); Reading Data from a Database (The Recordset Object, Using adovbs.inc, Reading and Displaying the Contents of a Database Table).
Inserting, Updating, and Deleting Database Records :- Inserting Records (Lock Types, AddNew and Update); Updating Records; Deleting Records.
Examining the RecordSet Object :- Enhancing Information Retrieval (Using the Fields Collection); Understanding the CursorType and CursorLocation Properties; Sorting Recordsets; Filtering Recordsets (Filtering Recordsets Bases on User Input).
Using SQL Statements to Query Data :- What is SQL ? (Executing SQL Statements Using ASP and ADO); The SELECT SQL Statement (Using the WHERE Clause, Iterating Through Recordsets Generated by SQL Statements); Allowing Users to Query Data.
BSI-502 RDBMS-II
An Overview of DBMS and DB Systems Architecture : Introduction to Database Management systems; Data Models; Database System Architecture; Relational Database Management systems; Candidate Key and Primary Key in a Relation; Foreign Keys; Relational Operators; Set Operations on Relations; Attribute domains and their Implementation.
Interactive SQL : SQL commands ; Data Definition Language Commands; Data Manipulation Language Commands; The Data types a cell can hold; insertion of data into the tables; Viewing of data into the tables; Deletion operations; updating the contents of the table; modifying the structure of the table; renaming table; destroying tables; Data Constraints; Type of Data Constraint; Column Level Constraint; Table Level Constraint; Null value Concepts; The UNIQUE Constraint; The PRIMARY constraint; The FOREIGN key constraint; The CHECK Constraint; Viewing the User Constraints;
Viewing The Data : Computations on Table Data; Arithmetic Operators; Logical Operators; Comparison Operators; Range Searching; Pattern Searching; ORACLE FUNCTIONS; Number Functions; Group Functions; Scalar Functions; Data Conversion Functions; Manipulating Dates in SQL ; Character Functions;
Sub queries and Joins : Joins; Equi Joins; Non Equi Joins; Self Joins; Outer Joins; SubQueries; Correlated Queries; Using Set Operators:- Union , Intersect; Minus ;
Views and Indexes : Definition and Advantages Views; Creating and Altering Views; Using Views; Indexed Views; Partitioned views; Definition and Advantages of Indexes; Composite Index and Unique Indexes; Accessing Data With and without Indexes; Creating Indexes and Statistics.
Introduction to PL/SQL : Advantage of PL/SQL; The Generic PL/SQL Block; The Declaration Section; The Begin Section; The End Section; The Character set; Literals; PL/SQL Data types; Variables; Constants; Logical Comparison; Conditional Control in PL/SQL; Iterative Control;
Advanced PL/SQL : Types of Cursors; Implicit Cursor; Explicit Cursor; Explicit Cursor attributes; Cursor For Loop; Parameterized Cursor; Error Handling in PL/sql;Internal Exceptions; User Defined Exceptions
Database Objects : Sequences, Creating Sequences; Referencing Sequences; altering a Sequence; Dropping a Sequence, Stored Procedures and Functions:- Advantages of using a Procedure or Function; Procedure Versus Functions; Creating stored Procedures and Functions; Parameters to Procedures and Functions; Deleting a Stored Procedure or a Functions; Packages:- Components of a Package; Package Objects; Private and Public ; Package state; Package Dependency; Triggers:- Use of Database Triggers; Database Triggers V/s Procedures; Database Triggers V/S Integrity constraints; RAISE_APPLICATION_ERROR PROCEDURE; Types of Triggers:- Row Triggers, statement Triggers; Before V/S After Triggers; Deleting a Trigger;
BSI-503 COMPUTER NETWORKS
DATA COMMUNICATIONS : Multiplexing, Signaling, Encoding & Decoding, Error Detection & Recovery, Flow Control, Sliding Window, Congestion Management.
COMMUNICATION NETWORKS : Introduction to networking, OSI Model for Networking, Internet, ATM, Network Components ( Cables, Hubs, Bridges, Switches, Routers), Network Topologies, Shared Medium, Peer to Peer, Hybrid Technology.
NETWORK TECHNOLOGIES : Local Area Network Technologies, Ethernet Technologies, Ethernet Versions, Token Ring Technologies, Wide Area Network Technologies (Frame Relay, SMDS, ISDN, SONET, PPP, HDLC, LLC), Wireless Networks (Radio Frequencies, Microwave Frequencies, Infrared Waves.
MULTIPLE ACCESS : Design Issues, Distributed & Centralized Design, Circuit Mode & Packet Mode Design, Implementation Issues, Performance Considerations, Base Technology (FDMA, TDMA, CDMA, Centralized Access, Circuit Mode Access, Poling or Packet Mode Access, Reservation Based Access), Distributed Access (decentralized polling, CSMA, CSMA/CA, CSMA/CD, Busy Tone Multiple Access & Multiple Access Collision Avoidance, Token Passing, ALOHA, Slotted ALOHA, Reservation ALOHA), Hardware Addressing
SWITCHING : Circuit Switching (Time Division switching, Space division switching, time space switching, time space time switching), Packet Switching (Port Mappers, Blocking, ATM Switching, Switching Fabric (Crossbar, Broadcast, Switching Fabric Elements), Bridges (Transparent bridges, Spanning Tree Algorithm, Virtual LANS), Switches.
NAMING & ADDRESSING : Hierarchical Naming, Addressing, Telephone Networks, Internet, IPv4, Subnetting Ipv4 Networks, Private Networks, Asynchronous Transfer Mode, Name Resolution, Address Resolution Protocol (Arp), RARP
BSI-504 PRINCIPLES OF MANAGEMENT
NATURE AND FUNCTIONS OF MANAGEMENT : Importance of management; Definition of management; Management functions or the process of management; Management Process; Roles of a Manager; Levels of management; Managerial Skills; Management and administration; Management-a science or an art?; Management-a profession?; Professional management vs. family management.
DEVELOPMENT OF MANAGEMENT THOUGHT : Early Management Approaches; Modern Management Approaches.
COORDINATION : Distinction between coordination and cooperation; Need for coordination; Requisites for excellent coordination; Types of coordination; Techniques of coordination; Difficulty of coordination; Systems approach and coordination.
PLANNING : Nature of planning; Importance of Planning; Forms of Planning; Types of plans; Steps in Planning; Limitations of Planning; Making Planning Effective; Strategic Planning in Indian Industry.
DECISION-MAKING : Meaning of a Decision; Types of decisions; Steps in rational decision-making; Rationality in decision-making; Environment of decision-making; Common difficulties in decision-making.
Organisation : Meaning; Why study organization?; Process of Organising; Span of management; Principles of organizing; Departmentalisation; Organisation structure; Why type of structure is best?; Committees.
AUTHOROTY DELEGATION & DECENTRALIZATION : Sources of formal authority, difference between authority & power, uses of authority, Responsibility, Line & Staff authority, Decentralization of authority.
STAFFING : Importance and need for proper staffing; Manpower planning; Recruitment; Selection; Placement and orientation; Recruitment and selection practices in India.
DIRECTION : Requirements of effective direction, Gicing orders, Motivation, Job Satisfaction, Morale.
COMMUNICATION : Importance of Communication, Purposes of Communication, Formal Communication, Forms of Communication, Informal Communication, thecommunication process, Barriers to communication, Principles of effective communication.
LEADERSHIP : Differences between a Leader& a Manager, Characteristics of Leadership, functions of a leader, Functions of a leader, Approaches to leadership, Effective leadership, Conditions of effective leadership, Leadership assessment, Leadership style in Indian Organization.
MANAGERIAL CONTROL : Steps in a control process; Need for control; Types of control methods; Essentials of effective control systems; Problems in the control process; Control techniques.
|
Responses
|
| Author: India 17 Dec 2007 | Member Level: Diamond Points : 1 | Nice postings of Examination Syllabus. Keep it up friend. Please post related to the subject, the old papers as well as any information available related to above subject of examination concerned . Write the text books as well reference books that you know and suggest journals of any topic for the above subject and the information available on the net. And the study material useful for the preparation .Write the class notes that available on any topic if you are having any details of that subject. Suggest the students how to prepare for the subject and the topic wise your valuable suggestions, because mode of exam is something tough to get good score . so I request you as friend, help all the friends those appearing for the exams with your valuable suggestions and guide lines for external, U.P.S.C and related exams, also please post
|
|
|