sql

Topic Replies Views Activity
Explain normalization with example (1NF, 2NF, 3NF)
Data Science, AI and ML
sql
2 1256 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 378 18 June 2022
What are indexes and types of indexes in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 137 18 June 2022
How to join columns of 3 different Tables?
Data Science, AI and ML
sql ,  join ,  data-science
3 354 18 June 2022
How to insert an index?
Data Science, AI and ML
sql ,  index
2 335 18 June 2022
What is the difference between DROP and TRUNCATE commands?
Data Science, AI and ML
sql ,  data-wrangling
0 133 15 June 2022
What is AUTO_INCREMENT?
Data Science, AI and ML
sql ,  data-wrangling
0 150 15 June 2022
What is an index?
Data Science, AI and ML
sql ,  data-wrangling
0 120 15 June 2022
What is a primary key?
Data Science, AI and ML
sql ,  data-wrangling
0 157 15 June 2022
What is meant by table and field in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 148 15 June 2022
What is the DBMS primary key and foreign key?
Data Science, AI and ML
sql ,  data-wrangling
0 160 13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL?
Data Science, AI and ML
sql ,  data-wrangling
0 139 12 June 2022
Does metadata only refer to the description of the attributes in RDBMS?
Data Science, AI and ML
sql ,  data-wrangling
0 114 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 184 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 122 12 June 2022
SQL: What does it mean to own a schema?
Data Science, AI and ML
sql ,  data-wrangling
0 113 12 June 2022
What is Instr in MySQL?
Data Science, AI and ML
sql ,  data-wrangling
0 130 12 June 2022
How do we filter data in SQL?
Data Science, AI and ML
sql ,  filter
2 279 12 June 2022
What is the difference between "like" and "wildcard" in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 542 12 June 2022
What are views in SQL? How are they useful?
Data Science, AI and ML
sql ,  data-wrangling
0 143 12 June 2022
Wildcards in SQL
Data Science, AI and ML
sql
2 303 12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 491 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 335 12 June 2022
Group BY and MERGE operation
Data Science, AI and ML
sql
3 349 12 June 2022
Explain subqueries
Data Science, AI and ML
sql ,  subqueries
2 336 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 110 12 June 2022
How do I check the codes of an SQL database?
Data Science, AI and ML
sql ,  data-wrangling
0 130 12 June 2022
How is data modified in a relational database?
Data Science, AI and ML
sql ,  data-wrangling
0 143 12 June 2022
What is the main role of SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 123 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 142 12 June 2022