.juansantiago
❔ Docker
The subject is quite long to explain. Most videos I found on youtube are outdated and long. You'll need to put at least 4 hours into this to understand everything you need and about 2 or 3 more to complete your assignment. If you have specific doubts I can help, but at least you need to start by watching a couple of videos. Please pay attention to the link on SQLsHack. They are showing how to use the command line to install an SQLServer instance in Docker for Mac. It's the same for Windows, just a different Docker Agent.
10 replies
❔ Docker
https://www.sqlshack.com/how-to-set-up-and-run-sql-server-docker-image/ here you have something similar to what I'm taking about, but is not exactly as what you need to do
10 replies
❔ Docker
https://www.youtube.com/watch?v=fqMOX6JJhGo This is a full video showing the architecture
10 replies
❔ Docker
They are asking you one image for your Gradebook app, one composer file to create a container of the Gradebook app and finally to download a docker image file of SQL Server and create a container. This last part is usually done in just one line of code. You take one image available on the internet, name your container and set all the parameters needed. That's why it's incredible practical. With one line you can deploy a DB server completely functional. Good luck!
10 replies
❔ Docker
Hi. I'd you're using Windows you can download Docker Desktop. It will install everything and system variables. Then you can execute commands from Powershell to work with containers and images.
Thing go like this: Docker will use hyperv to run virtual machines. You download or create images from scratch and to run those images you create containers.
The containers can be started and stopped by these Powershell commands. From Docker Desktop you have a particular console for each container. Use that one.
Dos and Powershell oftenly crash with Docker and you can lost all your progress.
10 replies
❔ How do these SQL queries work?
the distinct is to count the different scores, if you do COUNT(S1.Score) you'll be counting all Scores, even those that are repeated. In your sample table you don't have repeated scores, but it's there to count only different scores
9 replies
❔ How do these SQL queries work?
But that's really messed up. In real life, I don't think you'll ever see such a query. I haven't in +20 years.
I had to think to understand what they want. You have a lot better options to achive the same result.
9 replies
❔ How do these SQL queries work?
Hi. The first one: You're selecting all the data (*) from the Students table when the subquery result is 2. What's the subquery there? Is a calculation of the different scores that are bigger than the current Student being printed on the screen.
Let's say that you take Karen. Her score is 40. There's only one person with a bigger score. So the result of the subquery is 1. Then Karen won't be shown.
If you check Eden you'll see that he/she (idk the gender for that name) has 3 persons with bigger scores. Is not 2 either. The person you want is Casey. When you're doing that question what you are actually asking is Give me any Student that has the 3rd biggest score of all. Not the 3rd person in the rank. The persons with the third biggest Score.
9 replies