sql

Topic Replies Views Activity
Explain normalization with example (1NF, 2NF, 3NF)
Data Science, AI and ML
sql
2 1927 18 June 2022
There are 2 tables. One table has missing values in columns. So how do you perform join operation between those 2 tables?
Data Science, AI and ML
sql
2 497 18 June 2022
What are indexes and types of indexes in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 298 18 June 2022
How to join columns of 3 different Tables?
Data Science, AI and ML
sql ,  join ,  data-science
3 512 18 June 2022
How to insert an index?
Data Science, AI and ML
sql ,  index
2 485 18 June 2022
What is the difference between DROP and TRUNCATE commands?
Data Science, AI and ML
sql ,  data-wrangling
0 291 15 June 2022
What is AUTO_INCREMENT?
Data Science, AI and ML
sql ,  data-wrangling
0 286 15 June 2022
What is an index?
Data Science, AI and ML
sql ,  data-wrangling
0 252 15 June 2022
What is a primary key?
Data Science, AI and ML
sql ,  data-wrangling
0 327 15 June 2022
What is meant by table and field in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 456 15 June 2022
What is the DBMS primary key and foreign key?
Data Science, AI and ML
sql ,  data-wrangling
0 325 13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL?
Data Science, AI and ML
sql ,  data-wrangling
0 295 12 June 2022
Does metadata only refer to the description of the attributes in RDBMS?
Data Science, AI and ML
sql ,  data-wrangling
0 240 12 June 2022
Why would you add the same field multiple times to an aggregate query?
Data Science, AI and ML
sql ,  data-wrangling
0 354 12 June 2022
Are there any OLTP databases that are able to replace the use of OLAP databases?
Data Science, AI and ML
sql ,  data-wrangling
0 276 12 June 2022
SQL: What does it mean to own a schema?
Data Science, AI and ML
sql ,  data-wrangling
0 269 12 June 2022
What is Instr in MySQL?
Data Science, AI and ML
sql ,  data-wrangling
0 256 12 June 2022
How do we filter data in SQL?
Data Science, AI and ML
sql ,  filter
2 426 12 June 2022
What is the difference between "like" and "wildcard" in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 1302 12 June 2022
What are views in SQL? How are they useful?
Data Science, AI and ML
sql ,  data-wrangling
0 367 12 June 2022
Wildcards in SQL
Data Science, AI and ML
sql
2 433 12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 2507 12 June 2022
Difference between where and having clause. When do we use where function and when do we use having a function
Data Science, AI and ML
sql ,  function
2 483 12 June 2022
Group BY and MERGE operation
Data Science, AI and ML
sql
3 506 12 June 2022
Explain subqueries
Data Science, AI and ML
sql ,  subqueries
2 485 12 June 2022
Why is creating a data model for a beginner so time consuming and difficult to finish?
Data Science, AI and ML
sql ,  data-wrangling
0 244 12 June 2022
How do I check the codes of an SQL database?
Data Science, AI and ML
sql ,  data-wrangling
0 281 12 June 2022
How is data modified in a relational database?
Data Science, AI and ML
sql ,  data-wrangling
0 273 12 June 2022
What is the main role of SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 262 12 June 2022
Is a Kafka topic the equivalent of a database or a table within a database?
Data Science, AI and ML
sql ,  data-wrangling
0 304 12 June 2022