WebDevelopmentEssentials Objectives V1.0(JA) - Revision history

Okadaknj: /* 試験範囲の翻訳 */

2021-07-21T15:18:51Z

試験範囲の翻訳

← Older revision		Revision as of 15:18, 21 July 2021
Line 19:		Line 19:
	このwikiに、以下の試験範囲の翻訳があります:		このwikiに、以下の試験範囲の翻訳があります:

	* [[~~WebDevelopmentEssentials~~ Objectives V1.0\|English]]		* [[Web Development Essentials Objectives V1.0\|English]]
	* [[WebDevelopmentEssentials Objectives V1.0(PT-BR)\|Brazilian Portuguese]]		* [[WebDevelopmentEssentials Objectives V1.0(PT-BR)\|Brazilian Portuguese]]
	* [[WebDevelopmentEssentials Objectives V1.0(ZH)\|Chinese (Simplified)]]		* [[WebDevelopmentEssentials Objectives V1.0(ZH)\|Chinese (Simplified)]]

Okadaknj at 15:14, 21 July 2021

2021-07-21T15:14:51Z

← Older revision		Revision as of 15:14, 21 July 2021
Line 2:		Line 2:


	==~~日本語ページ構築中Minimally Qualified Candidate~~==		==最低限の資格を持つ受験生==

	受験生は、ソフトウエア開発の基本的な理解、ワールドワイドウェブ(WWW)とウェブアプリケーションの原理を理解している必要があります。受験生は、マークアップ言語の文法を利用して簡単なWebサイトを構築したり、そのWebサイトをlink, media要素やフォームを利用して拡張することが可能である必要があります。受験生は、これらのコンテンツがどのように表示されWebサイトに配置されるか、定義できる必要があります。さらに、受験生は変数・条件・ループ・関数などの、プログラミングの基本的な概念を知っている必要があります。受験生は、ウェブブラウザー上で動く、簡単なプログラムを作成できる必要があります。受験生は、ウェブサイトから送られたデータを処理し、データベースで永続化し、データベースのコンテンツで同的なウェブサイトを構築できる、サーバサイド側のプログラムを開発できる必要があります。		受験生は、ソフトウエア開発の基本的な理解、ワールドワイドウェブ(WWW)とウェブアプリケーションの原理を理解している必要があります。受験生は、マークアップ言語の文法を利用して簡単なWebサイトを構築したり、そのWebサイトをlink, media要素やフォームを利用して拡張することが可能である必要があります。受験生は、これらのコンテンツがどのように表示されWebサイトに配置されるか、定義できる必要があります。さらに、受験生は変数・条件・ループ・関数などの、プログラミングの基本的な概念を知っている必要があります。受験生は、ウェブブラウザー上で動く、簡単なプログラムを作成できる必要があります。受験生は、ウェブサイトから送られたデータを処理し、データベースで永続化し、データベースのコンテンツで同的なウェブサイトを構築できる、サーバサイド側のプログラムを開発できる必要があります。

Okadaknj at 15:11, 21 July 2021

2021-07-21T15:11:01Z

Show changes

Okadaknj at 14:47, 21 July 2021

2021-07-21T14:47:45Z

Show changes

Okadaknj at 14:20, 21 July 2021

2021-07-21T14:20:47Z

Show changes

Okadaknj at 14:03, 21 July 2021

2021-07-21T14:03:39Z

Show changes

Okadaknj at 13:57, 21 July 2021

2021-07-21T13:57:29Z

← Older revision		Revision as of 13:57, 21 July 2021
Line 9:		Line 9:


	==~~Version Information~~==		==バージョン情報==

	~~These objectives are '''A DRAFT FOR''' version 1.0~~.0.		この試験範囲は、バージョン1.0.0の「ドラフト」です。

	<br />		<br />

	==~~Translations of Objectives~~==		==試験範囲の翻訳==

	~~The following translations of the objectives are available on this wiki~~:		このwikiに、以下の試験範囲の翻訳があります:

	* [[WebDevelopmentEssentials Objectives V1.0\|English]]		* [[WebDevelopmentEssentials Objectives V1.0\|English]]
Line 32:		Line 32:
	<br />		<br />

	==~~Objectives~~==		==試験範囲==

	===''031 ~~Software Development and Web Technologies~~''===		===''031 ソフトウエア開発とウェブ技術''===

	====<span style="color:navy">031.1 Software Development Basics (weight: 1)====		====<span style="color:navy">031.1 Software Development Basics (weight: 1)====
