• 0

more SQL practice?

Asked by ultimate99,

 Share

Question

10 answers to this question

Recommended Posts

  • 0
Grand Master

Jose_49

Posted
Posted

What it has usually helped me are the following:

 

a) Start a personal project... Something interesting to build (You will learn a lot!). 

b) Go to StackOverflow or the StackExchange Network and try answering/reading questions/answers about SQL. 

 

If you want to expand your knowledge, I don't know if the courses cover it, but you can look over Table Partitioning (a.k.a Sharding) and how to do replications (This will only happen when you're targeting hundred of thousands of users, at least)

  • 0
Grand Master

Danielx64

Posted
Posted
  On 30/08/2016 at 11:16, Jose_49 said:

a) Start a personal project... Something interesting to build (You will learn a lot!). 

Expand  

I echo this, I started working on my own replacement for WordPress (as I had enough of it) and I learnt a lot - Not in just writing MySql statements but general logic like working out what I need and what I don't need. It also help me in deciding what could be split off to other tables because the same information can be used in different ways.

  • 0
Veteran

+Biscuits Brown MVC

Posted
  • MVC
Posted

I find one of the big 'gothchas' is performance. Most SQL is almost trivial to construct and will run pretty well in a lab setting. Performance  (or lack of it) really starts to show once you run things on tables with hundreds of millions of rows. I'm not sure in your  course if you have access to data that extensive. If not, that may be something to explore. 

  • 0
Grand Master

Danielx64

Posted
Posted
  On 30/08/2016 at 11:34, Zag L. said:

I find one of the big 'gothchas' is performance. Most SQL is almost trivial to construct and will run pretty well in a lab setting. Performance  (or lack of it) really starts to show once you run things on tables with hundreds of millions of rows. I'm not sure in your  course if you have access to data that extensive. If not, that may be something to explore. 

Expand  

It not just about how that SQL statement is written, it also about how it's stored in the database. Are you storing that data as text when it better to us BLOB instead?

  • 0
Grand Master

DevTech

Posted
Posted
  On 03/09/2016 at 20:54, ultimate99 said:

Thanks for the suggestions. 

I'm actually looking for something more health care related, any thoughts?

Expand  

https://github.com/search?utf8=✓&q=medical+sql&type=Repositories&ref=searchresults

 

https://github.com/search?utf8=✓&q=hospital+sql&type=Repositories&ref=searchresults

 

https://github.com/search?utf8=✓&q=doctor+sql&type=Repositories&ref=searchresults

 

https://github.com/search?utf8=✓&q=emergency+sql&type=Repositories&ref=searchresults

 

GitHub has a really bad search engine so something like SQL which would be used inside an application won't show up in search results unless the project actually used the word "SQL" in the high level summary or as part of the project name.

 

So repeating the above searches without the SQL will yeild far more ideas for medical based SQL examples.

 

BTW, "health" is a useless search term since in programming terms it is a common phrase for monitoring and logging of running applications.

 

So, from GitHub, we can construct some real world SQL challenges:

 

Exercise 1.

 

Take this project

 

https://github.com/CESoftWorks/sldb  "Patient Management Suite for Polysomnography Labs, developed for the Paphos General Hospital"

 

and convert the Access database it uses to SQL Server or Oracle

 

Exercise 2.

 

Take this Hospital Management System and add a real-time incoming ambulance display board with patient status and triage info

 

https://github.com/emrulkayes2103/Hospital-Management-System

 

Exercise 3.

 

Convert the Web API of this project to use MS SQL Server instead of MySQL

 

https://github.com/jlruatpuia/SRHF DBMS for State Referral Hospital, Falkawn

 

and so on...

 

 

 

  • 0
Grand Master

ultimate99

Posted
  • Author
Posted
  On 03/09/2016 at 23:51, DevTech said:

https://github.com/search?utf8=✓&q=medical+sql&type=Repositories&ref=searchresults

 

https://github.com/search?utf8=✓&q=hospital+sql&type=Repositories&ref=searchresults

 

https://github.com/search?utf8=✓&q=doctor+sql&type=Repositories&ref=searchresults

 

https://github.com/search?utf8=✓&q=emergency+sql&type=Repositories&ref=searchresults

 

GitHub has a really bad search engine so something like SQL which would be used inside an application won't show up in search results unless the project actually used the word "SQL" in the high level summary or as part of the project name.

 

