- Main
- Computers - Databases
- SQL QuickStart Guide: The Simplified...
SQL QuickStart Guide: The Simplified Beginner's Guide to SQL
Walter Shields你有多喜欢这本书?
下载文件的质量如何?
下载该书,以评价其质量
下载文件的质量如何?
This book covers a wide array of topics that all deal with how to get information from a database. It introduces SQL, the language for communicating with a database. The focus is on using SQL as a query language, while the other aspects of the language are omitted.
You'll learn that the key to extracting data with SQL is the SELECT statement, which allows you to select the columns and tables from which to extract data. You'll learn how to filter with the WHERE clause by specifying any number of conditions in order to obtain the results that suit
your particular needs. We'll introduce logical and comparison operators in order to better manage situational data conditions. We'll also show how to manage the order of results with the ORDER BY clause.
You'll use JOIN statements to tackle the slightly tricky topic of selecting data from more than one table. You'll manage to link two or more tables to form a new results set, and the importance of the unknown (NULL) value.
You'll summarize and aggregate data rather than getting results based on individual records by using the GROUP BY statement, which enables results to be based on groups of common data. In
conjunction with SQL’s aggregate functions such as COUNT, SUM, AVG, MAX, and MIN you'll learn how to manipulate data and calculate specific values. You'll also use the HAVING clause, which filters out the result of groups using various conditions, much like a WHERE clause does for a
SELECT statement. You'll learn how to add new records to a database using the INSERT INTO statement, update already existing data with the UPDATE statement, and learn about the DELETE statement, which allows you to delete all or specific records from a table.
Finally, we learned how to use SQL to define the structure of the database itself. We used the CREATE DATABASE statement to create a new database from scratch. You'll also learn about CREATE/ALTER/DROP TABLE commands to successfully manipulate the structures of tables.
You'll learn that the key to extracting data with SQL is the SELECT statement, which allows you to select the columns and tables from which to extract data. You'll learn how to filter with the WHERE clause by specifying any number of conditions in order to obtain the results that suit
your particular needs. We'll introduce logical and comparison operators in order to better manage situational data conditions. We'll also show how to manage the order of results with the ORDER BY clause.
You'll use JOIN statements to tackle the slightly tricky topic of selecting data from more than one table. You'll manage to link two or more tables to form a new results set, and the importance of the unknown (NULL) value.
You'll summarize and aggregate data rather than getting results based on individual records by using the GROUP BY statement, which enables results to be based on groups of common data. In
conjunction with SQL’s aggregate functions such as COUNT, SUM, AVG, MAX, and MIN you'll learn how to manipulate data and calculate specific values. You'll also use the HAVING clause, which filters out the result of groups using various conditions, much like a WHERE clause does for a
SELECT statement. You'll learn how to add new records to a database using the INSERT INTO statement, update already existing data with the UPDATE statement, and learn about the DELETE statement, which allows you to delete all or specific records from a table.
Finally, we learned how to use SQL to define the structure of the database itself. We used the CREATE DATABASE statement to create a new database from scratch. You'll also learn about CREATE/ALTER/DROP TABLE commands to successfully manipulate the structures of tables.
年:
2015
出版社:
ClydeBank Media
语言:
english
ISBN 10:
194505154X
ISBN 13:
9781945051548
系列:
#90,558
文件:
PDF, 5.07 MB
您的标签:
IPFS:
CID , CID Blake2b
english, 2015
在1-5分钟内,文件将被发送到您的电子邮件。
该文件将通过电报信使发送给您。 您最多可能需要 1-5 分钟才能收到它。
注意:确保您已将您的帐户链接到 Z-Library Telegram 机器人。
该文件将发送到您的 Kindle 帐户。 您最多可能需要 1-5 分钟才能收到它。
请注意:您需要验证要发送到Kindle的每本书。检查您的邮箱中是否有来自亚马逊Kindle的验证电子邮件。
正在转换
转换为 失败