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
NSBM Green University

Master of Information Technology (MIT) AND Master of Science in Information Technology (MSc in IT)

Master of Information Technology (MIT) AND Master of Science in Information Technology (MSc in IT)

clock-img

Duration

2 Years

Medium

English

Physical
GISM - Graduate Institute of Science and Management

Information Technology

Information Technology

clock-img

Duration

3 years

Medium

English

Online
University of Moratuwa

MSc in Artificail Intellegence

MSc in Artificail Intellegence

clock-img

Duration

Medium

English

Physical
Welington College

Certificate Level 3 PROGRAMMING

Certificate Level 3 PROGRAMMING

clock-img

Duration

3 Months

Medium

English

Physical
Mahapola Ports & Maritime Academy

Mahapola Ports & Maritime Academy - Course On Microsoft Office 200x (Basic)

Mahapola Ports & Maritime Academy - Course On Microsoft Office 200x (Basic)

clock-img

Duration

24 Sessions (Session is a half-day)

Medium

English

Physical
American College of Higher Education

Doctor of Philosophy (Ph.D.) in Informatics

Doctor of Philosophy (Ph.D.) in Informatics

clock-img

Duration

Medium

English

Ask from LAVTC