Topics tagged sql

Topic	Replies	Views	Activity
Explain normalization with example (1NF, 2NF, 3NF) Data Science, AI and ML sql	2	2116	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	509	18 June 2022
What are indexes and types of indexes in SQL? Data Science, AI and ML sql , data-wrangling	0	311	18 June 2022
How to join columns of 3 different Tables? Data Science, AI and ML sql , join , data-science	3	535	18 June 2022
How to insert an index? Data Science, AI and ML sql , index	2	496	18 June 2022
What is the difference between DROP and TRUNCATE commands? Data Science, AI and ML sql , data-wrangling	0	301	15 June 2022
What is AUTO_INCREMENT? Data Science, AI and ML sql , data-wrangling	0	301	15 June 2022
What is an index? Data Science, AI and ML sql , data-wrangling	0	262	15 June 2022
What is a primary key? Data Science, AI and ML sql , data-wrangling	0	340	15 June 2022
What is meant by table and field in SQL? Data Science, AI and ML sql , data-wrangling	0	481	15 June 2022
What is the DBMS primary key and foreign key? Data Science, AI and ML sql , data-wrangling	0	340	13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL? Data Science, AI and ML sql , data-wrangling	0	301	12 June 2022
Does metadata only refer to the description of the attributes in RDBMS? Data Science, AI and ML sql , data-wrangling	0	251	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	367	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	284	12 June 2022
SQL: What does it mean to own a schema? Data Science, AI and ML sql , data-wrangling	0	275	12 June 2022
What is Instr in MySQL? Data Science, AI and ML sql , data-wrangling	0	265	12 June 2022
How do we filter data in SQL? Data Science, AI and ML sql , filter	2	443	12 June 2022
What is the difference between "like" and "wildcard" in SQL? Data Science, AI and ML sql , data-wrangling	0	1445	12 June 2022
What are views in SQL? How are they useful? Data Science, AI and ML sql , data-wrangling	0	375	12 June 2022
Wildcards in SQL Data Science, AI and ML sql	2	442	12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL? Data Science, AI and ML sql , data-wrangling	0	3073	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	506	12 June 2022
Group BY and MERGE operation Data Science, AI and ML sql	3	521	12 June 2022
Explain subqueries Data Science, AI and ML sql , subqueries	2	496	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	257	12 June 2022
How do I check the codes of an SQL database? Data Science, AI and ML sql , data-wrangling	0	295	12 June 2022
How is data modified in a relational database? Data Science, AI and ML sql , data-wrangling	0	282	12 June 2022
What is the main role of SQL? Data Science, AI and ML sql , data-wrangling	0	274	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	314	12 June 2022