CIS-562.ABE1

CIS 562 Web Information Management

Intermediate Self-paced · 1 year access

49 Hands-On LiveLabs

Practice real IT tasks in guided environments.

  • Real environments
  • Auto-graded
  • No installation

01 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

26 Interactive Lessons · 265 topics
01 Web Database Programming Using PHP 8 topics
  • 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
02 XML: Extensible Markup Language 11 topics
  • 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
03 Strategies for Query Processing 12 topics · 4 LiveLab
  • 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 LiveLab in this lesson — see the labs panel →

04 Query Optimization 14 topics · 1 LiveLab
  • 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

1 LiveLab in this lesson — see the labs panel →

05 Introduction to Information Retrieval and Web Search 11 topics · 2 LiveLab
  • 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

2 LiveLab in this lesson — see the labs panel →

Hands-On Labs Our edge

49 LiveLabs
  • Identifying the steps of processing a high-level query
  • Counting the number of department from the table
  • Using NOT IN operator
  • Using INTERSECT operator
  • Unnesting query
  • Identifying the features of databases and IR systems
Labs run in your browser — nothing to install.

02 / FAQs

Questions before you start

Contact us ↗

Prepare for CIS 562 Web Information Management

One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.

  • 1 year of full access
  • 49 LiveLab included
  • Certificate of completion
Try Free

No credit card required

scroll to top