Videos uploaded by user “Chitu Okoli”
Create new connection with new user in Oracle SQL Developer
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 302707 Chitu Okoli
Create free test data for a database with foreign keys
There are various free data generators to create test or dummy data for a database, but generally speaking, they don't handle foreign keys between tables very well. This video shows how to create random data from a free test data site, manipulate the tables in Excel to maintain foreign keys and other advanced referential integrity logic, and then convert the data to SQL insert statements. The files referred to and other documentation can be obtained from: http://chitu.okoli.org/psyche/it/create-test-data-for-a-database-with-foreign-keys/
Views: 2530 Chitu Okoli
Panopto Tutorial
Tutorial for students using Panopto lecture capture as I use it in my BTM 382 Database Management class at Concordia University.
Views: 439 Chitu Okoli
Theory with lit reviews: 2. Protocol
The second step to building theory with literature reviews is to carefully plan the entire study with a research protocol and to train the review team. This video describes the protocol, how to train the team, and how to conduct a pilot study literature review. Unfortunately, the audio for the original recording was lost, and so this video is just a short review of the original class session that briefly recaps each point. * Full course: http://chitu.okoli.org/bios/pro/teach/build-theory-literature-reviews/ * Slides: http://chitu.okoli.org/media/pro/teach/ictu-lit/litReviewStep2protocol.pptx
Views: 63 Chitu Okoli
Open content as a business proposition - BTM Talentmash Quebec 2015
Open content is a digital information product whose copyright holder legally lets anyone read, download, and share it. Although fairly common today (think about Mozilla Firefox and Wikipedia, for example), this kind of product became widespread only since the dawning of the Internet age. But how can you make money by giving your stuff away for free? Well, as business managers in training, to effectively use open content, you have to shift your thinking from “making money” to “creating value” for your clients, partners, yourself, and even for your competitors. This kind of thinking can not only help you appreciate the business case for open content, but it also gives you a valuable perspective for evaluating the business case for anything.
Views: 71 Chitu Okoli
ShaRP demo - Chitu Okoli on business models for FOSS
This is a demonstration video of what we would like to prepare for each researcher in the ShaRP group
Views: 19 Chitu Okoli
MBA case study Concordia library resources - Janice Kung
Janice Kung presents to MBA students at John Molson School of Business (Concordia University) some key library resources for researching company backgrounds for case study analyses. The slides are at http://chitu.okoli.org/media/pro/teach/mba-615/mba-case-library.pptx
Views: 63 Chitu Okoli
Theory with lit reviews: Course overview
In the Fall semester of 2015, while I was an associate professor at Concordia University, Montreal, ICT University invited me to give a series of online guest lectures as part of their doctoral student course on how to carry out a literature review. ICT University is based in Yaoundé, Cameroun and Baton Rouge, USA. Its programs focus primarily on information and communication technologies and on management. I recorded most of the lectures and now I have edited them to be suitable for a more general audience. Although the lectures were given in the context of a specific course, these edited videos should be suitable for any researcher or graduate student who would like to learn how to develop theory using literature reviews. This first video is the overview to the course that I presented to the ICT University students. It provides a general introduction to literature reviews and the idea of developing theory using literature reviews. Here's the course outline: http://chitu.okoli.org/media/pro/teach/ictu-lit/ICTU_Lit_review_syllabus_Fall_2015.docx Here are the two articles I refer to: * Theory-mining reviews: http://ssrn.com/abstract=2699362 * Tutorial on systematic literature reviews: http://chitu.okoli.org/pub/okoli-2015-a-guide-to-conducting-a-standalone-systematic-literature-review/
Views: 62 Chitu Okoli
Theory with lit reviews: 1. Objectives
The first step to building theory with literature reviews is to determines the objectives of your theory-mining review. This video defines literature reviews and then explains what theory means and why it is important. Then it introduces theory-mining reviews (TMRs) and explains the three types of TMR. * Full course: http://chitu.okoli.org/bios/pro/teach/build-theory-literature-reviews/ * Slides: http://chitu.okoli.org/media/pro/teach/ictu-lit/litReviewStep1objectives.pptx * Flowchart to determine what kind of TMR to do: http://chitu.okoli.org/media/pro/teach/ictu-lit/Type_of_TMR_flowchart.pdf
Views: 47 Chitu Okoli
TestData - fix dates
Fixing some problems using Excel to generate test data that represents dates and times
Views: 114 Chitu Okoli
Theory with lit reviews: 3. Practical screen
The third step to building theory with literature reviews is to explicitly define the practical screen, that is, the criteria for including or excluding studies in the review. This video describes practical screen criteria from the perspective of building theory and also gives some practical tips. * Full course: http://chitu.okoli.org/bios/pro/teach/build-theory-literature-reviews/ * Slides: http://chitu.okoli.org/media/pro/teach/ictu-lit/litReviewStep3practicalScreen.pptx * Practical screen worksheet: http://chitu.okoli.org/media/pro/teach/ictu-lit/Practical_Screen_Worksheet_for_Theoretical_Importance.docx
Views: 37 Chitu Okoli