Tutor profile: Ian T.
Subject: SQL Programming
Using an example, explain the SUBSTR function
SUBSTR stands for substring. It returns a part of a string. We specify which part of the string we want to return. Example; select substr('Diploma',2,3) from sys.dual; Output -ipl
At a foundation level, when deciding to invest in a database, what are the first things decision makers should ask?
Firstly, decision makers should ask what resources are available at hand, both human and financial? The most basic questions that should follow are, what data do we need to store? How will we store it, and most importantly, how are will we pertain valuable information from the collection of data. Data is only valuable if it is stored efficiently, and utilised correctly. With this in mind, ETL processes are of the utmost importance when implementing a database
In order to succeed in a digital environment, what steps should an organization take when embarking on a business venture?
There are a number of ways organizations can utilize the digital world to succeed. However, at the outset, a company should begin by illustrating a business model that shapes the ethos of the organization. Additionally, an organization must consider its position on a life cycle format. Is it a startup? Is it a mature firm etc? By doing so a company can begin to establish how it should proceed to be a competitor in the digital world
needs and Ian will reply soon.