sql

Topic Replies Views Activity
Explain normalization with example (1NF, 2NF, 3NF)
Data Science, AI and ML
sql
2 1019 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 329 18 June 2022
What are indexes and types of indexes in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 72 18 June 2022
How to join columns of 3 different Tables?
Data Science, AI and ML
sql ,  join ,  data-science
3 301 18 June 2022
How to insert an index?
Data Science, AI and ML
sql ,  index
2 285 18 June 2022
What is the difference between DROP and TRUNCATE commands?
Data Science, AI and ML
sql ,  data-wrangling
0 61 15 June 2022
What is AUTO_INCREMENT?
Data Science, AI and ML
sql ,  data-wrangling
0 71 15 June 2022
What is an index?
Data Science, AI and ML
sql ,  data-wrangling
0 59 15 June 2022
What is a primary key?
Data Science, AI and ML
sql ,  data-wrangling
0 80 15 June 2022
What is meant by table and field in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 77 15 June 2022
What is the DBMS primary key and foreign key?
Data Science, AI and ML
sql ,  data-wrangling
0 88 13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL?
Data Science, AI and ML
sql ,  data-wrangling
0 67 12 June 2022
Does metadata only refer to the description of the attributes in RDBMS?
Data Science, AI and ML
sql ,  data-wrangling
0 60 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 88 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 59 12 June 2022
SQL: What does it mean to own a schema?
Data Science, AI and ML
sql ,  data-wrangling
0 54 12 June 2022
What is Instr in MySQL?
Data Science, AI and ML
sql ,  data-wrangling
0 73 12 June 2022
How do we filter data in SQL?
Data Science, AI and ML
sql ,  filter
2 228 12 June 2022
What is the difference between "like" and "wildcard" in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 169 12 June 2022
What are views in SQL? How are they useful?
Data Science, AI and ML
sql ,  data-wrangling
0 75 12 June 2022
Wildcards in SQL
Data Science, AI and ML
sql
2 259 12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 60 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 295 12 June 2022
Group BY and MERGE operation
Data Science, AI and ML
sql
3 300 12 June 2022
Explain subqueries
Data Science, AI and ML
sql ,  subqueries
2 277 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 52 12 June 2022
How do I check the codes of an SQL database?
Data Science, AI and ML
sql ,  data-wrangling
0 68 12 June 2022
How is data modified in a relational database?
Data Science, AI and ML
sql ,  data-wrangling
0 81 12 June 2022
What is the main role of SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 70 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 62 12 June 2022