Semester VI

Advance Diploma in Software Engineering (ADSE II )

Elective I – Enterprise Development in Oracle 10g     Elective II – Network Management with Microsoft Technologies Adding to application & Database development experience, Oracle 10g is the ultimate millstone for those, wanting to build a stable career in Buisness & Enterprise Application development and builds on your existing skillset and covers almost all the areas such as database management, database programming and database programming using SQLJ. The syllabus equips the participants with adequate knowledge of Networking modules viz. Networking Essentials, Microsoft TCP/IP, Firewall and Security Concepts, Implementing and Administering Microsoft Windows, Implementing and Administering Windows Server 2003, Microsoft Windows Server 2003 Network Infrastructure – Implementation, Management and Maintenance and much more.     Student will learn the following modules in this semester Student will learn the following modules in this semester       TOPIC Hrs Introduction to Oracle 10g: SQL and PL/SQL 68 Building web-based applications using Oracle10g Forms 60 SQLJ Programming 28 eProject (Oracle 10g) 40   Total Hrs. 196   TOPIC Hrs Networking Essentials 12 Microsoft TCP/IP 14 Firewall and security Concepts 10 Implementing and Administering Microsoft Windows 2000 Professional 32 Implementing and Administering Microsoft Windows Server 2003 32 Microsoft Windows Server 2003 Network Infrastructure Implementation, Management and Maintenance 24 Microsoft Windows Server 2003 Network Infrastructure Planning and Maintenance 24 Microsoft Windows Server 2003 Directory Services Infrastructure Planning, Implementation, and Maintenance 32 Microsoft Windows Server 2003 Directory Services Infrastructure Design 24 Microsoft Windows Server 2003 Network Security Design 34   Total Hrs. 238

Learning Outcomes :   Learning Outcomes :     Writing basic SQL SELECT statements Advance SQL Operations Creating and managing tables Controlling user access Use PL/SQL block structures, variables, datatypes, expressions, operators, and statements Write Object-oriented PL/SQL applications Deploy subprograms, procedures, functions, packages, and triggers Use Oracle’s object technology in the form Debug a form using the message built-in and Forms Builder’s Debug Console Develop SQLJ programs, applets, stored procedures, and database triggers Build object-oriented applications to access SQL databases on any Java-compatible platform Manage multiple database connections with SQLJ Convert Java streams to SQLJ Streams to communicate with the Oracle database.                                           Identify Network Hardware and connectivity devices Explain the features of various Network protocols and OSI model Explain TCP/IP architecture, IP Addressing and subnetting, TCP/IP utilities and troubleshooting methods Describe Firewall configuration, Firewall Policies and products Explore the features of Windows 2000 Professional Install Windows 2003 Server using Setup Manager Explain Active Directory Services Work with NTFS and shared folder permissions Implement and Configure DNS, DHCP, WINS, Certificate services, TCP/IP, IPSec, Routing and Remote Access, NAT, IAS on Windows 2000 Server Explore, implement and configure Active Directory Services Design Network Infrastructure, Internet connectivity, connectivity for internal networks and integrated Network Services framework Design strategies for Active Directory Naming, Administrative authority delegation and Group Policy implementation Design Security Policy, Audit Policy, Security Group Strategy, Security Policy inheritance and Authentication strategy.           Exit Profile :     Enterprise Oracle Developer           Exit Profile :     Network Engineer Track leads to MCTIP or MCSE