Programming & Development

55320 Programming with HTML, CSS, and JavaScript

Introduction:

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

Who Should Attend
The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Course Objectives
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog

Course Outline:

HTML is Part of a Team
Client-side Programming
Server-side Programming
Web Development Technologies

Exercise: A Simple HTML Document
Getting Started with a Simple HTML Document
HTML Elements, Attributes, and Comments
The HTML Skeleton
Viewing the Page Source
Special Characters
HTML Elements and Special Characters
History of HTML
The lang Attribute

Paragraphs
Heading Levels
Breaks and Horizontal Rules
Exercise: Paragraphs, Headings, and Text
The div Tag
Creating an HTML Page
Quoted Text
Preformatted Text
Inline Semantic Elements
Exercise: Adding Inline Elements

Links Introduction
Text Links
Absolute vs. Relative Paths
Targeting New Tabs
Email Links
Exercise: Adding Links
Lorem Ipsum
The title Attribute
Linking to a Specific Location on the Page
Targeting a Specific Location on the Page

Inserting Images
Image Links
Adding Images to the Document
Exercise: Adding Images to the Page
Providing Alternative Images

Unordered Lists
Ordered Lists
Definition Lists
Exercise: Creating Lists

Benefits of Cascading Style Sheets
CSS Rules
Selectors
Combinators
Precedence of Selectors
How Browsers Style Pages
CSS Resets
CSS Normalizers
External Stylesheets, Embedded Stylesheets, and Inline Styles
Exercise: Creating an External Stylesheet
Exercise: Creating an Embedded Stylesheet
Exercise: Adding Inline Styles
div and span
Exercise: Styling div and span
Media Types
Units of Measurement
Inheritance

font-family
@font-face
font-size
font-style
font-variant
font-weight
line-height
font shorthand
Exercise: Styling Fonts

About Color and Opacity
Color and Opacity Values
color
opacity
Exercise: Adding Color and Opacity to Text

letter-spacing
text-align
text-decoration
text-indent
text-shadow
text-transform
white-space
word-break
word-spacing
Exercise: Text Properties

JavaScript vs. EcmaScript
The HTML DOM
JavaScript Syntax
Accessing Elements
Where Is JavaScript Code Written?
JavaScript Objects, Methods, and Properties
Exercise: Alerts, Writing, and Changing Background Color

JavaScript Variables
A Loosely Typed Language
Google Chrome DevTools
Storing User-Entered Data
Exercise: Using Variables
Constants
Arrays
Exercise: Working with Arrays
Associative Arrays
Playing with Array Methods
JavaScript Operators
The Modulus Operator
Playing with Operators
The Default Operator
Exercise: Working with Operators

Global Objects and Functions
Exercise: Working with Global Functions
User-defined Functions
Exercise: Writing a JavaScript Function
Returning Values from FunctionsGlobal Objects and Functions
Exercise: Working with Global Functions
User-defined Functions
Exercise: Writing a JavaScript Function
Returning Values from Functions

Strings
Math
Date
Helper Functions
Exercise: Returning the Day of the Week as a String

Conditionals
Short-circuiting
Switch / Case
Ternary Operator
Truthy and Falsy
Exercise: Conditional Processing
Loops
while and do…while Loops
for Loops
break and continue
Exercise: Working with Loops
Array: forEach()

On-event Handlers
Exercise: Using On-event Handlers
The addEventListener() Method
Anonymous Functions
Capturing Key Events
Exercise: Adding Event Listeners
Benefits of Event Listeners
Timers
Typing TestOn-event Handlers
Exercise: Using On-event Handlers
The addEventListener() Method
Anonymous Functions
Capturing Key Events
Exercise: Adding Event Listeners
Benefits of Event Listeners
Timers
Typing Test

CSS Selectors
The innerHTML Property
Nodes, NodeLists, and HTMLCollections
Accessing Element Nodes
Exercise: Accessing Elements
Dot Notation and Square Bracket Notation
Accessing Elements Hierarchically
Exercise: Working with Hierarchical Elements
Accessing Attributes
Creating New Nodes
Focusing on a Field
Shopping List Application
Exercise: Logging
Exercise: Adding EventListeners
Exercise: Adding Items to the List
Exercise: Dynamically Adding Remove Buttons to the List Items
Exercise: Removing List Items
Exercise: Preventing Duplicates and Zero-length Product Names
Manipulating Tables

How HTML Forms Work
The form Element
Form Elements
Buttons
Exercise: Creating a Registration Form
Checkboxes
Radio Buttons
Exercise: Adding Checkboxes and Radio Buttons
Fieldsets
Select Menus
Textareas
Exercise: Adding a Select Menu and a Textarea
HTML Forms and CSS

Server-side Form Validation
HTML Form Validation
Accessing Form Data
Form Validation with JavaScript
Exercise: Checking the Validity of the Email and URL Fields
Checking Validity on Input and Submit Events
Adding Error Messages
Validating Textareas
Validating Checkboxes
Validating Radio Buttons
Validating Select Menus
Exercise: Validating the Ice Cream Order Form
Giving the User a Chance

Getting Started
Regular Expression Syntax
Backreferences
Form Validation with Regular Expressions
Cleaning Up Form Entries
Exercise: Cleaning Up Form Entries
A Slightly More Complex Example

Enroll in this course

$2,975.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.