FB

What’s Database Star All About?

Ben BrummGetting started in the IT industry can be pretty hard. You’ve graduated from college or university, got some good marks, and now you’re starting out in the world of software.

It doesn’t matter what kind of role you’re getting in to. Software development, software testing, business analysis, database development, application support. Working in these fields is a big change from studying them at college, and there’s a lot to know about the IT industry if you want to get ahead in your career.

That’s where Database Star comes in. I enjoy providing useful information, sharing advice, and giving resources to help YOU get ahead in your career. It doesn’t matter if you are a recent graduate from college or university looking to get a job in the IT industry, or have graduated and working at your first job, we can all benefit from career advice.

I’ve been helping people improve their careers for a few years. See what they have to say:

– “I never miss any article of yours. Thank you.” – Natalie

– “Your positive attitude has had a terrific influence on my life and your insights, mastery into my request shown I am with the right person.” – Kayode

– “As someone that has been interested in the IT world and its development, I have to say that this is one of the better sites out there. I am impressed with the articles, products and resources that it offers in an easy to follow format…great job!” – Nada

I’ve been in the software industry for some time, and have learnt a couple of things, but I’ve made a few mistakes too. I’d like to share these lessons and tips on this site, so that you don’t make the same mistakes.

If you’re looking for a job or currently employed in the database field in software development (roles such as database development, database administrator, software developer, etc) and you’re interested in advancing your career, sign up to my email newsletter below.

You’ll get weekly tips, notifications of new posts, and access to a whole bunch of resources for database developers.

Want an Oracle SQL function cheat sheet for easy reference? Click here to get a PDF file that contains all of Oracle functions for you to reference or print out.

Thanks,

Ben

24 thoughts on “What’s Database Star All About?”

  1. Dear Ben,
    you have a good website and good information about IT and related materials. Keep it up man, we need people like you.

    Regards,
    Mr. T

  2. Hello,
    I am really new to the world of programming and heavily relying on good tutorials. Up to now I never felt like I have to say thank you. You really made my day with your great, short and relevant explanaitions.
    Thank you so much!

  3. add 21c windows installation oracle database and how to connect SQL developer step by step video, sir, outstanding blog

  4. Belkis Pineiro Garcia

    Ben
    Good morning, please excuse my english is not good. Your site and email are very important for me. I every day study the recomendations and use frecuently in my work.
    I am a question that is posible. I am working in Oracle Database. The question is about how I can get best results with sentences count, the problem is, my source table have milliom rows every day, and I need calculate a total acumulative across month. For first day is not problem, the second day is good too, and more. The time is very bad with arrive final month and the procedure not respond.
    If you say me something when I read and study for resolved this problem is very good for me.
    Thanks

  5. Hi Ben!

    I hope you’re doing well.

    Can you help me with installing 2 different MySQL servers & 2 Different PHP versions in a server using docker? I saw your tutorial on Youtube. However, I could not find a detailed view.

    I am using Contabo Server, OS: Ubuntu Web server is Virtualmin.

    Thanks.

  6. Greetings. I just joined the Academy for SQL Developer and PostgreSQL. I like to be able to print off the course materials and make my notes, highlight, etc. I was able to do this for PostgreSQL bu can’t find the notes for SQL Developer. Kindly point me in the right direction.

    Thanks!

    Rick Monnin

    1. Thanks for joining! I have some of the courses (mostly the newer courses) include the slides and a PDF version of the course, as I created it when I created the course. Some of the older courses, such as “SQL Developer Jumpstart” don’t have this. (I plan to recreate these older courses, and when I do, I’ll create the slides and PDFs for them).

  7. Hello Mr. Brumm,

    I was searching on YouTube for some information on SQL and database creation and stumbled upon your page. I am not a programmer or a data analyst. I am looking for someone to help me build a DataMart and eventually an app for a business idea that I have. I have tried fiverr , but I can’t find someone who can develop a small test database and some SQL queries to help me design a proof of concept model. Do you or do you have contacts that would be willing to help me. I am willing to pay.

    Thank you.

    1. Priya Mougoundane

      Hi David,

      I would be happy to help you with what you are looking for. I am not completely into database background, but I have good experience working with Db2 database , creating complex SQL queries for the mainframe applications. I am passionate about database and I am very much interested to work in this field. I am on a lookout for database developer roles for which I would like to do some real time database developer role. If you think I would be a right fit I can help you preparing one and please feel free to contact me in LinkedIn.

      Thanks,
      Priya Mougoundane.

  8. Hello Mr.Ben
    Greetings for the day! Presently I am pursuing my Data Engineering Course. Also preparing for a mock interview I came across your website. I must say the content is very good. It is helping a lot to understand the SQL concept easily.
    Kindly keep on adding such content.
    Thank you for everything.

  9. I just stumbled on to this site for SQL JSON queries and decided to explore. I now have it booked marked, very nicely done. I like the format that shows all the details for leaning a new concept. Thank you for your effort to help others.

  10. julian harrall

    Hi Ben I have been on the Oracle website and tried to register for the exam but it is not straightforward. I select Oracle Database SQL 1Z0-071 but when it comes to confirm it seems to give a generic name with a list of maybe 30 exams, Oracle Database SQL 1Z0-071 being one of them. Do I select this generic name?
    I have tried contatcing Oracle but you have to email in and wait for reply.. contacting oracle is slow and tedious
    Please can you help Ben

  11. I’m not able to pay for the academy using PayPal. The PayPal login window hangs indefinitely.
    Is that a known issue?
    -B

  12. Hi,
    When running local Postgres in Docker, I encounter with this problem: Relation “X” does not exit Line 2 select * from …
    What is the reason?

  13. Good day

    Please my name is Moses from Nigeria

    I have a project on e-commerce and i will want to collaborate with you.

    I want you to help design the database..

    Kindly reach me on email via [email protected]

    Or whatsapp :- +2348145462488

    I will be waiting for your response as I am already 1 week behind schedule time to start

    Thanks

  14. Hi,

    I’m currently working with Microsoft SQL Server 2022, and I’m encountering an issue when trying to truncate a table. The error message I’m receiving is as follows:

    “Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.”

    To address this error, I attempted to use the following query:

    “`
    sp_msforeachtable “ALTER TABLE ? NOCHECK CONSTRAINT all”
    “`

    However, even after running this query, I’m still encountering the same error. Can anyone help me understand what I might be doing wrong or suggest an alternative solution to successfully truncate the table?

    Thank you!

  15. Nice content and very helpful for a beginner to get started on learning database.
    Subscribed for your sql cheatsheet.
    Oi oi oi🇦🇺🇦🇺🍻

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.