Please teach database beginners how to choose a learning direction

Database beginners ask for advice on learning directions

The three databases you mentioned are all mainstream options. However, DB2 is mainly used in IBM's own projects, and the use of DB2 externally is relatively rare. In comparison, Oracle and SQL Server are widely used in various industries. Therefore, it is recommended that you start with Oracle or SQL Server for learning and research. These databases have a wider range of application areas and can provide more learning resources and support.

2. The foundation is nothing more than sql statements, and sql statements include the usage of some built-in functions, related queries, subqueries, etc. This is the basic level of sql, and then advanced, it is custom functions, triggers, storage Writing methods such as procedures, of course, simple stored procedures are also simple. There is also an excessive process in the middle. First understand the basic syntax, and then mainly understand the usage of loops, cursors, dynamic sql, etc. In this case, you will be better at database programming. It should not be a big problem. If you have the foundation of one of the databases, it will be relatively easy to learn other databases in the future

3. As for your certification question, the most popular certifications at present are definitely Oracle’s three certifications, OCA, OCP, and OCM. These need to be tested in order, and of course they are expensive. It is not recommended that you take these certificates while you are in school. After all, you are only in school. It is better to finish your studies first. You can earn money by yourself after working and then take the exams as you gain experience. Don’t add too much to your family. A big burden.

If you have any questions, please ask

What books should I read when I first start learning database knowledge

1. ACCESS or Foxpro;

2. The relational algebra part in >;

3. Database principles and optimization;

4. TranSQL-92 standard;

5. One of SQL, ERVER, MYSQL, and ORACLE.

Database is a warehouse that organizes, stores and manages data according to data structure. It was produced more than 60 years ago. With the development of information technology and market, especially after the 1990s, , data management is no longer just about storing and managing data, but has transformed into various data management methods required by users. There are many types of databases, ranging from the simplest tables that store various data to large database systems that can store massive amounts of data. They are widely used in various aspects.

In the information society, fully and effectively managing and utilizing various information resources is a prerequisite for scientific research and decision-making management. Database technology is the core part of various information systems such as management information systems, office automation systems, and decision support systems. It is an important technical means for scientific research and decision-making management.

Strictly speaking, a database is an organized and shareable collection of data stored in a computer for a long time. The data in the database refers to being organized, described and stored together in a certain data model, with the characteristics of minimal redundancy, high data independence and easy scalability, and can be used by multiple databases within a certain range. User sharing.

This kind of data collection has the following characteristics: it is as non-duplicate as possible, serves multiple applications of a specific organization in an optimal way, its data structure is independent of the application that uses it, and it can add, delete, and modify data. , check is managed and controlled by unified software. From the perspective of development history, database is an advanced stage of data management, which was developed from file management system.

I want to learn database but don’t know where to start

Previous personal summary is for reference only!

First of all, you need to understand conceptual things such as data models, relational databases, DBMS paradigms, natural operations, etc. You can go to a bookstore or library to check out relevant books. You can understand it. It is not necessary to master it completely. Of course, if you can master it, then for Yours will be very helpful in the future.

In fact, there are SQL standards, object-relational SQL, basic SQL queries, and the most basic SELECT/UPDATE/INSERT/DELETE syntax. Various databases are similar.

Then there are different databases and different usages. You can also specialize in one, such as ORACLE

Or MSSQL MYSQL INFORMIX DB2 mainly these types~

After getting started, you can learn to embed the database and access the database program

As well as database performance optimization, integrity, views, security directory backup, restore, etc.

Of course, if you mainly want to learn ORACLE, you can also directly pick up an introductory ORACLE book first, which is similar to ORACLE10G introductory, a basic ORACLE book. If you don’t fully understand it, you can read a little bit. Learning ORACLE is a long-term process, and you will understand. After a while, read other books, and you will find a lot of similarities. At that time, you will have a feeling of enlightenment. Just read a little bit and it will be OK~

When you reach a certain level, you will know how to learn, what you need to master, and what direction you want to develop.

In addition, during the learning process, it is recommended that if you have any questions, you can do the experiments yourself, or go to major forums such as CSDN, CNOUG, ITPUB, CNBLOGS to find answers or ask questions. You can also download the tutorials in the basic area, but most of them It is a document compiled by experts, and it is also very good. You can learn a lot especially from the first two forums. However, I still recommend that you read the complete introductory book before talking about it. No matter how much you understand, you have any questions. Write it down and solve it bit by bit later.

ORACLE video tutorial, there is an out-of-print training tutorial oracle 10g video from the Chinese Academy of Sciences in 2004. It is very good. You can search for the oracle 10g training tutorial from the Chinese Academy of Sciences on Thunder.

Database development tools include TOAD (client connection tool), POWERDESIGN (database design and modeling tool), PL/SQL DESIGNER (PL/SQL development tool). Generally these 3 are enough, you can go by yourself Search through Thunder to download the latest version. In addition, there are tools called DBATRIN, E/R, etc. There are many. In fact, after installing the ORACLE client tool, the built-in JAVA console is also very easy to use.

Of course, if you want to get it done overnight, you can go directly to the Internet to find relevant introductory information on ORACLE. Those are all compiled articles, but they are not recommended. It is best to read more books and do more experiments.

The above is the detailed content of Please teach database beginners how to choose a learning direction. For more information, please follow other related articles on the PHP Chinese website!