| Description |
1 online resource |
| Series |
--For dummies |
|
--For dummies.
|
| Note |
"8 books in one"--Cover |
| Contents |
Book 1. SQL concepts. Understanding relational databases ; Modeling a system ; Getting to know SQL ; SQL and the relational model ; Knowing the major components of SQL ; Drilling down to the SQL nitty-gritty -- Book 2. Relational database development. System development overview ; Building a database model ; Balancing performance and correctness ; Crating a database with SQL -- Book 3. SQL queries. Values, variables, functions, and expressions ; SELECT statements and modifying clauses ; Querying multiple tables with subqueries ; Querying multiple tables with relational operators ; Cursors -- Book 4. Data security. Protecting against hardware failure and external threats ; Protecting against user errors and conflicts ; Assigning access privileges ; Error handling -- Book 5. SQL and programming. Database development environments ; Interfacing SQL to a procedural language ; Using SQL in an application program ; Designing a sample application ; Building an application ; Understanding SQL's procedural capabilities ; Connecting SQL to a remote database -- Book 6. SQL, XML, and JSON. Using XML with SQL ; Storing XML data in SQL tables ; Retrieving data from XML documents ; Using JSON with SQL -- Book 7. Database tuning overview. Tuning the database ; Turning the environment ; Finding and eliminating bottlenecks -- Book 8. Appendix A: SQL: 2016 reserved words ; Appendix B: Glossary. |
| Summary |
The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications. With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases. Cope with any issue that arises in SQL database creation and management Get current on the newest SQL updates and capabilities Reference information on querying SQL-based databases in the SQL language Understand relational databases and their importance to today's organizations SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries. |
| Subject |
SQL (Computer program language)
|
|
Relational databases.
|
|
SQL (Langage de programmation) |
|
Bases de données relationnelles. |
|
Relational databases |
|
SQL (Computer program language) |
| ISBN |
9781119569602 (electronic bk.) |
|
1119569605 (electronic bk.) |
|
More Resources