Topics tagged sql

Topic	Replies	Views	Activity
Explain normalization with example (1NF, 2NF, 3NF) Data Science, AI and ML sql	2	2254	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	525	18 June 2022
What are indexes and types of indexes in SQL? Data Science, AI and ML sql , data-wrangling	0	320	18 June 2022
How to join columns of 3 different Tables? Data Science, AI and ML sql , join , data-science	3	545	18 June 2022
How to insert an index? Data Science, AI and ML sql , index	2	505	18 June 2022
What is the difference between DROP and TRUNCATE commands? Data Science, AI and ML sql , data-wrangling	0	307	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	271	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	486	15 June 2022
What is the DBMS primary key and foreign key? Data Science, AI and ML sql , data-wrangling	0	343	13 June 2022
Do I really need triggers for relational database, for example, PostgreSQL? Data Science, AI and ML sql , data-wrangling	0	307	12 June 2022
Does metadata only refer to the description of the attributes in RDBMS? Data Science, AI and ML sql , data-wrangling	0	258	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	371	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	287	12 June 2022
SQL: What does it mean to own a schema? Data Science, AI and ML sql , data-wrangling	0	286	12 June 2022
What is Instr in MySQL? Data Science, AI and ML sql , data-wrangling	0	270	12 June 2022
How do we filter data in SQL? Data Science, AI and ML sql , filter	2	452	12 June 2022
What is the difference between "like" and "wildcard" in SQL? Data Science, AI and ML sql , data-wrangling	0	1448	12 June 2022
What are views in SQL? How are they useful? Data Science, AI and ML sql , data-wrangling	0	381	12 June 2022
Wildcards in SQL Data Science, AI and ML sql	2	458	12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL? Data Science, AI and ML sql , data-wrangling	0	3094	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	527	12 June 2022
Group BY and MERGE operation Data Science, AI and ML sql	3	540	12 June 2022
Explain subqueries Data Science, AI and ML sql , subqueries	2	512	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	263	12 June 2022
How do I check the codes of an SQL database? Data Science, AI and ML sql , data-wrangling	0	299	12 June 2022
How is data modified in a relational database? Data Science, AI and ML sql , data-wrangling	0	285	12 June 2022
What is the main role of SQL? Data Science, AI and ML sql , data-wrangling	0	279	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	319	12 June 2022