I d like to learn the basics of databases, but I can t find Can you help?

Buy textbooks. If you have the conditions, go to the training class to learn it.

It takes a lot of time to learn from learning databases to understand and realize that they are using them, and there are many things to learn. If for some data of the enterprise, the data is easy to use and store, and it is not a big enterprise or a big project, it is a bit professional to use SQL. If you use it yourself or just know a little bit, then learn it a little easier.

SQL is an abbreviation for Structured Query Language. SQL is a set of operational commands built specifically for databases, and is a full-featured database language. When using it, you only need to issue the command of "what to do", and the "how" is not considered by the user.

Powerful, easy to learn, and easy to use, SQL has become the foundation of database operations, and is now supported by almost all databases.

Composition of the SQL language:

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

2.An SQL table consists of a set of rows, which are a series (collection) 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 base table can span one or more storage files, and a storage file can hold one or more base tables. Each storage file corresponds to the previous physical file on external storage.

5.You 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 (**).

The user can be either an application or an end user. SQL statements can be embedded in programs in host languages, such as Fortran, Cobol, Pascal, PL I, C, and ADA. SQL users can also be used as stand-alone user interfaces for end users in interactive environments.

The small database of the desktop has foxpro, the most used is sql server2000, and the large one has oracle and so on.

It is recommended that you can learn SQL Server 2000, which is relatively simple.

3. Most of the common databases are relational databases, whether it is the theory and operation are basically the same, if from the perspective of operation and easy learning, SQL Server is still relatively easy to use, and there are a lot of information and various books on the Internet, but if the amount of data is large, the stability of the database, Oracle is still relatively strong. It's up to you to choose!

It's not clear what you mean by zero-based. If you're referring to the knowledge or skills that you don't have in the database area, most people are in the same situation. Many people change careers or work in jobs that are not in line with their majors after graduating from undergraduates, and everyone grows up step by step, so zero foundation will not become a burden for a person to study, and you don't have to worry about it at all.

However, if you have only graduated from high school, have not gone to college, do not have basic knowledge of mathematical statistics, and have not been able to form a good thinking pattern for university study, then it may be more difficult to study databases rashly, there are many things that need to lay a solid foundation, and the pressure may be too great and affect your life.

Step 1: Find this textbook on the theoretical basis of the database.

After having a certain theoretical foundation and practical experience, students should select the topics of the database for in-depth study one by one, such as storage mechanism, query optimization, backup and recovery, and multi-version mechanism. You can use Oracle as an example to learn and analyze and compare the differences between other databases.

In short, to do this business, you must think diligently, study more, practice more, and summarize more.

First of all, learn some basic knowledge of databases, such as records, patterns, statements, paradigms, etc., the first 7 chapters of the book "Introduction to Database Systems" are all basic theories, you should look carefully, the last 3 chapters are expansions, and the back is combined with specific database learning.

A database is where data is stored. Everything in a computer, in memory, in a hard disk is data stored in a database. And the place where this data resides is called the database.

It can also be called an electronic "filing cabinet". The database in computer science and application means that the data will become larger and larger in the future, and it also means that more data will be used in the future development of the data in many science and applications. A database management system can be classified according to the database model it supports, such as relational, XML; or by the type of computer supported, such as server clusters, or by the query language used, such as SQL, Xquery; Or they can be classified according to the focus of performance impulse, such as the classification method for the largest scale and highest operating speed.

If you are interested, click here to learn for free.

You should learn about data structures first, start with theory, and then learn access, orcal

If you really want to learn, it's better to start with practice. Find some themes by yourself and do them yourself! That's the most workouting thing. When you have a problem, you are communicating with others!

If you locate the "master", you may have a long way to go.

First of all, you need a solid SQL language foundation and some advanced skills to be able to turn a lot of queries written by others into a single sentence.

Then you need to master a high-level programming language, and if you don't, you may not be able to write easy-to-call and efficient stored procedures for backend developers.

Then you need to learn the principles of the database, in order to solve various problems that may be encountered in the real world, performance tuning, and so on.

Finally, you need to become a C language master before you become an Oracle master, be familiar with the operating system, and make scheduling decisions. In Oracle, it can be expanded and redeveloped, adding LIB to Oracle to solve various problems such as high performance and massive concurrent throughput.

The introductory book recommends Wang Shan's "Database System Basics and Applications", which is a database textbook for various colleges and universities, and you need a lot of practical operations. After getting started, go to see the blogs of the masters, and then cooperate with your own practical operations, why should you read their blogs? Because not only can you learn new things, but you can also learn the feelings and ways of thinking of these bloggers, and most importantly, you can often learn their unique secrets.

Actually, I think no matter how many books you read, it's useful, just look at it, yours will use it! Therefore, we need a practical environment, and practice can produce true knowledge.

To learn the database, you have to start with the most basic SQL statements, and all databases will be used, but there are slight differences between different databases, we learn to use our own teacher's book "Database Principles and Oracle Applications" Feng Fengjuan Editor-in-Chief, is an introductory book, Oracle is currently the most used database on the market, it is very good to learn it.