Database is SOOOO Boring

by lovboa Banned
22 replies
I'm taking a class at my school which is pretty much intro to relational databases with mySQL.

It is soooo boring.
Is it really important for me to stick through this course if I want to become a web designer/developer?
#boring #database
  • Profile picture of the author Sitesupplier
    I did some college a few years ago and one of our modules was learning to use a database through MS Access. It was absolutely the most boring lecture/class I've ever taken in my life.

    Not only that, but the lecturer was a boring, nerdy "professional" with no charisma or character. He made the lecture even more boring.

    About a year on I started to learn to write raw SQL (MySQL) and realised how completely different it is. It really depends on your outlook and what you want to achieve. For example, I find using phpMyAdmin to be quite easy, intuitive and user-friendly, but MS Access is boring, ugly and confusing and the docs suck.

    However, back to the point at hand: do you need to learn MySQL for web development? I don't know... what sort of web development are you interested in? There's client-side development and server-side development. Client-side is more JavaScript-based where are the server is all PHP/ASP/CGI, which you'll be using in tandem with a database most of the time.

    I know how boring database coding can be, but just think of it as a piece of a larger puzzle. It's just a place to store your data, it's no big deal. As long as you can learn how a database works, how to make queries, select/store/sort/etc., you'll be fine. Don't worry about it, there are people who specialise in SQL who will be around to cover your back in a real job anyway and if not, there's ALWAYS help online or in any coding communities where SQL geeks who love the language will be able to help.
    {{ DiscussionBoard.errors[7069267].message }}
    • Profile picture of the author lovboa
      Banned
      Originally Posted by Sitesupplier View Post

      However, back to the point at hand: do you need to learn MySQL for web development? I don't know... what sort of web development are you interested in? There's client-side development and server-side development. Client-side is more JavaScript-based where are the server is all PHP/ASP/CGI, which you'll be using in tandem with a database most of the time.
      Thanks, that was really helpful.

      The type of web development I'm interested in?
      I really enjoy just writing HTML and CSS, and I'd like to code with Javascript and PHP later on to build more interactive websites and web apps.

      So far in the course, we haven't even got to MySQL and queries yet. We're just on Microsoft Access and designing databases.
      {{ DiscussionBoard.errors[7069314].message }}
      • Profile picture of the author Sitesupplier
        Originally Posted by lovboa View Post

        Thanks, that was really helpful.

        The type of web development I'm interested in?
        I really enjoy just writing HTML and CSS, and I'd like to code with Javascript and PHP later on to build more interactive websites and web apps.

        So far in the course, we haven't even got to MySQL and queries yet. We're just on Microsoft Access and designing databases.
        Well, if you're doing HTML and CSS, at this stage it's probably not worth considering whether or not to learn SQL for web development. It's just my opinion, but I wouldn't bother learning MySQL until you have a solid foundation in PHP.

        Realise that SQL is a query language that makes requests through a given interface. You're not going to be able to use your databse without first knowing how to handle your code. This is important because it's only through PHP that you're going to be able to manipulate your data anyway.

        With that in mind, it might be worth your while just learning some basic SQL through websites such as W3Schools.com to give you a bit of an edge over the other students and the lectures you're having, because it'll make things a little clearer when you see how the IDE (Access) is working. It may also be worth familiarising yourself with phpMyAdmin because this is a tool built to handle MySQL databases written in PHP, but it is extremely user-friendly and well documented, but also tell you exactly what it's doing. By this I mean every time you click on a button, say you click the button to "view" your table, it gives you the precise MySQL code that it used to retrieve the data, so makes for a great learning tool.

        Anyway, good luck learning, it can be very fun... you just need to find the right people to educate you and motivate you and unfortunately, most teachers SUCK at this!
        {{ DiscussionBoard.errors[7069767].message }}
  • Profile picture of the author Jonas Glad
    If you're going to be a web developer it definitely is essential to know how to handle mySQL and such but it's pretty simple lol, not sure how boring classes on this subject are as I didn't go to school for this.
    {{ DiscussionBoard.errors[7069309].message }}
  • Profile picture of the author mojojuju
    I learned a lot of stuff that is relevant to web development when I took a database class in college.

    Originally Posted by lovboa View Post


    So far in the course, we haven't even got to MySQL and queries yet. We're just on Microsoft Access and designing databases.
    Microsoft Access is a good starting point to get a basic idea of how databases work and for learning SQL. Stick with it. I'm sure you'll learn something worthwhile.
    Signature

    :)

    {{ DiscussionBoard.errors[7069392].message }}
  • Profile picture of the author FirstSocialApps
    If your going to be a DESIGNER .. then no doesnt matter.
    If your going to be a DEVELOPER .. then its 100% needed.

    If you think its boring you might want to lean to the designer part

    By the way Access sucks .. It will get better when you get to MYSQL
    {{ DiscussionBoard.errors[7070548].message }}
    • Profile picture of the author Venkat001
      Originally Posted by FirstSocialApps View Post

      If your going to be a DESIGNER .. then no doesnt matter.
      If your going to be a DEVELOPER .. then its 100% needed.


      If you think its boring you might want to lean to the designer part

      By the way Access sucks .. It will get better when you get to MYSQL
      Loved the bold ones
      Signature

      [Beware] - The Dark Side of Few Adsense Sites on Flippa - [Read/Click Here]
      [Free Workout] – How Did I Get Additional Traffic With Just 2 Minutes of Work ?

      {{ DiscussionBoard.errors[7182832].message }}
  • Profile picture of the author chretit
    Hey, lovboa
    In my experience being able to model complex real-world data problems effectively in a relational db takes a lot of practice and constructing complex, fast queries can be fiendishly hard (although it can be exciting, in its own way, if you’re crazy like that)

    So I think, boring is good, my man. Enjoy boring. With databases that’s a win.
    As a web developer you may never come across real hard core back-end database programming unless you’re working on real-time, financial services applications or something.

    Let’s leave the complex stuff to specialists like someone else mentioned above.
    {{ DiscussionBoard.errors[7071781].message }}
  • Profile picture of the author rising_sun
    Banned
    Try to develop a site ,
    then you can realize mysql is boring or not.
    {{ DiscussionBoard.errors[7079393].message }}
  • Profile picture of the author daedhrogon
    Almost 99.99% of websites has some kind of database, if you want to build them you have to know how they work
    {{ DiscussionBoard.errors[7084793].message }}
  • Profile picture of the author JacobS
    Originally Posted by lovboa View Post

    Is it really important for me to stick through this course if I want to become a web designer/developer?
    If you want to do any type of programming for a living, then yes, you should stick through the course. Databases are everywhere, and you can't be a developer without having at least a basic understanding of how they work and how to use them.
    {{ DiscussionBoard.errors[7086584].message }}
  • Profile picture of the author webpeon
    Introductions to anything are rarely the life of the party, its not till later when you start realizing why you were taught all the boring stuff and what it does you'll see it's all worthwhile..
    Signature
    Web 2 Mobile
    The Future of The Web
    {{ DiscussionBoard.errors[7088046].message }}
  • Profile picture of the author kazim
    Ya to be a web developer you must have to learn it.
    it's really boring to me also.
    {{ DiscussionBoard.errors[7091903].message }}
  • Profile picture of the author Dansky
    DB (and database query optimization) is one of most important things in whole web development.

    You can begin with little knowledge over this but what would you do if website you manage gets (in effect of marketing campaign) lots of traffic (and queries).
    {{ DiscussionBoard.errors[7093073].message }}
  • Profile picture of the author fghaegele
    Originally Posted by lovboa View Post

    I'm taking a class at my school which is pretty much intro to relational databases with mySQL.

    It is soooo boring.
    Is it really important for me to stick through this course if I want to become a web designer/developer?
    Yes, and no.

    Whatever you don't learn from this course- you will pay in the future if you should build the next big thing. Whatever knowledge you forego will require you to pay a DB admin to do your dirty work, and they DON'T COME CHEAP.

    That's entirely up to you.

    Now.

    You can build websites without any knowledge of relational databases with just about any CMS-- joomla, wordpress, and drupal, just to name a few. The only prob is the developers of said software didn't really know much about relational DB's either-- or just failed to incorporate the features of mysql that mean the difference between taking 10 ms to load a page --or 5 secs....

    These toys, as I call them, scale very poorly. And because of the "one size fits all" approach to CMS's, you end up with bloatware and hundreds of round trips to the DB.

    You know, you can build a web app that makes less than 10 calls to the DB?

    see pof.com

    Built by one person, and it handles almost a TRILLION-- yes TRILLION-- pageviews a month with just 3 databases. Amazing! Marcus, his name, didn't sleep through HIS mysql classes

    Just sounds like you have a murderously boring instructor.

    This is POWERFUL stuff-- keep on it-- it's every bit as important as learning your favorite programming language. Hell- it IS a language in itself- and its concepts are used in even the trendy and sexier NOSQl solutions.
    Signature
    Take A Break. Play A Puzzle: Merlin's Puzzles
    {{ DiscussionBoard.errors[7118374].message }}
  • Profile picture of the author STG
    at some point you will need mysql in developing websites for sure, so it will come in handy
    {{ DiscussionBoard.errors[7135066].message }}
  • Profile picture of the author abyssofseo
    That depends on what you plan to do in the future. I think designers don't need that much.
    {{ DiscussionBoard.errors[7135309].message }}
  • Profile picture of the author Ttrain
    I think mysql will be a lot easier to learn, and a lot less boring if you learn it along with something else. because by itself it's pretty much useless, but when you combine it with server side langauges like php,python, ect. you can use it to actually build something cool. And then you will probably be more interested in it.
    {{ DiscussionBoard.errors[7144169].message }}
  • Profile picture of the author extremeboy
    SQL DB is important for Dynamic sites specially and it's easy if you use PHP with it + PHPMYADMIN
    {{ DiscussionBoard.errors[7144564].message }}
  • Profile picture of the author Mitchell143
    Banned
    [DELETED]
    {{ DiscussionBoard.errors[7159685].message }}
  • Profile picture of the author yukon
    Banned
    Stick with it, especially anything to do with mySQL & php, learn everything you can.

    IMO the money is in the developing part more than the design (Photoshop, etc...), the Photoshop part is easy once you figure out how to slice images & organize layers.
    Signature
    Hi
    {{ DiscussionBoard.errors[7174234].message }}
  • Profile picture of the author ksnipe123
    it depends,maybe someone just like it
    {{ DiscussionBoard.errors[7182666].message }}

Trending Topics