sql

Topic Replies Views Activity
Explain normalization with example (1NF, 2NF, 3NF)
Data Science, AI and ML
sql
2 1773 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 465 18 June 2022
What are indexes and types of indexes in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 266 18 June 2022
How to join columns of 3 different Tables?
Data Science, AI and ML
sql ,  join ,  data-science
3 473 18 June 2022
How to insert an index?
Data Science, AI and ML
sql ,  index
2 452 18 June 2022
What is the difference between DROP and TRUNCATE commands?
Data Science, AI and ML
sql ,  data-wrangling
0 247 15 June 2022
What is AUTO_INCREMENT?
Data Science, AI and ML
sql ,  data-wrangling
0 256 15 June 2022
What is an index?
Data Science, AI and ML
sql ,  data-wrangling
0 223 15 June 2022
What is a primary key?
Data Science, AI and ML
sql ,  data-wrangling
0 282 15 June 2022
What is meant by table and field in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 395 15 June 2022
What is the DBMS primary key and foreign key?
Data Science, AI and ML
sql ,  data-wrangling
0 280 13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL?
Data Science, AI and ML
sql ,  data-wrangling
0 260 12 June 2022
Does metadata only refer to the description of the attributes in RDBMS?
Data Science, AI and ML
sql ,  data-wrangling
0 207 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 308 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 238 12 June 2022
SQL: What does it mean to own a schema?
Data Science, AI and ML
sql ,  data-wrangling
0 221 12 June 2022
What is Instr in MySQL?
Data Science, AI and ML
sql ,  data-wrangling
0 222 12 June 2022
How do we filter data in SQL?
Data Science, AI and ML
sql ,  filter
2 383 12 June 2022
What is the difference between "like" and "wildcard" in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 1164 12 June 2022
What are views in SQL? How are they useful?
Data Science, AI and ML
sql ,  data-wrangling
0 306 12 June 2022
Wildcards in SQL
Data Science, AI and ML
sql
2 403 12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 2136 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 436 12 June 2022
Group BY and MERGE operation
Data Science, AI and ML
sql
3 464 12 June 2022
Explain subqueries
Data Science, AI and ML
sql ,  subqueries
2 448 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 208 12 June 2022
How do I check the codes of an SQL database?
Data Science, AI and ML
sql ,  data-wrangling
0 242 12 June 2022
How is data modified in a relational database?
Data Science, AI and ML
sql ,  data-wrangling
0 243 12 June 2022
What is the main role of SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 232 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 262 12 June 2022