<% @LANGUAGE = VBScript%> <% Option Explicit Response.Expires = 0 Response.Buffer = True Sub sendMail() Dim mailSubject,mailBody,inEmail,badMail,inID,x,mailName,eMail inID = Trim(Request.Form("FormID")) inEmail = Trim(Request.Form("Email")) mailSubject = "" mailBody = "" If inStr(inEmail, "@") < 1 OR inStr(inEmail,"@") > Len(inEmail) OR inStr(inEmail,"@") = Len(inEmail) Then badMail = "BAD EMAIL: " If inID = "BOOKING" Then mailName = Trim(Request.Form("FirstName"))&" "&Trim(Request.Form("LastName")) mailSubject = mailSubject & "RADWEB BOOKING: "&Trim(Request.Form("Course")) Else mailName = Trim(Request.Form("FullName")) mailSubject = mailSubject & "RADWEB CONTACT: "&Trim(Request.Form("Course")) End If mailBody = "radtrain.co.za: "&mailSubject&"" mailBody = mailBody&"

" mailBody = mailBody&"Date: "&Year(Now)&"/"&Month(Now)&"/"&Day(Now) mailBody = mailBody&" ("&Hour(Now)&":"&Minute(Now)&")
" mailBody = mailbody&"Subject: "&mailSubject&"

" For Each x in Request.Form If x = "SB" OR x = "RB" OR x = "FormID" Then Else If x = "Email" Then mailBody = mailBody&""&x&": "&Trim(Request.Form(x))&"
" Else mailBody = mailBody&""&x&": "&Trim(Request.Form(x))&"
" End If End If Next mailBody = mailBody&"

" 'Response.Write mailBody Set eMail = Server.CreateObject( "JMail.Message" ) eMail.Logging = true eMail.silent = true eMail.From = inEmail eMail.FromName = mailName eMail.AddRecipient "info@radtrain.co.za", "Radical Training Website" eMail.Subject = mailSubject eMail.HTMLBody = mailBody eMail.Send("mail.radtrain.co.za") Set eMail = Nothing End Sub sendMail %> Radical Training CC


 

HOME PAGE
PHOTO GALLERY
FOCUS AND MISSION
CONTACT US
BOOKINGS
PRICES

International Institute of Business Analysis

2012 Schedule
06 to 11 May - SAD (Systems Development Workshop) - KZN
14 to 18 May - SAD (Systems Development Workshop) - JHB
20 to 25 May - BAD (Business Analyst Development Workshop) - JHB
03 to 08 June - BAD (Business Analyst  Development Workshop) KZN
15 to 19 October - SAD (Systems Development Workshop) - KZN
26 to 30 November - BAD (Business Analyst Development Workshop)

Course Overview
 RELATIONAL DATA ANALYSIS

Computer systems revolve around two main aspects: Functions and Data. The data and how it is stored has a profound effect on the performance and flexibility of a system.

Whereas the functionality of a system can reasonably easily be modified and enhanced; data is a different ball-game - experience has shown that changes are both difficult and expensive to implement.

This means that the setting up of the database and files need to receive careful attention, because if it is not done with flexibility and future expansion in mind, it often leads to a maintenance nightmare that costs an organisation dearly over the years to come.

This two-day workshop addresses these and other related issues. We at Radical Training have found that showing someone how to do an Entity Relationship Diagram takes only a few minutes and the response usually is: "That's so easy!" But when it comes to actually doing it, it suddenly 'not that easy'. For this reason we conduct our training in the form of a workshop using South African case studies, where each person is given opportunities of putting the theory into practice and receiving constructive feedback on performance.

 

ITINERARY:

  1. The importance of data and how it is stored

  2. Considerations in file design

  3. Definitions: Data structure, data element, relationship, different keys, entities, and more

  4. The main features of an Entity Relationship Diagram

  5. Relationships and how to find them using grids

  6. The pro's and con's of normalisation and also an overview of the concepts of the normalisation process

  7. How to gather the information needed to build ERD's

  8. Maintaining a business focus.

  9. Constructing an ERD - the 8-step approach and how to quality-check each step

  10. Data and processes - making the connection

  11. The entity 'life history' grid

  12. The value of enterprise modelling, especially for maintenance and enhancements

  13. Using ERD's to size systems

This workshop is conducted in-house or request and will also be modified to suit your unique needs.


For prices please visit our Price Schedule link or click here!