Home | Courses | Alma | Diploma Courses | Diploma in Internet Application & E-Commerce

Diploma in Internet Application & E-Commerce

By
Font size: Decrease font Enlarge font
Diploma in Internet Application & E-Commerce

ALMA offers many job oriented computer courses.”Diploma in Internet Application & E-Commerce” is one of the ALMA approved course.The detailed contents of this course is in the attachment.

COURSE CODE : DP-07

ELIGIBILITY : 10th

DURATION : 1 Year

SYLLABUS

Oracle-SQL

  • Oracle Product details , Different data base model , RDBMS  components –Kernel , Data dictionary , client /server computing and oracle , Overview of oracle architecture –oracle files , system and user  process , Oracle memory , system data base object , protecting data.Oracle data type , working with tables , data Constraints , column level & table level constraints  , defining different constraints on the table defining integrity constraints  in the ALTER TABLE command , Select Command , logical operator  , Range Searching  , Pattern Matching  , Oracle Function  , Grouping data from table in SQL , Manipulation Data in SQL Joining Multiple Tables(Equi joins ) , Joining a Table to self (Self joins) , Sub queries Union , intersect & Minus clause , creating  view Renaming the column of a view , granting permissions –updating  , Selection , Destroying view.

Microsoft SQL Server

  • Exploring Transact-SQL , An Overview of SQL Server and Transact-SQL , Programming in Transact-SQL , Querying Data , Using the SELECT Statement , Formatting the Results Set , Changing Data Through Queries , Inserting Data , Deleting Data , Updating Data , Summarizing Data , Working with Aggregate Functions , Grouping Data , Joining Tables , Querying Multiple Tables , Implementing Advanced Table Joins , Implementing Sub queries , Designing Sub queries , Working with Full-Text Indexes , Implementing the Microsoft Search Service , Querying Full-Text Indexes , Programming Transact-SQL , Creating and Managing Views , Implementing Stored Procedures, Triggers, and User-Defined Functions 

PHP & My SQL

  • Introduction to PHP , What is PHP? , Basic Syntax of PHP , Common PHP Script Elements , Using Variables , Working With Arrays , Using Functions , File and Directory Handling , Including Files , File Access , Working With Forms , Processing Forms , Form Validation , Emailing Form Data , Addressing the Stateless Nature of HTTP , Hidden Form Fields , Cookies , Sessions , Accessing Databases With PHP , Interacting With Databases , Modifying Database Records Using PHP , My SQLIntroduction To Database , Relational and Non Relational Database , Using client programs to access a MySQL database  , Creating, altering and dropping a MySQL database  , Writing SQL statements to select data from a MySQL database , Writing joins and sub queries  , Using SQL expressions , Using SQL aggregate functions and scalar functions , Inserting, updating, deleting and replacing rows , Creating and altering tables, indexes and views , Using transactions , Granting and revoking access privileges on tables and views , Exporting and importing data

HTML overview

  • Installing Apache, PHP, and MySQL 

PHP Basic Constructs

  • Variables and data types , Expressions and operators , Conditional statements , Iteration statements , Functions , Arrays and Objects Forms Cookies and SessionsFiles and DirectoriesInteracting with MySQL using PHP 

JDK , JavaBeans , JDBC

  • Introduction To Core Java , Data Types and Variables , Operator and Expressions , Control Flow Statements , Methods , Object Oriented Programming , Object and Classes , Using Java Objects , Inheritance in Java , Packages , Exception Handling , Input/Output streams , Introduction To Threads , Interface and Abstract Classes , Serialization.

Java Servlet

  • Introduction to Web Programming , Introduction to servlet , Servlet life cycle , Developing and Deploying Servlets , Exploring Deployment Descriptor (web.xml) , Handling Request and Response , Initializing a Servlet , Processing Form Data , Storing User data , Servlet Chaining , Session Tracking & Management , Dealing with cookies , Transferring Request , Event Listener , Creating war files

JSP

  • Introduction To Tomcat , Intro to JSP , Scripting Elements , JSP Page Directive   Project , Files in JSP, Using JavaBeans , Custom JSP Tags , Advanced JSP Tags , Integrating Servlets and JSP , Scripting Variables , Expression Language , JSTL , Apache Struts 

