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
APIIT Sri Lanka

BSc (Hons) Computer Science (Cloud Technologies)

BSc (Hons) Computer Science (Cloud Technologies)

clock-img

Duration

Four Years

Medium

English

Physical
NIBM CAMPUSES

MSc Data Science

MSc Data Science

clock-img

Duration

18 Months

Medium

English

Physical
AICT

Professional Networking Course

Professional Networking Course

clock-img

Duration

Medium

English

458

Days more

June 19

Physical
SLIIT-Sri Lanka Institute of Information Technology

BEd (Hons) in Information Technology

BEd (Hons) in Information Technology

clock-img

Duration

04 Years

Medium

English

Physical
ESOFT College of Engineering and Technology

BTEC Higher National Diploma (HND) in Computing – Software Engineering

BTEC Higher National Diploma (HND) in Computing – Software Engineering

clock-img

Duration

18 Months

Medium

English

Physical
ESOFT Metro Campus

Bachelor of Information Technology (BIT External Degree) – University of Colombo (UCSC) – Semester 1

Bachelor of Information Technology (BIT External Degree) – University of Colombo (UCSC) – Semester 1

clock-img

Duration

Medium

English

Ask from LAVTC