Internet Business Associate
• Internet connection methods, internet protocols, the Domain Name System (DNS), cloud computing and mobile devices
• Basic functions of web browsers, the components of web addresses and browser use in the business world
• How browser plug-ins and add-ons can improve your web-browsing experience, and how you will use browsers to download and manage files

Network Technology Associate
• Essential networking technologies and skills, including TCP/IP, stable network creation, wireless networking, mobile devices and
network troubleshooting*
• Different types of transmission media
• Functions, features and technologies associated with internet services, such as cloud computing

Site Development Associate
• Develop web sites using Hypertext Markup Language version 5 (HTML5) and Cascading Style Sheets (CSS)
• Write code manually, as well as use graphical user interface (GUI) authoring tools, insert images, create hyperlinks, and add tables, forms, video, and audio to your web pages

*It is important to note that although all browsers are supported, knowledge of Internet Explorer will be particularly beneficial. TCP/IP is geared towards the Windows Operating System, however is accessible for Mac users. Please speak directly to your tutor should you have any queries.
 

CIW Advanced HTML5 & CSS3 Specialist
HTML5 - Hypertext Markup Language version 5 / CSS3 - Cascading Style Sheets version 3
• Builds upon your manual coding skills
• How to develop web documents
• Create web pages using the HTML5 structure elements
• Embed video and audio
• Develop cross-browser user-input forms
• Use CSS3 to position and format content and to create effects such as transformations, transitions and animation

CIW JavaScript Specialist
• Design client-side, platform-independent solutions that greatly increase the value of your web site by providing interactivity and interest
• How to use JavaScript to communicate with users
• Modify the Document Object Model (DOM)
• Control program flow
• Validate forms, animate images, create cookies, change XHTML on the fly, and communicate with databases

• Setting up your environment, Installing visual studio code, Installing Node.js and yarn

• Setting up a web server, Setting up Babel, Exploring JSX, JSX expressions, conditional rendering in JSX, ES6 Aside: const and let, Arrow functions, Events and attributes

• ES6 classes: Part 1, Part 11, Creating a React Component, Nesting Components, Component Props, Events and Methods, Method Binding, What is Component State?, Adding State to Counter App, Alternative setState Syntax, Build it: Adding state to VisibilityToggle, Indecision State: Part 1 and Part 11, Summary: Props vs. State

• The Stateless Functional Component, Default Prop Values, React Dev Tools, Removing Individual Options, Lifecycle Methods, Saving and Loading Options Data, Saving and Loading the Count

• What is Webpack?, Avoid Global Modules, Installing & Configuring Webpack, ES6 Import/export, Default Exports, Importing npm Modules, Setting up Babel with Webpack, Once Component per file, Source Maps with Webpack, Webpack Dev Server, ES6 class properties

• Section Intro: Using a Third-Party Component, Passing Children to Component, Setting up React-Modal, Bonus: Refactoring Other Stateless Functional Components

• Section Intro: Styling React, Setting up Webpack with SCSS, Architecture and header Styles, Reset that $#!*, Theming with Variables, Big Button & Options List, Styling the Options List, Styling Option Item, Styling React-Modal, Mobile Considerations, Bonus: Favicon

• Section Intro: React Router, Server vs. Client Routing, Setting Up Budget App, React-Router 101, Setting up a 404, Linking Between Routes, Organizing Our Routes, Query Strings and URL Parameters, Build It: Router for Portfolio Site

• Section Intro: Redux, Why Do We Need Something Like Redux?, Setting up Redux, Dispatching Actions, Subscribing and Dynamic Actions, ES6 Object Destructuring, ES6 Array Destructuring, Refactoring and Organizing, Reducers, Working with Multiple Reducers, ES6 Spread Operator in Reducers, Spreading Objects, Wrapping up Our Reducers, Filtering Redux Data, Sorting Redux Data

• Section Intro: Connecting React and Redux, Organizing Redux, The Higher Order Component, Connecting Store and Component with React-Redux, Rendering Individual Expenses, Controlled Inputs for Filters, Dropdown for Picking SortBy, Creating Expense Add/Edit Form, Setting up a Date Picker, Wiring up Add Expense, Wiring up Edit Expense, Redux Dev Tools, Filtering by Dates

• Section Intro: Testing React Components, Setting up Jest, Testing Expenses Action Generators, Testing Filters Action Generators, Testing Expenses Selector, Testing Filters Reducer, Testing Expenses Reducer, Snapshot Testing, Enzyme, Snapshot Testing with Dynamic Components, Mocking Libraries with Jest, Testing User Interaction, Test Spies, Testing Add Expense Page, Testing Edit Expense Page, Testing Expense List Filters, Testing Expense List Filters: Part II

• Section Intro: Deploying Your Apps, Installing Git, What is Git?, Integrating Git into Our Project, Setting up SSH and Github, Production Webpack, Creating Separate CSS Files, A Production Web Server with Express, Deploying with Heroku, Regular vs Development Dependencies, New Feature Workflow, Build It: Adding Total Selector, Build It: Adding Summary Component

• Section Intro: Firebase 101, Getting Firebase, Writing to the Database, ES6 Promises, Promises with Firebase, Removing Data from Firebase, Updating Data, Fetching Data From Firebase, Array Data in Firebase: Part I, Array Data in Firebase: Part II

• Section Intro: Firebase with Redux, Asynchronous Redux Actions, Testing Async Redux Actions: Part I, Testing Async Redux Actions: Part II, Creating a Separate Test Database, Heroku Environment Variables, Fetching Expenses: Part I, Fetching Expenses: Part II, Remove Expense, Update Expense

• Section Intro: Firebase Authentication, Login Page and Google Authentication, Logging Out, Redirecting Login or Logout, The Auth Reducer, Private Only Routes, Public Only Routes, Private Firebase Data, Data Validation and Deployment

• Section Intro: Styling Budget App, Styling Login Page, Styling Buttons, Styling Summary Area, Styling List Filters, Styling Inputs, Styling Expense Form, Styling Expenses List: Part I, Styling Expenses List: Part II, Adding Loader, Babel Polyfill, Final Deployment

• Section Intro: What Now?, Creating the Final Boilerplate, Budget App Enhancements, Indecision App Enhancements, New App Idea: Blog, Until Next Time

• About SQL Server 2012/2014
• About Transact-SQL (T-SQL)

• Creating Tables
• Modifying Existing Tables
• Understanding Indexes
• Understanding Views

• Creating and Modifying Constraints
• Understanding Triggers
• Modifying Triggers

• Using SELECT Statements
• Implementing Subqueries
• Implementing Data Types
• Implementing Aggregate Queries
• Managing XML Data

• Understanding Stored Procedures
• Using DML Statements
• Combining Datasets
• Working with Functions

• Tuning and Optimizing Queries
• Managing Transactions
• Evaluating Operations
• Implementing Error Handling
• Summary