Dear friend! This web site is using the JavaScript code and ActiveX components that are essential for presenting the information effectively allowing easy navigation and positive browsing experience. Please enable them in your browser. We guarantee that it is absolutely SAFE to browse our web site with enabled JavaScript/ActiveX. Thank you for your patience!
The Region Leader in Professional Hands-On IT Training
Your Trusted Onsite Training Partner
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
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.