Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> I hope you can leave your email address, it is estimated that around 8.15 I will send you the sample chapter of the full series of books.
Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> we sincerely hope you can get the following from your friends:
Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> 1. The recognition of this style is calculated by 10 points and a simple reason is given.
Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> 2. The recognition of this series of Knowledge collocation is calculated by 10 points, and simple reasons are given.
Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> 3. What do you want this series of books to look like?
Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> 4. Help me name the series and name each book separately
Mso-hansi-font-family: Calibri; mso-bidi-font-family: "> at that time, I will put a word2003 feedback table in the compressed package, hope you can get your support. Thank you !!
Mso-hansi-font-family: Calibri; mso-bidi-font-family: ">
Database Chapter 1 Preview
1.1 What is SQL Server 2005?
What does SQL Server 2005 do? This is really hard to clarify, so let's look at a conversation:
Xiaotian: What is SQL Server 2005?
Laotian: it is a database management system. Of course, we simply understand it as a tool for storing and managing data. As for data analysis, data mining, reports, and other things, let's wait until you finish learning the basics.
Xiaotian: So I understand SQL Server 2005 as a database, right?
Lao Tian: there is no problem with this understanding.
John: No. I don't think it is necessary to use databases to store and manage data. I use Execl now.1.2 Why database use
Laotian: Let's take an example. Figure 1.1. Do you think this is similar to management?
Figure 1-1
Tian: Yes, I think it's clear.
Laotian: When you need to perform the following operations frequently:
1. Add new employees;
2. The department supervisor changed the phone number;
3. The Department has changed to the supervisor;
4. Changed the company leadership;
5. Change multiple employees to branch offices;
6. Change an employee to another department;
7. When the number of employees exceeds 500;
Next, let's simulate these tasks.
To add new employees, it is easier as long as the ownership information of employees is complete. In case of incomplete information, I had to perform a row-by-row query.
The Department Supervisor changed the phone number. If you do not know that Execl can be searched and replaced in full text, you can only change the line by line. If you typed a wrong word when you entered someone's information...
Xiaotian: sweating...
Laotian: The department changes to the supervisor. If the supervisor leaves directly, it will be easy. Otherwise, he will first change the information of the new supervisor and continue to arrange new jobs for him.
Of course, as long as the amount of data is small, it is not a big problem. If the company is CNPC and China Mobile, then the amount of data should be less than tens of thousands?
There is also the most serious problem. You cannot guarantee that data will not be added repeatedly;
Xiaotian: Don't worry. I'm tired of these situations, but is it solved in SQL Server 2005? If this problem is solved, I will immediately learn how to use it.
Laotian: Of course, the solution is solved because SQL Server 2005 is a relational database, so these problems can be solved.
Xiaotian: It's not a database. Why is it a relational database?
Lao Tian: Well, I will explain it to you from the history of the database to the current situation.
Below is my writing purpose for this series of books:
Mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:
""> 1: This is not a book made up of knowledge points.
Calibri; color: #333399 "> 1.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> the content of this series of books is explained in the form of [Laotian and Xiaotian] conversations. Many of them offer humorous questions and answer questions, avoid the following questions: MSDNmso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:
; Color: #333399 "> difficult to learn about the previous knowledge point description;" Times New Roman "; color: #333399 '>
Calibri; color: #333399 "> 2.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> the terminology used in the full series of books also tends to be more professional with the deepening of knowledge;
Calibri; color: #333399 "> 3.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> at the end of each chapter, the questions raised in" daily practice "are often mixed with incorrect questions, the following question requires you to correct the previous question, which greatly avoids cramming teaching and prevents you from thinking or thinking about it.
Mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:
""> 2: This is a book that teaches you how to learn.
Calibri; color: #333399 "> 4.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> learning is based on the understanding of beginners, check the instance-> mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:
; Color: #333399 "> ask a question-> mso-bidi-font-family:; color: #333399"> answer the question;
Calibri; color: #333399 "> 5.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> answers to questions raised by Xiaotian to guide students in thinking and learning modes;
Calibri; color: #333399 "> 6.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> the learning time is calculated by day;
Calibri; color: #333399 "> 7.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> This chapter provides the learning line tips for each chapter;
Mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:
""> 3: This is a book that gives you a one-year working experience from scratch. "Times New Roman" '>
Calibri; color: #333399 "> 8.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> refer to DotNetmso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri in dozens of training institutions in China; mso-bidi-font-family:
; Color: #333399 "> the professional syllabus is developed. The full series are divided into winfrommmso-bidi-font-family:; color: #333399"> programming, WebFromCalibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> four stages: programming, advanced knowledge, and project practice;
Calibri; color: #333399 "> 9.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> each book can be a part of the series according to the outline we propose, or be an independent subject. The knowledge points written in the book cover three stages: High School and low school;
Calibri; color: #333399 "> 10.
Calibri; mso-hansi-font-family: Calibri; mso-bidi-font-family:; color: #333399 "> it only describes the knowledge points required for a general zero to one year of work experience, not all-inclusive (after all, the thickness of the book is related to silver)