18 ms·
CS is about Computer Science, not programming. The foundational courses should be in math, physics, statistics, calculus, proofs, algorithms, complexity, type s
by WalterBright 4y ago
CS is about Computer Science, not programming. The foundational courses should be in math, physics, statistics, calculus, proofs, algorithms, complexity, type systems, theorems, computability, etc.
Learning how to use SQL is more of a trade school course.
I have a BS, Bachelor of Science. The foundational classes were math, math, math, math, and more math. There were no classes in how to operate a machine tool. I befriended the guy who ran the machine shop that built apparatus for the scientists, and he taught me how to run the machines. But that wasn't a class, it was just something I did on my own initiative.
- gosh400 4y agoThat sort of erroneous thinking (about SQL) was the reason Sun Microsystems (Java, NeWS, Sparc processors, etc), didn't have a Relational DBMS, and then had to buy MySQL for $1B, in order to make itself an attractive purchase (to save the company) - which Oracle then did for $7B.
- bruce511 4y ago>> Learning how to use SQL is more of a trade school course. While SQL the language is more "trade school", the original poster mentioned; >> Database Systems (relational algebra, SQL) Certainly I would expect a CS course to cover databases, in the sense of 3rd-normal-form etc, sorting, searching, indexing and so on. I wouldn't expect them to necessarily be proficient in any one database product, but I would expect them to understand different ways of storing data, and how to design a "data layout" based on good practices (again 3rd normal form etc).
- deleted 4y ago[deleted]
- junofan 4y agoI don’t think top CS programs teach that. Maybe they’ll have a course on implementing databases.
- platzhirsch 4y agoThank you, this is indeed what I meant and was covered by our curriculum in the third year. SQL was merely a practical example.
- ilikehurdles 4y agoSQL was probably only one semester’s course over a 4+ year college career. They probably continued to interact with SQL here and there in some other classes, but would rarely encounter needing more than cursory, googleable knowledge to get the job done. On top of all that, it’s likely their first (or close to first) time in an interview setting. Nerves have a way of making you forget a lot of things.
- WalterBright 4y agoI learned the nuts and bolts of engineering on the job, and from reading the (absolutely delightful) Boeing design manuals, where they distilled the lore of how to design airliners in a series of manuals. But in my long career, I've never encountered anyone who learned math on the job. Math was my superpower at work. But since I was not a CS major, I never properly learned the academic side of CS. I run into this deficit now and then, and I'm not proud of it. Andrei Alexandrescu joined me on the D project, and had the academic chops, which was greatly appreciated by me.
- tzs 4y ago> But since I was not a CS major, I never properly learned the academic side of CS. Would you have been a CS major if that had been an option at Caltech? For everyone wondering why CS would not have been an option, at the time Walter was at Caltech they didn't offer CS as an undergraduate major. They did have a CS department which did offer some undergraduate CS classes but it only offered graduate degrees. Undergraduates interested in CS typically majored in math or physics or engineering and took the undergraduate CS courses in addition to the coursework of their major. I don't remember when they started offering an undergraduate CS degree. I think it was not too long after I graduated (class of '82), which was a couple years or so behind Walter.
- WalterBright 4y ago> Would you have been a CS major if that had been an option at Caltech? No. I wanted to design airplanes, jet engines, rockets, etc. I had a secondary interest in electronics, and a tertiary one in programming. I wasn't that interested in the academic side of computing. P.S. nice to see other techers here!
- ghaff 4y agoBy way of context, at MIT (which I'm much more familiar with), there was effectively a CS major out of the School of Electrical Engineering and Computer Science, but there weren't PCs and computing was pretty much limited to Multics in the AI lab. (There was a mainframe with punch cards that you could get a limited account for using with the other branches of engineering. I took a Fortran course then I don't think I touched a computer for the rest of my time as an undergrad.) There wasn't widespread access to computers at MIT until Project Athena. So CS was historically mostly not hands on. And that's somewhere where CS was in the engineering school. At many schools, it was part of the math department. So, there's a strong academic tradition of CS being more about math than programming. Even the current CS intro course at MIT is mostly about algorithms and you're pretty much expected to pick up Python on your own.
- shusaku 4y agoIn the spirit of the above poster, I have to say as an undergrad we spent a lot of time on relational algebra rather than SQL, even though the latter is surely more practical.
- bobthepanda 4y agoHonestly, a lot of university curricula are, at best, out of date, since often academics are not necessarily incentivized to learn the latest and greatest of programming. I remember entering a Java course, where the professor specifically said to write Java 6, even though it was EOL and Java 8 had been out for a while, and you would get points knocked off if you used any "fancy" Java 8 stuff they didn't know.
- bawolff 4y agoProgramming really hasn't changed much fundamentally in the last 20 years. I think its a good thing university doesn't chase the current trend. The knowledge would be quickly outdated. They should teach the stuff that isn't flavour of the week but common to everything.
- alpaca128 4y agoSome things do change, though, and courses which involve specific technologies should at least be up to date to a point where people aren't required to use Windows XP when every laptop runs Windows 10.
- zerkten 4y agoI kind of get what you mean, but you don't provide a good example. The first question is what are the specific technologies and why are they involved? If you take some outdated version of Java, this could be interpreted as teaching you to be a Swing developer, or how to apply Java for user interfaces and learning some fundamental design patterns. Whether it is the former or latter matters a lot. Oftentimes the people taking the course don't appreciate which it either which is problematic. In your example, someone could be given a really good desktop programming class on Win32 whether they used Windows XP or Windows 10. The success of this is orthogonal to the tools at hand really. It is what the professor and/or students make of it.
- bobthepanda 4y agoIn general, I find that many fresh college folks (new hires and interns alike) struggle with Java streams. Streams and stream adjacent things like Optional remove a lot of tedium and footguns from older Java code styles, and unfortunately learning them tends to be a speed bump for anyone onboarding to the code base from college, because it’s just not covered, even in a Java algos course where I believe they’d be fairly relevant.
- daveslash 4y agoMy CS curriculum (15+ years ago) offered Databases as an upper-level elective. Another upper level elective was Compilers. Another was AI. There were other upper-level electives, and any student in the program had to take a few but not all of them. Any student in the program had the option to take the Database class, but not all did.
- zerkten 4y agoMy CS undergrad in the UK circa 2001 covered the items you mentioned in the first course. The second course was similar to http://www.inf.unibz.it/~artale/DB2/db2-course.htm http://www.inf.unibz.it/~artale/DB2/db2-course.htm. With UK degrees there is limited ability for students to pick their own adventure and miss these when they choose a CS degree at a reasonable university. I personally don't agree with the purist approach that CS degrees should just be maths. There needs to be some minimal application at the very least and different universities will have different maths-CS-engineering boundaries based on how they've evolved.
- WalterBright 4y agoThere is some overlap between programming and CS, sure. But Computer Science is more a branch of mathematics than programming.
- srcreigh 4y agoIn UWaterloo CS there's at least two database courses. One covering SQL/querying/normal forms, another looking at how DBs are implemented. They are not required courses. I agree with GP that DBs are not fundamental to CS in any way. It's trivial with other building blocks of CS though: predicate logic, algorithms, data structures. Set theory. Discrete math basics (also fundamental CS) gives lots of examples of normal forms (prime decomposition, mod p arithmetic, etc).
- SkyBelow 4y agoI think this is an important point. Knowing how to specifically create a table in X flavor of SQL is something that a new grad can easily look up. Knowing when to consider normalizing data, why one would want to normalize, and why one wouldn't want to normalize, is more of what I would expect someone to learn in college. It isn't something that can be looked up using a quick google unless one already knows it and just forgotten the details.
- alxmng 4y agoHow is computer science not programming? The vast majority of CS research papers are about programming.
- tylerchr 4y agoHave you read a lot of biology papers? Are they all about operating microscopes?
- alxmng 4y agoWe're not talking about biology. There is no such thing as computers without programming.
- nbernard 4y ago> There is no such thing as computers without programming. But there is computer science not applied to computers: Operations research for instance is basically a branch of CS: it is not about programming and it has applications in business, logistics, etc.
- WalterBright 4y agoTry to prove your type system is sound without the academic math.
- alxmng 4y agoA type system is an aspect of programming. I would hope a CS course covers type systems.
- WalterBright 4y agoProving something about a type system requires zero expertise in programming, debugging, git, Linux, C++, etc. And expertise in programming, debugging, etc., is of zero use in attempting to prove something about the type system. As has been pointed out to me several times by CS academics, I could stand taking a course in type theory. I have a good intuitive sense about it (likely from my math background), but have no idea how to prove something about it.
- herewulf 4y agoIt needs to be more like a trade school. The vast majority of jobs call for workers who can create and maintain programs that actually do things, not just theory. I've encountered far too many CS interns and grads who couldn't actually write reliable, non-spaghetti code. They also typically write commit messages that consist entirely of "Updated $THING" (no shit, I can see that from your diff), nothing about the why. My perspective may be slightly skewed from being called in as a consultant to fix the software these "computer scientists" have been hacking on, but I encountered a lot of these people when I was a undergrad student also.
- WalterBright 4y agoWhen hiring a newly minted undergrad, you should expect to need to do some mentoring on the nuts and bolts of programming. CS is not about lucid commit messages. If you want a trade school grad, hire one from a trade school. There's nothing wrong with that. I wouldn't hire a Caltech grad to fix my transmission, either. (I could fix your transmission, but AFAIK I was the only motorhead at Caltech, which was pretty disappointing.)
- TheSpiceIsLife 4y agoWhere are the computer programming trade schools? TasTAFE offers a Cert III in Information and Communications Technology. This looks to be one third tech support, one third networking and server operations, and one third python / web / CSS. So not really much programming. A programming trade school to Mr would look like: four years on the job as an apprentice, full time, at some discounted pay rate. Two weeks four times a year at a training institution, away from the demands of the job, where theory and practice are taught. My trade certificate (metal fabrication) is a Cert III, my trade school included a fairly wide variety of subjects, both theory and practical. The employer would be required to give progressively more difficult tasks, and doing apprentice swaps with other businesses to cover industry experience if in-house doesn't provide opportunities for key requirements. Is anyone, anywhere doing that? I help train two apprentices every year here in metal fabrication. It's not that difficult, but few developing foetuses are borth wielding a welder. I mean the trade is not difficult, training people is hard.
- deleted 4y ago[deleted]
- dgb23 4y agoRelational algebra is math. SQL is a practical application of relational bags. There’s math and science behind concurrency and parallelism, and the coordination thereof. Network programming is a practical application of several parts, each of having foundations in math and science. From coding/decoding, to state machines. Wires are all about math and physics too. There’s more that is often left out. Specifically holistic systems and their research. Lisp, Smalltalk, Self etc. These systems reach into math, HCI, compilers, JITs…
- thrown123098 4y ago>SQL is a practical application of relational bags. Apart from the fact it isn't; elements have specific order and that order matters. SQL is SQL, it's not relational algebra or whatever bastardization of it you can think up. In fact when it comes to SQL the only use relational algebra has is to tell you that anyone talking about it has never used SQL.
- dgb23 4y agoYour computer is also not a Turing Machine. The regex that you use is not really a regular language. Your functions and logic are not referentially transparent, because well, they have to run on a computer. But it's useful to learn the foundational mathematics of these things as there is a direct relationship between them. SQL has semantics that can be understood by relational algebra of relational bags. It's of course not a 1:1 translation, but the mathematical underpinnings are explained there. It's useful to learn the simpler, more abstract thinking tool in order to understand the concrete programming tool.
- thrown123098 4y agoMy computer is very much a Turing machine since each time it runs out of disk space I can buy more disks. The fact you think a Turing machine has infinite memory rather than finite but arbitrarily large memory tells me all I need to know about the sorry state of your theoretical education.
- raincole 4y agoSQL is a trade school course? Do you think 1) We should teach relational database purely from relational algebra without an practical example. or 2) Relational database is a trade school course too. If 1), maybe it makes sense for in academic sense, but I personally would rather to work with an intern who doesn't know database at all than someone who knows a bit of relational algebra but not SQL. If 2), how about operation systems? Compiler? Networking? Are these all just implementation details and not belong to a CS cirriculum?
- deleted 4y ago[deleted]
- pjmlp 4y agoThat is US specific, I can assure you that without programming knowledge across several domains there is no graduation on many European universities. https://www.di.fct.unl.pt/en/education/integrated-master-computer-science https://www.di.fct.unl.pt/en/education/integrated-master-com... https://tecnico.ulisboa.pt/en/education/courses/undergraduate-programmes/computer-science-and-engineering/ https://tecnico.ulisboa.pt/en/education/courses/undergraduat...
- titannet 4y agoAt my German university I could have graduated with next to no knowledge of programming and SQL and afaik the curriculum hasn't really changed.
- viraptor 4y agoI know they're half-European now, but I've finished MComp in the UK and you could totally do the post-batchelor stuff with next to no programming.
- deleted 4y ago[deleted]
- ACS_Solver 4y agoI got my computer science BS and MSc from two different EU universities and I found the programming aspects to be very secondary. Yes, you needed some programming to graduate but not nearly as much as math, and half of the programming you needed had little to do with real-world programming. In two undergrad courses, we programmed in an old language and a very outdated environment, the one the professor had used their entire career - and apparently that continued until the prof retired. The courses were about implementing algorithms, so the language didn't really matter, but I would say the course was probably a net negative from a software engineering perspective. We had a database course covering the mathematics in good detail. We learned the relational model, normal forms and such mathematically, with a little basic SQL at the end. That was great for understanding, as at the end of the course you'd be able to write out the actual maths performed by a query but it didn't really teach SQL. Multiple professors wrote typical "researcher code" - I don't necessarily want to say it's bad but it's very different from what you'd see as good industry code. Lots of global state, variable names with 1-2 letters, magic numbers. It's understandable why research code to be like that but it is much more fitting for an implementation of a research paper than for a software product.
- eurasiantiger 4y agoProgramming is just applied discrete mathematics.
- Koshkin 4y agoSure. Just like making cars is applied classical mechanics.
- eurasiantiger 4y agoThat is not a false statement.
- hardware2win 4y ago>CS is about Computer Science, not programming. Then why almost every semester has some heavy programming course?
- zelphirkalt 4y agoHeavily dependent on where you study.
- deleted 4y ago[deleted]
- richrichardsson 4y ago> I have a BS, Bachelor of Science. Mildly off-topic, but is "BS" the usual shortening of this type of degree where you hail from? If it's United States I would be even more surprised that this would be the case, since who wants a "BS Degree"? In the UK at least we normally refer to them as BSc degrees and there's never really a need to expand.
- bdcravens 4y agoYes, that's the common abbreviation.
- rawbert 4y agoIf it is, you should stop using it like that because it made even me, a non-english native, giggle.
- rxhernandez 4y agoThere are at least a hundred million you would have to convince to stop using that abbreviation before it goes out of fashion in the US.
- bregma 4y ago"BS" is the simplified American initialism for Baccalaureate Scientate. In most other English-speaking countries the acronym "B.Sc." is used. It's like the way they misspell "colour" and "labour". A cute affectation that we may well snicker about behind their collective backs but in the end it's meaningful and respectable and we move on. "CS" on the other hand is not short for "computer programmer job training" so I'm confused by the expectation of the original Ask HN question.
- mhh__ 4y agoDatabases aren't about SQL as much as a taste of distributed systems.
- AnimalMuppet 4y agoIn the real world, though, 95% of those with CS degrees are going to work as software engineers, not as computer scientists. So what we really need is software engineering programs, and far fewer people in CS programs. We need, essentially, the divide between chemistry degrees and chemical engineering degrees. That hasn't happened yet for CS, but it needs to. And that's what the OP is asking for - people who have software engineering knowledge, not CS knowledge.
- gedy 4y agoNot quite the same as what you suggest, but I did a BS in Computer Engineering, and really enjoyed it compared to CS or EE. There were some software engineering and practical programming courses, but also included hardware design. Though I struggle with leet code quizzes so there's that..
- cmrdporcupine 4y agoThe relational data model is first order or propositional logic, and set theory. It's math & logic. It is intrinsic to computer science, since Codd's foundational papers. SQL itself is full of problems, but the foundations behind it are definitely not; database theory and database internals is one of the deepest domains of computer science, up there with operating systems. And dismissing this knowledge as "trade school course"work is... sad.
- jiriknesl 4y agoI think exactly the opposite. 95% of people studying CompSci are going to work as developers, system administrators or IT managers. They should know systems programming, databases, operating systems, web app development, security, basic logic, data structures, algorithms, JavaScript, and some backend languages. Add some ability to interview users, design at least basic UI, organize tasks, release your product and monitor it. Math, physics, statistics, calculus, proofs, theorems, and computability should be the interest when you decide to pursue PhD. For someone who's going to build ERP systems in Java, Oracle ad Angular these things are completely useless. Most of the developers are like this.
- 7952 4y agoIt is common in science to do experiments and learn lab skills to be able to do those experiments. Surely programming languages are just a way of doing practical work.