Member Avatar for theashman88

I'm taking a database class, to be more specific MySQL. I want to know if I will use this if I enter the programing field as a C#, C++, or Java programmer. If so what will I need to know

  • 4 Contributors
  • 3 Replies
  • 344 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by RomelynCastillo

Dani AI

Generated

Yes — the bits you learn in a MySQL class matter for C#, C++ and Java work. Relational design, SQL thinking, and the mechanics of connecting an application to a server-side database are used in most back-end jobs; MySQL publishes drivers and connectors for the major languages. (mysql.com)

Focus on transferable, practical skills (this expands on points by and ): data modelling (normalization), set-based querying (JOINs, GROUP/ORDER), safe parameterized queries, basic transaction control and isolation, and how to find and fix slow queries with EXPLAIN. Learn to harden access (least-privilege accounts, prepared statements) so you don’t introduce SQL injection risks. (cheatsheetseries.owasp.org)

Integration approach differs by language but the patterns are the same — use an official driver or an ORM to avoid hand-rolling SQL in every place. In .NET you’ll commonly use Connector/NET and an EF Core provider such as Pomelo, in Java you use Connector/J with JDBC plus a JPA provider (Hibernate), and in C++ you can use Connector/C++ or ODBC and manage resources more directly. Example (C#) — always bind parameters, never concatenate untrusted input:

using (var conn = new MySql.Data.MySqlClient.MySqlConnection(connString))
{
    conn.Open();
    using (var cmd = new MySql.Data.MySqlClient.MySqlCommand(
        "SELECT balance FROM accounts WHERE id = @id", conn))
    {
        cmd.Parameters.AddWithValue("@id", accountId);
        using (var rdr = cmd.ExecuteReader()) { /* read rows */ }
    }
}

If you want a short practice path: build a small CRUD service in your preferred language, add unit tests that try bad input, profile queries with EXPLAIN/EXPLAIN ANALYZE, add/adjust indexes, and learn simple admin tasks (dump/restore, user/privileges). That workflow — build, profile, secure, deploy — is exactly what employers expect. (github.com)

Recommended Answers

All 3 Replies

Member Avatar for Reverend Jim

Taking a database class is valuable no matter what programming language you are planning to specialize in. What you will need to know is mostly independent of the programming language. You will learn how to define a database to properly store real world data in a manner that is both useful and non-redundant. You will learn the commands (SQL commands that are mostly common to all relational database systems) to modify, maintain and retrieve data from that database. Pay attention to the part about normalization.

Member Avatar for RomelynCastillo

Definitely. When you’re in already in the programming or IT industry, you will be doing programs wherein database serves as the backbone. Take for example when you need to do a program for bank operations, you need to have knowledge on how about database and MySQL is one of the most basic and yet efficient tool that you should know how to use.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.