| 7185.D1.1 |
Identify and define important evolutionary changes in modern markup and style languages. |
Lessons
|
| 7185.D1.2 |
Define and apply essential semantic and logical elements of HTML. |
Lessons
|
| 7185.D1.3 |
Use CSS to apply style to a single HTML element, a single Web page, and an entire Web site. |
Lessons
|
| 7185.D1.4 |
Create wireframes for a variety of viewports including mobile and desktop. |
Lessons
|
| 7185.D1.5 |
Write valid and responsive HTML and CSS code based on a wireframe. |
Lessons
|
| 7185.D1.6 |
Develop Web pages and sites using current industry and W3C standards without the support of WYSIWYG software. |
Lessons
|
| 7185.D1.7 |
Understand appropriate application of Tables to complete web sites. |
Lessons
|
| 7185.D1.8 |
Develop Web pages and sites that follow the “Mobile First” and “Responsive Web Design” (RWD) approach to Web development. |
Lessons
|
| 7185.D1.9 |
Identify essential ethical and legal issues in developing and maintaining a Web site. |
Lessons
|
| 7185.D1.10 |
Apply the phases of the SDLC and the principles of project management to design, develop, test, implement, and maintain a Web site. |
Lessons
|
| 7185.D1.11 |
Use Creative Commons licensing and attributions to offer usage rights, reserve other rights, and comply with existing copyright licenses for images and multimedia elements on a Web site. |
Lessons
|
| 7185.D1.12 |
Apply common techniques to improve search engine rankings and enhance the marketing of a Web site. |
Lessons
|
| 7185.D1.13 |
Trace and explain programs in JavaScript or other client-side scripting languages encoding operators, variables, arrays, control structures, events, and functions. |
Lessons
|
| 7185.D1.14 |
Explain the behavior of HTTP including GET and POST. |
Lessons
|
| 7185.D1.15 |
Examine secure programming including HTTPS and languages such as SQL injections. |
Lessons
|
| 7185.D2.1 |
Define data and evaluate its need for decision-making in a business setting |
Lessons
|
| 7185.D2.2 |
Identify, define or describe the types and nature of databases in a business setting. |
Lessons
|
| 7185.D2.3 |
Compare and contrast the general structure and organization of relational, hierarchical, and network database structures. |
Lessons
|
| 7185.D2.4 |
Demonstrate an understanding of the relational data model. |
Lessons
|
| 7185.D2.5 |
Given a scenario, plan, design, create and modify a database schema. |
Lessons
|
| 7185.D2.6 |
Document a database by creating entity-relationship diagrams (ERDs), describing the field names, field types, and relationships among tables. |
Lessons
|
| 7185.D2.7 |
Apply normalization techniques to the design of databases, and define and describe the 1NF, 2NF, 3NF, and BCNF. |
Lessons
|
| 7185.D2.8 |
Define and describe higher normal forms. |
Lessons
|
| 7185.D2.9 |
Discover unstructured data techniques including Key-pair and JSON. |
Lessons
|
| 7185.D2.10 |
Retrieve, insert, update, and manipulate data using SQL commands. |
Lessons
|
| 7185.D2.11 |
Create and manage tables and data bases using an integrated environment like SQL Management Studio. |
Lessons
|
| 7185.D2.12 |
Successfully identify and debug errors in SQL queries. |
Lessons
|
| 7185.D2.13 |
Create and manage user roles on a SQL database server. |
Lessons
|
| 7185.D2.14 |
Define stored procedures, triggers, views and functions. |
Lessons
|
| 7185.D2.15 |
Identify data integrity and security requirements. |
Lessons
|
| 7185.D2.16 |
Discuss the concepts and use of big data, data warehousing, and data mining. |
Lessons
|
| 7185.D2.17 |
Discuss the use and implementation of distributed database systems. |
Lessons
|
