All geek questions in one place

Database Programming Concepts

So, I read a couple of books on SQL, and I used SQL and created the databases, but nothing really advanced, the pairs of tables, the pairs are combined, something like that.

So now I am working on a project that is quite large. The database will have several tables, and we will process from 40'000 to 80'000 series of data daily.

Now I am missing basic SQL concepts, for example:

I have a dataset with files and files. Files are listed in one table, and file data is listed in another table. We also have a build table and a fourth table that integrates the build table, the file and file table table.

The problems are similar to: "How to process files and have the correct file data associated with files and related to the assembly?

Even my university did not cover this, and now I feel that I am very far from the depths.

Take another example. Take the file table. In my application I have 40'000 files, I need to add files that do not yet exist in the file table. Should I search for each individual record and add it if it does not exist, and skip if this happens?

So my real question is: where is a good place to familiarize yourself with common concepts?

+3
source share
4 answers

The best books I've found on this topic are Joe Selco's SQL for Smarties series. They cover the basics, from normalization to the presentation of various data structures in SQL.

+5
source

  • SQL - SQL, Chris J. Date; :

    SQL . SQL : , - , , . - , SQL-, , , ( , , , ), - , SQL - , . ? SQL?

    , , SQL , . , SQL ; - , . , , - . , , ( ); SQL ; , , . , SQL . , SQL , , , , .

    , SQL relationally, . , SQL. ​​, , , , ( , ); , . 1969 , , 40 , , -, . ; , SQL ....

  • , , , (RIP) Toon Koppelaars; , . ():

    . , . . , , . , , , . , . , , , . 10....

  • : , :

    - - : . , . , , , . , , , , - .... [ : 2000 , , WWW, , fad.]

  • , , , .

+3

, , SQL-, . LPCRoy, , , . , , , " ", . , . SqlServerCentral.com .

(, , ) . , , . , , , .

, Python #, . , , MS Sql Server 2008, , . , , , , Python #, .

+1

, , , , . PL/SQL ? -db ?

I usually find that the first episode of a chapter is an informative and interesting way to learn. http://headfirstlabs.com/books/hfsql/

0
source

Source: https://habr.com/ru/post/1711305/

More articles:


All Articles