What do we use to work with databases?

Question

In the context of this exercise, what do we use to work with databases?

Answer

To work with databases, we use software known as database management systems, or DBMS for short. Database management systems let us do very useful things such as create and manipulate database tables, by writing and running code in the form of queries or statements. For an example, the following query will return all the rows from a database,

SELECT * 
FROM table;

Some of the most popular and well-known database management systems are SQLite which is used in the courses on Codecademy, Oracle, SQL Server, MySQL, and PostgreSQL.

24 Likes

to become familiar with the company’s datd

With the help of

SELECT *
FROM browse
LIMIT 10;

I have selected all columns with 10 rows.

When i used below mentioned code

SELECT 1
FROM browse
LIMIT 10;

It is showing all 1s .

Why the code has not selected 1 column in case of this? Or Is there any way we can limit the column and unlimited rows?

You select individual columns by their name. For example , if you wanted only the user_id column, you could:

SELECT user_id
FROM browse;

Leaving out the LIMIT clause would return all 2,352 user id’s in a single column.

1 Like

SELECT 1
FROM browse;
They can limit the column (SELECT 1 - limit columns have value = 1) and unlimit rows.

1 Like