Year
|
Technology & Responsiblities | Title | Industry |
2004-2005
|
Office, Adobe, FoxPro, HTML, C | Faculty | School |
2005-2006
|
Advance Excel -VBA | Transaction Processing | BPO |
2006-2009
|
Access with VBA, MIS Automation | MIS Executive | Telecom |
2009-2010
|
SQL Server 2000, 2005 and ASP Apps | Software Engineer | Telecom |
2010-2013
|
SQL Server 2005,2008,Asp, Asp.net,IIS, Windows 2003 |
DB Admin | Telecom |
2014- 2015
|
Windows 2012 , SQL Server 2012, MVC
Apps, IIS, MySQL,TFS |
SQL-DBA | Research |
2015-Now | SQL,
SQL Server, mySQL, mongoDB |
Data Architect -DBA | Software |
For encrypting and decrypting , we must use the bytea data type on the column which we implement. Bcoz bytea will use the pgcrypto method by default. However, you will need to create the pgcrypto extension to enable these functions as they are not pre-defined in PostgreSQL/PPAS. Example CREATE EXTENSION pgcrypto; CREATE TABLE userinfo (username varchar(20), password bytea); >> Inserting the data in an encrypted format INSERT INTO userinfo VALUES(' suman ',encrypt('111222','password','aes')); select * from userinfo ; >> Retrieving the data as decrypted format SELECT decrypt(password,decode('password','escape'::text),'aes'::text) FROM userinfo; Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757