Database is a tool to store information, and sql statement is a way to view information. The method is easy to learn, as long as the logic is clear, it will be learned in a few days. But if you want to save data,
Then there's something to learn. Dan sql sentences have tutorials everywhere on the internet, and they are also very short; Learn database, I suggest you buy a book to read. Video teaching is also available online.
Practice more by yourself during your study. Computer is a lot of homework, and you can learn it well with more practice.
Is the database difficult to learn?
1, select database:
Before learning, choose the database you want to learn according to your own purpose: small databases include ACCESS and FOXPRO；; Medium-sized databases include SQL SERVER and MySQL. Large databases include: ORICLE.
2. Learn database theory.
Databases are generally similar, and now they are mainly relational databases. Understand what is relational database, what is SQL language, how to use SQL language, and what are fields, primary keys and foreign keys. ...
Step 3 operate
After you have a theory, you have to operate it. You must figure out how to create a new database, how to create a new table, how to add data, and how to establish relationships.
Step 4 choose a language
The development of database is inseparable from the program. The database is used to store the data that the program wants to access, so you should choose a language to manipulate the data. C, C++, JAVA, VB, C# and other languages can realize database access.
Conclusion: The above four steps can be carried out simultaneously, but the theory is very important. Understand the essence of theoretical database, and you will master it, and the rest is the different operations of different databases.
The database one is easy to learn? Is it practical?
It depends on what you want to do. If you want to do general database development (coding), then any one will do, mainly the compilation and specification of sql statements. Although each database has some different functions, it is not right after all. The main sql specifications are still the same.
If you want to go further, such as database management, you can't say which one is practical, because now large databases are basically divided by oracle and db2, and small and medium-sized mysql is still very strong, and the architectures of the three are not exactly the same. Mysql is widely used, and now oracle has a larger market share, but db2' s share is also increasing. So this is not easy to choose, but the demand market for this piece is not very good now. Of course, the market for new students is still good.
Is the database difficult to learn?
It's really hard to learn. As for learning to learn, it depends on your patience and learning ability. It must be boring to learn. Check the salary of professional database administrators, and then look at the money and ability they need to study, and you will understand why the salary is so good. At present, there are not many such people in China. Anyway, these people are very popular talents in the computer industry abroad-data is the core of computers-
Do you think the database is easy to learn? Computer foundation zero. 20 points
If you study hard, you need patience to study.
Can I learn the database without programming? What are the database difficulties?
A database is a warehouse that organizes, stores and manages data according to the data structure. It came into being 50 years ago. With the development of information technology and market, especially after 1990s, data management is no longer just storing and managing data, but changing into various data management methods that users need. There are many types of databases, from the simplest tables with various data to large-scale database systems that can store massive data, which have been widely used in all aspects. The basic structure of the basic structure database is divided into three levels, which reflects three different angles of observing the database.
(1) physical data layer.
It is the innermost layer of the database and the * * * layer of the data actually stored on the physical storage device. These data are original data, which are processed by users and consist of bit strings, characters and words processed by instruction operations described by internal modes.
(2) Conceptual data layer.
It is the middle layer of the database and the overall logical representation of the database. It is pointed out that the logical definition of each data and the logical relationship between data are where the records are stored. It involves the logical relationship of all objects in the database, not their physical conditions, and is a database under the concept of database administrator.
(3) Logical data layer.
It is a database that users see and use, representing the data used by one or some specific users, that is, the body of logical records.
The relationship between different levels of databases is transformed by mapping.
The main feature (1) realizes data sharing.
Data sharing includes that all users can access the data in the database at the same time, and users can use the database in various ways through the interface and provide data sharing.
(2) Reduce data redundancy.
Compared with the file system, because the database realizes data sharing, users are prevented from creating application files separately. Reduce a large number of duplicate data, reduce data redundancy and maintain data consistency.
(3) independence of data.
The independence of data includes that the logical structure of database and application program are independent of each other, and the change of physical structure of data does not affect the logical structure of data.
(4) Centralized control of data.
In the file management mode, the data is in a decentralized state, and different users or the same user do nothing with their own files in different processes. Database can be used to centrally control and manage data, and data model can be used to express the organization of various data and the relationship between data.
(5) Consistency and maintainability of data to ensure the safety and reliability of data.
It mainly includes: ① security control: preventing data loss, wrong update and unauthorized use; ② Integrity control: ensure the correctness, validity and compatibility of data; ③ Concurrency control: multiple accesses to data are allowed in the same time period, which can prevent abnormal interaction between users; ④ Fault discovery and recovery: The database management system provides a set of methods to find and repair faults in time, thus preventing data from being destroyed.
(6) Fault recovery.
A set of methods provided by database management system can find and repair faults in time, thus preventing data from being destroyed. The database system can recover the faults occurred during the operation of the database system as soon as possible, which may be physical or logical errors. Such as data errors caused by system misoperation.
Category databases are usually divided into hierarchical databases, network databases and relational databases. Different databases are connected and organized according to different data structures.
1. data structure model
(1) data structure
The so-called data structure refers to the organizational form of data or the relationship between data. If d represents data and r represents the relationship between data objects, then DS = (d, r) is called data structure. For example, there is a telephone directory in which the names and corresponding telephone numbers of N people are recorded. In order to find someone's phone number conveniently, names and numbers are arranged in dictionary order, and the corresponding phone number is followed by the name. In this way, if you want to find a person's phone number (assuming that the first letter of his name is Y), you only need to find those names that start with Y. In this example, *** D of the data is the name and phone number, and the relationship R between them is arranged in dictionary order, and its corresponding data structure is DS = (d, R), which is an array.
(2) the type of data structure
Data structure is divided into data logic. ......
Is database management easy to learn? I'm going to work in a company, and I'm still at a zero foundation.
Database management is the technology of establishing, storing, modifying and accessing the information in the database, which refers to the technical management work that the relevant personnel must carry out in order to ensure the normal operation and service quality of the database system. The individual or group responsible for managing these technologies is called a database administrator (DBA). The main contents of database management include: database optimization, database reorganization, database reconstruction, database security control, analysis, summary and handling of error reporting problems, and daily backup of database data. The above is the definition of database management. It feels like you just joined the company, and the supervisor won't let you touch so many things. You should start with the simplest, otherwise the company will pay you to train for a while before contacting. After all, the database is very important.
I want to learn database development, which one should I learn?
Generally, large enterprises (especially banks, insurance companies) and other financial industries have higher requirements for the security and performance of databases, which are basically minicomputers, so they have certain requirements. For example, if you use an IBM minicomputer, you will definitely use IBM's DB2 database to optimize directly. If you use an HP minicomputer, it may be equipped with oracle. I think sqlserver is generally a lightweight application for small and medium-sized enterprises. This can't be changed for the time being, so if you want to develop it, you'd better learn from oracle or db2, and you'll get more benefits. The first two are much deeper than sqlserver.
Is SQL SERVER database easy to learn?
Whether it is sql SERVER or ORACLE, or DB2, MYsql, learning database, if you just want to use, build tables, query and so on, it is not difficult to learn SQL statements. It will be difficult to tune and maintain the database. If you think about a dba with a monthly salary of tens of thousands, it is definitely not for nothing. .
How do beginners learn database?
This must first learn SQL, learn to write SQL statements, and then learn specific databases, including relatively simple mysql, complex sql server, oracle and so on. Beginners use mysql first.
How to connect with the website, you have to learn the development of the website. At present, the most widely used languages are C# and java. C# should learn the basics first, and then learn to develop. Java learns java se first, and then develops websites to learn java ee.
There is a lot to learn. You have to write teaching videos or training, otherwise it will be difficult to study systematically.