Create a database - CS academy

Create a database

Peace be upon you. Thank God who helped me write this book for the Arab and Islamic nation. And I thank him for
My success in learning this language. I hope that I have provided even a little for the Arab and Islamic nation.
The Internet, we always wish this nation progress and prosperity in the Internet, and here I am writing this simple book in order to
This nation learns and depends on itself, and we wish success to all,,,
I dedicate this book to the family of my dear brother, and I dedicate it to the family of my teachers in this language and elsewhere.
language, and I do not want to mention any name so as not to forget anyone,,,
And this book is free and no one is entitled to it. www.el7zn.com All rights reserved to the site and forums of grief
. MaaSTaaR Someone sold it , This book is authored by
3
About this chapter:
Information that will benefit you, God willing, and increase your SQL balance. This chapter contains a simple introduction to SQL
Your information in the Internet and database languages
What is SIL?
And its meaning (the Structured Query Language), uses the Structured Query Language, which is the abbreviation of the word SQL
This language in dealing with databases is used to extract, update and add data from a database
Data This type of database is often used in websites that use technologies
Through the famous SQL engine, and as we can see that most web programs depend on the famous PHP, such as the
,,, MySQL
? MySQL Where can I get information on th
, MySQL must contain information, even if simple, about PHP, most of the sites that are interested in PHP
General, these links may help you:
http://www.rafiaphp.com/news.php?action=list&cat_id=10
http://www.phpvillage.com/p.php?page=0&idp=48&search=mysql&total=8371
http://www.phpvillage.com/p.php?page=0&idp=49&search=mysql&total=8831
http://www.phpvillage.com/p.php?page=0&idp=52&search=mysql&total=7058
http://www.phpvillage.com/p.php?page=0&idp=55&search=mysql&total=5400
http://www.mysql.com
Not our topic, well it's okay to take some information about this engine, let's MySQL hey!! the
We proceed to the next step,
What will we study in this book? SQL Where can I apply commands
In fact, there are several ways, and I will mention two of them.
Before, you can apply the commands that we will study through the PHP function. The first way: If you are a programmer
But we must connect to the database and create the database. If you are a beginner, I do not recommend mysql_query();
In this way, let's see the second way is better,,,
The second method: Through the Access program that comes with the Microsoft Office package, we will explain
The way to find pictures, God willing,,,
4
? What will I gain from learning SQL?
Good question. In fact, if you are a web programmer, you will benefit a lot, because you will learn
This will help you to use databases in your program. SQL will also use the command syntax in
Like SQL, it consists of using Access and all programs and database engines that depend on SQL
,,, SQL That is, you will be proficient in using anything that deals with MySQL, PostgerSQL, SQL Server
? SQL What can I do in the
1\ Create a table with the specifications you need
2\ Add fields or delete fields after creating the table
3/ Empty the table
4/ Delete the table
5/ Enter the information
6/ Edit information
7/ Delete the information
8\ Create a database
9\ Delete a database
10 \ Extracting information
11 \ Use of terms in extracting information (ascending, descending, 10 information, information about
specific user etc...)
Are you eager to learn more about this language? So rest your eyes a little bit, that's okay
From a cup of coffee or a cup of tea, after you finish, follow me to the next chapter
...
5
About this chapter:
,,, SQL This chapter talks about the database, what it contains, and the importance of databases for it
What are databases?
A database is a database that contains several tables or one table, and these tables contain
Information added by users,,,
? What SQL databases are important to
Without a database that contains SQL because, in fact, we cannot work with SQL. We can describe it with the nerve of Al
on schedules,,,
? SQL Can I create a database through the
Of course it can.
Eve?
Through the commands that will be addressed in the coming chapters, God willing.
What are the tables?
They are tables that contain fields and information can be added according to the existing fields, for example there is
Through this field we can add our name in the table ,,, name We have a field in the table with a name
? What SQL tables are important to
Because through tables we can deal with data and this is what SQL I can describe as the second nerve for
We would like to deal with the existing data and add new data.
6
? SQL Can I create tables through the
Yes, of course it can.
Eve?
Do not rush things in the coming chapters, God willing. This will be explained in boring detail, God willing.
Well, how many data can I add in one table?
You can add an almost infinite number, you may wonder how? Almost infinite because you can almost add
9999999999 information or more than that, you can add a huge amount of information.
Will the huge amount of information put pressure on the database?
I don't think it will affect it but it will be difficult to back up the database, or take it
A long time .
Well, after we took information about the database and tables, let's go to
next chapter,,,
7
About this chapter:
Through this chapter, you will learn how to write SAL commands in Microsoft Access.
,,, New and click on Microsoft Access First, run the program
You will see this screen: Now choose Blank Database
The explanation is clear in the picture.
After creating the database, this window will appear:
8
After clicking, this window will appear.
After pressing e will appear