Notifications
Clear all
Topic starter
I am the Clinical Information Specialist for GE at our clinic and started in this position end of April this year. I do not have any prior "IT" experience or education. I worked as a clinic receptionist prior to accepting my current position. I am beginning to think I could use some SQL training as a lot of responses I get on this forum include solutions using SQL. Does anyone have advice on where/how to obtain training for SQL? Would I need to take some other educational courses prior to courses on SQL?
Posted : December 1, 2015 7:57 am
Hi Jessica,
I provide SQL training / CPS specific. If your company is wanting me to provide you on-site training or remote (online) training, I can do that as well. Please email me at [email protected] if you are interested. You can also visit my website at www.aphoenixtech.com for more information about myself and my company. I was considering doing something like this for a Centricity Live session, but maybe in the near future.
Posted : December 1, 2015 8:03 am
Jessica,
At you own leisure, there are several resources that are available on the web. I often turn to youtube for the quick and dirty overview of some basic information. you can take a look at the following link to see if it helps at all or search for SQL Basics in youtube. I would also encourage you to take a look at some local classroom SQL/IT Basic Training classes. you will want to right click the link and open in a new window.
SQL Lesson 1 (She is a little difficult to understand at first but covers the basics)
to gain familiarity to the CPS specifically, you can take a look at the Data Dictionary that GE provides to you online. you should have a login for their site to view that information. if not, please contact your VAR or GE.
Good luck and Congrats on your new position!
Mark
Posted : December 1, 2015 9:19 am
You can go this route for sure, however, please practice on a test database before you do anything to live. One wrong script can screw up your entire database and CPS system. Make sure you keep good backups as well. If you will be using mostly SELECT statements to get your data, best practice is to create a READ ONLY user so that nothing can be overwritten or deleted by mistake. Even as someone who works on custom scripts all the time, I still use a test database prior to running anything on the live system, so be very careful.
Posted : December 1, 2015 11:18 am
Preach it brother.
Posted : December 1, 2015 12:35 pm
I like "SQL Queries For Mere Mortals" (bought off Amazon); you'll also need to learn the data dictionary. Take GE specific training if possible. If you learn Crystal Reports, you can mostly avoid writing your own queries, but Crystal has a steep learning curve, IMO.
Posted : December 2, 2015 3:32 am
Take a look the SQL training at Microsoft Virtual Academy. You can start with
Posted : December 2, 2015 10:17 pm
First, I want to say Congratulations on your big step up.
Second, there is a lot to learn to buckle up
Third, here is a site I used just for practice with the basics http://www.sqlcourse.com/
Hang in there and Enjoy The Ride!
Posted : December 3, 2015 10:50 am
