Defining and controlling database in SQL

[GOOL]

I am an IT student , I am looking forward my career as a database administrator, but do not have much knowledge about the SQL language . I wanted to know how those database are created in and manage in database , so if you have any idea , please provide share a bit of knowledge about this.

[Shreevats]

You can use a the control statements in the data control language, data definition language and data manipulation language in order to deal with the database in the SQL. These are not actually state these are all standards that contain the basic schema of all those structures being created.

[Villiers]

The DDL can be used to define any particular data base or a table , so in case if you want to create any data base you can use the create statement , through which you will be able to create a database or a table. You can also drop those tables and database using DROP statement.

[Ronchi]

Apart from the DDL statements there are some more statements that allows you to manipulate the contents of the tables , these statements are SELECT, INSERT, DELETE and UPDATE. These statements are used as their name suggests and perform necessary modifications being done in the table.

[Author]

A lot of SQL users do not have to be concerned about creating a database; they utilize interactive or programmatic SQL to utilize a database of commercial information or to utilize a few other database that has been created by someone else. In a classic commercial database, for example, the database administrator may provide you authorization to reclaim and possibly to update the stored information. However, the administrator will not permit you to make new databases or to alter the formation of the presented tables. As you nurture further convenient with SQL, you will possibly want to begin making your own individual tables to stock up private data such as results of the test being conducted or forecasts made on annual sale . If you are using a multi-user database, you may want to generate tables or even whole databases that will be common among many such users. If you are using a personal computer database, you will definitely want to generate your own tables and databases to sustain your private applications. The syntax of these statement is similar in case of creating a data base or creating a table. you will have to use the CREATE STATEMENT to create this type f structures. But the query in SQl differ slightly from that of Oracle . If you are really looking to learn these handling of database, you will have to learn first all the basic statements and all things you should practice all these queries and begin with the simple one and then go with the complex queries. I have got a bit of SQL language if you get stuck you can post your question back I will be there for you to assist you.

[Jacques25]

Data Definition Language (DDL) explains the part of SQL that permits you to create, alter, and drop the objects created in database . you can create different types of such objects such as schemas, tables, views, and aliases. You can do such actions when using statements such as CREATE statements , Drop Statements and Alter statements. These statements are also called as DDL statements or data definition statements because they are used to define the structure of the data base objects