Question

write sql commands for the following: a. create two different fom1s of the insert command to add a student with a studen t id of 65798 and last name lopez to the student table. b. now write a command that will remove this student from the student table. c. how would your command look like if your task was to remove any student with the last name lopez from the student table? d. create an sql conm1and tha t will modify the name of course ism 4212 from da tabase to introduction to relational databases.

Answer 1

a. INSERT INT0 Student(StudentID, StudentName)

   VALUES(65798, Lopez);

b. DELETE FROM Student

   WHERE StudentName = 'Lopez';

c. DELETE FROM Student

   WHERE StudentLastName = 'Lopez';

d. UPDATE Course

   SET CourseName = 'Introduction to Relational Databases

   WHERE CourseID = 'ISM 4212';

About SQL

SQL is a standardized programming language used to manage relational databases and execute various operations on their contents.

SQL is the most used database language. Thereforeore it may be utilized by virtually any organization that needs to store relational data. SQL queries are used to obtain data from the database. However, their performance varies.

Some of the largest organizations use SQL on a daily basis. They are used for performance analysis and data analysis. Even small businesses and startups utilize SQL for comparable goals. SQL is an excellent language for communicating with databases and retrieving crucial data.

Learn more about SQL here:

brainly.com/question/14469511

#spj4