[MT-L] Off-topic - SQL Training
Carla Fuller
--
Joe Cocuzzo
You coud try Open Courseware at MIT “EDx”
Price is FREE
If you search for SQL there is a class starting Monday and other SQL classes.
I paid $$$ for a group of my staff to take a Microsoft Certified training class remotely from company in Canada. We did one person to try it and she had great experience. The larger group not so much, but I think that was due to dud instructor.
My understanding is that the EDx classes are not as structured as the training we paid for, they are more like on line classes where you have lectures to watch, homework, chat board/support of some sort. MIT is spending millions to give away the classes, along with some other lesser institutions like Harvard, Stanford..
|
Dawn Blandford
I would appreciate this information as well.
Thanks
Dawn Blandford
Ganesh Seshadri
Looking at reports already created by others may not be complete, but would be a quick way to get a feel of SQL reports in a meditech environment for the first two steps I’ve mentioned. I wouldn’t start with something like the Meditech MU reports because they’re way too involved for starter reports. Once you get a feel for doing the SQL part, then you can look into tools like Visual Studio and reporting services to create the .rdl files, put it on users’ menus and run scheduled jobs.
The only thing I disagree with you on is to label this issue “off-topic” ;)
Clemmons, Darryl W
Hi,
Since this isn’t “off-topic”, where is a good place to learn about reporting services? I have recently starting writing SQL commands for our hospital—a lot of it to pull quick data for one time reports that I dump into an Excel spreadsheet and email to those requesting the data. I would love to be able to branch out to write scripts we need regularly and schedule them to run. I have been told reporting services would do that, but I know nothing about it.
Thanks,
Darryl Clemmons
Systems Analyst
Phone - (252)535-8562
Fax - (252)535-8563
email - dcle...@halifaxrmc.org
Website - www.halifaxregional.org
| The information contained in this e-mail message is intended only for use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender at the above address/telephone number. |
Susan Iturbe
Contact Aquilus Healthcare Solutions for training. Although they are a new company, they have been involved with RD, RW and SQL for a number of years:
Jeremy Lo
Daniel Korstvedt
Aquilus Healthcare Solutions
Susana R. Iturbe
INFORMATICS ANALYST
P:(830)278-6251 ext. 1169
F: (830)591-0023
Uvalde Memorial Hospital ·
1025 Garner Field Road
· Uvalde, TX 78801
·
www.umhtx.org
Promoting the healing of those we serve by providing compassionate, high-quality healthcare.
This message, together with any attachments, is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential and prohibited from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination, or copying of this message, or any attachment, is strictly prohibited. Please notify the original sender immediately by telephone or by return e-mail and delete this message along with any attachments, from your computer. Thank you. This e-mail is Property of UMH.
Lykins, Patrick
I point all of the people that I tutor and colleagues to http://www.codeacademy.com They have a lot of free courses and I believe all three SQL courses are free, but I have only started the Learn SQL class so I’m not 100% sure how great they are but I have taken several of their other classes just to get a refresher on my skills and they have all been great. I’ve taken several courses for languages that companies that I’ve looked to apply to used which I hadn’t used before and it helped me build basic to intermediate things after I took them so I can attest that they do structure things really well.
Getting the basics of SQL is the first step but learning were all of the data is at in DR is the hard part. Once you start learning were data is at you can slowly build upon those reports. I’ve been solely using DR since 2013 and still can’t find 60+% of the data that I need for some of our reporting needs.
Does anyone know of any good repositories for sample reports?
Patrick L. Lykins
Senior Programmer Analyst
Fairmont Regional Medical Center
1325 Locust Ave.
Fairmont, WV 26554
From: Meditech-l [mailto:meditech-...@mtusers.com]
On Behalf Of Dawn Blandford
Sent: Thursday, August 25, 2016 5:54 PM
To: Carla Fuller <cfull...@gmail.com>
Cc: medit...@mtusers.com
Subject: Re: [MT-L] Off-topic - SQL Training
I would appreciate this information as well.
***Email Disclaimer***
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager (postm...@frmcwv.com). This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.
Fairmont Regional Medical Center
1325 Locust Ave
Fairmont, WV 26554
***End Disclaimer***
Doug Watson
Courses that will allow you to work through some basic SQL examples will probably be beneficial to start out, as I have seen recommended by others on this thread.
I do also think that seeing some examples of functional reports may help you to get a feel for the some basic SQL tactics that you can work to understand and build from.
This can also help you start to see some common tables that you will likely hit over and over again when accessing common data.
One resource that I have used multiple times is the Acmeware Data Repository Network. They have some freely available reports, functions and stored procedures. The reports contain an SSRS .rdl file and a stored procedure. I would recommend finding a report for your MT platform that may be of use and looking at the stored procedure and executing it to see the results to start out.
Here is the link to the Acmeware DR Network: http://www.acmeware.com/data-repository-network.aspx
Thanks,
Doug Watson
Systems Administrator
Decatur County Memorial Hospital
720 N Lincoln Street
Greensburg, IN 47240
812.663.1167
doug....@dcmh.net
From: Carla Fuller [mailto:cfull...@gmail.com]
Sent: Thursday, August 25, 2016 4:41 PM
To: medit...@mtusers.com
This message and attachments may contain protected health information from Decatur County Memorial Hospital, and is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521. This information is intended only for the use of the individual or entity named in the email. Any unintended recipient is hereby notified that the information is privileged and confidential. Any use, disclosure or reproduction of this information is prohibited. Any unintended recipient should contact DCMH by phone at 812-663-4331 or by email immediately and delete/destroy the original message. Confidential health information is protected by state and federal law, including, but not limited to, The Health Insurance Portability and Accountability Act (HIPAA) of 1996 and related regulations. Please note that any views or opinions presented in the email are solely those of the author and do not represent DCMH.
Ganesh Seshadri
I agree it’s less straightforward getting insight into products that are used after the .sql is created. I learned to do scheduled jobs basically by trial and error by using the “subscriptions” options after putting an .rdl on our intranet. However I don’t know what the “best practices” are for setting these up since there are considerations such as using data sources whose access isn’t dependent on the access of the user running it. Similar problem trying to schedule hard copy printouts like we do all the time with Meditech spooled jobs with managed printers – I still don’t know how to do it in SQL. Other issues we have at our site are things like how to have a more current version of Excel associated with the export function in reporting services so as to permit exports of over 64,000 rows (right now I just ask the user what kind of summaries they want from the huge exported file and create multiple reports with just the summaries rather than letting the user get all the data and manipulate it on their own with a more recent version of Excel)
Sexton Kevin - Fauquier
Carla,
I would definitely sign up for training with someone like Acmeware. If you were a SQL expert, they would save you 100 hours of learning the in’s and out’s of the DR. If you are just learning SQL, they will spare you months of painful learning. J
Thanks,
Kevin Sexton
Business Applications Analyst
Fauquier Health 500 Hospital Drive, Warrenton, VA 20186
p. 540-316-5522 f.540-316-5501 sex...@fauquierhealth.org
From: Meditech-l [mailto:meditech-...@mtusers.com] On Behalf Of Carla Fuller
Sent: Thursday, August 25, 2016 4:41 PM
To: medit...@mtusers.com
Subject: [EXTERNAL] [MT-L] Off-topic - SQL Training
WARNING: This email originated outside LifePoint Health’s
email system.
DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.
The information transmitted via this e-mail is intended only for the person or entity to which it is addressed and may contain confidential and/or proprietary information. Any use, review, retransmission, dissemination or other use of, or pursuing of any action in reliance upon this information by persons or entities other than the intended recipient is strictly prohibited. If you are the recipient of this e-mail transmission in error, please reply to the sender and delete the material from any computer. Thank you.
Maureen Bachmann
Hi Patrick
I came to Meditech with a SQL and database developer background. DR is not a standard relational model database.
Meditech has taken hierarchical MUMPS and flattened into tables but there are many difficulties (as you found) in this approach.
Standard training in SQL will help you learn syntax, function calling, query writing and stored procedures. Those are all good! But finding linkages between tables is completely different. It's called recursive inner joins and heres a blog here http://blog.sqlauthority.com/2012/04/24/sql-server-introduction-to-hierarchical-query-using-a-recursive-cte-a-primer/
This is not a beginner skill imho. I know that Meditech will 'turn on' tables for download. I have found some modules that have a table postfixed with "main" that Meditech has created as a way to 'preload' the joined table results. This was a common practice in the 90s to run nightly reporting tables so that results can just be written straight out.
If you download the Meaningful Use SQL scripts from the Meditech website, you can gain insight into how to create stored procedures, how *some* data *might* be structured and how to leverage your hospital's custom scripts.
For large data extractions which is my specialty (usually after sunsetting Meditech) I use NPR to pull it all out then create custom tables with cistom keys so that reporting can be done relationally. (This means the stuff you learn in a SQL course will apply.) I found the DR had many holes in the data (and I know you know what I mean!) for it to be a 100% reliable source of all the data.
Let me know if you have any further questions.
Maureen Bachmann
===###===###===###===###===###===###===
To unsubscribe from the meditech-l, follow the instructions at the URL http://mtusers.com/mailman/options/meditech-l_mtusers.com/
Please do NOT send messages that ask "Please post to the list" or "I'd like to see your answers" or "Send that info to me, too" These are useless messages that just waste the email server's resources. Instead, email the original requester and ask that they send you or post the results of their question.
Go to http://MTUsers.net for other information on the list, as well as:
1) reading meditech-l messages online
2) job opportunities
3) vendor products and service
Do NOT send email to meditech...@MTUsers.com. This is a system email box that is NOT monitored by a human. If you need help or advice on how to use the meditech-l, email ju...@MTUsers.net. Julia helps manage the meditech-l, so she is your best resource.
===***===***===***===***===***===***===
Ratcliffe, Judy
Any suggestion besides Acmeware? I did not find anything there in the way of instruction about anything.
From: Sexton Kevin - Fauquier [mailto:SEX...@fauquierhealth.org]
Sent: Monday, August 29, 2016 11:48 AM
To: Carla Fuller; medit...@mtusers.com; 'CSLis...@SISUnet.org' (CSLis...@SISUnet.org)
Subject: RE: [EXTERNAL] [MT-L] Off-topic - SQL Training
-------------------------------------------------------------------------
This message was secured by
ZixCorp(R).
This e-mail message, including any attachments, is for the sole use of the person(s) to whom it was intended and may contain information that is privileged, confidential or legally protected from disclosure. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments.