SQL: The Practical Guide to Master Relational Databases, SQL Syntax, and Sublanguages for Effective Database Management (Rheinwerk Computing)
Format:
Paperback
En stock
0.86 kg
Sí
Nuevo
Amazon
USA
- Whether you’re managing large datasets or writing your first query, expand 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-word applications!Master SQL programming for database management and manipulationLearn to use the five SQL sublanguages: DDL, DML, TCL, DQL, and DCLDefine schemas and tables; modify and query data; and configure database authorizations Relational Database Elements Understand the fundamentals of relational databases and schemas. Learn the elements of a database structure, from tables to views to keys. Then, review more advanced concepts like normalization, stored procedures, triggers, and authorization.Setting Up Your Environment Follow 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.SQL Sublanguages Use 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.
IMPORT EASILY
By purchasing this product you can deduct VAT with your RUT number