using databases and sql since there are so many different database vendorsthe structured query language (sqlwas standardized so we could communicate in portable manner to database systems from multiple vendors relational database is made up of tablesrowsand columns the columns generally have type such as textnumericor date data when we create tablewe indicate the names and types of the columnscreate table tracks (title textplays integerto insert row into tablewe use the sql insert commandinsert into tracks (titleplaysvalues ('my way' the insert statement specifies the table namethen list of the fields/columns that you would like to set in the new rowand then the keyword values and list of corresponding values for each of the fields the sql select command is used to retrieve rows and columns from database the select statement lets you specify which columns you would like to retrieve as well as where clause to select which rows you would like to see it also allows an optional order by clause to control the sorting of the returned rows select from tracks where title 'my wayusing indicates that you want the database to return all of the columns for each row that matches the where clause noteunlike in pythonin sql where clause we use single equal sign to indicate test for equality rather than double equal sign other logical operations allowed in where clause include =!=as well as and and or and parentheses to build your logical expressions you can request that the returned rows be sorted by one of the fields as followsselect title,plays from tracks order by title to remove rowyou need where clause on an sql delete statement the where clause determines which rows are to be deleteddelete from tracks where title 'my wayit is possible to update column or columns within one or more rows in table using the sql update statement as followsupdate tracks set plays where title 'my waythe update statement specifies table and then list of fields and values to change after the set keyword and then an optional where clause to select the rows that are to be updated single update statement will change all of the rows that match the where clause if where clause is not specifiedit performs the update on all of the rows in the table these four basic sql commands (insertselectupdateand deleteallow the four basic operations needed to create and maintain data