Home
Videos uploaded by user “Brian Green”
SQL Lab 1 - Exploring AdventureWorks
 
06:10
This lab is intended to acclimate students with Management Studio Express using the AdventureWorks database.
Views: 6739 Brian Green
Logical Database Design and E-R Diagrams
 
32:23
This video explores logical database design (a pre-cursor to physical database design) and demonstrates the use of Entity Relationship Diagrams.
Views: 66022 Brian Green
Database Normalization
 
26:53
An overview on how to normalize a database for a relational database management system.
Views: 11754 Brian Green
Visio 2013 - Database DIagram (Crows Foot Notation)
 
22:20
This video demonstrates using Crow's Foot Notation to create a database diagram using MS Visio 2013.
Views: 48458 Brian Green
Creating a Database with Tables and Relationships (MS SQL)
 
29:00
Creating a Database with Tables and Relationships using Microsoft Management Studio Express for Microsoft SQL Server 2008 Express
Views: 111412 Brian Green
OO Systems Analysis and Design Overview (Part 2)
 
57:46
We will learn about the systems development life cycle, which we will be using and referencing throughout the course. We apply the SDLC and the core processes to a simple example, and demonstrate some OO-SAD project deliverables (which are covered in much more detail later).
Views: 35878 Brian Green
Introduction to OO Systems Analysis and Design Course (Part 1)
 
10:20
This is a brief introduction to Drexel's Systems Analysis and Design course. This includes what to expect throughout the course, and some thoughts about success for this course.
Views: 64067 Brian Green
OO Systems Analysis and Design - Domain Class Modeling (Part 5)
 
01:04:18
This video explains Domain Class Model Diagramming for systems analysis in UML (Note: class diagrams for systems design are discussed in another video). Structured techniques for data modeling are also presented, such as E-R diagrams.
Views: 17279 Brian Green
Systems Analysis & Design - Investigating System Requirements (Part 3)
 
44:34
In this presentation, I will discuss exactly what requirements are, and why it is important to accurately capture them. We will look at specific techniques to gathering requirements, and then discuss some modeling techniques for demonstrating our understanding of the requirements (which will be covered in more detail later).
Views: 19834 Brian Green
Database Project for MS SQL Server
 
39:05
This project uses the Westlake Database project. It adds the tables needed to patient visits / symptoms, adds stored procedures, triggers and indexes, and asks the student to create views using query skills learned previously. The importance of database security to prevent SQL injection attacks is also demonstrated, and mitigated through the use of stored procedures. In addition, indexes are discussed and demonstrated.
Views: 26489 Brian Green
Systems Development Lifecyle - An Introduction
 
19:57
This presentation is based on the content of Chapter One: Modern Systems Analysis and Design by Joseph Valacich. In this presentation, I discuss an introduction to the Systems Analysis and Design discipline. Various forms of the SDLC are discussed, as well as the techniques, tools and methodologies. In addition, the iterative nature of information systems design is stressed and explained.
Views: 1089 Brian Green
Systems Analysis and Design: Databases and Controls (Part 12)
 
38:49
Most systems projects will require the use of databases for persistence. Up to this point, we have not discussed databases, but in most projects you will be required to build a database schema based on your design and the developed software. In this unit, we will discuss relational databases, how to build database schema to effectively support your system, and the various options for databases. We will also discuss security issues.
Views: 4126 Brian Green
Object Oriented Systems Analysis and Design Use Cases (Part 4)
 
31:32
A description of use cases, how to determine appropriate use cases for a system being designed, and UML syntax for use case models.
Views: 17762 Brian Green
Troubleshooting DICOM using StoreSCP and StoreSCU
 
11:25
StoreSCP and StoreSCU are tools that can be downloaded from http://dicom.offis.de which are very useful for simulating an SCU (device sending DICOM) and an SCP (device receiving DICOM). At UltraRAD, we frequently use these tools to test connections and settings, or when we need to test functionality against our applications where we want to use a third party application, Many PACS administrators will find these helpful tools, regardless of the PACS, archive or nodes. These tools can be used to simulate and troubleshoot in any environment, and masquerade as existing devices. In this video, you will see how to use both tools, by observing the commands to send DICOM files from StoreSCU, which are received by StoreSCP. You will also see various options that allow for setting Called and Calling AE Titles, transfer syntax, and multiple files. I hope you find this video helpful, please leave any comments or questions below, and thanks for watching!
Views: 4236 Brian Green
Systems Analysis and Design - Extending the Requirements Models (Part 6)
 
