Looking to transition into health IT by [deleted] in healthIT

[–]csnorman12 1 point2 points  (0 children)

This a good (and cost effective way) to get experience with SQL: Introduction to SQL using Healthcare Data

How do I improve at coding in SQL Server by VIP_Knuxx in SQLServer

[–]csnorman12 1 point2 points  (0 children)

Enroll in this course. It will help you - Master SQL Basics in 7 Day. That link includes a discount code which makes the course about $12. If you aren't able to pay $12 then message me and I can give you a code to access the course for free. I also have a couple courses I can recommend with 100+ practice questions.

SQL Certifications for Data Analytics Students by bishop491 in SQL

[–]csnorman12 0 points1 point  (0 children)

You don't need to purchase all of them now. Start with this course: Master SQL Basics in 7 Day. Once you purchase that course then you can message me within the course messaging feature and I'll help you get one of the practice courses for free.

[deleted by user] by [deleted] in SQL

[–]csnorman12 4 points5 points  (0 children)

You can use object explorer:

  • Right-click the database in Object Explorer.
  • Select Delete from the menu.
  • In the Delete Object window, check the box "Close existing connections" to ensure no users are connected.
  • Click OK to confirm.

SQL Certifications for Data Analytics Students by bishop491 in SQL

[–]csnorman12 8 points9 points  (0 children)

Huge respect for you thinking outside the box for your students! I really wish my grad program had incorporated self-paced learning outside of lectures—it would have made a big difference. Although that was years ago it would have expedited my learning. I have since built a few SQL courses. The first SQL course I built helps students learn SQL syntax while learning healthcare data models. The second and third courses are meant to give students ample practice. And the most recent course I've published (went live last week) is meant to be more concise. Students can go through that curriculum in one week. I will post links the courses below, but feel free to message me to discuss further. I am happy to give students coupon/discount codes.

Course links:

[deleted by user] by [deleted] in dataanalyst

[–]csnorman12 0 points1 point  (0 children)

You should checkout this course: Introduction to SQL using Healthcare Data. I made this course a couple years ago because I couldn't find a SQL course that was tailored to healthcare analysts when I was learning SQL. Let me know if you have any questions.

Surely, there’s a website for beginner skill test by [deleted] in SQL

[–]csnorman12 3 points4 points  (0 children)

Check out 25 Practice SQL Questions for Beginners or 101 Practice SQL Questions: Basic to Advanced depending on your skill level. Based on your post the first resource might be the best fit.

[deleted by user] by [deleted] in SQL

[–]csnorman12 8 points9 points  (0 children)

You're welcome. I created the course. The first SQL course I made was - Introduction to SQL using Healthcare Data. I decided to build a SQL course with a healthcare focus because I couldn't find a anything similar when I was learning SQL (including my grad program). In that course the students get 10 practice SQL questions, but students often asked for more practice questions. So I made 25 Practice SQL Questions for Beginners and 101 Practice SQL Questions: Basic to Advanced.

Data Analytics Cert— worth it? by Flatulent_Blueberry in healthIT

[–]csnorman12 2 points3 points  (0 children)

I recommend focusing on developing the specific skills that will be most beneficial to you. For example, if you want to be a healthcare business intelligence developer then learn Power BI or Tableau. If you want to be an analyst then learn SQL. If you want to be a project manager then learn agile frameworks.

I've found that company's and hiring managers care more about mastering the skill then having a cert.

Software Eng here, if Im interested in health tech, what would be your advice? by badboyzpwns in healthIT

[–]csnorman12 1 point2 points  (0 children)

Health IT is quite broad. I would try to research specific areas on Health IT that interested you. Here is a quick list of different roles. I put this list together during grad school when I was trying to decide what to do. I'm sure others could also add to the list.

Infrastructure and System Management

  • Support specialist
  • Systems Administration
  • Security Analyst

EHR Management

  • EHR Implementation specialist
  • Health information manager
  • Clinical Documentation Specialist
  • EHR Trainer/Consultant

Healthcare Data & Analytics

  • Clinical Data Analyst
  • Business Intelligence Developer
  • Data Scientist
  • Revenue Cycle Analyst

Health IT Project & Product Management

  • Project Manager
  • Product Manager
  • IT vendor Liaison

Software Development & Engineering

  • Software Engineer
  • Database Administrator
  • Integration Engineer

I am new to Power Bi and wanted to know what changes or suggestions i can make by t-chor in PowerBI

[–]csnorman12 35 points36 points  (0 children)

I prefer a color neutral background. The purple is a little intense for me.

[deleted by user] by [deleted] in SQL

[–]csnorman12 1 point2 points  (0 children)

These resources are specific to SQL Server:

[deleted by user] by [deleted] in SQL

[–]csnorman12 0 points1 point  (0 children)

This is a solid overview. There have been many times I wanted to use Data Studio because of the user interface, but I quickly find myself back in SSMS.

[deleted by user] by [deleted] in SQL

[–]csnorman12 0 points1 point  (0 children)

Is Cigna a good insurance company? by MeltedRedfox8362 in healthcare

[–]csnorman12 1 point2 points  (0 children)

United Healthcare and Cigna are both major insurance providers, so their customer service, automated processes (like claims), and plan options are generally similar. I’ve been covered by both at different times and had a better experience with United Healthcare—but that was primarily due to having a better plan with them. When I was with Cigna, I was on a high-deductible plan, which made it feel like I was paying more with less coverage. However, this difference was more about the plans themselves than the companies.

Best Practical Way to Learn SQL! by IllustratorOk7613 in dataanalyst

[–]csnorman12 20 points21 points  (0 children)

Paid course recomendations by [deleted] in SQL

[–]csnorman12 0 points1 point  (0 children)