sql

Topic Replies Views Activity
Explain normalization with example (1NF, 2NF, 3NF)
Data Science, AI and ML
sql
2 755 18 June 2022
What is JDBC?
Data Science, AI and ML
sql
2 308 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 257 18 June 2022
What are indexes and types of indexes in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 19 18 June 2022
How to join columns of 3 different Tables?
Data Science, AI and ML
sql ,  join ,  data-science
3 255 18 June 2022
How to insert an index?
Data Science, AI and ML
sql ,  index
2 242 18 June 2022
What is the difference between DROP and TRUNCATE commands?
Data Science, AI and ML
sql ,  data-wrangling
0 14 15 June 2022
What is AUTO_INCREMENT?
Data Science, AI and ML
sql ,  data-wrangling
0 16 15 June 2022
What is an index?
Data Science, AI and ML
sql ,  data-wrangling
0 12 15 June 2022
What is a primary key?
Data Science, AI and ML
sql ,  data-wrangling
0 21 15 June 2022
What is meant by table and field in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 17 15 June 2022
What is the DBMS primary key and foreign key?
Data Science, AI and ML
sql ,  data-wrangling
0 26 13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL?
Data Science, AI and ML
sql ,  data-wrangling
0 15 12 June 2022
Does metadata only refer to the description of the attributes in RDBMS?
Data Science, AI and ML
sql ,  data-wrangling
0 13 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 13 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 13 12 June 2022
SQL: What does it mean to own a schema?
Data Science, AI and ML
sql ,  data-wrangling
0 11 12 June 2022
What is Instr in MySQL?
Data Science, AI and ML
sql ,  data-wrangling
0 16 12 June 2022
How do we filter data in SQL?
Data Science, AI and ML
sql ,  filter
2 195 12 June 2022
What is the difference between "like" and "wildcard" in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 24 12 June 2022
What are views in SQL? How are they useful?
Data Science, AI and ML
sql ,  data-wrangling
0 22 12 June 2022
Wildcards in SQL
Data Science, AI and ML
sql
2 216 12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 14 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 226 12 June 2022
Group BY and MERGE operation
Data Science, AI and ML
sql
3 257 12 June 2022
Explain subqueries
Data Science, AI and ML
sql ,  subqueries
2 223 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 15 12 June 2022
How do I check the codes of an SQL database?
Data Science, AI and ML
sql ,  data-wrangling
0 15 12 June 2022
How is data modified in a relational database?
Data Science, AI and ML
sql ,  data-wrangling
0 16 12 June 2022
What is the main role of SQL?
Data Science, AI and ML
sql ,  data-wrangling
0 18 12 June 2022