The Region Leader in Professional Hands-On IT TrainingProfessional Hands-On IT TrainingYour Trusted Onsite Training Partner
Computer Training at Your Site
IT Training and Certification Guru
Computer Training. Dreamweaver Training. Adobe Training
You Are Here: You Are Here-->  Home >> Courses >> Database/SQL

The most effective way to get real world experience through hands-on training!
 
Web Module 313
Instructor-led, on-site training program



Our 'Gold Reserve'
       
cnet    Introduction
   Prerequisites
   Who Should Attend
   Registration
   Course Objectives
   Course Materials
   Tuition Fee

  INTRODUCTION
This one-session program is intended to train IT professionals who desire to learn about the basics of the Relational Database for building the professional-grade web sites.

  PREREQUISITES
It is recommended that the students, in addition to user-level experience using Windows - based personal computers, have a basic familiarity with the Internet, and HTML coding.

  WHO SHOULD ATTEND
Corporate IT Employeesand small business owners: who want to acquire new skills or those who want to update their skills learning about utilizing relational database to build the e-commerce web sites.

  COURSE MATERIALS
You get:
  • Highly qualified Instructors with extensive industry experience and excellent teaching skills
  • Printouts from Instructor targeted to specific course objectives
  • Two Web Developer CD disks packed with electronic books, tutorials, and links to technical resources

  COURSE OBJECTIVES
Every Web Developer must know how to create, improve, and manage database-enabled Web sites in the ever-changing world of the Web. Most of the information assets often are already available but not yet accessible. You will learn:
* How to improve your Web Site with database tools
* How to add Web Database connectivity using ODBC to integrate multiple databases into your Web
* The technique of implementing MS-SQL, MS-Access and Oracle databases for your Web site

Note: RTEK 2000 reserves the right to change the curriculum in response to market demands.
Module Web-313.

  Introduction to Database Design

Chapter 1: Introduction to Database Design
  • Software Development Life Cycle
  • The relation model
  • Techniques of Design

Chapter 2: Data Modeling
  • What are a Data Model
  • Entities and attributes
  • Table Diagrams and data modeling.

Chapter 3: Relationships
  • Types of relationships
  • Foreign Keys
  • Referential Integrity.

Chapter 4: Normalization
  • Normalization
  • Normalization advantages and disadvantages
LAB. Objective: Get the practical skills in design of a simple database.

  The SQL

Chapter 5: The SQL
  • What is SQL, why we need it, types of SQL Languages.
  • Introduction to the SELECT Statement
  • Single Table Queries
  • Selecting Specific Rows
  • Calculating fields
  • Working with Operators

LAB. Objective: Get the practical skills in writing the select statements for a simple database.
Chapter 6: Queries
  • Multiple Table Queries
  • Aliases
  • Joins
  • Modifying Data
  • Grouping Querying a database using Access, MS SQL, and Oracle

LAB. Objective: Get the practical skills in writing the select statements for a simple database.

LAB. Objective: Get the practical skills in utilizing MS-Access for analyses and design of databases. Get hands-on experience in working with the table using SQL statements.


Copyright © 1999-2006 RTEK 2000, Inc. The Internet Technology Trainers. All rights reserved. Send your comments and questions to our . Direct all comments about these pages to our Webmaster. Designed by 800-WEBDESIGN.COM