Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>When one starts to learn programming, language syntax is a logical starting point. It enables a budding programmer to properly express their ideas and formulations in code that will run. However, as you correctly pointed out, syntax means little in the "larger scheme" of programming. </p> <p>I don't know what the tutorials you have read cover in terms of that "larger scheme", and I can't think of any specific tutorials or books of the top of my head. But, I would recommend finding a resource that will teach you about <strong>data structures</strong>. If you are unfamiliar with the concept, a data structure is a very fundamental topic in computer science. The topic comes about from the following question: <em>"How does one process, store, and access information efficiently with regards to time and memory usage?"</em> </p> <p>For many CS students in college, a class heavy in data structures would be their 2nd course after an intro like the one you've described, and usually where the real computer science begins. Also, data structures will provide you with a foundation worthy of moving on to studying <strong>algorithms</strong>, a more major concept in computer science that deals with how one solves problems in a logical, step-by-step, and most importantly, reproducible and scalable way. </p> <p>Once again, I apologize for not having any links, but I hope I've provided you with some topics to jump-start some google or amazon searches. Good luck with your autodidactic pursuit of CS!</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to think as a programmer?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USIsaac Drachman
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI agree Isaac, Data Structures are a great fundamental skill to learn. OP: I challenge you to write a LinkedList implementation in whatever language you are comfortable using. Use whatever resources necessary in order to learn how to do it. It should be able to insert to the front, remove any element, and search for any element. Once this is done, use the knowledge you've learned to build a binary tree.
      singulars
      1. PO
      1. USSamuel O'Malley
    2. COMind me to disagree with that? In my opinion, data structures aren't that much of a deal - they are more patchworking tools, so you don't have to do the thinking other people have already done. Re-inventing the wheel. You know? But they don't do much to help understanding programming. You can know all famous design patterns in whatever language you are. You can know all about efficient storage. You can know all language quirks. And still write inefficient or buggy algorithms.
      singulars
      1. PO
      1. USJohannes H.
    3. COJohannes: In my opinion, data structures are fundamental and quite important for computer science. I am no professor, but I'm sure many would agree. Of course anyone, no matter how well learned, can write an inefficient or buggy algorithm. But, for example, give a programmer the knowledge and understanding as to why they should use a map instead of a vector for a specific problem, and you make them that much more capable.
      singulars
      1. PO
      1. USIsaac Drachman
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload