uCertify

CIS 562 Web Information Management

(CIS-562.ABE1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Instructor-Led (Add-on)
Get A Free Trial

Skills You’ll Get

Get the support you need. Enroll in our Instructor-Led Course.

Download Course Outline

1

Web Database Programming Using PHP

  • A Simple PHP Example
  • Overview of Basic Features of PHP
  • Overview of PHP Database Programming
  • Brief Overview of Java Technologies for Database Web Programming
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
2

XML: Extensible Markup Language

  • Structured, Semistructured, and Unstructured Data
  • XML Hierarchical (Tree) Data Model
  • XML Documents, DTD, and XML Schema
  • Storing and Extracting XML Documents from Databases
  • XML Languages
  • Extracting XML Documents from Relational Databases
  • XML/SQL: SQL Functions for Creating XML Data
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
3

Strategies for Query Processing

  • Translating SQL Queries into Relational Algebra and Other Operators
  • Algorithms for External Sorting
  • Algorithms for SELECT Operation
  • Implementing the JOIN Operation
  • Algorithms for PROJECT and Set Operations
  • Implementing Aggregate Operations and Different Types of JOINs
  • Combining Operations Using Pipelining
  • Parallel Algorithms for Query Processing
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
4

Query Optimization

  • Query Trees and Heuristics for Query Optimization
  • Choice of Query Execution Plans
  • Use of Selectivities in Cost-Based Optimization
  • Cost Functions for SELECT Operation
  • Cost Functions for the JOIN Operation
  • Example to Illustrate Cost-Based Query Optimization
  • Additional Issues Related to Query Optimization
  • An Example of Query Optimization in Data Warehouses
  • Overview of Query Optimization in Oracle
  • Semantic Query Optimization
  • Summary
  • Review Questions
  • Exercises
  • Selected Bibliography
5

Introduction to Information Retrieval and Web Search

  • Information Retrieval (IR) Concepts
  • Retrieval Models
  • Types of Queries in IR Systems
  • Text Preprocessing
  • Inverted Indexing
  • Evaluation Measures of Search Relevance
  • Web Search and Analysis
  • Trends in Information Retrieval
  • Summary
  • Review Questions
  • Selected Bibliography
6

Data Mining Concepts

  • Overview of Data Mining Technology
  • Association Rules
  • Classification
  • Clustering
  • Approaches to Other Data Mining Problems
  • Applications of Data Mining
  • Commercial Data Mining Tools
  • Summary
  • Review Questions
  • Selected Bibliography
7

Introduction to the World of Big Data

  • Understanding Big Data
  • Evolution of Big Data
  • Failure of Traditional Database in Handling Big Data
  • 3 Vs of Big Data
  • Sources of Big Data
  • Different Types of Data
  • Big Data Infrastructure
  • Big Data Life Cycle
  • Big Data Technology
  • Big Data Applications
  • Big Data Use Cases
8

Big Data Storage Concepts

  • Cluster Computing
  • Distribution Models
  • Distributed File System
  • Relational and Non‐Relational Databases
  • Scaling Up and Scaling Out Storage
9

Big Data Processing, Management, and Cloud Computing

  • Part I: Big Data Processing and Management Conce...essing, Management Concepts, and Cloud Computing
  • Data Processing
  • Shared Everything Architecture
  • Shared‐Nothing Architecture
  • Batch Processing
  • Real‐Time Data Processing
  • Parallel Computing
  • Distributed Computing
  • Big Data Virtualization
  • Part II: Managing and Processing Big Data in Clo...essing, Management Concepts, and Cloud Computing
  • Introduction
  • Cloud Computing Types
  • Cloud Services
  • Cloud Storage
  • Cloud Architecture
10

Driving Big Data with Hadoop Tools and Technologies

  • Apache Hadoop
  • Hadoop Storage
  • Hadoop Computation
  • Hadoop 2.0
  • HBASE
  • Apache Cassandra
  • SQOOP
  • Flume
  • Apache Avro
  • Apache Pig
  • Apache Mahout
  • Apache Oozie
  • Apache Hive
  • Hive Architecture
  • Hadoop Distributions
11

What Is Web Publishing?

  • Thinking Like a Web Publisher
  • Web Browsers
  • Web Servers
  • Uniform Resource Locators
  • Defining Web Publishing Broadly
  • Summary
  • Workshop
  • Additional Exercises
12

Getting Your Tools in Order

  • Anatomy of a Website
  • Setting Up Your Computer for Web Publishing
  • Using the Google Chrome Developer Tools
  • What Do You Want to Do on the Web?
  • Wireframing Your Website
  • Web Hosting
  • Summary
  • Workshop
  • Additional Exercises
13

Introducing HTML and CSS

  • What HTML Is (And What It Isn't)
  • What HTML Files Look Like
  • HTML Attributes
  • Using the style Attribute
  • A Short History of HTML Standards
  • The Current and Evolving Standard: HTML5
  • Summary
  • Workshop
  • Additional Exercises
14

Learning the Basics of HTML

  • Structuring Your HTML
  • The Title
  • Headings
  • Paragraphs
  • Comments
  • Summary
  • Workshop
  • Additional Exercises
15

Organizing Information with Lists

  • Lists: An Overview
  • Numbered Lists
  • Unordered Lists
  • Definition Lists
  • Nesting Lists
  • Other Uses for Lists
  • Summary
  • Workshop
  • Additional Exercises
16

Working with Links

  • Creating Links
  • Linking Local Pages Using Relative and Absolute Pathnames
  • Links to Other Documents on the Web
  • Linking to Specific Places Within Documents
  • Anatomy of a URL
  • Kinds of URLs
  • Summary
  • Workshop
  • Additional Exercises
17

Formatting Text with HTML and CSS

  • Character-Level Elements
  • Character Formatting Using CSS
  • Preformatted Text
  • Horizontal Rules (or Thematic Breaks)
  • Line Break
  • Addresses
  • Quotations
  • Special Characters
  • Fonts and Font Sizes
  • Summary
  • Workshop
  • Additional Exercises
18

Using CSS to Style a Site

  • Including Style Sheets in a Page
  • Selectors
  • Units of Measure
  • Editing Styles with Developer Tools
  • Using Color
  • Links
  • The Box Model
  • More Selectors
  • The <body> Tag
  • Summary
  • Workshop
  • Additional Exercises
19

Using Images on Your Web Pages

  • Images on the Web
  • Image Formats
  • Inline Images in HTML: The <img> Tag
  • Images and Text
  • Images and Links
  • Other Neat Tricks with Images
  • Image Backgrounds
  • Using Images as Bullets
  • What Is an Imagemap?
  • Image Etiquette
  • Summary
  • Workshop
  • Additional Exercises
20

Building Tables

  • Creating Tables
  • Table Parts
  • Sizing Tables, Borders, and Cells
  • Table and Cell Color
  • Aligning Your Table Content
  • Spanning Multiple Rows or Columns
  • More Advanced Table Enhancements
  • How Tables Are Used
  • Summary
  • Workshop
  • Additional Exercises
21

Using CSS to Position Elements on the Page

  • Positioning Schemes
  • Absolute Positioning
  • Fixed Positioning
  • Controlling Stacking
  • Creating Drop-Down Menus
  • Summary
  • Workshop
  • Additional Exercises
22

Designing Forms

  • Understanding Form and Function
  • Using the <form> Tag
  • Using the <label> Tag
  • Creating Form Controls with the <input> Tag
  • Using Other Form Controls
  • Grouping Controls with fieldset and legend
  • Displaying Updates with progress and meter
  • Applying Cascading Style Sheet Properties to Form Elements
  • Planning Your Forms
  • Summary
  • Workshop
  • Additional Exercises
23

Structuring a Page with HTML5

  • A Short History of HTML Page Layout
  • Laying Out a Page in HTML5
  • HTML5 Structural Tags
  • The Page Outline
  • Using HTML5 Structural Elements
  • Summary
  • Workshop
  • Additional Exercises
24

Integrating Multimedia: Video and Sound

  • Embedding Video the Simple Way
  • Hosting Your Own Video
  • Embedding Video Using <video>
  • Embedding Flash Using the <object> Tag
  • The <embed> Tag
  • Embedding Flash Movies Using SWFObject
  • Flash Video Players
  • Embedding Audio in Your Pages
  • Summary
  • Workshop
  • Additional Exercises
25

Advanced CSS: Page Layout in CSS

  • Laying Out the Page
  • The Role of CSS in Web Design
  • Summary
  • Workshop
  • Additional Exercises
26

Using Responsive Web Design

  • What Is Responsive Web Design?
  • Mobile Devices Should Come First
  • Planning a Responsive Website
  • Writing Media Queries
  • Understanding the Mechanics of RWD
  • Responsive Web Design Best Practices
  • Summary
  • Workshop
  • Additional Exercises

1

Strategies for Query Processing

  • Identifying the steps of processing a high-level query
  • Counting the number of department from the table
  • Using NOT IN operator
  • Using INTERSECT operator
2

Query Optimization

  • Unnesting query
3

Introduction to Information Retrieval and Web Search

  • Identifying the features of databases and IR systems
  • Identifying types of queries
4

Data Mining Concepts

  • Understanding the applications of data mining
5

Introduction to the World of Big Data

  • Discussing Big Data Characteristics
  • Discussing Big Data
6

Big Data Storage Concepts

  • Discussing Big Data Storage
7

Big Data Processing, Management, and Cloud Computing

  • Implementing the Data Processing Cycle
  • Discussing Big Data Processing and Management Concepts - Part I
  • Discussing Big Data Processing and Management Concepts - Part II
8

Driving Big Data with Hadoop Tools and Technologies

  • Discussing Components of Hadoop
  • Discussing Big Data Using Hadoop Tools and Technologies
9

Introducing HTML and CSS

  • Creating a Basic HTML Page
10

Learning the Basics of HTML

  • Using Paragraphs and Headings in HTML
11

Organizing Information with Lists

  • Organizing Content in HTML
12

Working with Links

  • Creating Hyperlinks
13

Formatting Text with HTML and CSS

  • Formatting Text in HTML
14

Using CSS to Style a Site

  • Creating the External Style Sheet
  • Using CSS IDs
  • Implementing a Class
  • Creating an Internal Style Sheet
  • Implementing Inline Styles
  • Using Positioned Floats
  • Using Overflow Properties
15

Using Images on Your Web Pages

  • Implementing the SVG Format
  • Using Inline Flow vs. Block Flow in CSS and Float Properties
  • Using the Image Tag
16

Building Tables

  • Organizing Content in HTML Part 1
17

Using CSS to Position Elements on the Page

  • Using the Absolute Position Property
  • Implementing CSS Overlapping and Positioning
18

Designing Forms

  • Using the Pattern Attribute
  • Using the Required Attribute
  • Using the Types of Input Fields
  • Using the Input Tag
  • Implementing the Checkbox Input and Using the Textarea Tag
  • Using the Select Tag
  • Using the Mark, Meter, and Progress Tags
19

Structuring a Page with HTML5

  • Using the Header and Footer Tags
  • Using the Nav Tag
  • Using the Article Tag
  • Using the Section Tag
  • Using the Aside and Hr Tags
20

Integrating Multimedia: Video and Sound

  • Using the Video Tag
21

Advanced CSS: Page Layout in CSS

  • Implementing CSS Columns and Hyphenations
22

Using Responsive Web Design

  • Using Media Query

Related Courses

All Courses