Duration: 3 MONTHS

Course Syllabus

Introduction to Database Management

  • Introduction to database concepts and its need
  • Database Terminology: Data, Record/Tuple, Table, Database, field/attribute
  • Concept of Keys: Candidate key, Primary key, Alternate key, and Foreign key
  • Examples of common Database Management System: MySQL, Ingres, Postgres, Oracle, DB2, MSSQL
  • Server, Sybase etc.
  • Introduction to MySQL: Using MySQL creating Database and table, defining primary key, inserting
  • records, displaying records using SELECT command, WHERE clause, modifying records using
  • UPDATE, deleting records
Networking And Open Standards
  • Computer Networking: Evolution of Networking: ARPANET, WWW, Internet
  • Network Topologies: Bus, Star, Tree,Types of Network: PAN, LAN, WAN, MAN
  • Wired Technologies: Twisted pair cable, coaxial cable, optical fiber
  • Wireless Technologies: Bluetooth, infrared, radio link, microwave link, radio link and satellite link
  • Network devices: MODEM, Hub, switch, repeater, gateway – and their functions
  • Identifying computers and users over a network: Basic concept of domain name, MAC (Media
  • Access Control) and IP Address, domain name resolution
  • Wireless/Mobile Communication: GSM, CDMA, GPRS, WLL, 3G, 4G
  • Internet Applications: SMS, Voice mail, e-Mail, Chat and Video conferencing
  • Network Security Concepts: Cyber law, firewall, cookies, hackers and crackers,
  • OpenSource Concepts: Proprietary and open source software(OSS), common FOSS/FLOSS
  • examples (e.g. GNU/Linux, Firefox, OpenOffice, Linux, Mozilla web browser, Apache server,
  • MySQL, Postgres, Pango, Tomcat, PHP, Python)
  • Indian Language Computing: character encoding, UNICODE, different types of fonts (open type vs
  • true type, static vs dynamic), Entering Indian Language Text – phonetic and key map based
Web Page Development
  • Installation and Managing WEB-Server: IIS/XAMPP/LAMP;
  • PHP: Concept of PHP, features of PHP, other equivalent tools – JSP, PHP
  • Including PHP in web page
  • Data types: integer, double, string, boolean, null, array, object,Variables: Using variables in PHP,Constants: Using constants in PHP, constant() function,Output data to Screen: echo and print statements,Operators:Arithmetic operators: +, - (Unary and Binary), *, /, %, **,
  • Assignment operators : =,+=,- =,*=,/=.%=,String operator: . , . =,Comparison operators: <, >, <=, >=, !=, ==,===.!===,Incrementing/Decrementing operators:++,--,Logical operators: !,&&,||;,Array Operators: union(+),equality ==,inequality <>,!=,Operator precedence,
  • Built In Functions:String Manipulation Functions: strtoupper(), strtolower(), strlen(), ltrim(), substr(), rtrim(),trim() ,strrev(), strcasecmp(),strcmp(),stripslashes(), strchr(), strpos(), stripos(),Time & Date Functions: Date(),getdate(),gettimeofday(),Mktime(),strtotime(),
  • cal_days_in_month(),Arrays: Declaration and use of indexed arrays(1 dimensional), inbuilt functions sort(),rsort()
  • Conditional statements: if, if else, if...elseif....else, switch,Loops: while, do while , for, for each,Unconditional exit from loop /switch using break
  • User Defined Functions: Defining a function, calling/invoking a function,
  • Passing parameters/arguments, Pass by value, pass by reference, return value, default value
  • Global Variables – Superglobals,GLOBALS,$_SERVER,$_REQUEST,$_POST,$_GET,$_FILES,$_ENV,$_COOKIE,$_SESSION
  • Elements of $_SERVER : PHP_SELF, SERVER_NAME, HTTP_HOST, HTTP_USER_AGENT,PHP Forms,Form Handling, Form Validation, Form URL/E-mail
  • Text Files:
    • Opening a file, Reading a file, Writing a file, Closing a file,Other Features
    • PHP File Upload, Cookies, Sessions (start, modify and destroy), Error Handling
    • Working on Database: (Using MySQLi Procedural API)Connecting with Databases, opening and
    • closing databases, Inserting, retrieving, modifying/updation , deleting of records from tables
Multimedia and Authoring Tools
  • Movie File Formats: AVI, MPEG, SWF, MOV, DAT,Embedding: Audio/Video on the web page,
  • Multimedia Authoring Using Macromedia Flash: Making of simple movie, setting properties,
  • frame rate, dimensions, and background color,Movie Frames: Concept of frame, frame buffer, and frame rate, creating a key frame, Inserting
  • text into the frame, inserting graphical elements into the frame, converting text/graphics to
  • symbol, inserting symbol into the frame, setting symbol property (graphics/button/movie),
  • inserting blank key frame, selecting all/specific frames of a layer, copying/pasting selected,frames Scene: Concept of scene, duplicate scene, add scene,delete scene, and navigating between scenes,Layers: Concept of layer, layer properties, layer name, show/hide/lock layers, viewing layer as,
  • outline, adding/deleting a layer,Types of Layer - normal/guide/mask,Special Effects: Motion Tweening, Shape Tweening, Inserting Sound Layer,
  • Testing a Scene and Movie,Import/Export (Movie/Sound and other multimedia objects),Publishing:
  • Publishing a movie, changing publish settings, producing swf(flash movie), html page, gif image,
  • jpeg image (*.jpg), png image, windows projector (*.exe), macintosh projector (*.hqx), quick time
  • (*.mov), real player (*.smil),Testing with Publish Preview,Multimedia Application: Education (use of CAL tool), entertainment, edutainment, virtual reality,digital libraries, information kiosks, video on demand, video phone, video conferencing and telemedicine.

Read More



Back to top