So repeating the above searches without the SQL will yeild far more ideas for medical based SQL examples.

 

BTW, "health" is a useless search term since in programming terms it is a common phrase for monitoring and logging of running applications.

 

So, from GitHub, we can construct some real world SQL challenges:

 

Exercise 1.

 

Take this project

 

https://github.com/CESoftWorks/sldb  "Patient Management Suite for Polysomnography Labs, developed for the Paphos General Hospital"

 

and convert the Access database it uses to SQL Server or Oracle

 

Exercise 2.

 

Take this Hospital Management System and add a real-time incoming ambulance display board with patient status and triage info

 

https://github.com/emrulkayes2103/Hospital-Management-System

 

Exercise 3.

 

Convert the Web API of this project to use MS SQL Server instead of MySQL

 

https://github.com/jlruatpuia/SRHF DBMS for State Referral Hospital, Falkawn

 

and so on...

 

 

 

Expand  

woah! dude, thank you!

This topic is now closed to further replies.
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Posts

    • Politically funny images of the World

      By +primortal · Posted

    • Linus Torvalds releases a pretty ordinary Linux 6.16-rc3

      By zikalify · Posted

      Linus Torvalds releases a pretty ordinary Linux 6.16-rc3 by Paul Hill Linus Torvalds, the head and founder of the Linux kernel, has announced the release of Linux 6.16-rc3. This release comes with fixes for new features that were introduced during the merge window several weeks ago, and for old features where issues have been detected or improvements need to be made. If you remember last week, Torvalds said that rc2 seemed smaller than usual, putting it down to people going on vacation. He said this week’s rc3 seems to be in the usual ballpark for this time of the cycle, so everything looks “entirely normal.” In terms of changes, this release is “dominated” by wireless networking and GPU driver updates, however, Torvalds doesn’t think that anything really huge stands out this time. While nothing stands out Torvalds urged people to carry on testing and submitting patches. This update saw improvements to the core system and architecture. There have been improvements to ARM64 KVM that improve stability and correctness of virtualizations on ARM64. There are also improvements to RISC-V KVM and Trust Domain Extensions (TDX) for Intel which expand and secure virtualization capabilities on those architectures. On the graphics front, there are fixes for the amdgpu and amdkfd drivers that fix job handling, engine resets, display corruption, and power management features. The driver used for Qualcomm’s Adreno GPUs has been updated to improve fault handling, display timing, and driver binding. The open-source Nouveau (Nvidia) driver has been updated with fixes for GSP message queue references, potential integer overflows, buffer size adjustments, and a use-after-free bug. Finally, the Intel i915 driver has been updated to address early wedge issues, memory initializations, and build errors. There are also improvements to Wi-Fi devices (ath12k and iwlwifi), sound (ALSA), power management on AMD, and file system improvements (OverlayFS, EROFS, XFS, NFS, SunRPC). Linux 6.16 is due for release at the end of July and will then be picked up by Linux distributions, which will be the first interaction most end users have with the new features in this update. The main benefit of a newer kernel is that Linux will work on newer hardware, so if you’ve had issues with Linux, be sure to try it periodically in case your hardware is now supported.
    • Microsoft Visual Studio Professional 2022 for Windows reaches all-time low price

      By adrynalyne · Posted

      I guess it depends on if you sign in or not.
    • Microsoft Visual Studio Professional 2022 for Windows reaches all-time low price

      By Matthew S. · Posted

      Technically, it should be account-bound after activating it
    • This hidden Windows 11 setting makes the system feel a lot faster

      By Ringo Tanner · Posted

      Follow this video, and a new build will feel a lot faster. https://www.youtube.com/watch?...WLAytRBid7Qryv3&index=1

  • Recent Achievements

    • Week One Done
      urbanmopdubai1 earned a badge
      Week One Done
    • One Month Later
      Jim Dugan earned a badge
      One Month Later
    • First Post
      Johnny Mrkvička earned a badge
      First Post
    • Week One Done
      viraltui earned a badge
      Week One Done
    • One Month Later
      serfegyed earned a badge
      One Month Later

  • Popular Contributors

    1. 1
      +primortal
      645
    2. 2
      Michael Scrip
      226
    3. 3
      ATLien_0
      219
    4. 4
      Steven P.
      150
    5. 5
      Xenon
      146
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!