SQL database learning, how to get started with learning databases

At least the basic things must be mastered, such as: the linear structure of the database, the storage method, the way to call Hezheng, and the operation of the table in the database (to use statements to erect the bench to achieve).

After mastering these things, Yu Lu is looking at some database management and maintenance things, I think if you have a foundation in this area, you should know how to develop your future direction.

In addition, what you learn from the database is only about data management, and you must master an object-oriented development tool, so that you can give yourself a more suitable position!

If you don't have any database knowledge, first set up the database environment you want to learn (there are many tutorials on the Internet).

Don't read the book first, after the environment is successfully built, collect some demos, sql scripts, etc. on the Internet, and directly type in to experience it little by little.

The simple SQL statements that can be searched have been practiced, and then combined with the questions to turn the book, and systematically learn the basics. The efficiency up to this point is much higher than holding a book and chewing hard (and it's easy to get sleepy and give up halfway).

Entry-level books, personally, I think it's okay as long as there are as few mistakes as possible. Find a book from the Sakura Edition Society in Cheating Town with a better reputation. It's never too late to pick up advanced books for rent.

Extension: What foundation is needed for database travel-based learning?

You don't need a foundation, the biggest foundation for computer learning is interest, as long as you are interested, many things will not be learned.

It takes about 3-5 months to learn SQL from scratch. If you want to get started, you can only be cautious and hail a star filial piety period, but to learn well for a year or two is not a long time, the key depends on what applications you do, do database maintenance, then you have to learn fine, it takes a long time to learn and practice; If you just store data to develop applications, then you can use the libraries, tables, rows, and columns clearly.

Composition of a SQL database:

1. An SQL database is a collection of tables, which are defined by one or more SQL schemas.

2. An SQL table consists of a set of rows, and a row is a sequence of columns, and each column corresponds to a data item with a row.

3. A table is either a basic table or a view. A base table is a table that is actually stored in a database, while a view is the definition of a table that consists of several base tables or other views.

4. A basic table can span one or more storage files, and a storage file can also store a finger sail or multiple basic tables. Each storage file corresponds to the previous physical file on external storage.

5. Users can use SQL statements to query views and basic tables. From the user's point of view, the view and the basic table are the same, there is no difference, they are all relationships.

6. The SQL user can be an application or an end user. SQL statements can be embedded in programs in the host language, and SQL users can also be used as stand-alone user interfaces for end users in interactive environments. <>