Certificate Programme in IT Applications (After O/L or A/L)-Next Batch On 13th February 2012

1. Principle of Computer Architecture

• Main components of the computer system
• Memory Hierarchy
• Main Storage
• Bytes and Words
• Buses
• Cache Memory
• Secondary Storage
• Microprocessor
• Start-up Operation

2. Computer Arithmetic and Data Representation

• Data Types and Data Representation
• Number Bases
• Number Systems
• Number Base Conversion
• Conversion of Fractions
• Computer Arithmetic
• Number Representation
• Floating Point Numbers
• Overflow and Underflow

3. Boolean Algebra and Logic Gates

• Basic Gates
• Boolean algebra
• Integrated Circuits
• Combinational Circuits
• Memory Organization

4. Operating System Concepts

• Main component of the operating system
• Process concepts
• Process Scheduling
• Memory and Virtual memory management
• File system interface and implementation
• I/O Operation

5. Introduction to C Programming

• Variables and Arithmetic Expressions
• Symbolic constant
• Arrays
• Functions
• Data Types
• Arithmetic Operation
• Relational and Logic Operators
• Conditional and looping construct

6. Introduction to C#.NET Programming

• Configure and use Visual Studio .NET
• Program with C#.NET
• Use of Visual Studio .NET IDE
• Create feature-rich Windows-based applications
• Use Microsoft ADO.NET to access and manipulate data in a database
• Report Generation

7. Database Design and Development (MS SQL Server 2008 / Oracle 10g)

• Introduction to database management systems
• Database design process
• Conceptual Database Design
• Logical Database Design
• Schema refinement
• Physical Database Design
• Query language (MS SQL Server and Oracle)
• Basic SQL queries
• Advanced SQL queries
• Database programming
• Introduction to database programming (T-SQL)
• Basic programming constructs
• View
• Stored procedures and Functions
• Triggers

8. Introduction to WEB Development

• The Internet
• Web Terminology
• Web 2.0 and beyond
• Effective searching with Google
• Principles of web design
• Introduction to Client-Server architecture
• HTML syntax and techniques
• Formatting control using CSS (Cascading Style Sheets)
• Develop a static website using Adobe Dream Viewer
• RAD (Rapid Application Development) in ASP .Net programming using C#
• Dynamic/Database-driven website design
• Administration of server-side hosting environments
• Introduction to SEO (Search Engine Optimization)
• Web Project

9. Introduction to Computer Networking

• Basic Concepts of Data Communication
• Network Devices                    
• Addressing IP & MAC
• Basics of Plan and Design of Local Area Networks
• Installing and Configuring TCP/IP for Local Area Networks & Troubleshooting
• Internet & E mail 

10. Use of System Software and Application Software

• Microsoft Windows 7
• Linux
• Microsoft Word
• Microsoft Power Point
• Microsoft Excel