sql and creating database structure

/in /by

On Motel Industry

Introduction

This module provides an overview of the Structured Query Language (SQL). The database will be created according to the database design and will be tested to satisfy the database defined requirements from Module 1.

Module Competencies:

  • Determine the SQL (DDL and DML) requirements to support an organizations data needs.

Task 3:

Create a Database Structure for the project.Provide sample copies of the structure and an update on project status.

  • SQL Essentials
  • Database Structure (DDL)
  • Watch “SQL Essential Training” Video | Lynda
  • Read / Review the following Section from: Data Modeling-Logical Database Design
    • Section 11 (RDBMS Implementation of the Physical Model)
      • Workshop Section: Review and Complete the exercise

SQL Essential Training

  • Create the Database Structure

Module 3 Resources

eBook:

  • Introduction to Database Management System – By: Satinder Bal Gupta and Aditya Mittal
  • Data Modeling—Logical Database Design By: By: Sideris Courseware Corporation
  • Microsoft MySQL
  • Microsoft SQL Server
  • OracleSQL Server

(http://library.books24x7.com.ezp-02.lirn.net/assetviewer.aspx?bookid=34047&chunkid=518679005&rowid=1072

http://library.books24x7.com.ezp-02.lirn.net/assetviewer.aspx?bookid=45790&chunkid=1&rowid=2

Lynda:

SQL Essential Training Video | Lynda

http://www.lynda.com/SQL-tutorials/SQL-Essential-Training/139988-2.html?srchtrk=index:1%0Alinktypeid:2%0Aq:sql%0Apage:1%0As:relevance%0Asa:true%0Aproducttypeid:2

Websites:

Microsoft (Databases) http://msdn.microsoft.com/en-us/library/windows/desktop/ff728828(v=vs.85).aspx

Software:

One of the following database platforms: