= Technical Talk=

Whenever we get any doubt the one which is always there for us to help is "google". Wonder why people write those technical articles which helps thousands of freshers, adults etc, what are they getting? , i wondered and realized that it's from google they must be got help sometime in their beginning and they could have thought that their writings can also help people who are in the same journey. At work when they are no friends to help, I definetly know google can give some solution which can help in reaching the final solution. So recently when ever i am browsing google for something i am thinking that, i am taking so much from google, it should be good if i can return something. I dont know how techincal I could be but I am definetly learning and have some knowledge which i can share. There should be a start somewhere for my dream to become a ********* where I believe having knowledge and sharing is the key and happy to start in someway...actually enough of dreaming...start walking towards it ..thats what i say.
In Software, whatever is the front-end there is no meaning without Backend.
When I say Backend, yes thats the databases I am talking about. It's the data which manipulate here and there in any business process and how we are showing is we call as an Business application. I have some knowedge in front-end and Back-end technologies, still learning and thats what my writings would be from now on.
Ok you need to have some client tools now to connect the database, see the tables, see the data, see the columns, see the datatypes etc. Client tools can be SQL Developer, TOAD, Teradata SQL Assistant, SQL Enterprise manager etc.
First You must be added as a User for the database, can be added if you are the administrator.
1. SQL Developer
a) Connection Name........Give any name
b) Username
c) Password
d) Hostname....................Database Name
e) Port...............................tnsping DatabaseName from ur cmd....thats the PORT
f) SID.................................I usually give the database name again
g) Test................................Connect
h) Tools---->SQL Worksheet
2. TOAD
a) Database
b) Username
c) Password
d) Connect as ....Normal
e) Conncet Using ......Client 8 or 10
f) Connect
g) SQL Editor
3. Teradata SQL Assistant
a) Tools--->Define a Datasource
b) User DSN/ System DSN
c) Teradata Driver
d) Datasource Name
e) Datasource Description
f) Teradata Server Info Name or IP Address
g) Username
h) Password
i) Options---> No help Database (To See the tables, views)
j) Ok and Save
k) Tools --> Connect
l) File Datasource/ Machine Datasource.....Ok
4. SQL Server Enterprise Manager
a) New SQL Server Registration
b) Next --> Select an available Server and Add
c) Windows Authentication / SQL Server Authentication
d) Next--> Finish
e) You should be added as the user for that database and also as the Security Login.
f) Tools --> SQL Query Analyzer
Now we have the workspace for actually executing the sql commands we know. These vary depending on the requirement but What I feel is that there are only four commands in any Back-End which I say "Four Mantras".
1. Select Command
a) Select Column1, Column2....ColumnN from SCHEMA.TableName
2. Insert Command
a) Insert into SCHEMA.TableName (Column1, Column2....ColumnN) Values ( Value1, Value2...ValueN)
3. Update Command
a) Update SCHEMA.TableName Set Column1 = Value1, Column2= Value2,...,ColumnN=ValueN
Where Some_Column = Some_Value
4. Delete Command
a) Delete from SCHEMA.TableName Where Some_Column = Some_Value
That's a good start....Uh OOH, will catch up u later...Have fun and a Happy ThanksGiving Holidays!!!!!