Curriculum: Improve guided practice of intro to databases

[vegetabill]

The relational DB lesson is far too lengthy. It should introduce some basics, ensure the participant has installed and can successfully use Postgres, and leave the rest of it up to the other lessons, e.g. SQL 1.

Areas to Improve

• [ ] The guided practice is not really guided at all - guide the reader through the example actions with concrete suggestion.
• [ ] Replace hypothetical query examples of SELECT etc
  
  
  
  • [ ] Use an activity based around a test table instead with real examples
  
  
• [ ] Remove "under construction" note at the top that refers to this issue

Related to #1380

[meghaa105]

Can you assign this to me?

[Kundan28]

@meghaa105 Sorry to say but this issue could not be worked under GSSoC20

[meghaa105]

I can work anyways

On Tue, 10 Mar, 2020, 5:35 PM Kundan, [e-mail] wrote:

@meghaa105 https://github.com/meghaa105 Sorry to say but this issue
could not be worked under GSSoC20

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/Techtonica/curriculum/issues/1202?email_source=notifications&email_token=ALE7EJJMSQAYL2ADWNOYRTDRGYUH7A5CNFSM4K3UBTY2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEOLELBI#issuecomment-597050757,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/ALE7EJICJWGTDQAVDB46N4LRGYUH7ANCNFSM4K3UBTYQ
.

[Kundan28]

I can work anyways

Are you a participant of GSSoC20 ?

[shreyakapoor08]

I want to take up this issue

[Kundan28]

@shreyakapoor08 Sorry to say but this issue could not be worked under GSSoC20

[meghaa105]

Yes

On Wed, 11 Mar, 2020, 12:26 PM Kundan, [e-mail] wrote:

I can work anyways

Are you a part of GSSoC20 ?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/Techtonica/curriculum/issues/1202?email_source=notifications&email_token=ALE7EJM6JQOIFTEZF7CPXALRG4YYHA5CNFSM4K3UBTY2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEOOLQSI#issuecomment-597473353,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/ALE7EJJQUX7QAODJV37XWBLRG4YYHANCNFSM4K3UBTYQ
.

[Kundan28]

Then how could you work ? @meghaa105

[alodahl]

@vegetabill are things being removed already in SQL1, or do they need to be moved over there?

[alodahl]

@meghaa105 are you still interested?

[meghaa105]

Yes

[Kundan28]

@meghaa105 I have assigned you this issue.

Please follow the Contributor instructions and ask any questions here.

[alodahl]

Hi @meghaa105 , how is this issue going? Let us know if you have any questions.

[Kundan28]

@meghaa105 Are you still working on this, please reply as soon as possible. Otherwise someone else would be assigned to this issue.

[meghaa105]

Yes I am working on it, will update you in a day or two.

On Tue, Apr 28, 2020 at 11:51 PM Kundan [e-mail] wrote:

@meghaa105 https://github.com/meghaa105 Are you still working on this,
please reply as soon as possible. Otherwise someone else would be assigned
to this issue.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/Techtonica/curriculum/issues/1202#issuecomment-620775559,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/ALE7EJKUPB2LZ764O2JQ4ATRO4NCFANCNFSM4K3UBTYQ
.

[Kundan28]

Yes I am working on it, will update you in a day or two.

Sure.

[alodahl]

Hi @meghaa105 , feel free to continue working on this issue, but as it was assigned to you 6 weeks ago and there's no PR yet, I will make this available for someone else to try. I will merge whoever's PR is ready first.

[alodahl]

Assigning to @iamdhruvsharma

[iamdhruvsharma]

Hi!

Can you just update me on the things that I need to do because I believe some of the issues are already being handled. So, if you can tell me how exactly I can help that would be more efficient.

Thanks!

[alodahl]

@iamdhruvsharma , I don't think this issue is out of date. I'm not sure what you mean.

[iamdhruvsharma]

Thanks for the response.

Please tell me little bit more about this:

Basic column types - include examples and their equivalent in JavaScript
e.g. varchar is like String
remove Text
remove auto increment

[iamdhruvsharma]

Replace all the "Common mistakes" with just one: "Database can refer to the tables, the database server, or SQL. You'll just have to use context to know what someone means"

The above requirement is already completed I believe.

[alodahl]

I don't even see a common mistakes section... it may have been deleted completely in the last merge. Could you add it back with the "just one" part? It should look like the "Common Mistakes & Misconceptions" section here: https://github.com/Techtonica/curriculum/blob/master/_templates/topic-outline.md#common-mistakes--misconceptions

[iamdhruvsharma]

Sure! Will definitely do.

[iamdhruvsharma]

Move the non-relational examples to an Optional Section covering other types of databases. What about this one??

Rest I am all clear and will do all the things very soon.

[alodahl]

If you find examples that aren't directly about relational databases, remove them, or group them all in a section clearly marked something like "Non-relational dbs to be aware of."

[iamdhruvsharma]

Got the idea!!! On it now. Will complete as soon as possible. Thanks for the clarification.

[alodahl]

Hi @iamdhruvsharma , any word on this one?

[iamdhruvsharma]

Hi there!! Hope you are perfectly safe in this difficult situation. Sorry of the delays, for last couple of weeks I was little with my University curriculum but I assure I will complete this task very soon. On it now.

[iamdhruvsharma]

Hello! Just made the pull request. Please have a look.

[vegetabill]

@alodahl I merged in the small fixes from that PR and now this description is accurate as to what remains. Unfortunately what remains is much more important for the apprentices 😢