ASP.NET

Web Architecture

  • The Way the Web works , The Asp.net difference , Client-Side Processing , How Asp.net Ties It Together

Setting up and Installing ASP.NET

  • Installing Internet Information Server , IIS Manager , Creating virtual/home directory , Folder Settings , Adding a virtual directory to your neighborhood , Installing .Net Framework SDK 

Overview of the ASP.NET Framework

  • Asp.net and the .NET Framework , Common Language Runtime , .Net Framework Class Library , Understanding Namespaces , The Structure of asp.net Page , Directives , Code Declaration Blocks , Code Render Block , C# fundamentals

Using the Standard Controls

  • Displaying information , Label Controls , Literal Controls , Accepting User Input , Textbox controls , RadioButton And RadioButtonList Controls , CheckBox And CheckBoxList Controls , Submitting Form Data , Button controls , LinkButton Control , ImageButton Control , Displaying Images , Image Control , Using Panel Control , Using Hyperlink Control

Using the Validation Controls

  • RequiredFieldValidator Control , RegularExpressionValidator Control , CompareFieldValidator Control , RangeValidator Control , ValidationSummary Control , CustomValidator Control , Disabling Validation , Creating a LengthValidator Control , Creating a AjaxValidator Control

Using the Rich Controls

  • Accepting File Uploads , Saving files to file system , Saving files to database , Uploading Large files , Displaying a calendar , Creating a popup date picker , Rendering a calendar from a database table , Displaying advertisements , Storing advertisements in XML files , Storing advertisements in database tables

Designing Websites with master pages

  • Creating master pages , Creating default contents , Nesting master pages , Using images and hyperlinks in master pages , Registering master pages in web configuration

Overview of Data Access

  • Using DataBound Controls , Working with List Controls , Working with tabular DataBound Controls , Working with Hierarchical DataBound Controlsu , Working with other Controls , Using Data Source Controls , Using ASP.NET parameters with data source controls , Using programmatic DataBinding , Understanding Templates and Databinding Expressions , Using templates , Using DataBinding Expressions , Using 2 way DataBinding Expression

Using SQLData Source Control

  • Creating database connections , Connecting to MSSQL Server , Connecting to ORACLE and MS Access , Storing connection String in web configuration file , Executing Database Commands , Executing inline SQL Statements , Executing Stored Procedures , Filtering database rows , Changing the datasource mode , Handling SQL Command execution errors , Executing Insert , Update and Delete commands , Executing select commands

Using List Controls

  • Overview of the List Controls , Declaring List Items , Binding to a Data Source , Determining the selected List Item , Appending data items , Enabling automatic post backs , Using the Items Collection , Working with the DropDownList control , Working with the RadioButtonList control , Working with the ListBox control , Working with the CheckBoxList control , Working with BulletedList control , Summary

Using the GridView Control

  • GridView Control fundamentals , Displaying Data , Selecting Data , Using Data Keys , Sorting Data , Paging through Data , Editing Data , Displaying Empty Data , Formatting the GridView Control

Using Repeater Controls

  • Using Repeater Control , Displaying data with the Repeater Control , Using Templates with the Repeater Control

Using the Login Control

  • Overview of Login Controls , Using Login Controls , Automatically Redirecting a user to the Referring Page , Automatically Hiding the Login Control from Authinticated Users , Authenticated Users , Using a Template with Login Control 

 

 DOWNLOAD SYLLABUS

Editor's Desk

How Much Faster Can You Learn?

Say you were to optimize everything you possibly could for a particular learning goal. You used the best time-management system, you picked exactly the right tasks that would drive learning improvement, you applied tremendous motivation and effort. How much faster could you learn something than the status quo would expect? The answer, of course, will be: it depends. But that's rather unsatisfying, if true, because the crucial question is: what does it depend on? Asking how much improvement over the status quo or expected rate of progress is an interesting question in many domains. In some areas, there might be ... Read More

  • Email to a friend Email to a friend
  • Print version Print version