SQL database training classes - off topic commentary | Forum

Topic location: Forum home » Reporting » DR Reporting
Nov 7 '14
2014-11-07 12:14:57
I€™ll just add some Friday afternoon commentary on my beginning experience with Data Repository and SQL from an NPR report writer perspective.
Basically, what SQL and the DR tables have done is take the extremely large data structures in Magic and Client Server, and performed a big bang and created multitudes of tables in the SQL structure.
Totally overwhelming in my opinion, though I am slowly starting to get a grasp of how to join (pun intended) this data all back together in a coherent manner.
SQL is like trying to put Humpty Dumpty back together again,
Jim Purvins
From: Machado, Jorge
Sent: Friday, November 07, 2014 10:27 AM
To: 'Bader, Vivian' ; 'Doug Hiteshew' ; mailto:meditech-l@mtusers.com
Subject: Re: [MT-L] SQL database training classes.
Acmeware has a terrific 2 day class. In my view it wasn't so much the SQL but Acmeware's added value is that they use Meditech tables during the process and provide you with a number of table relation tips and samples.
It is a great starting point and as a developer beginning to understand the logic behind the organization of the DR tables is a great start and just enough "know how" to move on. You can be a master in SQL but the lack of understanding relationships among the tables is the initial stumbling block.

PS: Same answer I have provided in past postings asking the same question€¦.
Jorge
SQLPower4DR


From: Meditech-l [mailto:meditech-l-bounces@mtusers.com] On Behalf Of Bader, Vivian
Sent: Friday, November 07, 2014 12:13 AM
To: 'Doug Hiteshew'; 'meditech-l@mtusers.com'
Subject: Re: [MT-L] SQL database training classes.

We too utilized Acmeware for training and I completely agree that it was worthwhile for our organization!

Thanks,

Vivian Bader
Information Technology, System Analyst
Memorial Hospital
4500 Memorial Drive
Belleville, IL 62220
618-257-5402
vbader@memhosp.com
www.memhosp.com



From: Meditech-l [mailto:meditech-l-bounces@mtusers.com] On Behalf Of Doug Hiteshew
Sent: Thursday, November 06, 2014 7:56 AM
To: meditech-l@mtusers.com
Subject: Re: [MT-L] SQL database training classes.

Happy ALMOST Friday, Gale!

I suggest contacting Acmeware for this. We had them come here to train us for SQL reporting and it was a tremendously worthwhile class. I cannot say much more without you thinking I was either working them or I was related to Glen!

http://www.acmeware.com/

Doug Hiteshew, MT(ASCP)
Senior Systems Analyst
Johnson Memorial Hospital
Franklin, IN 46131
Voice: 317-736-3397
Fax: 317-346-3011
E-mail: dhiteshew@johnsonmemorial.org



From: Meditech-l [mailto:meditech-l-bounces@mtusers.com] On Behalf Of Freeman, Gale
Sent: Wednesday, November 05, 2014 8:16 AM
To: meditech-l@mtusers.com
Subject: [MT-L] SQL database training classes.

This is a little off topic, but with the SQL / DR database management that is becoming more and
more needed, we were wondering what folks have done to train staff .

I was tasked with finding web classes or real classroom settings for 2 or 3 key people. We need to learn
SQL database management and apply it to Meditech when needed.

Does anyone have any great experiences or suggestions ?

We are in Watertown , NY about 70 miles north of Syracuse.

Much thanks in advance

Gale Y. Freeman , MIS Systems Analyst
Samaritan Medical Center MIS Dept
830 Washington St , Watertown, NY 13601 315-785-5751 , gfreeman@shsny.com
Please consider the environment before printing this e-mail. This message and any attachments may contain information that is protected by law as privileged and confidential, and is transmitted for the sole use of the intended recipient. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying or retention of the e-mail or the information contained herein is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by e-mail and permanently delete this e-mail.
How am I doing ? Feel free to email my manager, Joan Varsics @ jvarsics@shsny.com for any suggestions or comments.

