Relational Database System Sql Analysis Paper
Relational Database System SQL Analysis Paper
In this section I learned that SQL can input a lot of information into Access for you. I have taken some SQL courses before and still have not learned all of these commands. I can see why people take full degrees on just programming. Another thing I saw was SQL could do a lot of damage to Access. All you would have to do is write a script that could change a lot of information.
During this assignment I learned “SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. (Interactive Online SQL Training)” In the lessons I learned different things: * In lesson 2 I learned that a relational database system contains one or more objects that are called tables. The data or information for the databases is stored in the tables (Interactive Online SQL Training). * In lesson 3 I learned how the select statement is used to query the databases. I also learned how to retrieve selected data that match the criteria that I specified (Interactive Online SQL Training). * In lesson 4 I learned how to create a table statement. This statement is used to create new tables (Interactive Online SQL Training). * In lesson 5 I learned how to use the insert statement to insert or add a row of data into the table (Interactive Online SQL Training). This lesson was extremely hard because of information already being in the table. I made a couple of different tables all with other peoples information already in them. I finally had to make a new table from scratch to get this lesson to work (Interactive Online SQL Training). * In lesson 6 I learned that the update statement is used to update or change records that match specified criteria in the table (Interactive Online SQL Training). * In lesson 7 I learned that the delete statement is used to delete records or rows from the table (Interactive Online SQL Training). * In lesson 8 I learned I learned how to delete
In this section I learned that SQL can input a lot of information into Access for you. I have taken some SQL courses before and still have not learned all of these commands. I can see why people take full degrees on just programming. Another thing I saw was SQL could do a lot of damage to Access. All you would have to do is write a script that could change a lot of information.
During this assignment I learned “SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. (Interactive Online SQL Training)” In the lessons I learned different things: * In lesson 2 I learned that a relational database system contains one or more objects that are called tables. The data or information for the databases is stored in the tables (Interactive Online SQL Training). * In lesson 3 I learned how the select statement is used to query the databases. I also learned how to retrieve selected data that match the criteria that I specified (Interactive Online SQL Training). * In lesson 4 I learned how to create a table statement. This statement is used to create new tables (Interactive Online SQL Training). * In lesson 5 I learned how to use the insert statement to insert or add a row of data into the table (Interactive Online SQL Training). This lesson was extremely hard because of information already being in the table. I made a couple of different tables all with other peoples information already in them. I finally had to make a new table from scratch to get this lesson to work (Interactive Online SQL Training). * In lesson 6 I learned that the update statement is used to update or change records that match specified criteria in the table (Interactive Online SQL Training). * In lesson 7 I learned that the delete statement is used to delete records or rows from the table (Interactive Online SQL Training). * In lesson 8 I learned I learned how to delete
Cited: [ Interactive Online SQL Training. (n.d.). (QuinStreet Inc.) Retrieved March 10, 2013, from SQLCourse.com: http://www.sqlcourse.com/index.html ]