|
|
The Objective of the course is to provide hands on experience to students in using computers for data organization and addressing business needs. There is also stress on use of statistical package for analysis of business data and its proper interpretation using SPSS. The exposure to PROWESS of Centre for Monitoring Indian Economy is with a view to make students aware of data bases of Indian Companies and enable them to work on mini projects and think of topic for their final year project.
Experiments covering Basics of SQL, DBMS, RDBMS,ORACLE, SQL statements, functions, Views, Joins, Constraints, operators(standard/set operators)synonyms/sequences, index, snapshots, PL/SQL components, PL?SQL block structures, PL/ SQL attributes, cursors, Procedure, Functions, Exception Packages, triggers etc.
Hands on experience with Prowess of CMIE and a few simple exercises on ratio analysis using the package.
Hands on experience with SPSS package and a few simple exercises on statistical analysis.
References
Introduction to Computers
• Morley, Understanding Computers, 10/e Thomson, 2007.
• Norton, Introduction to computers, 6/e, Tata McGraw-Hill , 2007
• Deepak Bharioke, Fundamentals of Information Technology, 3/e, 2005
• V.Rajaraman, Introduction to Information Technology, PHI.
• Efraim Turban, R. Kelly Rainer, Jr., Richard E. Potter, Introduction to Information Technology, Second Edition, Wiley India, 2006.
MS-Office
• Greg Perry, Microsoft Office 2007, Sam Teach your self, Pearson Education, 2007.
• Mansfield, MS Office, Reprint 2006, Tata McGraw-Hill , 2006.
• Microsoft Office System step by step, 2003 edition, PHI, 2004
• Vikas Guptha, Comdex Computer Course Kit, Office 2007, Dreamtech Press, Wiley-India, 2007
SQL, PL/SQL
Groff, SQL 2/e, the Complete Reference, Tata McGraw-Hill , 2007.
P.S. Despande, SQL/PLSQL for Oracle 9i, Dreamtech Press, India, 2007.
Urman, Hardman, McLaughlin, PL/SQL Programming, Oracle Press, Tata McGraw-Hill , 2004
Rosenzweig, Oracle PL/SQL by example, 3/e, Pearson Education, 2004
|
No responses found. Be the first to respond and make money from revenue sharing program.
|