Certificate Associate in Web Development – 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.
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.
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.
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.
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.
Foundational certificate in Programming
Mix of Instructor-led, case study driven and hands-on for select phases
H/w, S/w Reqd
24 Hours (2 days Instructor led + 8 hours online learning)
- Course Name:Certificate Associate in Web Development – Databases
- Duration:2 days classroom + 8 hours online
- Exam Time: 60 minutes
- Course Price: Call for price
- Minimum requirements: Foundational Certificate in Programming
|#||Topic||Method of Delivery|
Chapter 1 Database Design
Understanding the Importance of Design
Strengths and Weaknesses of Information Containers
Desirable Database Features
Chapter 2 Database Types
|Case study||Hands-on session|
Chapter 3 Relational Database Fundamentals
Relational Points of View
Table, Rows, and Columns
Relations, Attributes, and Tuples
Chapter 4 Data Models
What Are Data Models
User Interface Models
Semantic Object Models
Chapter 5 Normalizing Data
What Is Normalization?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
|Online Self paced|
- Certificate Title: Certificate Associate in Web Development – Databases
- Certificate Awarding Body: 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.
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.
- Exam Format: Closed-book format.
Questions: 30 multiple choice questions, coding exercises
Passing Score: 65%
Exam Duration: 60 minutes
- Exam needs to be taken within 12 months from the exam voucher issue date
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.