Now Accepting Apple Pay

Apple Pay is the easiest and most secure way to pay on StudyMoose in Safari.

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).

Get to Know The Price Estimate For Your Paper
Topic
Number of pages
Email Invalid email

By clicking “Check Writers’ Offers”, you agree to our terms of service and privacy policy. We’ll occasionally send you promo and account related email

"You must agree to out terms of services and privacy policy"
Check writers' offers

You won’t be charged yet!

Get quality help now
WriterBelle
Verified writer

Proficient in: Data

4.7 (657)

“ Really polite, and a great writer! Task done as described and better, responded to all my questions promptly too! ”

+84 relevant experts are online
Hire writer

* 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 the data and all rows in a table by using the drop table command (Interactive Online SQL Training).

By doing the SQL tutorials I learn another method on how to input data into the Access databases. If I know more about SQL I would easily write a script that could input or update all the data I need into the database for me in a matter of minutes. This could save me time when inputting data or updating the data but the first time making the script could take a while to make. This would cause a delay if the first time the information is needed to be done quickly.

Also if there is an issue with script you could have incorrectly entered information or just not have the script run. In the real world I see SQL being used a lot in my work place. The programmers use it all the time on the programs we build of the customer. Our IA department uses it to scan computer for being compliant to DoD polices. Another place I see this used is with hackers. Hackers use this technique to input or change information in databases. I see that if you have basis knowledge of these commands you could do well in many IT fields.

Cite this page

Relational Database System SQL Analysis Paper. (2020, Jun 02). Retrieved from http://studymoose.com/relational-database-system-sql-analysis-paper-new-essay

👋 Hi! I’m your smart assistant Amy!

Don’t know where to start? Type your requirements and I’ll connect you to an academic expert within 3 minutes.

get help with your assignment