48:01
Once the requirements have been determined, the analyst begins modeling those requirements with use case and class diagrams. We can further decompose the user cases with activity diagrams, and decompose our classes with state machine diagrams. This helps us demonstrate and refine our understanding of the system we will eventually be designing, and we can also create system sequence diagrams to demonstrate use cases. These diagram techniques are not only useful for helping us analyze and understand the current systems and needs in the new system to be designed, but it also introduces us to these diagramming techniques which we will be using in more detail for our systems design.
Views: 8873 Brian Green
Systems Analysis and Design - Designing the User/System Interface (Part 8)
 
38:03
In the first half of the course, we learned techniques for systems analyses. These activities were focused on understanding what the new system needs to accomplish. Using the deliverables from our analysis, we can begin designing a system. In essence, during the analysis phase, we focused on understanding the new system; in design activities we focus on the solution (i.e., how the system will be built, the components, etc). Where before we focused on more soft skills (like business processes), in this unit we begin using more technical skills.
Views: 7357 Brian Green
Systems Analysis and Design - Software Development Life Cycle (Part 11)
 
27:04
After a few gruelling units, we begin to slow down a little... in this unit we rewind a little, and discuss approaches to systems development. We already learned both structured and object oriented techniques (although we focused on object oriented), we compare these and other methods, and how they can be carried out in an over system design. Objectives: Compare the underlying assumptions and uses of a predictive and an adaptive system development life cycle (SDLC) Describe the key activities and tasks of information system support Explain what comprises a system development methodology—the SDLC as well as models, tools, and techniques Describe the two overall approaches used for software construction and modeling: the structured approach and the object-oriented approach Describe the key features of Agile development
Views: 8102 Brian Green
Systems Analysis and Design - Introduction to Project Management, Part 1
 
30:49
This video introduces the discipline of project management, and including the phases of project management as wells as tools and techniques such as Work Breakdown Structure (WBS), Network Diagrams, and GANTT charts. This video is based on content from Modern Systems Analysis and Design, 8th Ed, available fro Pearson
Views: 1891 Brian Green
Structured Anlysis Process Modeling (OO Systems Analysis Appendix A)
 
34:09
Although this course is focused on object oriented systems analysis and design, another technique that is frequently used is structured analysis and design. The Gane and Sarson techniques for data flow diagramming are just as useful for modeling and understanding systems, and in some cases may be even more appropriate than OO methods. You may also find that users and non-technical stakeholders can digest structured models a bit easier than UML models with their complicated syntax.
Views: 4952 Brian Green
Create an ERD in MS Visio (Lab 4.1)
 
18:58
In this lab, we create and normalize our database design using MS Visio.
Views: 3336 Brian Green
OO Systems Analysis and Design - OO Design (Part 9)
 
45:28
In this unit we expand on object oriented approaches to design. We will apply OO design principals to architectural design, learn about design class diagrams, CRC cards, communications diagrams, and other OO techniques. Of course, all of this will rely on the OO techniques we employed in the analysis phase.
Views: 6185 Brian Green
OO Systems Analysis and Design - Essentials of Design (Part 7)
 
30:43
In the first half of the course, we learned techniques for systems analyses. These activities were focused on understanding what the new system needs to accomplish. Using the deliverables from our analysis, we can begin designing a system. In essence, during the analysis phase, we focused on understanding the new system; in design activities we focus on the solution (i.e., how the system will be built, the components, etc).
Views: 6359 Brian Green
Systems Analysis and Design - Feasibility Analysis
 
28:48
Before analysis can begin, we must first evaluate various alternatives from which we can use to develop an information system, and perform an objective analysis to validate our decision. The objective analysis will include an economic, technical, organizational, political and other feasibility studies, which are described in this video. This presentation is based on content in Modern Systems Analysis and Design, 8th Ed, available from Pearson.
Views: 1501 Brian Green
Systems Analysis and Design - The Sources of Software
 
26:38
This presentation is based on the content of Chapter Two: Modern Systems Analysis and Design by Joseph Valacich. In this presentation, I discuss the various sources of software mentioned in the text. This includes outsourcing, the cloud, enterprise resource planning vendors such as SAP, open source, packaged software vendors, and in-house development.
Views: 569 Brian Green
Install Fedora 23
 