Line 41:		Line 41:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 1		\| style="background:#eaeaea" \| 1
Line 73:		Line 73:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 116:		Line 116:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 3		\| style="background:#eaeaea" \| 3
Line 161:		Line 161:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 200:		Line 200:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 242:		Line 242:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 276:		Line 276:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 313:		Line 313:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 1		\| style="background:#eaeaea" \| 1
Line 348:		Line 348:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 3		\| style="background:#eaeaea" \| 3
Line 383:		Line 383:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 414:		Line 414:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 454:		Line 454:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 1		\| style="background:#eaeaea" \| 1
Line 489:		Line 489:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 3		\| style="background:#eaeaea" \| 3
Line 525:		Line 525:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 4		\| style="background:#eaeaea" \| 4
Line 563:		Line 563:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 2		\| style="background:#eaeaea" \| 2
Line 600:		Line 600:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 1		\| style="background:#eaeaea" \| 1
Line 635:		Line 635:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 4		\| style="background:#eaeaea" \| 4
Line 678:		Line 678:
	\| style="background:#dadada" \|		\| style="background:#dadada" \|

	'''~~Weight~~'''		'''総重量'''

	\| style="background:#eaeaea" \| 3		\| style="background:#eaeaea" \| 3

Okadaknj: Created page with "FORCETOC ==日本語ページ構築中Minimally Qualified Candidate== The candidate has a basic understanding of software development, the principle of the world wide w..."

2021-06-11T14:55:13Z

Created page with "__FORCETOC__ ==日本語ページ構築中Minimally Qualified Candidate== The candidate has a basic understanding of software development, the principle of the world wide w..."

New page

__FORCETOC__

==日本語ページ構築中Minimally Qualified Candidate==

The candidate has a basic understanding of software development, the principle of the world wide web and web applications. The candidate is able to use semantic markup to create simple web sites and extend these websites with links, media elements and forms. The candidate is able to define how these contents are displayed and placed on a website. Furthermore, the candidate is familiar with core programming concepts such as variables, conditions, loops and functions. The candidate can create simple programs which run in a web browser. The candidate is also able to develop server-side programs which can process data submitted from a website, persist this data in a database and generate dynamic web sites based on the database contents.

<br />

==Version Information==

These objectives are '''A DRAFT FOR''' version 1.0.0.

<br />

==Translations of Objectives==

The following translations of the objectives are available on this wiki:

* [[WebDevelopmentEssentials Objectives V1.0|English]]
* [[WebDevelopmentEssentials Objectives V1.0(PT-BR)|Brazilian Portuguese]]
* [[WebDevelopmentEssentials Objectives V1.0(ZH)|Chinese (Simplified)]]
* [[WebDevelopmentEssentials Objectives V1.0(ZH-TW)|Chinese (Traditional)]]
* [[WebDevelopmentEssentials Objectives V1.0(NL)|Dutch]]
* [[WebDevelopmentEssentials Objectives V1.0(FR)|French]]
* [[WebDevelopmentEssentials Objectives V1.0(DE)|German]]
* [[WebDevelopmentEssentials Objectives V1.0(IT)|Italian]]
* [[WebDevelopmentEssentials Objectives V1.0(JA)|Japanese]]
* [[WebDevelopmentEssentials Objectives V1.0(ES)|Spanish]]

<br />

==Objectives==

===''031 Software Development and Web Technologies''===

====<span style="color:navy">031.1 Software Development Basics (weight: 1)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 1
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be familiar with the most essential concepts of software development and be aware of important programming languages.

|}

'''Key Knowledge Areas:'''

* Understand what source code is
* Understand the principles of compilers and interpreters
* Understand the concept of libraries
* Understand the concepts of functional, procedural and object-oriented programming
* Awareness of common features of source code editors and integrated development environments (IDE)
* Awareness of version control systems
* Awareness of software testing
* Awareness of important programming languages (C, C++, C#, Java, JavaScript, Python, PHP)

<br />

====<span style="color:navy">031.2 Web Application Architecture (weight: 2)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should understand common standards in web development technology and architecture.

|}

'''Key Knowledge Areas:'''

* Understand the principle of client and server computing
* Understand the role of web browsers and be aware of commonly used web browsers
* Understand the role of web servers and application servers
* Understand common web development technologies and standards
* Understand the principles of APIs
* Understand the principle of relational and non-relational (NoSQL) databases
* Awareness of commonly used open source database management systems
* Awareness of REST and GraphQL
* Awareness of single-page applications
* Awareness of web application packaging
* Awareness of WebAssembly
* Awareness of content management systems