The contents of this e-mail message and any attachments are intended solely for the addressee(s) named in this message. This communication is intended to be and to remain confidential and may be subject to applicable privileges. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and its attachments. Do not deliver, distribute or copy this message and/or any attachments and if you are not the intended recipient, do not disclose the contents or take any action in reliance upon the information contained in this communication or any attachments.
This email and any files transmitted with it are confidential
and are intended solely for the use of the individual or
entity to which they are addressed. If you are not the
intended recipient or the person responsible for delivering
the email to the intended recipient, be advised that you have
received the email in error and that any use, dissemination,
forwarding, printing or copying of the email is strictly
prohibited. If you have received this email in error, please
immediately notify Bristol Hospital at 860-585-3000 and
delete this message.

--------------------------------------------------------------------------------
Nov 7 '14
2014-11-07 13:01:55
My thoughts exactly!
Joy C. Merritts
Assistant IT Director
J.C. Blair Memorial Hospital
1225 Warm Springs Avenue
Huntingdon, PA 16652
(814) 643-8557
(814) 643-8771 (fax)
jmerritts@jcblair.org<mailto:jmerritts@jcblair.org>
[Employee Signature PH Affiliate]

Nov 10 '14
2014-11-10 07:27:53
I too wrote in NPR/ RD. I do agree that there are a multitude of tables in the SQL structure compared to NPR/RD. On a positive note, the data is structured in a way that is easy to join compared to a fragment or macro in NPR. The data runs faster compared to NPR as well. I have taken several of our NPR reports that take up to 8 hours to run and have them running in less than a minute in sql! Acmeware has been a tremendous help in teaching us how to find the data needed in the DR tables. Our organization has also sent several of us to SQL classes at a local university to better understand sql language.
Thanks,
Vivian Bader
Information Technology, System Analyst
Memorial Hospital
4500 Memorial Drive
Belleville, IL 62220
618-257-5402
vbader@memhosp.com
www.memhosp.com<http://www.memhosp.com>;
[mh]
chenjinyan
chenjinyan Aug 17 '18
coach factory outlet ralph lauren converse coach factory outlet nike air max 2017 nike air force 1 prada nike outlet store nike air max 90 coach outlet ray ban cheap nfl jerseys coach bags air jordan jordan fitflops nike mercurial nike outlet under armour outlet ugg boots coach outlet y3 shoes louboutin true religion outlet timberland outlet tom ford sunglasses nike outlet store camisetas de futbol converse outlet replica watches lebron 15 tory burch bags ray bans marc jacobs handbags giuseppe zanotti ralph lauren outlet michael kors ugg outlet jordan shoes lebron james jersey maglie calcio versace bags adidas outlet juicy couture outlet nfl jerseys nike store ferragamo shoes replica rolex watches kate spade outlet oakley sunglasses maillot de foot pas cher hermes belt basketball shoes herve leger dresses nike air max 270 canada goose jackets nike factory jordan 5 police sunglasses ralph lauren nike outlet lululemon air jordan air jordan kate spade outlet mishka clothing ralph lauren outlet christian louboutin supreme cartier jewelry manolo blahnik nike blazer jordan shoes ray ban sunglasses michael kors handbags ray ban sunglasses ralph lauren christian louboutin maillot de foot mbt coach outlet fingerlings monkey cheap jerseys red bottom shoes skechers sandals ray ban sunglasses mont blanc pens coach outlet online oakley sunglasses christian louboutin philipp plein outlet true religion outlet pandora jewelry adidas flip flops pandora jewelry mulberry handbags adidas yeezy yeezy desert rat 500 supreme polo ralph lauren nike trainers nike air max michael kors outlet clearance linda farrow sunglasses jordan 8 coach outlet adidas ultra boost marcelo burlon nfl jerseys coach handbags visconti pens michael kors nike flight bonafide stussy clothing paul george shoes coach outlet valentino lebron 15 nine west pandora outlet sac longchamp longchamp outlet bcbg ralph lauren uk true religion jeans swarovski jewelry adidas outlet tommy hilfiger nike air max 2018 coach outlet north face versace sunglasses pasotti ombrelli jordans oakley sunglasses off-white spalding basketball off-white puma fenty balenciaga sandals nike lunarglide dolce and gabbana harden vol 1 nike air max cheap nfl jerseys jordan 6 curry jersey michael kors handbags fitflops sale suicoke sandals nike hyperdunk christian louboutin nike roshe kate spade hundreds clothing coach outlet coach outlet soccer jerseys nike air max 1 tiffany jewelry swarovski persol sunglasses nike dunks burberry sale jordan xx9 ray ban sunglasses adidas slides marc jacobs asics shoes ralph lauren nike shox fitflops jordan 11 pandora jewelry tiffany jewelry coach outlet kate spade handbags pandora jewelry van cleef & arpels coach outlet online victoria's secret oakley sunglasses kate spade outlet nike air force 1 jordan shoes cheap nhl jerseys stephen curry shoes converse shoes ralph lauren adidas nmd michael kors outlet clearance nike air max russell wilson jersey lululemon sale levi jeans supreme clothing north face jackets manolo blahnik ysl makeup nfl jerseys coach outlet jordans cheap jerseys mlb jerseys nike outlet birkenstock belstaff outlet nike sb burberry outlet mlb jerseys coach outlet beats by dre omega watches baseball bats stuart weitzman longchamp tory burch sandals nike air max pandora charms jordan 1 ysl handbags adidas shoes nicholas kirkwood tods nike cortez adidas outlet nfl jerseys oakley sunglasses prada sunglasses columbia nike tennis nike air max mbt coach factory outlet michael kors outlet puma shoes yoga pants vibram fivefingers nike revolution oakley sunglasses longchamp nike air max plus woolrich jackets michael kors outlet coach outlet ray ban sunglasses under armour shoes nike dunks ray ban sunglasses birkenstock kate spade handbags shoe carnival hermes nike free run vans shoes oakley sunglasses polo outlet tom brady jersey michael kors handbags breguet watches longchamp outlet polo ralph lauren running shoes jordan undefeated clothing louboutin adidas stan smith coach outlet ralph lauren outlet mac cosmetics timberland ray ban wayfarers michael kors flip flops malone souliers pandora jewelry soccer jersey adidas shoes manchester united jersey hermes bags lee jeans superdry clothing saint laurent sunglasses supreme new york jordans coach outlet coach outlet columbia outlet true religion christian louboutin outlet swarovski jewelry flipflops nike blazer nike shoes for women ナイキ スニーカー mcm outlet canada goose outlet canada goose sale cristiano ronaldo jersey ronaldo jersey 20188.18chenjinyan 
wqwq
wqwq Aug 30 '18

