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

We use data bases because is a way to have the data organized. In this sense then is necessary a management system to administrate the data so people develop a language to administrate de organized data in a databases.

Select 1 from (table_name) => will return a column named [1] and having value = 1 for the number of rows in the table you specified in (table_name).
if you want to only select first column in your table use :
SELECT [Column_name] FROM [TableName]