more SQL practice?

[ultimate99]

I'm almost done with the Oracle SQL online course and I was wondering what can I do to get more practice? I don't want to redo the exercises in the course, but is there a set of exercises I can work on or maybe start a project?

[Jose_49]

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)

[Danielx64]

  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.

[+Biscuits Brown MVC]

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. 

[Danielx64]

  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?

[ultimate99]

How can I start a personal project with SQL? Should I build a couple of tables and just query them, lol?

 

[Circaflex]

  On 31/08/2016 at 22:05, ultimate99 said:

How can I start a personal project with SQL? Should I build a couple of tables and just query them, lol?

 

Expand  

Catalog something of yours. Create a database that you can continue to maintain for personal reasons.

[Danielx64]

Some examples of projects that I can think of:

 

- Own a large CD/DVD/Blu-ray collection? Create a database that catalog then all

- Build a database that keeps tracks of your income/spending.

- Maybe a phone book with name and addresses and other information

[ultimate99]

Thanks for the suggestions. 

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

[DevTech]

  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...

 

 

 

[ultimate99]

  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!