TERMS IN SQL

TERMS IN SQL

Attributes - The columns in a table is known as the attributes and it is also known as degree of relation .

Tuples - The Rows in a table is known as the tuples and it is also known as cardinality .

Alternate key - Can be used as primary key but in a table there is only one primary key can take place but the alternate key or unique key can more than one unique key can take place and the unique key will work same as the primary key but it is not use as the primary key .

DDL - Data Definition Language

 It is the part of the Sql in which we can design the structure of the table .

the following commands will ve used in DDL -

 1 - create Table
 2 - Alter Table
  Alter Command is use to Add or Modify something in the table

3 - Drop Table
Drop Command is used to remove or to delete the particular comlumn

Data Types -

Types of Data is known as Data Type for more information about Data Type you can see our previous Blogs

there are some data types which are used to create the table -

1 - int - integer
2 - chr - character
3 - varchar - variable character
4 - float
5 - boolean
6 - date

Now ,
first you need to install the SQL command line in your computer / system / pc or anythin which you are using the SQL command line is of 450 mb abd after installing the SQL command line you need to set up the password in the SQL command line the password option in the SQL command line is the inbuilt function this password function is provided because in this you need to enter the lot of data in the table form so that no one other than you can see you data .
After setting the password dont set the very difficult password choose the easy password such as - 0000 or 1234 or 4321 or another easy password .
After Installing the you need to create a data base .

CREATE DATA BASE

Create database ________
you can give any name to your data base after the command create database

now to display the databases you need tyoe another command -

show databases

thats all for todays blog .

IN THE NEXT BLOG WE LEARN MORE ABOUT THE DDL IN THE SQL  AND THE OTHER WORKING  IN PYTHON AND OTHER IMPORTANT SUB TOPICS  THANK YOU FOR VISITING KEEP VISITINGK LEARNING STAY TUNED FOR NEXT BLOG FOLLOW OUR BLOG FOR REGULAR UPDATES VIEW OUR PREVIOUS BLOG FOR THE BASIC CONCEPTS OF PYTHON AND OTHER BASIC CONCEPTS OF COMPUTER AND ALSO FOR THE IMPORTANT DEFINITIONS OF THE SQLVISIT OUR SECOND BLOG – indianbasics.blogspot.comVISIT OUR YOUTUBE CHANNEL -  Learn Python Our youtube channel will give you the short motivational speeches of the great person in the present there is only one motivational video on channel but in future I will upload the motivational videos soon .VISIT OUR INSTAGRAM PAGE – instagram.com/learnpython16Out instagram page is also a new page i9 have just crated few hours ago but stay tuned I will upload the post very soon . Please support us by following our blog and by subscribing our youtube channel and by following our instagram page .