What is required to get into the database development / mangement sector

[_kabal_]

Does that mean I would be using something like C#? I have not worked with C#, did read a textbook on it once...lol but never really used it to build something apart from the exercises in the textbook.

correct

C#, like most mainstream typed languages is basically the same as Delphi, with a slightly different syntax

public ReturnType functionName(ParameterType parameterName) {}

instead of

public functionName(parameterName: ParameterType): ReturnType {}

fun fact: Anders Hejlsberg, who wrote Turbo Pascal and Delphi, is the lead architect of C#

 

[ReleasedFromCaptivity]

correct

C#, like most mainstream typed languages is basically the same as Delphi, with a slightly different syntax

public ReturnType functionName(ParameterType parameterName) {}

instead of

public functionName(parameterName: ParameterType): ReturnType {}

fun fact: Anders Hejlsberg, who wrote Turbo Pascal and Delphi, is the lead architect of C#

Yes C# for me had a very similar feel as C++ syntax wise.

 

[Benedict A55h0le not]

There is no real demand for 'database developer' or Delphi. Maybe you are refering to 'back-end developer'? SQL dev and design is assumed as part of normal dev duties, mostly 'full stack' and then the dev does everyting from ui to db, and even db admin. If you want to be a back-end dev then use C#, Azure Functions (http API) or MVC Web API, and learn to dev noSQL dbs like Cosmos and Azure Table Storage.

 

[Kosmik]

There is no real demand for 'database developer' or Delphi. Maybe you are refering to 'back-end developer'? SQL dev and design is assumed as part of normal dev duties, mostly 'full stack' and then the dev does everyting from ui to db, and even db admin. If you want to be a back-end dev then use C#, Azure Functions (http API) or MVC Web API, and learn to dev noSQL dbs like Cosmos and Azure Table Storage.

Hope folks realise the differant use cases for relational vs no-sql database.

Side rant.

 

[Benedict A55h0le not]

Hope folks realise the differant use cases for relational vs no-sql database.

Side rant.

So what is the different use cases?

I left out SQL Server in that list because he already knows it. I recommend getting to know Azure SQL as well.

 

[ReleasedFromCaptivity]

There is no real demand for 'database developer' or Delphi. Maybe you are refering to 'back-end developer'? SQL dev and design is assumed as part of normal dev duties, mostly 'full stack' and then the dev does everyting from ui to db, and even db admin. If you want to be a back-end dev then use C#, Azure Functions (http API) or MVC Web API, and learn to dev noSQL dbs like Cosmos and Azure Table Storage.

Thanks for the explanation, I really do not have much experience, yes I have a degree and some things I built with Delphi, but apart from that, I do not have much experience. That is why I came here to ask, yes I can google, but it is always better to get first hand feedback from people working in the industry and not some guy blogging about it.

 

[Kosmik]

So what is the different use cases?

I left out SQL Server in that list because he already knows it. I recommend getting to know Azure SQL as well.

Azure sql is pretty much normal ms sql with some caveats. Use cases are pretty much as described in the name, no sql for unstructured high volume data with minimal index requirements and relational sql for the opposite. Many systems use a mix of multiple db types depending on need, particularly in a micro services architecture.

We use a mix of sql, cosmos and flat storage ( blob, queues table etc). All depends on use case. And let's not forget cache use like redis.

 

[Y'all Qaeda]

Delphi, almost shy to say I'm developing in it...lol

If you're talking data, you're doing yourself a massive disservice by not learning Python. We work with data and analytics daily, and we have a severe need for python devs. So maybe that's one way of getting into your line?
Also, maybe look at getting into these:

Training for Data Engineers

Microsoft Learn helps you discover the tools and skills you need to become a data engineer.

docs.microsoft.com

Training for Data Scientists

Microsoft Learn helps you discover the tools and skills you need to become a data scientist.

docs.microsoft.com

but from your explanation, I think the top one would be best.

 

[ReleasedFromCaptivity]

If you're talking data, you're doing yourself a massive disservice by not learning Python. We work with data and analytics daily, and we have a severe need for python devs. So maybe that's one way of getting into your line?
Also, maybe look at getting into these:

Training for Data Engineers

Microsoft Learn helps you discover the tools and skills you need to become a data engineer.

docs.microsoft.com

Training for Data Scientists

Microsoft Learn helps you discover the tools and skills you need to become a data scientist.

docs.microsoft.com

but from your explanation, I think the top one would be best.

Yes that is why I'm learning the python on my own at the moment. Since I will not have any work experience with it, I will have to build some things on my own to have some kind of portfolio. But yes, I was thinking Python is ideal for any data related field.

 

[JohnStarr]

Management won't happen overnight unless you play the political game (hang out with the bosses, kiss ass etc) for the most part. I have been in IT for 20 years and only this year became a manager.
It's something to work towards.

 

[Rouxenator]

 

[zippy]

In the U.K. the term “database developer” seems to actually mean DBA, if read the detail of what the jobs entail. Most companies now don’t use database developers as “developers”. It’s now the programming language that is more important and the database structure is usually generated from business entities. DBA’s would be responsible for maintenance tasks. The development environment would use an ORM technology to create the tables, relationships, indexes, foreign keys etc. Some frameworks aren’t even directly aware of which DB is being used.

I used to be an “Oracle Developer” because I worked on Oracle Forms and the Oracle database and created Oracle PL/SQL packages (stored procedures). Now I work in Java(Gosu) and have not done any direct database work(other than SQL queries) for years.

If you really like database work, look into non relational databases. Something like MongoDB or NoSQL