Topics tagged an-introductory-guide-to-sql_

Topic	Replies	Views	Activity
Why both names are inserted if the length of one string is more than 5? Courses quiz-16__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	20	January 9, 2023
Ascending order wrong? Courses group-by__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	17	December 20, 2022
Is it just me, or 2nd question just doesn't make sense, is there an error? Courses quiz-10__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	19	December 14, 2022
Bug - 2nd question is completely the same as 1st, but has another answer with wrong info in the explanation Courses quiz-14__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	17	December 13, 2022
Any explanation for the now(), sleep(10), now() in question 2? Courses quiz-16__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	17	December 13, 2022
Explanation missing for question 4's answer Courses quiz-12__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	2	35	November 23, 2022
Question 1 answer using correlated subquery, as another option Courses solution-practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	23	November 19, 2022
How Question 3 is supposed to be solved if session variables were not covered in the course? Courses solution-practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	15	November 18, 2022
Your window function example isn't even supported by MySQL version, and why is GROUP BY there? Courses solution-practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	12	November 18, 2022
Typo in expected result for question 1 Courses practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	17	November 18, 2022
What "alternate rows" means in the 1st question? Courses quiz-10__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	22	November 14, 2022
For those wondering about question 4 answer with case and aggregate function Courses quiz-14__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	16	November 12, 2022
More details for quiz 5? Isn't TRUNCATE a DDL which can't be rolled back? And "log" is mentioned, which wan't in any topics in lessons Courses quiz-12__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	38	November 10, 2022
Aren't heap tables just tables where there is no clustered index? Why should they be in memory and not last after the restart? Courses quiz-12__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	17	November 10, 2022
Any possibility to add a clarification for the 2nd question? Courses quiz-11__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	19	November 10, 2022
Question 4 - some clarification? Correct answer contradicts the question in a way Courses quiz-10__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	18	November 10, 2022
Definition of child/parent tables for whose who wonder Courses quiz-7__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	0	26	November 3, 2022
Mistake in output table in Question 2, value "9" in bID from nowhere Courses quiz-7__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	34	October 28, 2022
What about DDL triggers? Courses what-are-triggers__triggers__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	27	October 25, 2022
How can we use cursor for a dynamic sql query? Courses cursors__stored-procedures__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek , data-structures-for-coding-interviews-in-java__coderust	1	46	October 24, 2022
No image which "explains the flow control" Courses conditional-statements__stored-procedures__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	48	October 24, 2022
What is meant by "secondary index" in this lesson? Courses continued__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	2	40	October 22, 2022
Natural join with multiple columns of the same name Courses natural-join__joins__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	32	September 21, 2022
Change the capitalized letter Courses creating-a-view__views__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	30	September 21, 2022
Cannot Use Order By on numbers Courses order-by__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	21	September 16, 2022
Terminal Screen sustaining time problem Courses creating-a-view__views__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	2	27	September 13, 2022
The screen appearing time too short Courses creating-a-view__views__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	23	September 13, 2022
The introductory paragraph is irrelevant Courses more-on-alter__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	34	September 11, 2022
Not explained why it would be "catastrophic" if leaf nodes of InnoDB would point to rows Courses continued__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	26	September 8, 2022
So do non-clustered indexes point to rows or pages? Courses continued__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek	1	26	September 8, 2022

Why both names are inserted if the length of one string is more than 5?

Courses

quiz-16__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

20

January 9, 2023

Ascending order wrong?

Courses

group-by__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

17

December 20, 2022

Is it just me, or 2nd question just doesn't make sense, is there an error?

Courses

quiz-10__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

19

December 14, 2022

Bug - 2nd question is completely the same as 1st, but has another answer with wrong info in the explanation

Courses

quiz-14__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

17

December 13, 2022

Any explanation for the now(), sleep(10), now() in question 2?

Courses

quiz-16__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

17

December 13, 2022

Explanation missing for question 4's answer

Courses

quiz-12__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

2

35

November 23, 2022

Question 1 answer using correlated subquery, as another option

Courses

solution-practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

23

November 19, 2022

How Question 3 is supposed to be solved if session variables were not covered in the course?

Courses

solution-practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

15

November 18, 2022

Your window function example isn't even supported by MySQL version, and why is GROUP BY there?

Courses

solution-practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

12

November 18, 2022

Typo in expected result for question 1

Courses

practice-set-5__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

17

November 18, 2022

What "alternate rows" means in the 1st question?

Courses

quiz-10__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

22

November 14, 2022

For those wondering about question 4 answer with case and aggregate function

Courses

quiz-14__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

16

November 12, 2022

More details for quiz 5? Isn't TRUNCATE a DDL which can't be rolled back? And "log" is mentioned, which wan't in any topics in lessons

Courses

quiz-12__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

38

November 10, 2022

Aren't heap tables just tables where there is no clustered index? Why should they be in memory and not last after the restart?

Courses

quiz-12__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

17

November 10, 2022

Any possibility to add a clarification for the 2nd question?

Courses

quiz-11__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

19

November 10, 2022

Question 4 - some clarification? Correct answer contradicts the question in a way

Courses

quiz-10__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

18

November 10, 2022

Definition of child/parent tables for whose who wonder

Courses

quiz-7__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

0

26

November 3, 2022

Mistake in output table in Question 2, value "9" in bID from nowhere

Courses

quiz-7__practice-prep__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

34

October 28, 2022

What about DDL triggers?

Courses

what-are-triggers__triggers__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

27

October 25, 2022

How can we use cursor for a dynamic sql query?

Courses

cursors__stored-procedures__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek , data-structures-for-coding-interviews-in-java__coderust

1

46

October 24, 2022

No image which "explains the flow control"

Courses

conditional-statements__stored-procedures__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

48

October 24, 2022

What is meant by "secondary index" in this lesson?

Courses

continued__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

2

40

October 22, 2022

Natural join with multiple columns of the same name

Courses

natural-join__joins__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

32

September 21, 2022

Change the capitalized letter

Courses

creating-a-view__views__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

30

September 21, 2022

Cannot Use Order By on numbers

Courses

order-by__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

21

September 16, 2022

Terminal Screen sustaining time problem

Courses

creating-a-view__views__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

2

27

September 13, 2022

The screen appearing time too short

Courses

creating-a-view__views__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

23

September 13, 2022

The introductory paragraph is irrelevant

Courses

more-on-alter__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

34

September 11, 2022

Not explained why it would be "catastrophic" if leaf nodes of InnoDB would point to rows

Courses

continued__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

26

September 8, 2022

So do non-clustered indexes point to rows or pages?

Courses

continued__basic-sql__an-introductory-guide-to-sql , an-introductory-guide-to-sql__datajek

1

26

September 8, 2022