Introduction to Database Design

Introduction to Database Design online course
Course Name

Introduction to Database Design

Database design is crucial to effectively implement a relational database. In this course we discuss the parts of a database, how to model data, database construction, and developing a database in a business environment. These skills are fundamental to managing database backed websites, or any relational database application.

Applicable Job Roles: web programmers, web application developers, database administrator, webmasters, and web project managers.

Outline
Week 1:
  • Describe and define Database Management System (DBMS)
  • List and evaluate database models
  • Describe the relational database model
  • Describe the role of databases in information management
Week 2:
  • Define business entities and business rules
  • Describe entities and tables
  • Describe attributes and columns
  • Understand data types
  • Understand relationships and cardinality
Week 3:
  • Understand Data Definition Language (DDL)
  • Understand Data Manipulation Language (DML)
  • Understand Data Query Language (DQL)
  • Undetstand the role of SQL in the relational database
  • Understand rudimentary SQL commands
  • Describe database construction methods
Week 4:
  • Understand primary keys
  • Understand surrogate and composite keys
  • Understand foreign keys
  • Understand normalization and normal forms
  • Understand denormalization
  • Identify and resolve anomalies
Week 5:
  • Understand entity relationship modeling
  • Create ER diagrams
  • Understand process modeling
  • Implement a database
Week 6:
  • Describe naming conventions
  • Understand indices
  • Understand the client/server model
  • Understand how databases are used with applications
  • Understand how databases are used with the web
  • List and evaluate common database application languages
Prerequisites
None
Requirements
Microsoft Access 97 or later, OR OpenOffice Base, OR Filemaker Pro. Note that OpenOffice Base is available as a free download.
Course Books

Required Book Databases Demystified [
]
Course Price
  • Member Price: $80 US
  • Non-Member Price: $180.00 US
[Register Now]

Additional Information:
Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page.

How eClasses Work:Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Dreamweaver Online CourseBuilding Data-Driven Websites Course
Adobe Flash Adv. Online Course Flash Design Course Adobe Fireworks Online Course
Flash Level 2 CourseWeb Videography CourseContracting Your Services - Online Course
Web Design Legal Issues CourseContracting Your Services - Online CourseApache Admin Course
Blog Content Writing Course - OnlineWeb Content Writing Skills CourseDNS Administration Course
UNIX Administration Course - OnlineGoogle Web Analyics CourseWordpress Theme Design Course
Wordpress Content Management CourseDrupal Beginner CourseProject Management Training Course
Joomla Training CourseJoomla 2 Course OlineLogo Design Concepts Course
Website Project Management CourseWeb Design Legal Issues CourseWeb Design Legal Issues Course
Search Engine Optimization CourseWebsite Promotion and Marketing Course - OnlineEmail Marketing Course Strategies
Social media Marketing CourseSocial media Marketing CourseAccessible Web Design Course
Web Design Concepts Training CourseWeb Design Course Training OnlineAdobe Muse Course
Mobile UI Design Course TrainingWeb Design Concepts Training CourseWeb Design Concepts Training Course
Adobe Photoshop CoursePhotoshop for Web Graphics CoursePhotoshop Retouching Course
Adobe InDesign CourseAdobe Illustrator Online CourseIllustrator Design 2 - Online Course
Adobe Edge Animate CourseHTML Beginners CourseHTML Level 2 Course
Mobile Web Design Online CourseHTML5 Online CourseCascading Style Sheets Online Course
Cascading Style Sheets Level 2 Online TrainingCSS 2.1 in Depth Online CourseCSS3 Online Course
CSS3 Online CourseCSS3 Online CourseMobile Web Design Online Course
XHTML Online Course Web TrainingDatabase Design Online Web CourseSQL Using Access Online Course
SQL Using MySQL Online Web TrainingMySQL Online CourseSQL Server Online Course
Programming Concepts Online Web TrainingPHP Online CourseShopping Cart using PHP and MySQL Online Web Training
PHP Online CourseJSP Web TrainingColdFusion Web Development Online Class
ColdFusion Web Development Online Web Training Level 2JavaScript for Beginners Online Web TrainingJavaScript Level 2 Online Course
AJAX Programming Online Web Training CoursejQuery Web Programming Online CourseJava for Non-Programmers Web Training Course
Beginning Java Programming Online CourseJava Programming Web TrainingPerl Beginner Course
C# Beginning Programming Online CourseBeginning ASP.NET Web Development Online CourseVisual Basic.Net Programming Online Course
ASP Programming for Beginners Online CourseASP Programming Second Level Online CourseASP Web Development with C# Programming Online Course
PHP Online CourseJavaScript for Beginners Online Web TrainingWeb Security Training Online Course
XML Web Programming Online CourseXML Programming for the Web Online CourseAndroid Application Development Online Course
Game Programming and Production Online CourseGame Development and Design Web TrainingProgramming Flash Games Online Course
Video Game Programming using C++ Online CourseGame Programming on Windows using C++ Online Course3D Video Game Programming using DirectX Online Course