Topics tagged sql

Topic	Replies	Views	Activity
Explain normalization with example (1NF, 2NF, 3NF) Data Science, AI and ML sql	2	2237	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	521	18 June 2022
What are indexes and types of indexes in SQL? Data Science, AI and ML sql , data-wrangling	0	316	18 June 2022
How to join columns of 3 different Tables? Data Science, AI and ML sql , join , data-science	3	544	18 June 2022
How to insert an index? Data Science, AI and ML sql , index	2	498	18 June 2022
What is the difference between DROP and TRUNCATE commands? Data Science, AI and ML sql , data-wrangling	0	304	15 June 2022
What is AUTO_INCREMENT? Data Science, AI and ML sql , data-wrangling	0	303	15 June 2022
What is an index? Data Science, AI and ML sql , data-wrangling	0	270	15 June 2022
What is a primary key? Data Science, AI and ML sql , data-wrangling	0	343	15 June 2022
What is meant by table and field in SQL? Data Science, AI and ML sql , data-wrangling	0	483	15 June 2022
What is the DBMS primary key and foreign key? Data Science, AI and ML sql , data-wrangling	0	341	13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL? Data Science, AI and ML sql , data-wrangling	0	302	12 June 2022
Does metadata only refer to the description of the attributes in RDBMS? Data Science, AI and ML sql , data-wrangling	0	255	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	369	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	286	12 June 2022
SQL: What does it mean to own a schema? Data Science, AI and ML sql , data-wrangling	0	282	12 June 2022
What is Instr in MySQL? Data Science, AI and ML sql , data-wrangling	0	269	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	380	12 June 2022
Wildcards in SQL Data Science, AI and ML sql	2	456	12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL? Data Science, AI and ML sql , data-wrangling	0	3089	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	523	12 June 2022
Group BY and MERGE operation Data Science, AI and ML sql	3	532	12 June 2022
Explain subqueries Data Science, AI and ML sql , subqueries	2	505	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	260	12 June 2022
How do I check the codes of an SQL database? Data Science, AI and ML sql , data-wrangling	0	298	12 June 2022
How is data modified in a relational database? Data Science, AI and ML sql , data-wrangling	0	283	12 June 2022
What is the main role of SQL? Data Science, AI and ML sql , data-wrangling	0	275	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	316	12 June 2022