SQL: SQL stands for “Structured Query Language”. The current version of SQL is “ANSI SQL – 92”. SQL is not a programming language. It is text-based and it is also called as data sublanguage. In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on. It contains constructs which are used to define and process database . They are executed using DBMS-supplied command prompt. Some of the DBMS products provide GUI tools in order to perform tasks are as follows: SQL Server Oracle Database MySQL Display values from table: The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML). Syntax to view the contents using asterisk () is as follows: SELECT FROM table_Name; Columns can also be retrieved by replacing all the column names in place of the asterisk symbol. “JOIN ON” Syntax: The “JOIN ON” syntax is usually used to join two or more than two tables. This syntax usually works with “WHERE” clause. The keyword “JOIN” is normally placed between the table names in the SQL FROM clause. The keyword “ON” includes the matching key values.

Question

Want to see the full answer?

Answer 1

Question

Chapter 3, Problem 3.39RQ

Program Plan Intro

SQL:

SQL stands for “Structured Query Language”.

The current version of SQL is “ANSI SQL – 92”.

SQL is not a programming language. It is text-based and it is also called as data sublanguage.

In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.

It contains constructs which are used to define and process database. They are executed using DBMS-supplied command prompt.

Some of the DBMS products provide GUI tools in order to perform tasks are as follows:

SQL Server

Oracle Database

MySQL

Display values from table:

The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML). Syntax to view the contents using asterisk () is as follows:

SELECT FROM table_Name;

Columns can also be retrieved by replacing all the column names in place of the asterisk symbol.

“JOIN ON” Syntax:

The “JOIN ON” syntax is usually used to join two or more than two tables. This syntax usually works with “WHERE” clause. The keyword “JOIN” is normally placed between the table names in the SQL FROM clause. The keyword “ON” includes the matching key values.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Security in general means the protection of an asset. In the context of computer and network security, explore and explain what assets must be protected within an online university. What the threats are to the security of these assets, and what countermeasures are available to mitigate and protect the organization from such threats. For each of the assets you identify, assign an impact level (low, moderate, or high) for the loss of confidentiality, availability, and integrity. Justify your answers.

Please include comments and docs comments on the program. The two other classes are Attraction and Entertainment.

Object-Oriented Programming In this separate files. ent, you'll need to build and run a small Zoo in Lennoxville. All classes must be created in Animal (5) First, start by building a class that describes an Animal at a Zoo. It should have one private instance variable for the name of the animal, and one for its hunger status (fed or hungry). Add methods for setting and getting the hunger satus variable, along with a getter for the name. Consider how these should be named for code clarity. For instance, using a method called hungry () to make the animal hungry could be used as a setter for the hunger field. The same logic could be applied to when it's being fed: public void feed () { this.fed = true; Furthermore, the getter for the fed variable could be named is Fed as it is more descriptive about what it answers when compared to get Fed. Keep this technique in mind for future class designs. Zoo (10) Now we have the animals designed and ready for building a little Zoo! Build a class…