Computing & IT

Certificate In Software Development Database Administration Technology

Course Contents


Semester 1

Database Systems I

  • Introduction to DBMS
  • Database architecture and modeling
  • Database design process
  • Relational Data model
  • Entity-Relationship model
  • Data Normalization process and the normal forms
  • Data manipulation using SQL
  • Fundamentals of Database Systems
  • Database Management and Design
  • Software Programming- JAVA
  • Fundamental of java programming
  • Object oriented concepts
  • Stream and exception handling
  • Work with databases
  • Graphical User Interface Designing (GUI)
  • System Analyzing & Designing
  • Definition of a System
  • Introduction to system Analysis and design
  • Requirement gathering and fact finding techniques
  • Date Modeling Technique
  • Object Oriented System Design
  • System Requirement Specification (SRS Documentation)
  • Semester 1
  • Database Systems II
  • Install a database in a given environment
  • Configure database and install application packages
  • Data manipulation with SQL
  • Programming Database Applications
  • Fundamentals of Database Systems
  • Web Programming
  • HTML /CSS
  • Java script & Jquery
  • Fundamental of PHP Programming
  • Object oriented concepts
  • PHP With MySQL
  • Work Twitter Bootstrap
  • Workplace information Management
  • Identification fo Documentation Requirments
  • Selecting and or Collecting required documentation
  • Documentation procedure & Methods
  • Completing / perecting Documentation reading
  • Interpreting & using equipement/system manulas & specifications
  • Interpretation of all applicable laws
  • Policies & procedures relevant to enterprise
  • Computer & Information system usage
  • Forecasting Techniques
  • Forecasting Software
  • Mathematical Modeling Data Collection Technique for Market Research
  • The range of analytical techniques appropriate for analysis of information
  • The influence of human factors on information analysis e.g.prejudices & biases conduction & recording performance evaluations


Duration

12 Months

Category

Computing & IT

Course Level

Certificate

Related Courses

Physical

Short Course in PHP MySQL Web Development

The Open University of Sri Lanka - OUSL
duration
Duration 3 Months
Physical

Diploma in Information and Cyber Security Technology

Times School of Higher Education
duration
Duration 12 months
Online

Computer Basics Course with Certificate

eAcademy.lk
duration
Duration Online
Physical

Advanced Diploma in Information Technology

Siksil Institute Of Business & Technology - SIBT
duration
Duration 04 Months
Physical

Mahapola Ports & Maritime Academy - Course On Advanced Microsoft Office Word 200x

Mahapola Ports & Maritime Academy
duration
Duration 12 Sessions in 12 Days
Physical

GCE (A/L) ICT

Global Network of Technological Studies
duration
Duration 10 Weeks

Ask from LAVTC

Need Help?
How can we help you?
Frequently Asked Questions
Contact Support
Call Us:
+94 11 766 2626
+94 77 107 0711
WhatsApp Support