Go to Database Application Basic series-Chapter 1

From http://www.cnblogs.com/zhenyulu/articles/204218.html

Chapter 1

 

As a result, I have been teaching in colleges and universities for the ninth year. My major is industrial foreign trade, while my major is computer. In order not to miss the children, I tried my best to catch up on the computer. Fortunately, the students were very enthusiastic about the computer courses they taught, in the ninth year, I recorded some of my database experience and skills for future reference.

 

Just like many important colleges and universities, I am faced with a shortage of teachers and a shortage of teachers after graduation. In such a difficult situation, I was forced to open more than 10 computer courses within nine years, ranging from FOXBASE to Visual FoxPro, from database principles to SQL Server to Data Warehouse and mining, from VB to C #, from plane image processing to 3D animation production to dynamic audio and video editing, from static webpage design to dynamic website construction, from basic data structures to complicated design patterns, from XML to WebService, it's really a "Multi-faced. Some of these courses have been learned by themselves, and some of them are not even familiar with anything at first. They are sold now. During this period, they are under great pressure and have exercised their self-learning ability. Without the guidance of a famous teacher, a lot of knowledge is not very "Orthodox", but also has accumulated a lot of unique understanding, practice is always the best teacher to guide my cognition. Now I want to write down some of the content related to the database. On the one hand, I will record my own thinking process, and on the other hand, I hope I can give you some advice.

 

The content in this series is relatively less difficult. It is suitable for beginners of databases and those with a small amount of experience in database operations, at the same time, I also welcome people with profound database operation skills to comment on my cognitive understanding process.ArticleThe main content includes the following parts (which can be adjusted or supplemented at any time ):

 

• Database basics: a new understanding of the database and its related concepts, concurrency issues, and database-level solutions
• Data Update: Several abstractions of the concurrent consistency solution.
• C/S database operations: starting from a simple winform, this article introduces the database access process and the implementation of Microsoft ADO. net.
• B/S operation:
• Multi-layer applications:
• XML and WebService:
• Remoting
• O/R mappting and nhibting

 

The focus is on the first few parts, which is also the most basic part. A large number of lab exercises are used to deepen your understanding. In addition, some definitions that may appear in subsequent articles are easy to understand and not strictly defined (to ensure that they are basically correct). The main purpose is to facilitate cognition. I don't want this series to become a rigid series of dogmas and human feelings.

 

The software environments used in this series include:

 

• Visual FoxPro 8.0
• SQL Server 2000
• Visual Studio. NET 2003
• ... (To be supplemented)

 

Finally, I would like to thank the blog Park for giving me a place to post articles.