• 0

can someone be a SQL "developer" or "programmer" without CS background?


Question

I had a conversation with my colleague at work the other day about healthcare and IT and how programming can be self-taught and I wanted to get your opinions as well:

 

1. What makes someone a SQL developer or programmer? 

2. What about someone in the healthcare field and wants to focus on SQL rather than straight up programming (java, C, C++, javascript, etc.), is that possible?

3. As my workflow develops, I'm moving away from MS and limiting to just using a Mac, would that affect learning/using SQL in anyway (especially that hospital systems tend to depend on Windows heavily) other than https://www.visualstudio.com/vs/visual-studio-mac/?

4 answers to this question

Recommended Posts

  • 0
  On 05/01/2017 at 12:06, ultimate99 said:

I had a conversation with my colleague at work the other day about healthcare and IT and how programming can be self-taught and I wanted to get your opinions as well:

 

1. What makes someone a SQL developer or programmer? 

2. What about someone in the healthcare field and wants to focus on SQL rather than straight up programming (java, C, C++, javascript, etc.), is that possible?

3. As my workflow develops, I'm moving away from MS and limiting to just using a Mac, would that affect learning/using SQL in anyway (especially that hospital systems tend to depend on Windows heavily) other than https://www.visualstudio.com/vs/visual-studio-mac/?

Expand  

1. The ability to do it. I imagine it would include designing and deploying databases with proper normalization and best practices, knowing how to write stored procedures, triggers, views, functions etc. 

2. Yes but it limits you. I do both where I work. 

3. Not really, you could always spin up a VM for sql server either locally or in azure. Programs like datagrip can work with t-sql fine. 

  • 0

Hello,

I have a friend who works as a SQL developer at an healthcare company.  His degree is in business, and he got started coding with HTML and ColdFusion in the 1990s.  In response to your questions:

 

  1. What makes him a SQL developer is the HR department, because they are the ones who set job titles at his place of employment.
  2. It's a good idea to be comfortable in 2-3 languages, and have passing familiarity with a few more.  This allows you to help troubleshoot and fix things which use your database.  You don't have to be an expert, but you should have some level of fluency.  This will also help your career/paycheck as you move forward and take on new roles and responsibilities.
  3. You can always run Windows in a Boot Camp partition or via Parallels.  It probably wouldn't be a bad idea to familiarize yourself with using Linux and Microsoft SQL for Linux as well.

Regards,

 

Aryeh Goretsky

 

  • 0

1)in order to be a SQL developer, one must have a good understanding of relational databases, data types and sizes, data formats.  Tables, Views, Queries, etc.

2)In most cases the concept of a pure SQL developer is rare, generally multi-discipline developers are the ones chosen for positions.  One might be a SQL developer as part of a back end or full stack web developer.  one might be a SQL developer as part of being a DBA.

3)Since there are many versions of SQL (MySQL, SQL server, Oracle, etc) each with their own quirks and differences, one must understand the targeted platform in order to make full use of its capabilities.

 

Having been a full stack developer for only 3 years has shown me that SQL is one of the most hardest parts of any project.  Rarely are simple join queries enough for business.  I have had to pass in entire tables as parameters to stored procedures and then process those records in 3 different ways in the same procedure (add/remove/update).

Many times when trying to mate summary data with detailed data, then trying to only see the most recent 3 records, requires a lot of nesting queries, CTE's, and lots of other heavy work.

Then you can get into other databases which are not relational and are instead Key-Value databases which might store entire other databases inside a record as an XML or JSON string.

 

SQL work so far is proving to be far more work than I was ever prepared for.

  • 0

SQL developers aren't that rare, big organisation databases are managed by people who are solely working with sql so why would they need to know programming?

 

Also do you mean C# with CS? Since SQL can be accessed by a multitude of programming languages, not just C#.

Also there are multiple SQL standards, e.g. SQL Server(also known as MSSQL or TSQL), MySQL, Oracle etc.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Boy, I wonder how much time they'll save when Copilot ######s something up and they find out the error years if not decades later. It's not like UK had a massive ######up within their postal service decades ago that destroyed hundreds of lives of Brits because their computer systems were hallucinating s**t...
    • You clearly missed the sarcasm in that comment. It's pretty clear that the point of that comment was to point out the irony in the fact that nearly every negative thing people say about Windows 11, also applies to Windows 10. Heck, even the Win10 start menu was wildly unpopular when it came out.
    • Even biggest AMD fans and Intel haters will love this 14600K deal as you get free 240 AIO by Sayan Sen Last week, the Intel 14600K was on sale for $193, and you also got a free game with it. However, it looks like there is still some stock of these chips left, as the processor is selling for $199. Along with the free game, you also get a free 240 mm AIO liquid cooler (purchase link under the specs list below). The 14600K is based on Intel's 14th Gen Raptor Lake Refresh design. Since it is a K variant, it is unlocked for overclocking. However, do keep in mind that it is a fairly power-hungry processor, much more so than something like an equivalent Ryzen. But the chip is fairly powerful, and you can enjoy excellent gaming and productivity performance with it. Speaking of AMD Ryzen, the 14600K is about equivalent to the Zen 4-based 7600(X) in gaming and faster in productivity, thanks to the E-cores. Ensure your motherboard has decent VRM power delivery and cooling (ideally a Z790 chipset motherboard), plus you will need a good quality air cooler (and a complementary good case with excellent airflow) or a 240/280 mm AIO liquid cooler. Thus this is where the free MSI AIO cooler will come in handy. The technical specs of the 14600K are given below: Core Count: 14 (6 Performance Cores + 8 Efficiency Cores) Thread Count: 20 Base Clock Frequency: 3.5 GHz (P-core), 2.6 GHz (E-core) Boost Clock Frequency: Up to 5.3 GHz Cache: 24 MB Cache Stock Memory Support: DDR4 (3200 MT/s) and DDR5 (5600 MT/s) Socket: LGA 1700 TDP: 125 W Integrated Graphics: Intel UHD Graphics 770 PCIe Support: PCIe Gen 5 (16 lanes) and Gen 4 (4 lanes) Process Technology: Intel 7 (10 nm) Maximum Temperature: 100° C Get the Intel Core i5-14600K at the link below (make sure to select the checkbox for the free AIO and the free game): Intel Core i5-14600K BX8071514600K + MSI MAG Coreliquid A13 240mm Liquid Cooler 240mm + Free Intel Spring Bundle (Civilization VII & Dying Light: The Beast): $199.99 (Sold and Shipped by Newegg US first-party seller) This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • I think the use of AI generated ads will be directly proportional to the cost of the ad time. If you are paying $1,000 to put some ads on social media, then expect the level of effort to reflect that price (and it has for years). If you are paying $1,000,000 for ad time, then expect more effort.
    • nvm.. You can use daisy chain if your monitors can use it.  
  • Recent Achievements

    • First Post
      ClarkB earned a badge
      First Post
    • Week One Done
      Epaminombas earned a badge
      Week One Done
    • Week One Done
      Prestige Podiatry Care earned a badge
      Week One Done
    • Week One Done
      rollconults earned a badge
      Week One Done
    • Week One Done
      lilred1938 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      142
    2. 2
      Xenon
      130
    3. 3
      ATLien_0
      124
    4. 4
      +Edouard
      102
    5. 5
      snowy owl
      97
  • Tell a friend

    Love Neowin? Tell a friend!