|
title:
|
|
type:
|
|
description:
|
|
duration:
|
|
Introduction to Database theory
|
|
lecture
|
|
Relational databases concepts
Database technology and terminology
Best practice design methods
Explanation of relational structure
|
|
2h 0m
|
|
|
Introduction to Database design
|
|
lecture
|
|
Scenario analysis
Modelling methods explained
Introduction to entity relationship diagrams
explanation of normalisation
|
|
2h 0m
|
|
|
Database design
|
|
prepare assigment
|
|
A short exercise where the student will attempt a database design from a provided scenario
|
|
3h 0m
|
|
|
MS SQL Server interface explained
|
|
lecture
|
|
Installation and configuration of SQL Server
Navigation of the SQL server interface
Introduction to SQL server security models
|
|
2h 0m
|
|
|
Creating Tables & Views
|
|
live session
|
|
Creating and relating tables in a MS SQL server database.
Create Views of table data.
|
|
2h 0m
|
|
|
Create SQL Server database
|
|
other
|
|
The student will use the database design created in an earlier session and create that database in MS SQL Server
|
|
2h 0m
|
|
|
Introduction to SQL
|
|
lecture
|
|
This is a brief introduction to Structured Query Language (SQL) It will cover
Select, Insert, Update and Delete statement syntax, joins, Create Alter and Drop statements
|
|
2h 0m
|
|
|
Introduction to Stored Procedures
|
|
lecture
|
|
In this session the student will learn basic T-SQL syntax and how and when to use Stored procedures
|
|
2h 0m
|
|
|
Creating Queries
|
|
other
|
|
The student will use their knowledge of SQL and stored procedures to create and execute queries against their SQL server database
|
|
2h 0m
|
|
|
Other SQL Server Tools
|
|
lecture
|
|
This session will introduce students to the other tools available within SQL server. This will include the SQL profiler, the wizards and security management
|
|
2h 0m
|
|
|
total duration: 21h 0m over 10 session(s)
comments: This will be broken in 5 1 hour sessions
|