'''Files, terms, and utilities:'''

* Chrome, Edge, Firefox, Safari, Internet Explorer
* HTML, CSS, JavaScript
* SQLite, MySQL, MariaDB, PostgreSQL
* MongoDB, CouchDB, Redis

<br />

====<span style="color:navy">031.3 HTTP Basics (weight: 3)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 3
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be familiar with the basics of HTTP. This includes understanding HTTP headers, content types, caching, and status codes. Furthermore, the candidate should understand the principles of cookies and their role for session handling and be aware of advanced HTTP features.

|}

'''Key Knowledge Areas:'''

* Understand HTTP GET and POST methods, status codes, headers and content types
* Understand the difference between static and dynamic content
* Understand HTTP URLs
* Understand how HTTP URLs are mapped to file system paths
* Upload files to a web server's document root
* Understand caching
* Understand cookies
* Awareness of sessions and session hijacking
* Awareness of commonly used HTTP servers
* Awareness of HTTPS and TLS
* Awareness of web sockets
* Awareness of virtual hosts
* Awareness of common HTTP servers
* Awareness of network bandwidth and latency requirements and limitations

'''Files, terms, and utilities:'''

* GET, POST
* 200, 301, 302, 401, 403, 404, 500
* Apache HTTP Server ("httpd"), NGINX

<br />

===''032 HTML Document Markup''===

====<span style="color:navy">032.1 HTML Document Anatomy (weight: 2)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should understand the anatomy and syntax of an HTML document. This includes creating basic HTML documents.

|}

'''Key Knowledge Areas:'''

* Create a simple HTML document
* Understand the role of HTML
* Understand the HTML skeleton
* Understand the HTML syntax (tags, attributes, comments)
* Understand the HTML head
* Understand meta tags
* Understand character encoding

'''Files, terms, and utilities:'''

* <nowiki><!DOCTYPE html></nowiki>
* <nowiki><html></nowiki>
* <nowiki><head></nowiki>
* <nowiki><body></nowiki>
* <nowiki><meta></nowiki>, including the charset (UTF-8), name and content attributes

<br />

====<span style="color:navy">032.2 HTML Semantics and Document Hierarchy (weight: 2)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to create HTML documents with a semantic structure.

|}

'''Key Knowledge Areas:'''

* Create markup for contents in an HTML document
* Understand the hierarchical HTML text structure
* Differentiate between block and inline HTML elements
* Understand important semantic structural HTML elements

'''Files, terms, and utilities:'''

* <nowiki><h1></nowiki>, <nowiki><h2></nowiki>, <nowiki><h3></nowiki>, <nowiki><h4></nowiki>, <nowiki><h5></nowiki>, <nowiki><h6></nowiki>
* <nowiki><p></nowiki>
* <nowiki><ul></nowiki>, <nowiki><ol></nowiki>, <nowiki><li></nowiki>
* <nowiki><dl></nowiki>, <nowiki><dt></nowiki>, <nowiki><dd></nowiki>
* <nowiki><pre></nowiki>
* <nowiki><blockquote></nowiki>
* <nowiki><strong></nowiki>, <nowiki><em></nowiki>, <nowiki><code></nowiki>
* <nowiki><b></nowiki>, <nowiki><i></nowiki>, <nowiki><u></nowiki>
* <nowiki><span></nowiki>
* <nowiki><div></nowiki>
* <nowiki><main></nowiki>, <nowiki><header></nowiki>, <nowiki><nav></nowiki>, <nowiki><section></nowiki>, <nowiki><footer></nowiki>

<br />

====<span style="color:navy">032.3 HTML References and Embedded Resources (weight: 2)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to link an HTML document with other documents and embed external content, such as images, videos and audio in an HTML document.

|}

'''Key Knowledge Areas:'''

* Create links to external resources and page anchors
* Add images to HTML documents
* Understand key properties of common media file formats, inlcuding PNG, JPG and SVG
* Awareness of iframes

'''Files, terms, and utilities:'''

* id attribute
* <nowiki><a></nowiki>, including the href and target (_blank, _self, _parent, _top) attributes
* <nowiki><img></nowiki>, including the src and alt attributes

<br />

====<span style="color:navy">032.4 HTML Forms (weight: 2)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to create simple HTML forms containing input elements of various types.

|}

'''Key Knowledge Areas:'''

* Create simple HTML forms
* Understand HTML form methods
* Understand HTML input elements and types

'''Files, terms, and utilities:'''

* <nowiki><form></nowiki>, including the method (get, post), action, and enctype attributes
* <nowiki><input></nowiki>, including the type (text, email, password, number, date, file, range, radio, checkbox, hidden) attribute
* <nowiki><button></nowiki>, including the type (submit, reset, hidden, button) attribute
* <nowiki><textarea></nowiki>
* common form element attributes (name, value, id)
* <nowiki><label></nowiki>, including the for attribute

<br />

===''033 CSS Content Styling''===

====<span style="color:navy">033.1 CSS Basics (weight: 1)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 1
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should understand the various ways to style an HTML document using CSS. This includes the structure and syntax of CSS rules.

|}

'''Key Knowledge Areas:'''

* Embedding CSS within an HTML document
* Understand the CSS syntax
* Add comments to CSS
* Awareness of accessibility features and requirements

'''Files, terms, and utilities:'''

* HTML style and type (text/css) attributes
* <nowiki><style></nowiki>
* <nowiki><link></nowiki>, including the rel (stylesheet), type (text/css) and src attributes
* ;
* /*,*/

<br />

====<span style="color:navy">033.2 CSS Selectors and Style Application (weight: 3)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 3
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to use selectors in CSS and understand how CSS rules are applied to elements within an HTML document.

|}

'''Key Knowledge Areas:'''

* Use selectors to apply CSS rules to elements
* Understand CSS pseudo-classes
* Understand rule order and precedence in CSS
* Understand inheritance in CSS

'''Files, terms, and utilities:'''

* element; .class; #id
* a, b; a.class; a b;
* :hover, :focus
* !important

<br />

====<span style="color:navy">033.3 CSS Styling (weight: 2)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should use CSS to add simple styles to the elements of an HTML document.

|}

'''Key Knowledge Areas:'''

* Understand fundamental CSS properties
* Understand units commonly used in CSS

'''Files, terms, and utilities:'''

* px, %, em, rem, vw, vh
* color, background, background-*, font, font-*, text-*, list-style, line-height

<br />

====<span style="color:navy">033.4 CSS Box Model and Layout (weight: 2)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should understand the CSS box model. This includes defining the position of elements on a website. Additionally, the candidate should understand the document flow.

|}

'''Key Knowledge Areas:'''

* Define the dimension, position and alignment of elements in a CSS layout
* Specify how text flows around other elements
* Understand the document flow
* Awareness of the CSS grid
* Awareness of responsive web design
* Awareness of CSS media queries

'''Files, terms, and utilities:'''

* width, height, padding, padding-*, margin, margin-*, border, border-*
* top, left, right, bottom
* display: block | inline | flex | inline-flex | none
* position: static | relative | absolute | fixed | sticky
* float: left | right | none
* clear: left | right | both | none

<br />

===''034 JavaScript Programming ''===

====<span style="color:navy">034.1 JavaScript Execution and Syntax (weight: 1)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 1
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to execute JavaScript files and inline code from an HTML document and understand basic JavaScript syntax.

|}

'''Key Knowledge Areas:'''

* Run JavaScript within an HTML document
* Understand the JavaScript syntax
* Add comments to JavaScript code
* Access the JavaScript console
* Write to the JavaScript console

'''Files, terms, and utilities:'''

* <nowiki><script></nowiki>, including the type (text/javascript) and src attributes
* ;
* //, /* */
* console.log

<br />

====<span style="color:navy">034.2 JavaScript Data Structures (weight: 3)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 3
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to use variables in JavaScript code. This includes understanding values and data types. Furthermore, the candidate should understand assignment operators and type conversion and be aware of variable scope.

|}

'''Key Knowledge Areas:'''

* Define and use variables and constants
* Understand data types
* Understand type conversion/coercion
* Understand arrays and objects
* Awareness of the variable scope

'''Files, terms, and utilities:'''

* =, +, -, *, /, %, --, ++, +=, -=, *=, /=
* var, let, const
* boolean, number, string, symbol
* array, object
* undefined, null, NaN

<br />

====<span style="color:navy">034.3 JavaScript Control Structures and Functions (weight: 4)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 4
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to use control structures in JavaScript code. This includes using comparison operators. Furthermore, the candidate should be able to write simple functions and understand function parameters and return values.

|}

'''Key Knowledge Areas:'''

* Understand truthy and falsy values
* Understand comparison operators
* Understand the difference between loose and strict comparison
* Use conditionals
* Use loops
* Define custom functions

