sql-and-creating-database-structure
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
- Section 11 (RDBMS Implementation of the Physical Model)
- 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=45790&chunkid=1&rowid=2
Lynda:
SQL Essential Training Video | Lynda
Websites:
Microsoft (Databases) http://msdn.microsoft.com/en-us/library/windows/desktop/ff728828(v=vs.85).aspx
Software:
One of the following database platforms:
