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: 360954 Chitu Okoli
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: 3293 Chitu Okoli
Some tips for efficient reading of academic or school reading assignments so that you can understand and remember things better. My approach mainly involves spending quite a bit of time to first understand the outline and structure of the reading--that time investment makes all the difference.
Views: 401 Chitu Okoli
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: 71 Chitu Okoli
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: 78 Chitu Okoli
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: 72 Chitu Okoli
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: 48 Chitu Okoli
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: 64 Chitu Okoli
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: 55 Chitu Okoli
This is a demonstration video of what we would like to prepare for each researcher in the ShaRP group
Views: 23 Chitu Okoli