{"product_id":"sql-full-colour-edition-the-practical-guide","title":"SQL (Full Colour Edition) The Practical Guide","description":"\u003cp\u003eWhether you’re managing large datasets or writing your first query, build your SQL skills with this practical guide! Learn the basic elements of relational databases and walk through the syntax, features, and applications of SQL. Then dive into the sublanguages of SQL and apply them for tasks such as modifying tables and querying data. See SQL in action with an example PostgreSQL database and detailed code samples from real-world applications!\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eMaster SQL programming for database management and manipulation\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eLearn to use the five SQL sublanguages: DDL, DML, TCL, DQL, and DCL\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eDefine schemas and tables; modify and query data; and configure database authorizations\u003c\/span\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eRelational Database Elements \u003c\/b\u003eUnderstand the fundamentals of relational databases and schemas. Learn the elements of database structures, from tables to views to keys. Then review more advanced concepts like normalization, stored procedures, triggers, and authorization.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eSetting Up Your Environment \u003c\/b\u003eFollow click-by-click instructions to install and set up a local PostgreSQL database and a pgAdmin or Visual Studio Code IDE. See a SQL demo in action in your environment and experiment with code samples.\u003c\/p\u003e\n\u003cp\u003e\u003cb\u003eSQL Sublanguages \u003c\/b\u003eUse the sublanguages of SQL for your daily tasks. Start by creating and altering database objects. Insert, update, and delete data in tables and then modify multiple tables together. Query data from single or combined tables and limit data access using authorizations.\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eDatabases\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eSchemas\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eTables\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eViews\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eKeys\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003ePostgreSQL\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eData definition language (DDL)\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eData manipulation language (DML)\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eTransaction control language (TCL)\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eData query language (DQL)\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eData control language (DCL)\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan class=\"a-list-item\"\u003eEntity-relationship diagrams (ERD)\u003c\/span\u003e\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"BOOKZONE","offers":[{"title":"Default Title","offer_id":68226542633039,"sku":"9789368082002","price":3100.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0635\/9583\/9567\/files\/sql-full-colour-edition-the-practical-guide-8815613.jpg?v=1795076048","url":"https:\/\/bookzoneindia.com\/products\/sql-full-colour-edition-the-practical-guide","provider":"BOOKZONE","version":"1.0","type":"link"}