Thursday 20 March 2014

Open SSL Certificate for Https Implementation


 Self signed Open SSL Certificate:
  -To Implement Https on any webpage, first we need SSL certificate. This SSL certificate have multiple extension format like ( .pem, .key, .crt  etc)
-To register SSL certificate or to get self signed SSL certificate, we need to generate Self signed SSL key by using following commands in command prompt console.
openssl genrsa -out sample.key 4096
            openssl req -new -x509 -days 365 -key sample.key -out sample.crt
In the above command days 365 represents certificate validity period.while generating certificate you must provide following details,

Tuesday 18 March 2014

Database Anomalies and how to Overcome those Anomalies:

                In our day-to-day life, we come across data stored in various formats and structure. The most common form is a flat-file structure or commonly known as "spreadsheet-like" structure. This means nothing but data stored in rows and columns with the first row representing the headers under which the relevant data is stored. However, as the amount of data i.e. the number of records and the number of fields go on increasing the format becomes difficult to manage, analyze & maintain.

Open Northwind Database Explained:

 Northwind Database Explained:

                Northwind Database is a sample database that is shipped along with Microsoft Access application. Basically, the database is about a company named "Northwind Traders". The database captures all the sales transactions that occurs between the company i.e. Northwind traders and its customers as well as the purchase transactions between Northwind and its suppliers.