Topics tagged sql

Topic	Replies	Views	Activity
Explain normalization with example (1NF, 2NF, 3NF) Data Science, AI and ML sql	2	2281	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	533	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	552	18 June 2022
How to insert an index? Data Science, AI and ML sql , index	2	512	18 June 2022
What is the difference between DROP and TRUNCATE commands? Data Science, AI and ML sql , data-wrangling	0	310	15 June 2022
What is AUTO_INCREMENT? Data Science, AI and ML sql , data-wrangling	0	305	15 June 2022
What is an index? Data Science, AI and ML sql , data-wrangling	0	275	15 June 2022
What is a primary key? Data Science, AI and ML sql , data-wrangling	0	344	15 June 2022
What is meant by table and field in SQL? Data Science, AI and ML sql , data-wrangling	0	487	15 June 2022
What is the DBMS primary key and foreign key? Data Science, AI and ML sql , data-wrangling	0	345	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	261	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	372	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	289	12 June 2022
SQL: What does it mean to own a schema? Data Science, AI and ML sql , data-wrangling	0	289	12 June 2022
What is Instr in MySQL? Data Science, AI and ML sql , data-wrangling	0	271	12 June 2022
How do we filter data in SQL? Data Science, AI and ML sql , filter	2	457	12 June 2022
What is the difference between "like" and "wildcard" in SQL? Data Science, AI and ML sql , data-wrangling	0	1449	12 June 2022
What are views in SQL? How are they useful? Data Science, AI and ML sql , data-wrangling	0	384	12 June 2022
Wildcards in SQL Data Science, AI and ML sql	2	460	12 June 2022
What is the difference between ‘any’, ‘all’ and ‘exists’ in SQL? Data Science, AI and ML sql , data-wrangling	0	3095	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	531	12 June 2022
Group BY and MERGE operation Data Science, AI and ML sql	3	547	12 June 2022
Explain subqueries Data Science, AI and ML sql , subqueries	2	515	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	303	12 June 2022
How is data modified in a relational database? Data Science, AI and ML sql , data-wrangling	0	286	12 June 2022
What is the main role of SQL? Data Science, AI and ML sql , data-wrangling	0	281	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	322	12 June 2022