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
Informatics Institute of Technology (IIT)

Professional Certificate in Web Development

Professional Certificate in Web Development

clock-img

Duration

3 Months (Part Time)

Medium

English

Physical
WinSYS Networks

Certificate in C# Programming

Certificate in C# Programming

clock-img

Duration

45 hours

Medium

English

Physical
Lincoln University Sri Lanka

Bachelor of Computer Science (Hons) (Network Technology and Cybersecurity)

Bachelor of Computer Science (Hons) (Network Technology and Cybersecurity)

clock-img

Duration

3 Years

Medium

English

Physical
Siksil Institute Of Business & Technology - SIBT

Certificate in Computer Studies

Certificate in Computer Studies

clock-img

Duration

4 Months (Weekday/Weekend)

Medium

English

Online
American Institute of Innovation-AII

Certificate Course in Artificial Intelligence

Certificate Course in Artificial Intelligence

clock-img

Duration

4 Months

Medium

English

Online
ESOFT Metro Campus

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

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

clock-img

Duration

Medium

English

Ask from LAVTC