SQL NOTES

SQL Oracle Query Structure and Overview

Creating a New Database User Account .....In Oracle 10g.

Step 1:
Login Into Oracle....
Start->All Programs->Oracle Database 10g Express Edition->Go To Database Home Page
 The Default Username Is "system" And Enter The Password You Entered During Installation
Click Login Button As Shown In Fig Below.....

 Step 2:
Now To Create New Administration Account...
 Clcik On Administration->Database Users->Create User
As Shown In Fig Below.....

 Step3:
Now On Create Database User Page Enter Username,Password And Confirm Password
And UnCheck The Check Box For DBA In Role Category....
The DBA Role Checkbox Determines The Type Of Account Created. This Is The Only Difference Between creating a regular database account and an administrative database account....
As Shown In Fig below......

Step 4:
Click On Create Button... That's It.....

Creating a New Administration Account.... In Oracle 10g

 Step 1:
Login Into Oracle....
Start->All Programs->Oracle Database 10g Express Edition->Go To Database Home Page
 The Default Username Is "system" And Enter The Password You Entered During Installation
Click Login Button As Shown In Fig Below.....

 Step 2:
Now To Create New Administration Account...
 Clcik On Administration->Database Users->Create User
As Shown In Fig Below.....

 Step3:
Now On Create Database User Page Enter Username,Password And Confirm Password
And Check The Check Box For DBA In Role Category....
The DBA Role Checkbox Determines The Type Of Account Created. This Is The Only Difference Between creating a regular database account and an administrative database account....
As Shown In Fig below......

Step 4:
Click On Create Button... That's It.....

Creating Digital Clock...........

Step 1:
Create New Windows Application

Step 2:
Add Following Controls On The Form

Label1:      Set Font To "OCR A Extended"
                 Set ForColor To "Lime"
                 Text To "00.00.00.AM"

Timer1:      Set Enable="True"
                  Interval="100"

And Set Forms Text Property To "DIGITAL CLOCK"

Step 3:
Add Following Code To Timers Tick Event And Forms Load Event Respectively.........

Code:

Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
        Label1.Text = Microsoft.VisualBasicTimeOfDay
End Sub

Code:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Timer1.Enabled = True
        Timer1.Interval = 1000

End Sub

Generating Connection String........

STEP1:

 Create New Project.... Got To Data Inf Menu Bar. Then Select Add Data Source ..... As Shown In Fig Below........

 STEP 2:
After That Following Data Source Configuration Wizard Will Get Open In That Select Database and Click Next Button.... As Shown In Fig Below.......

STEP 3:
Select New Connection ... As Shown In Fig Below......

Step 4:
Now The Add Connection Dialog Box Gets Open In It Select Change Button..... As Shown In Fig Below

STEP 5:
Now Select Data Source In My Case I am Using Microsoft SQL Server... A s Shown In Fig Below....

STEP 6:
Now Click On Server Name DropDown Box Select Your Server Name... In My Case Its VISHAL\SQLExpress.... And As Per Your Requirements Select Windows Or SQL Authentication.... And Select DataBase Name From The List In My Case DataBase Name Is "AlphaDB"...... As Shown In Fig Below........

Step 8:
Now Click On Test Connection button To See Weather The Connection Is Created Or Not... As Shown In Fig Below......

Step 9:
Now Click on The Plus Sign In Front Of Connection String To See The Connection String ... And If Your Are Using SQL Authentication Don't Front To Select The Radio Button In The Following Fig Which Says "Yes,Include sensitive data in the connection string" so your Password gets attachted to it......

Working With Progress Bar.......

Step 1:

Create a Windows Application

• Select Start--All Programs--Microsoft Visual Studio 2008--Microsoft Visual Studio 2008....
• After that Select File--New Project
• Select the project type as Visuyal C# from the project types pane, and Windows form Application from the Templates pane
• Type the name of the new project as Progress bar int the name text box.
• Click OK

Step 2: Add ProgressBar Control And Timer Control

Step 3:
Set the Properties Of Timer As Follows:

 Step 4:
Double Click On Timer Control And Write Following Code:

Final Project:

KGB Archiver : Compress 1GB File to 10MB Easily

Amazing Software it easily compress 1GB file upto 10MB... Cant You Believe It Try It By YourSelf ...

KGB Archiver 

Features Of KGB Archiver:

Supports native .kgb files and .zip files
AES-256 Encryption
Able to create self-extracting archives.
Multilanguage supports like Arabic, German, Greek, Japanese, Spanish many more.
Unicode is supported in both User Interface and File Systems.
An Explorer shell extension is available for the windows version.
Make Password protected compressed file.

System Requirements:

Due to high compression ratio of KGB archiver, you need to have a decent system hardware configuration 256 MB RAM and 1.5 GHz Processor....