• 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

    • OontZ Angle 3 Coca-Cola Edition Bluetooth Speaker: Worth it at 25% off? by Paul Hill If you are looking for a portable Bluetooth speaker for yourself or for Father’s Day, check out this OontZ Coca-Cola branded Angle 3 Bluetooth speaker. Right now, you can pick it up for just $30, thanks to a recent 25% discount from the previous $40 price tag. Aside from the Coca-Cola branding, this speaker has a range of nifty features including a 100-foot range, a 14-hour battery, IPX5 water resistance, it promises no distortion of sound, and its shape ensures it won’t fall over. What it does (and doesn’t) The Oontz Bluetooth Speaker Angle 3 Coca-Cola Edition is super portable, making it an ideal choice for when you’re traveling. The speaker is just 5.3 inches long and weighs just 10 ounces. The width and height of the speaker are both under three inches and its triangular shape ensures it won’t fall over so you can put it down quickly whenever you’re out and about. According to OontZ, the speaker has 10 watts output that is “surprisingly loud” with “zero distortion” even when you turn it up to the max. These OontZ speakers are crafted by Cambridge Soundworks, a firm that has received critical acclaim since its inception in 1988. The firm is praised for delivering solid sound quality and construction - it makes some of the industry’s best speakers and offers excellent value for the price. As a travel speaker, it’ll probably end up on the beach or next to swimming pools where it can get wet. You don’t need to worry about splashing it though because it comes with IPX5 water resistance meaning it’s splash-proof, suitable for the shower, beaches, or the pool. While it will offer protection against splashes, it shouldn’t be submerged under water. On a single charge, the speaker will last for 14 hours on a single charge and connects to your device using Bluetooth 5.0. It has a good range of 100 feet so it shouldn’t become choppy just because you went into the next room with your phone. Should you buy? This OontZ Coca-Cola Bluetooth speaker is ideal for anyone who wants a great listening experience at home or on the go. It’s also a good choice for anyone looking for good sound on a budget as it’s now $30, which won’t break the bank. The main strengths of the speaker are its excellent value at the discounted price, reliable connectivity, and the good battery life considering its size. The fact that it’s from a reputable brand, Cambridge Soundworks, is also key. The iconic Coca-Cola branding may not be for everybody but it will definitely stand out with that vibrant red color. The IPX5 is also good to protect against splashes but it’s not fully waterproof, so if you need that, this speaker might not be for you. Oontz Bluetooth Speaker Angle 3 Coca-Cola Edition: $29.99 (Amazon US) - MSRP $39.99 / 25% off 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.
    • GPUs selling higher than their MSRP is the new norm it seems. This shouldn't surprise anyone. Dumb duopoly, if Intel could just stop shooting itself in the foot and release some more cards and undercut the other two that'd be great.
    • I saw that recently, and the thing that would be useful also would be to have the PC model in that spec card as well. I know that it's on the main portal page of System, but repeating it in this "Device specs" module, especially if it's meant for the main specs of the computer, would certainly be useful.
    • Do you want a little in the ground or a lot in the air?
    • Bethesda readying two updates for Oblivion Remastered targeting bugs and performance by Pulasthi Ariyasinghe The surprise release of The Elder Scrolls IV: Oblivion Remastered was a massive success for Bethesda and Microsoft, with the title going on to gain over four million players in just three days at launch while also breaking franchise records for concurrent players. While reactions to the game have been positive from both critics and players, plenty of complaints have since been pouring in about the state of the remaster. Now, Bethesda is aiming to push out updates to resolve these concerns. Today, the company revealed that two updates are currently planned for the RPG, both with different scopes. The first of these is already available in beta form to Steam players. It seems Bethesda is using the same beta update format it uses for Starfield for this Elder Scrolls entry as well. "Thanks for all your excitement and feedback since the launch of The Elder Scrolls IV: Oblivion Remastered," said the development team today. "We are actively working on two separate updates to be launched in the coming weeks, both of which will come to our Steam Beta first, before being released to all other platforms." According to the studio, the first update is focused on "quests, major bugs and blockers, and quality of life fixes. " Following the June 5 launch on the Steam beta platform, all other PC players, as well as those on Xbox Series X|S, PlayStation 5, and Game Pass subscribers, will receive the update on June 11. The beta changelog for Update 1.1 can be seen here, with bug fixes coming for the UI, gameplay, quests, and more. Multiple crashes have been resolved here, with many being related to loading saves and exploring specific locations. Instances of infinite loading, alt-tab freezing, resetting settings, and more are being targeted with fixes, too. To opt into the Elder Scrolls IV: Oblivion Remastered beta update, Steam players can head into the game's properties, select Betas, and choose the [beta] branch to receive the new build. While Bethesda hasn't revealed any release dates for the second update, it did say that improving performance will be its main focus. This is a major point of criticism for the title at the moment, so the update can't come soon enough.
  • Recent Achievements

    • Week One Done
      jbatch earned a badge
      Week One Done
    • First Post
      Yianis earned a badge
      First Post
    • Rookie
      GTRoberts went up a rank
      Rookie
    • First Post
      James courage Tabla earned a badge
      First Post
    • Reacting Well
      James courage Tabla earned a badge
      Reacting Well
  • Popular Contributors

    1. 1
      +primortal
      408
    2. 2
      +FloatingFatMan
      181
    3. 3
      snowy owl
      178
    4. 4
      ATLien_0
      172
    5. 5
      Xenon
      135
  • Tell a friend

    Love Neowin? Tell a friend!