How To Add Page Level Ads To Maximize Revenue

Google cares about content creators as well as content readers . After reading this you will have an in depth understanding on page level ads.

Google has come of with on page ads display solution for mobile devices. This time it targets high end mobile devices. The secret sauce is “Page Level Ads”. As the name suggests, page level ads run at page level. That means, it deals with page load event.

There are two types of page level ads.

1.Anchor Or Overlay Ads

  • These ads stick to the bottom of high end mobile devices.
  • It is not countable to 3 Ads per page.
  • It is shown at optimal time to increase revenue of user.
  • User can easily close the ad. As you know, google ads are not meant to disturb primary content of any website.

Here is how it looks like,

 

2. Vignette Ads

  • These are full screen ads high end mobile devices.
  • It gets fired up during page load. So now you are not seeing a loading screen. Your Vignette Ads by Google AdSence is the amazing alternative.
  • It is also shown at optimal time to increase revenue of user.
  • User can easily close the ad.

Now, Lets see how we can enable Page Level Ads in Google AdSence

Activate Page Level Ads In Google AdSence

  1. Please Login to your AdSence Account.
  2.  Please Navigate to myAds > Page Level ads
    you should be on the following page

  3. Please turn on the off toggle button.
  4. Please Click on the get code icon.
  5. Now please copy the code
  6. Paste it inside <head> <head/> or just after <body> tag.

You are all set. Congratulations. !!

Resource Refered : Google Page Level Ads
 * This is only for helping out adsence users Whole credit goes to google to make our life easier.

SQL Operation

In SQL select query we can add, multiply, divide, subtract between columns. We can definitely increase user experience . Thanks to the concatenation operator . Can we concat between two column values ? Lets see how with examples.

Basic Operation on column in terms of SQL Query Result Format

  1. Arithmetic Calculations
  2. String Concatenation
  3. SQL Functions

Arithmetic Calculation On Columns Of A Table

We have gone through select query basic syntax. Do you know, you can do mathematical operation on select query columns.

For example,
Requirement : Employee table has employee_id, employee_name, employee_age, emplyoyee_salary, employee_bonus_factor. Need to prepare a “bonus report” of employees.

SELECT employee_name, 
employee_salary + employee_salary * employee_bonus_factor 
FROM employee;
  1. employee_salary + employee_salary * employee_bonus_factor takes the employee_salar, employee_bonus_factor data from the employee table and calculate it.
  2. The result of the employee_salary + employee_salary * employee_bonus_factor expression is populated in the second column.

String Concatenation On Columns To Present Nicely

sql concat(s1,s2) ?
CONCAT(s1,s2) accepts two arguments and returns one concatenated string.

Unlike arithmetic operation, we can concatenates stings to format or display nicely. The result becomes
readable and easy on eyes.

Syntax :   ||   two vertical pipelines . This is usually located just above the enter key in keyboard.

For example,
In some reports, we do not want tables. We want data report pulled out from sql database. We want those to be formatted as per our need. In such cases concatenation operator works like a gem.

SELECT 'Employee "' 
|| employee_name 
|| '" is having salary : '
|| 'Rs ' 
|| TO_CHAR(employee_salary + employee_salary * employee_bonus_factor) 
|| '/-' 
FROM employee;
/
  1. Here the result is a single column.
  2. The string expression pulls data from 3 columns. The columns are employee_name, employee_salary, employee_bonus_factor of employee table.

SQL Function On Column(s) Of A Table

We can call sql functions inside select statement. Lets see how it looks like. We will go through sql functions in detail.

Syntax :  SUM( column_name )   sum is an aggregate function.
*Aggregate functions operate with row sets.

For example,
Lets say, we want total salary to be given to all employees. In such case we basically want sum of salary(including bonus) of each employee.

SELECT SUM(employee_salary + employee_salary * employee_bonus_factor) 
FROM employee;
  1. Here SUM() is the aggregate function.
  2. It takes column name as argument.

SetUp Required

SQL Select

SELECT query is responsible for data retrieve or data read operation in CRUD. We can select data from table either by saying : We want all columns data . or : We want specific column data. Lets see how to get data from database .

SQL Select Statement

Lets know SELECT Query in SQL

SQL SELECT query is used to retrieve data or fetch data from relational database.

Note : We will learn create table and insert data later. For now , let us see how SELECT works.
EMPLOYEE

EMPLOYEE_ID EMPLOYEE_NAME EMPLYOYEE_AGE
100 Ramu Lala 25
101 Mojik Lalit 35
104 Kishore Kumar 36
105 Deepika Padukone 40

SELECT syntax

SELECT * FROM employee;

Keywords ?
Keywords are reserved words. That means no one can use the same name to create an object in database.
  • SELECT and FORM are keywords. 
  • * means all columns
  • employee  is the name of table.

Selecting specific columns by column name in Oracle

SELECT column1, column2, column3,...., columnN FROM table_name;
--returns data of column1, column2, column3,...., columnN

Retrieve all columns data in Oracle

In the above “employee” table, there are three columns

  1. EMPLOYEE_ID
  2. EMPLOYEE_NAME
  3. EMPLOYEE_AGE
SELECT * FROM table_name;
--Returns all columns

SQL Syntax

Do you know the literal meaning of database ? We will understand what database is , different types . Difference between NDBMS and RDBMS, Best Practices and many more. If you love databases , then lets get started.

SQL Syntax – Know SQL grammar ?

Before looking into syntax of SQL , let us have a look into basic terms like Database, Entity etc.

What is Database ?

Database is something which contains data or you can call it data-container. We can access data with ease. Data can be sorted. User or any other application can interact with data in no time.

What is Database Management System (DBMS) ?

NDBMS or RDBMS ?
NDBMS is Navigational DBMS (1960). Relational DBMS is being upgraded since 1970.

Database Management System (DBMS) also termed as Relational Database Management System (RDBMS).
These database stores data in organised way in the form of table (primary entity of DBMS). Data
can be stored, retrieved, manipulated or delete with easy. User can play with the stored data . Any other
application ( web app, desktop app, database application ) can interact with the database easily.

how do sql statements look like ?

What are case sensitive ?
String literals. e.g SELECT * FROM employee WHERE emp_name = ‘CASE_SENSITIVE’
  1. Case Insensitive – However, it is a good practice to use uppercase for keywords to increase readability
  2. Semicolon – Semicolon is an indicator to tell database, “You know what ; is the end of statement 1. Execute stement 1 and proceed..”

SQL Basics

What is SQL ?

First of all we should understand , SQL stands for Structured Query Language. SQL is a standard. So on top of sql , many relational  database systems are built. Some of the RDBMS (Relational Database Management Systems) are SQL*Plus, Oracle, MySQL etc.
Hence SQL lets you deal with database.

Why to learn SQL ?

Before knowing the answer to this question , I must say welcome. Its because , as you are on our beautiful land of SQL

  1. You are curious
  2. You wanna have a concrete base enriched with clear concepts
  3. You know what is sql but wanna have in depth knowledge

So Learning SQL helps in understanding and taking up oracle , msql and many more.

What SQL can do ?

CRUD ?
CRUD is fancy way of saying Create, Read, Update, Delete.

You can CRUD on data or data-blocks holding data.

  1. Create data rows/structure in database
  2. Read data from database
  3. Update data of database
  4. Delete Data in database

You can do many more.We will explore one by one.