What do we use to work with databases?

Computer Science
1

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.

36 Likes
2

to become familiar with the company’s datd

3

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 .

image
image.png1366×768 87.4 KB

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?

1 Like
4

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.

6 Likes
5

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

Screenshot%20from%202019-08-11%2002-36-24
Screenshot from 2019-08-11 02-36-24.png441×539 3.21 KB

1 Like
6

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.

1 Like
7

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]

8

Does this course have prerequisites please?

9

In my opinion that we use SQL to work with databases

1 Like
10

The thing is, looking at the schema there wasn’t a column named 1. Is it that integer selections will override the logic of the database and generate it’s own table?

11

No, it doesn’t. If you are new to coding, I can recommend starting with Code Foundations career path. I started with it😉. It helped me to decide what to learn🥳.

2 Likes
12

We use a data management systems such as a SQL, Excel or Google Sheets to sift through data and draw conclusions based on the problem we’re attempting to solve, or information we’re attempting to string together to tell a cohesive story.

1 Like
13

if i want to select 2 column, for example user_id and browse_date
how do i incorporate into Select function?

1 Like
14

You could try:

SELECT user_id, browse_date
FROM   browse;
1 Like
15

We use a software to work with database known as Data Base Management System or DBMS in short.
To interact with the DBMS ,we write SQL(structured query language) queries like:
SELECT * FROM tablename;
will fetch or display all tables of the tablename table
For example if a table students exists in database, then to display it we write:
SELECT * FROM students;

Some of the popular dbms software used today Mysql, PostgreSQL, Oracle etc.

1 Like
16

We use SQL query to work with databases

17

What are some common challenges that data scientists face when working with large datasets, and how do they typically overcome these challenges?

18

What we use to work with databases is SQL, because this database management system allows us to order the data in a table. And in this way it’s easier for us when we want to manipulate it.