Many times in our asp dot net application we need to manipulate page titles and keywords.E.g. You may like to change page title Or to get page title.Sometimes you will need to display as content header in content area of page.In a typical .Net web application you can change the title of a page on the fly by accessing the Page object’s Title property.

Page.Title = “My Custom Page Title”;

But from within your DotNetNuke module code you do it in a slightly different way. You first type-cast the Page object into a DotNetNuke.Framework.CDefault variable. Then you read and write the Title member on the CDefault object:….

There are manby things which are considered as basics in dot net nuke.When you are using host sql window from dnn then most definitely you will need to have ideas of basic sql statements to fetch info from db.Few of them are:-
Listing all tables from DataBase:-

SELECT * FROM information_schema.Tables

Get Stored procedure description and Structure:-

select * from information_schema.routines where routine_name = ‘Stored Procedure Name’

Querry to fetch all tables in a database:

select * from sysobjects where type=’u’