Topics tagged sql

Topic	Replies	Views	Activity
Explain normalization with example (1NF, 2NF, 3NF) Data Science, AI and ML sql	2	2204	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	519	18 June 2022
What are indexes and types of indexes in SQL? Data Science, AI and ML sql , data-wrangling	0	315	18 June 2022
How to join columns of 3 different Tables? Data Science, AI and ML sql , join , data-science	3	542	18 June 2022
How to insert an index? Data Science, AI and ML sql , index	2	497	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	269	15 June 2022
What is a primary key? Data Science, AI and ML sql , data-wrangling	0	341	15 June 2022
What is meant by table and field in SQL? Data Science, AI and ML sql , data-wrangling	0	482	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	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	254	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	368	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	281	12 June 2022
What is Instr in MySQL? Data Science, AI and ML sql , data-wrangling	0	268	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	378	12 June 2022
Wildcards in SQL Data Science, AI and ML sql	2	452	12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL? Data Science, AI and ML sql , data-wrangling	0	3085	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	520	12 June 2022
Group BY and MERGE operation Data Science, AI and ML sql	3	531	12 June 2022
Explain subqueries Data Science, AI and ML sql , subqueries	2	502	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	258	12 June 2022
How do I check the codes of an SQL database? Data Science, AI and ML sql , data-wrangling	0	297	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	316	12 June 2022