12:27
For Temple Fox School of Business, ITACS 5209 - Securing the Infrastructure
Views: 305 Brian Green
Unix/Linux Directory Services
 
51:47
A brief overview of using NIS and/or LDAP for directory services in Linux or Unix. This video also contains a 30,000 foot view of some LDAP concepts that some students may find useful if new to LDAP.
Views: 612 Brian Green
Systems Analysis and Design: Build, Test and Implement (Part 13)
 
26:39
In this final unit, we discuss issues with implementation of a system. After all the analysis and design, we need to implement the system--however, like everything else we have discussed thus far, there are some techniques and planning to do this. For example, we need to perform adequate testing, possibly migrate data, and implement in a way that will ensure user acceptance.
Views: 4026 Brian Green
Systems Analysis and Design - Baseline Project Plan
 
03:23
A description of the Baseline Project Plan, which is used to begin a systems development project, and justifies the initial decisions. This presentation is based on content in Modern Systems Analysis and Design, 8th Ed, available from Pearson.
Views: 298 Brian Green
IT Security II Mitigation Techniques (4)
 
51:20
In this unit, you will became acquainted with how to select appropriate types of mitigation and deterrent techniques for a wide range of attacks. The unit opens with a discussion of monitoring system logs, with common logs including security, DNS, system, performance, event, access, firewall, antivirus, and IDS/IPS logs.The unit continues with discussion of periodic audits of security settings. System hardening and the protection of management interfaces is presented with sections on disabling unnecessary services,protecting management interfaces and applications, password protection, and disabling unnecessary accounts. Password selection criteria, password policy guidelines, the components of a good password, and password aging are all discussed. The unit also covers some concepts in network security, covering the topics of MAC limiting and filtering, 802.1x, disabling unused interfaces and unused application service ports, and rogue machine detection. Security posture is discussed, where system baseline initialization and updates, continuous security monitoring, and remediation are presented. The unit closes with a review of the differences between detection controls and prevention controls.
Views: 355 Brian Green
UltraBROKER Order Entry
 
06:59
This video demonstrates the use of a DICOM Modality Work List broker where only ADT can be sent from an EMR or HIS.
Views: 97 Brian Green
Using Telnet to test HTTP on port 80
 
01:15
Using telnet from Unix/Linux to test HTTP without a web browser
Views: 16058 Brian Green
Systems Analysis and Design - Initiating the Systems Development Lifecycle
 
10:10
Once a problem domain is identified, the systems development planning phase begins. This presentation is based on content in Modern Systems Analysis and Design, 8th Ed, available from Pearson.
Views: 271 Brian Green
OO Systems Analysis and Design - Use Case Realizations (Part 10)
 
35:04
In this unit we expand on object oriented approaches to design. We will apply OO design principals to architectural design, learn about design class diagrams, CRC cards, communications diagrams, and other OO techniques. Of course, all of this will rely on the OO techniques we employed in the analysis phase.
Views: 7139 Brian Green
Systems Analysis and Design - Feasibility Study Demonstration
 
25:59
A demonstration of performing a feasibility study, this video uses the simple example of deciding between two vacation lodging alternatives (timeshares vs hotels). While most of us do not use a decision process as structured and detailed as this when deciding how to purchase lodging for vacations, this serves a simple example to learn the concepts which can be applied to information systems projects.
Views: 449 Brian Green
Introduction to Database Course
 
14:22
This is an intro for IT203 Students for Brian Green's Database course.
Views: 582 Brian Green
Systems Analysis and Design - Introduction to Project Management, Demonstration
 
40:36
A demonstration of creating project mangement deliverables, using free tools. First, the Work Breakdown Structure (WBS) is completed in a text editor, along with a PERT analysis to estimate the time to complete each task. Next, I use http://draw.io to make a Network Diagram to visualize the task dependencies and critical path. Finally, I use http://www.teamgantt.com to create a GANTT chart and a project plan.
Views: 432 Brian Green
Systems Analysis and Design - Introduction to Project Management, Part 2
 
17:04
This video introduces the discipline of project management, and including the phases of project management as wells as tools and techniques such as Work Breakdown Structure (WBS), Network Diagrams, and GANTT charts. This video is based on content from Modern Systems Analysis and Design, 8th Ed, available fro Pearson
Views: 506 Brian Green
Oracle Database Programming - Single Row Functions
 
41:01
An overview and examples of Single Row Functions using Oracle SQL
Views: 229 Brian Green