CODING & ANALYTICS by Gbenga Oridupa

Big Data! Yes, do you really know what exactly it is, and its influence to the world today?. In order to understand the term 'Big Data' , we first need to know what 'Data' is. Oxford dictionary defines 'data' as - "The quantities, characters, or symbols on which operations are performed by a computer, which may be stored and transmitted in the form of electrical signals and recorded on magnetic, optical, or mechanical recording media. " Now imagine what ‘Big Data’ is. Big Data is a term used for a collection of data sets that are large and complex, which are difficult to store and process using available database management tools or traditional data processing applications. Examples of Big Data: The following are some of the examples of 'Big Data'- The New York Stock Exchange g...

Firstly;  .NET DataProvider -- Standard Connection with username and password: Put this at the top of your code: using System.Data.SqlClient; Put this  in your code body: SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=ServerName;" + "Initial Catalog=DataBaseName;" + "User id=UserName;" + "Password=UserPassword;"; conn.Open(); Secondly;  .NET DataProvider -- Trusted Connection: Put this at the top of your code: using System.Data.SqlClient; Put this  in your code body: SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=ServerName;" + "Initial Catalog=DataBaseName;" + "Integrated Security=SSPI;"; conn.Open(); Thirdly; .NET Configuration manager (Web configuration); Put this at the top of your code: using System.Web.Configuration; using System.Data.SqlClient; Put this in Web.Config: <connectionStrings > <add name="myCo...

Why would you convert lists to tuples? Let’s say you have such data which you never want to change, then you should use tuple. (tuples == immutable). They work like the array object in JavaScript. You can add items, delete items from a list; but you cannot do that to a tuple, tuples have a fixed size. Why would you convert tuples to lists? Let’s say you want to make changes to the initial tuple created, even though you know you can't modify the data directly. Therefore, you can convert them to lists and then make the change, then convert them back to tuples. (list == mutable). Examples bellow shows conversion between tuple and list and vice versa. Here is an example demonstrating the mutable nature of lists in Python: An example showing the immutable nature of tuples in Python: An example of converting between tuples and lists to edit data: Tip:  When you create a variable, some fixed memory is assigned to the variable. If it i...