I went through this link: https://msdn.microsoft.com/en-us/library/bb934049(v=sql.110).aspx Is that it, it only encrypts the database, what about the column inside the table.
I used the syntax
USE master;
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<UseStrongPasswordHere>';
go
CREATE CERTIFICATE MyServerCert WITH SUBJECT = 'My DEK Certificate';
go
USE AdventureWorks2012;
GO
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_128
ENCRYPTION BY SERVER CERTIFICATE MyServerCert;
GO
ALTER DATABASE AdventureWorks2012
SET ENCRYPTION ON;
GO
But the column are visible to me how to encrypt the columns also using TDE
I am new to TDE please help me out.
TDE is an encryption type which encrypts the data and log files of a database. If someone manages to steal your backup files they will not be able to decrypt it without the database encryption key referred to as the DEK, which is stored in the Master database. Even if you want to restore a backup of a TDE encrypted database you will have to have the same DEK in the destination database. Enabling TDE also encrypts your tempdb.
For a more clear understanding, please refer to Microsoft's Books Online and you can also use the following from TechNet. Transparent Data Encryption (TDE)
Before enabling on any system please make sure to read up more and know its effects, advantages and disadvantages.