Question

What do you know about database and SQL?

What do you know about database and SQL?

Homework Answers

Answer #1
database is an organized collection of data(tables), stored and accessed from a computer.
when databases become more complex, they are often developed using formal design and modeling techniques.
databases comprises of tables also called as relations.

SQL(Structured Query Language)
SQL is a Query language(a type of programming language) which is used in programming and designed for managing data held in a database management system.
A typical SQL query looks like the one below.

select Column1, Column2 from TableName

This query is used to retrieve Column1, Column2 from a table named TableName
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
What do you really know about the life-styles of older people? What do you know about...
What do you really know about the life-styles of older people? What do you know about about aging and its effects?
(PHP and My SQL for Dynamic Websites) What version of MySQL are you using? if you...
(PHP and My SQL for Dynamic Websites) What version of MySQL are you using? if you dont know, find out now! What characters can be used in database,table, and column names? Should you treat database,table, and column names as case-sensitive or case-insensitive? What are the three general column types? What are the differences between CHAR and VARCHAR?
Assignment 2 Instructions You need to access to the database and write SQL queries on the...
Assignment 2 Instructions You need to access to the database and write SQL queries on the following site: https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in 1. Use INNER JOIN to create a report. In this report, list each customer’s CustomerID, CustomerName, and their each OrderID and each order’s OrderDate, if the customer has ever placed an order. You should use the Customers table and the Orders table in the database to complete this query.   2. Use INNER JOIN to create a report. In this report, list...
topic: oracle sql I have a database 'guitar'. I want to add a user to that...
topic: oracle sql I have a database 'guitar'. I want to add a user to that database. Please get me started at least with overview / tutorial.
what do know about supply and demand? explain? what can you explain about economic models? what...
what do know about supply and demand? explain? what can you explain about economic models? what can you explain about surplus and shortage? what do you know about equilibrium? what do you understand about changes in quantity demanded versus demand? what do you understand changes in quantity supply and supply? what do you understand in normal goods versus inferior goods? what are your thoughts on quantity supplied, law demand, equilibrium, quantity demand?
Why should passwords be applied to services individually and uniquely when using SQL database.
Why should passwords be applied to services individually and uniquely when using SQL database.
A Guide to SQL Questions 1. How do you create a table using SQL? 2. How...
A Guide to SQL Questions 1. How do you create a table using SQL? 2. How do you delete a table using SQL? 3. What are the common data types used to define columns using SQL? 4. Identify the best data type to use to store the following data in Oracle, in SQL Server, and in Access:    a. The month, day, and year that an employee was hired    b. An employee’s Social Security number    c. The department...
1. Most database applications require a host programming language to communicate with the database using SQL....
1. Most database applications require a host programming language to communicate with the database using SQL. A wide range of programming languages can be used with SQL,from traditional languages such as COBOL, FORTRAN, and Assembler to more modern languages such as C/C++, Java, and Visual Basic. Your choice of host programming language can impact the way you will have to code SQL. True or False? 2. It is an entity name guideline: a. Do not pluralize the name; use singular...
what is your opinion about Twixters? Do they exist? Do you know one? Are you one
what is your opinion about Twixters? Do they exist? Do you know one? Are you one
I Was able to backup using transact-sql, but I could not do a restore for some...
I Was able to backup using transact-sql, but I could not do a restore for some reason. IT says database have not been backup. But the .bak file is in the folder. Here is my code for restore: USE master RESTORE DATABASE [SmartHomes FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\SQLTestDB.bak' WITH FILE = 1, NOUNLOAD, STATS = 5 GO My backup file that was successful: BACKUP DATABASE SmartHomes TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\SmartHomes.bak' WITH NOFORMAT, NOINIT,  NAME = N'SmartHomes-Full...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT