391B Orchard Road #23-01 Ngee Ann City Tower B, Singapore 238874
+ 65 66381203

Certificate Associate in Web Development – Databases

Home»Certificate Associate in Web Development – Databases

Certificate Associate in Web Development – Databases

CAWD Databases

A database is nothing more than a collection of data, usually organized in some structured way. We use databases everyday although we might not think of them as databases. Take a phone directory, for instance. It contains a lot of data. The data itself consists of names, addresses, and, of course, phone numbers, typically sorted by last name.

Relational databases

It presents a model that shows the relationships between the different elements of data and heavily uses tables. In each of those tables, there are several fields or columns that can contain data of various types (strings, numbers, dates, and so on). Entries in those tables are called rows, and the first column in each row is an index or primary key, a number, which is usually not changed after it has been created.

SQL

Many people believe that SQL stands for Standard Query Language, but actually it doesn’t – it is just plain SQL. However, it is a language, and is some kind of a standard used to perform queries on a database.

NoSQL

In this course, we will first compare traditional relational databases with so-called NoSQL databases and quickly introduce MongoDB, a document database. You will learn what it is, how to get and install it, and how to create a database to insert documents. The NoSQL part can be interpreted in two ways: NO SQL, meaning no query language available, or Not Only SQL, meaning the technology supports more than just SQL. NoSQL databases have become quite popular in web development.

There are several types. The group of NoSQL databases that is of interest to us are so-called document databases. What is stored in the database are documents. A document in this context is not, let’s say, a Word or PDF document, but a JSON object. Document databases provide the ability to query on any field in the document, so they are, for sure, Not Only SQL databases.

Learning Objectives

Upon completion of the course, participants should be able to:

  • Describe the topic of NoSQL and distributed databases
  • Understand the design principles and trade-offs involved in NoSQL database design
  • Set up a database
  • Perform CRUD (Create, Read, Update, Delete) operations on a database

Who should attend

This course will help beginners, programmers, application developers and software engineers pick the right strategy for developing cross-platform web applications that run on a variety of desktop computers as well as mobile devices. The primary audience is developers who need to learn how to develop web applications using the HTML5 stack.

Prerequisite

Foundational certificate in Programming

Delivery Method

Mix of Instructor-led, case study driven and hands-on for select phases

H/w, S/w Reqd

JavaScript, CSS, HTML, Chrome Browser with at least 2GB RAM and a Windows /Ubuntu/Mac OS X operating system

Duration

24 Hours (2 days Instructor led + 8 hours online learning)

Enroll Now
  • Course Name:Certificate Associate in Web Development – Databases
  • Location:Singapore
  • Duration:2 days classroom + 8 hours online
  • Exam Time: 60 minutes
  • Course Price: Call for price
  • Minimum requirements: Foundational Certificate in Programming

 ITPACS LogoITPACS Web Certification Road Map

Course contents

# Topic Method of Delivery
Day 1
1

Chapter 1 Database Design

Understanding the Importance of Design

Information Containers

Strengths and Weaknesses of Information Containers

Desirable Database Features

Instructor Led
2

Chapter 2 Database Types

Flat Files

Relational Databases

Spreadsheets

Hierarchical Databases

XML

Network

Object

Object-Relational

Instructor Led
  Case study Hands-on session
Day 2    
3

Chapter 3 Relational Database Fundamentals

Relational Points of View

Table, Rows, and Columns

Relations, Attributes, and Tuples

Keys

Indexes

Constraints

Database Operations

Instructor Led
4

Chapter 4 Data Models

What Are Data Models

User Interface Models

Semantic Object Models

Entity-Relationship Models

Relational Models

 
5

Chapter 5 Normalizing Data

What Is Normalization?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Instructor Led
 

Assignment

Online Self paced

Certification

  • Certificate Title: Certificate Associate in Web Development – Databases
  • Certificate Awarding Body: ITPACS

About ITPACS

Information Technology Professional Accreditations and Certifications Society (ITPACS) is a non-profit organization focused on improving technology skills for the future. ITPACS offers associate level, professional level and leader certifications across 6 domains including data science, web development, mobile development, cyber security, IoT and blockchain. Applicants have to go through a exam eligibility process demonstrating their experience.

Eligibility

The Associate certification is catered to individuals with less than 1 year working experience in the field. This is ideal for newcomers starting out in the profession or those seeking to make an entry into the profession. Applicants are required to have completed the application process prior to taking the exam.  

Styling Eligibility

Exam

  • Exam Format: Closed-book format.
    Questions: 30 multiple choice questions, coding exercises
    Passing Score: 65%
    Exam Duration: 60 minutes
    Proctored
  • Exam needs to be taken within 12 months from the exam voucher issue date

ITPACS Certification Training Road Map

Web Applications

Web Developers build web applications. A web application is one that helps an organization run its business online. ​​Most web applications are built in a three-tier architecture that consists of three important layers: data, logic, and presentation. In web applications, the application structure usually breaks down to database, server, and client, while in modern web development; it can also be broken into database, server logic, client logic, and client UI.

Dynamic web pages are known as pages that are created as soon as a call is sent to the server. So data can be built interactively into the sites. They are particularly helpful when you need to react to user inputs. Forms can be evaluated immediately and the content of the next page can be shown. The application possibilities are nearly unlimited. Whether and to which extent databases are used depends on the goal. Dynamic web pages actually do not need a database.

A popular paradigm for implementing this model is the Model-View-Controller (MVC) architectural pattern. In the MVC paradigm, the logic, data, and visualization are separated into three types of object, each handling its own tasks. The View handles the visual part, taking care of user interaction. The Controller responds to system and user events, commanding the Model and View to change appropriately. The Model handles data manipulation, responding to requests for information or changing its state according to the Controller’s instructions.