'''Files, terms, and utilities:'''

* if, else if, else
* switch, case, break
* for, while, break, continue
* function, return
* ==, !=, <, <=, >, >=
* ===, !==

<br />

====<span style="color:navy">034.4 JavaScript Manipulation of Website Content and Styling (weight: 2)====
{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 2
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should understand the HTML DOM. This includes manipulating HTML elements and CSS properties through the DOM using JavaScript as well as using DOM events in simple scenarios.

|}

'''Key Knowledge Areas:'''

* Understand the concept and structure of the DOM
* Change the contents and properties of HTML elements through the DOM
* Change the CSS styling of HTML elements through the DOM
* Trigger JavaScript functions from HTML elements

'''Files, terms, and utilities:'''

* document.getElementById(), document.getElementsByClassName(), document.getElementsByTagName(),document.querySelector(), document.querySelectorAll()
* innerHTML, setAttribute(), removeAttribute() properties and methods of DOM elements
* classList, classList.add(), classList.remove(), classList.toggle() properties and methods of DOM elements
* onClick, onMouseOver, onMouseOut attributes of HTML elements

<br />

===''035 NodeJS Server Programming ''===

====<span style="color:navy">035.1 NodeJS Basics (weight: 1)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 1
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should understand the basics of NodeJS. This includes running a local development server as well as understanding the concept of NPM modules.

|}

'''Key Knowledge Areas:'''

* Understand the concepts of Node.js
* Run a NodeJS application
* Install NPM packages

'''Files, terms, and utilities:'''

* node [file.js]
* npm init
* npm install [module_name]
* package.json
* node_modules

<br />

====<span style="color:navy">035.2 NodeJS Express Basics (weight: 4)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 4
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to create a simple dynamic website with the Express web framework. This includes defining simple Express routes as well as serving dynamic files through the template engine EJS.

|}

'''Key Knowledge Areas:'''

* Define routes to static files and EJS templates
* Serve static files through Express
* Serve EJS templates through Express
* Create simple, non-nested EJS templates
* Use the request object to access HTTP GET and POST parameters and process data submitted through HTML forms
* Awareness of user input validation
* Awareness of cross-site Scripting (XSS)
* Awareness of cross-site request forgery (CSRF)

'''Files, terms, and utilities:'''

* express and body-parser node module
* Express app object
* app.get(), app.post()
* res.query, res.body
* ejs node module
* res.render()
* <nowiki><% … %></nowiki>, <nowiki><%= … %></nowiki>, <nowiki><%# … %></nowiki>, <nowiki><%- … %></nowiki>
* views/

<br />

====<span style="color:navy">035.3 SQL Basics (weight: 3)====

{|
| style="background:#dadada" |

'''Weight'''

| style="background:#eaeaea" | 3
|-
| style="background:#dadada; padding-right:1em" |

'''Description'''

| style="background:#eaeaea" |

The candidate should be able to create individual tables in an SQLite database and add, modify and delete data using SQL. Furthermore, the candidate should be able to retrieve data from individual tables and execute SQL queries from NodeJS. This does not include referencing or combining data between multiple tables.

|}

'''Key Knowledge Areas:'''

* Establish a database connection from NodeJS
* Retrieve data from the database in NodeJS
* Execute SQL queries from NodeJS
* Create simple SQL queries excluding joins
* Understand primary keys
* Escape variables used in SQL queries
* Awareness of SQL injections

'''Files, terms, and utilities:'''

* sqlite3 NPM module
* Database.run(), Database.close(), Database.all(), Database.get(), Database.each()
* CREATE TABLE
* INSERT, SELECT, DELETE, UPDATE

<br />

WebDevelopmentEssentials Objectives V1.0(JA) - Revision history

Okadaknj: /* 試験範囲の翻訳 */

Okadaknj at 15:14, 21 July 2021

Okadaknj at 15:11, 21 July 2021

Okadaknj at 14:47, 21 July 2021

Okadaknj at 14:20, 21 July 2021

Okadaknj at 14:03, 21 July 2021

Okadaknj at 13:57, 21 July 2021

Okadaknj: Created page with "__FORCETOC__ ==日本語ページ構築中Minimally Qualified Candidate== The candidate has a basic understanding of software development, the principle of the world wide w..."

Okadaknj: Created page with "FORCETOC ==日本語ページ構築中Minimally Qualified Candidate== The candidate has a basic understanding of software development, the principle of the world wide w..."