great job

How important to use what we had learned. Actually I’m very happy because I think that I’m working hard and very well on this project. I had done all queries except one query I don’t know why I’m sure that the code is right, but maybe there is a very small mistake. I can’t forget that day when I started to create query, as I didn’t have any result, but they showed me that there is an error. I checked the code, checked the selection, rechecked, but I didn’t find any things. Finally the mistake was in table name as I put the space in the field name. Any way now I had done 22 queries, saved queries in the bookmark and created the 22 views to make it easy to use in our website.

Nice feeling

It is very nice feeling when you learn new things. Now I can say that I had a good knowledge in SQL as I can:
- Creating databases and databases file
- Creating data types and tables
- Create indexes
- Create and manage views
- Create stored procedures (with and without parameterized)
- Create and using functions
- Transfer the SQL code to XML
In addition, the most important things that I had export the data “perfume” from MS Access to SQL. So I had my tables in SQL. Now I’m working on my queries.

Great week

This week was great week with this project as I think that I did very good job. First of all, I downloaded the XAMPP and used it. Now I know more about XAMPP program, the feather which provided by it and how to use it. What’s more I found the way which allowed me to transfer the data from M. S. Access to SQL. In addition, I leant how to create queries in the SQL which was the new interesting knowledge. I’m really was very happy because I found out the answer of my question (how to transfer the data from M. S. Access to SQL?), at the same time, I learnt new things which it “create queries using SQL”.

Difficult week,

This week was a very difficult week. I didn’t feel that I did any things in this project. As we had lots of deadlines and projects. I can’t lean any new things, but I reread the project documentation because I think that we need to read it again. What’s more, I reviewed what I had leant in “SQL”.

keep going on

I keep going on what I have to do in “Store your info project”. So in this week I learnt more about how to create a table using SQL and how to put the field properties’ “data type, field size, and so on”. It found it very difficult event if I know how to set some properties like data type, field size, but I felt that there are lots of rules I have to know how to use it. What’s more I think that I need to take one more week on creating tables and maybe that will be much better. Then I will start to learn about how to create queries.