SQL For Beginners
Cód:
491_9781801235037
De: R$ 0,00Por: R$ 132,45ou X de
Learn SQL (Structured Query Language) from Installation to Database Management and Database AdministrationAnything that stores data records is called a database. It can be a file, CD, hard disk, or any number of storage solutions. From a programming point of view, a database is a methodically structured repository of indexed data information that can be easily accessed by the users for creating, retrieving, updating and deleting information.Data can be stored in many forms. Most applications require a database for storing information. A database can be of two types:(1) flat database and (2) relational database.As the name suggests a flat database has a two-dimensional structure that has data fields and records stored in one large table. It is not capable of storing complex information, which creates a need for relational databases. A relational database stores data in several tables that are related to each other.Lets take the example of a school.A school will have to maintain data for several students. To find information for a student, we will first ask the class name. After the class name, we will ask for the first name. However, if there are two children with the same first name, then we will ask for the surname.If there are two children will identical names, we can still discriminate the information related to them based on their student id, parents name, date of birth, siblings in the same school, etc.This is all related information. When all of this information is stored on paper, it takes a lot of time to retrieve it. The relational database allows easy access to all of this information.SQL is a computer language we can use to work with the various database management systems. It is the standard language for the various relational database management systems such as Oracle, MySQL, MS Access, SQL Server, Postgres, Sybase, etc. With the use of SQL, a database user can create various database objects and perform various manipulations on them.When they have ac
Veja mais
