Ten Years of Service
Posts: 183
Threads: 40
SQL Advice 06-28-2017, 10:12 PM
#1
During my interview a few weeks back my boss said something about reports, i work in a hospital as an IT guy. These reports are driven by SQL or whatever, I've never studied SQL so i'm curious if anyone has any experience with it or has made reports for hospitals? My boss hasn't debriefed me on these reports yet because he doesn't want to overwhelm me. (this is my 3rd day) I just want to get a head start on all of this, sorry if i didn't include enough information as i don't have much yet.
![[+]](https://sinister.li/images/modern/collapse_collapsed.png)
•
Ten Years of Service
Posts: 171
Threads: 11
RE: SQL Advice 06-30-2017, 10:44 PM
#3
Personally, I think SQL is one of the easiest languages to learn. The basic commands are written in plain English, and there's really only 20 or so different commands that you will likely be using daily (there's much more, but you can use the same commands to accomplish different things too). I find the only complicated part about SQL is differentiation between the vendors, and some validity rules.
I haven't worked with it in a business environment, but I'll be graduating in the Fall with a degree in DBA. I personally think within a week you can be pretty efficient with SQL if you study and practice. Just go over the basics (SELECT, FROM, WHERE, UPDATE, DELETE, TRUC, etc.) and know them, and you'll be able to catch on pretty quickly.
Twelve Years of Service
Posts: 37
Threads: 0
RE: SQL Advice 07-01-2017, 01:06 AM
#4
SQL is shit in my opinion but it is not hard........FreightTrain gave you the basic commands I could link you a ebook that I used in college if you would like .
Fourteen Years of Service
Posts: 74,287
Threads: 317
RE: SQL Advice 07-01-2017, 07:37 AM
#6
I use SQL (MySQL) for database exploitation each day, so being proficient In SQL Is absolutely Imperative.
Don't just assume that doing a crash course In SQL will see you through. Almost all online tutorials offer the basics and a little advanced learning. To be fluent, you "must learn" every query, statement, operator, constraint, function, encryption, clause, ALIAS, data types, attributes, etc and of course, the "syntax" of how to formulate and apply It.
There are many different types of databases that run SQL (example, Oracle, Microsoft Access, SQL Server, MySQL, Sybase etc) and the syntax can differ between all types. Getting a syntax error and having no clue where It went wrong, Is the last thing you need.
Pertaining to your question, find out the type of SQL database your company Is using and establish the expectations thereafter. You can then apply your learning material accordingly.
![[Image: AD83g1A.png]](http://i.imgur.com/AD83g1A.png)
