people sharing knowledge
 


home | offered | wanted | your account | about us | help


login

username

password

go

register








< back to search results
<< browse all categories

 book















Introduction to Database design with Microsoft SQL Server

courses


 with Vince Dooher






short description:
The aim of this asset is to provide students with the essential knowledge to design and develop databases with working examples in SQL server
 
long description:
This course will cover the basics of good database design from the level that the student feels most comfortable.

 
level of difficulty:
all welcome
 
minimum class size:
1
 
availability:
I am available Monday, Wedensday, Thursday and Friday evenings (after 5:30pm London Time) and all day Saturday and Sunday
 
fee comments:
n.a.
 
 session structure




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
 

discussion forums: 1
 










languages: English
duration: 21h 0m over 10 session(s)
fee: 100US$  (1000lp)
payment: at booking
delivery method: live online and self-paced

Quick Help




United Kingdom


Vince Dooher



description of :
I have worked in the IT industry in a variety of roles, from developer to IT Director, over the last 9 years.
I currently work for the British Library as a senior Technical architect.
I have delivered training in both a business and classroom environment to audiences with a wide range of skill levels from novice to technical experts.
 
Teacher's qualifications:
I have an MSc in Computing & information systems.
I have written training courses for Thomson Netg in VB.NET, C#, Web services and XML for all levels up to and including microsoft certification.
I am currently studying for Sun Certified enterprise Architect status.

 
's preferred teaching style:
I prefer to use example based learning techniques in combination with reference material. I believe that real world worked examples are the quickest way to gain an understanding of a subject. I am quite happy to take suggestions on example areas from students. If you have a specific project in mind I can create examples around this.
 



jobs | about us | contact us | terms of usage | privacy policy

Copyright ę 2012 Limu.com ltd. All rights reserved.