Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more.
SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages―and this book shows you how to harness the core element of relational databases with ease.
Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems
Find great examples on the use of temporal data
Jump right in―without previous knowledge of database programming or SQL
As database-driven websites continue to grow in popularity―and complexity―SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.
Editorial Reviews
Review
Select Guide Rating
From the Inside Flap
Learn all the features in the latest version of SQL
Build a relational database and create a management system
Secure and protect your database from corruption
Get ready to make SQL easy
Updated for the latest version of SQL, the new edition of this perennial bestseller shows you how to use SQL to build relational databases and extract valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; retrieve information from a database; and much more.??As database-driven websites continue to grow in popularityand complexitySQL For Dummies 9th Edition is the easy-to-understand, go-to resource you need to use it seamlessly.
Inside…
What SQL is and isn’t
Use SQL to build databases
Build a multi-table relational database
Manipulate database data
Use advanced value expressions
Zero in on the data you want
Use relational operators
Provide database security
From the Back Cover
Learn all the features in the latest version of SQL
Build a relational database and create a management system
Secure and protect your database from corruption
Get ready to make SQL easy
Updated for the latest version of SQL, the new edition of this perennial bestseller shows you how to use SQL to build relational databases and extract valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; retrieve information from a database; and much more.??As database-driven websites continue to grow in popularity and complexity SQL For Dummies 9th Edition is the easy-to-understand, go-to resource you need to use it seamlessly.
Inside…
What SQL is and isn’t
Use SQL to build databases
Build a multi-table relational database
Manipulate database data
Use advanced value expressions
Zero in on the data you want
Use relational operators
Provide database security
About the Author
Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 40 books, including SQL For Dummies 9th Edition and Crystal Reports For Dummies. He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development internationally through a leading online education provider.
Wow! eBook