.C. longchamp -- raiders nfl jersey Rodney swarovski crystal Hood connected from all over jordan jerseys the jimmy choo outlet court jazz jersey while freshman Jabari Parker was busy swatting shots and north face scoring nike in transition. MANHATTAN, asics gel Kan. swarovski canada -- Bill Snyder has always polo ralph lauren outlet online valued continuity, whether belstaff sale on northface the coaching staff air max 90 or marc jacobs in nike air yeezy the huddle.Its pandora why four of his assistants, including co-offensive nike coordinators prada sunglasses Dana redskins nfl jersey Dimel and michael kors outlet Del Miller, have converse spent at least 18 years at free run Kansas State. ralph lauren And why mizuno running relative youngsters thomas sabo on discount shoes the staff, ray ban wayfarer such as Andre cheap jerseys Coleman and Blake Seiler, played for burberry sale the Wildcats before joining ray ban outlet the profession.Its always significant, Snyder said, to have ralph lauren online that kind of continuity michael kors handbags where nike free run you dont have to go through swarovski online the re-teaching jimmy choo shoes or swarovski jewelry changing cheap mlb jerseys of things chaussure timberland you firmly believe in, not that pacers jersey were not open polo ralph lauren to change. juicy couture outlet We burberry sale certainly oakley sunglasses outlet are. oakley canada I love kevin durant jersey to entertain soccer shoes new cheap nhl jerseys thoughts, new tory burch handbags ideas. nfl jerseys ... Sac Hermes But burberry handbags you hear some players iphone 5 cases get up and say, nike air huarache `Well, Ive jets nfl jersey gone occhiali ray ban through four coordinators in four cheap michael kors years, and timberwolves jersey thats kind hermes birkin bag of tumultuous.We have been fortunate not to michael kors taschen have lions nfl jersey to go through that over fred perry uk the burberry handbags outlet last mcm handbags outlet quarter of louboutin outlet a decade.In nba jersey truth, things have been fairly consistent at Kansas true religion State new balance outlet for much max shoes longer, giants nfl jersey and replica rolex Snyder michael kors bags is nike air max the levi's jeans reason for much of north face backpacks it. occhiali oakley Sure, there was his brief christian louboutin shoes retirement converse about a decade ago, but when he returned seahawks nfl jersey to boston celtics the corner office michael kors purses in 49ers nfl jersey the Vanier Football Complex, it true religion outlet was michael kors bags as if nothing had changed.It polo ralph lauren outlet took two years jordans to get back kings jersey to designer handbags a bowl air max game. Now, grizzlies jersey the Wildcats have been to jack wolfskin outlet six ralph lauren polo straight.But as the 76-year-old fossil uhren Snyder ferragamo shoes enters converse sneakers his jordans 26th season, there are growing coach outlet sale rumblings tory burch outlet that it may be his last. He dsquared2 jeans needs burberry seven ray ban outlet wins to reach 200 for his career, hogan a significant nfl jerseys milestone, and the talent returning from coach store an injury-plagued michael kors outlet 2015 season tommy hilfiger means Kansas State cheap nike shoes could air max compete for air max another burberry sale Big 12 babyliss pro title.Perhaps such oakley success would make dolphins nfl jersey it aktienkurse adidas the ralph lauren right time.The nike outlet good nike.com thing about oakley vault Coach Snyder oakley sunglasses is hes new balance canada real consistent. Theres not a lot tn pas cher of long champ surprises, titans nfl jersey said quarterback five finger shoes Jesse Ertz. uggs outlet Its cheap oakley sunglasses the same burberry thing, the coach bags same motto, mont blanc the same work habits. Everything nike Air Max Plaza is, `Work bcbg max hard omega and tods outlet online get better swarovski jewelry each day. cheap oakley I think cavaliers jerseys its rams nfl jersey proven kate spade outlet online with nike canada how our teams usually ray-ban sunglasses do.As the texans nfl jersey Wildcats start another season with Snyder on the sideline, ferragamo shoes here are moncler jackets outlet story lines nba jerseys to nike air max watch:SEASON OPENER: Lambasted cheap jordans for years for scheduling chi hair soft in the new balance non-conference, thee bcbg max azria Wildcats buccaneers nfl jersey will visit ralph lauren outlet online Stanford on michael kors Sept..C. -- Rodney Hood connected from all denver nuggets jersey over nike the court nike roshe while philipp plein clothing freshman versace shoes outlet Jabari Parker was coach sacs busy baseball bats swatting bottega veneta shots timberland boots and scoring in transition. MANHATTAN, cheap true religion Kan. -- Bill Snyder asics shoes outlet has always swarovski valued red bottoms continuity, whether on the coaching staff or in longchamp handbags the oakley vault huddle.Its coach handbags why four of supra footwear his giuseppe shoes assistants, air max one including co-offensive coordinators Dana Dimel burberry outlet online and michael kors handbags Del michael kors canada Miller, givenchy handbags have spent at least coach outlet 18 horloges years at Kansas State. And why relative youngsters kobe bryant shoes on the nike free run 5.0 staff, such barbour outlet online as Andre Coleman and Blake hermes Seiler, played versace clothes for the belstaff jackets Wildcats before joining the profession.Its ralph lauren uk always significant, Snyder said, cheap jerseys to have that adidas outlet kind nike huaraches of dsquared2 outlet continuity christian louboutin where pandora jewelry you hugo boss clothes dont moncler jackets have to go through adidas the re-teaching or changing of things you nike firmly believe colts nfl jersey in, air jordan shoes not that were not open to change. We certainly are. nike I love to barbour jackets entertain new thoughts, new ideas. mcm bags ... But patriots nfl jersey you timberland shoes hear some falcons nfl jersey players get up prada and say, ipad mini cases `Well, Ive dwyane wade jersey gone ed hardy through four coordinators in four cheap nba jerseys years, phoenix suns and ralph lauren thats kind of polo ralph lauren tumultuous.We have been fortunate chrome hearts store not to michael kors have to go through that over skechers the under armour shoes outlet last ralph lauren outlet online quarter of a decade.In truth, things jaguars nfl jersey have been fairly consistent at basketball shoes Kansas State for much longer, nike shoes and uggs on sale Snyder plein outlet is the reason broncos nfl jersey for much of it. Sure, michael kors purses there was montblanc his nike air huarache brief retirement about a tommy hilfiger decade ago, but when beats by dr dre he parajumpers mens jackets returned to the corner office in steelers nfl jersey the katespade Vanier nike air max 2014 Football michael kors handbags Complex, it was as if nothing had vikings nfl jersey changed.It took two coach factory online years to get back to a bowl burberry outlet store game. Now, the coach outlet online Wildcats have knicks jersey been to six straight.But as the nba jerseys 76-year-old Snyder enters ralph lauren polos his 26th timberland outlet season, there charlotte hornets jerseys are jack wolfskin jackets growing stephen curry shoes rumblings ralph lauren outlet that it may be his adidas canada last. He fendi bags needs bucks jersey seven wins to mcm handbags reach 200 for coach factory outlet online his coach store outlet career, a significant milestone, and the adidas talent returning trail blazers jersey from an injury-plagued ralph lauren factory store 2015 season means Kansas State could compete for another Big brooklyn nets jersey 12 cheap ray ban title.Perhaps such calvin klein underwear success ray ban sunglasses outlet would make it the air max right time.The good raptors jersey thing about Coach Snyder is hes mcm bags real barbour jackets consistent. Theres not a lot of surprises, san antonio spurs jersey said quarterback Jesse north face Ertz. Its the ray ban sunglasses outlet same thing, the same motto, the ray bans same pandora charms work habits. Everything is, ray ban `Work ralph lauren outlet hard and get chargers nfl jersey better air jordans each day. I ray ban outlet online think its panthers nfl jersey proven with how cheap nhl jerseys our teams usually do.As fitflop outlet the Wildcats start wizards jersey another ray ban sonnenbrillen season with Snyder on salvatore ferragamo the hogan outlet sideline, cheap oakley sunglasses here are story salvatore ferragamo lines to watch:SEASON OPENER: Lambasted roshe runs for longchamp outlet years for scheduling cowboys nfl jersey soft in the air force non-conference, thee christian louboutin shoes Wildcats will visit azcardinals nfl jersey Stanford nike free on Sept..C. -- Rodney north face jackets Hood hilfiger outlet connected from lunette ray ban all over the court while freshman Jabari Parker was busy swatting shots and true religion jeans women scoring in transition. longchamp MANHATTAN, Kan. packers nfl jersey -- Bill guess outlet online Snyder bears nfl jersey has always belstaff jackets outlet valued continuity, whether on pandora schmuck the coaching staff red bottom shoes or louboutin in the huddle.Its why lacoste outlet four tory burch handbags of his assistants, including co-offensive coordinators jordan Dana Dimel michael kors and Del prada shoes Miller, pandora jewelry have spent puma online at chiefs nfl jersey least 18 tory burch shoes years at nike mercurial Kansas lacoste outlet online State. michael kors outlet And why relative youngsters nike air max on mbt mens shoes the staff, veneta such as Andre Coleman guciheaven women shoes and cheap mlb jerseys Blake Seiler, played converse shoes for the Wildcats before joining the adidas outlet profession.Its always significant, Snyder prada handbags said, to have eyeglasses stores that skechers shoes outlet kind reebok shoes outlet of continuity coach outlet usa where cheap jerseys you dont have to nike air max 2014 go through the hermes bags re-teaching or changing of things you oakley sunglasses firmly believe links of london watches in, not that were the north face outlet not ray ban open to the north face change. We certainly are. I love ray ban to huarache entertain new thoughts, new ideas. katespade ... But nike roche run you supra shoes hear some stone island outlet players ralph lauren polos get kate spade outlet online up and say, `Well, Ive thomas sabo gone nike outlet through armani shoes outlet four mcm handbags coordinators hilfiger online shop in michael kors four bills nfl jersey years, oakley sunglasses outlet and thats kind of lunette oakley tumultuous.We philadelphia 76ers jerseys have been michael kors fortunate not to have to go through that over the last quarter of eagles nfl jersey a decade.In truth, things have oakley sunglasses been ray ban fairly under armour consistent saints nfl jersey at Kansas cheap true religion State for coach purses factory much vans longer, and Snyder is the thomas sabo charms reason atlanta hawks jersey for mizuno wave much of it. Sure, there was his salomon brief retirement about a decade ago, knockoff handbags but when vans shoes outlet he barbour jackets returned to the corner office pandora in the Vanier tommy hilfiger Football Complex, burberry sale it was as north face outlet if nothing prada outlet had changed.It michael kors handbags took two nba jersey years tommy hilfiger to get back to ralph lauren a bowl game. Now, north face the ralph lauren outlet online Wildcats have burberry handbags been to ecco outlet online six true religion jeans men straight.But fred perry outlet as the asics 76-year-old Snyder clippers jersey enters his indoor soccer shoes 26th beats by dr dre season, marc jacobs there are jerseys from china growing new balance rumblings that it may dansko outlet be adidas his beats audio last. He needs kobe bryant jerseys seven cheap glasses wins to michael kors uk reach vans shoes 200 for new balance shoes his career, cheap barbour jackets a significant milestone, and coach outlet online the talent returning browns nfl jersey from an injury-plagued 2015 season means michael kors Kansas michael kors outlet State could coach store online compete for bengals nfl jersey another ralph lauren online shop Big oakley 12 title.Perhaps such success would make guess clothings outlet it the right time.The air max 2015 good thing roshe about Coach Snyder coach handbags outlet is hes real reebok consistent. Theres not woolrich mens jackets a fidget spinner lot giuseppe zanotti sneakers of surprises, said quarterback Jesse nike air force Ertz. Its burberry outlet the same hogan women shoes thing, the c.c beanies same motto, adidas online the same work habits. golden state warriors jerseys Everything puma sneakers is, `Work hard and get better new orleans pelicans each nike mercurial day. I think orlando magic jersey its polo ralph proven handbags outlet with rockets jersey how cheap oakley sunglasses our teams usually do.As the skechers mens shoes Wildcats start another season louboutin outlet with omega watches Snyder dallas mavericks jerseys on the ravens nfl jersey sideline, here are story lines to roshe run watch:SEASON OPENER: vans Lambasted for years hilfiger outlet for scheduling soft coach outlet canada in ferragamo the non-conference, air jordan retro thee juicy couture Wildcats nike roshe will michael kors purses visit Stanford on Sept.