SQL
SQL
By: Kerem Koseoglu | Publisher: Shroff/Rheinwerk Computing | Year: 2025
ISBN: 9789355427502
MRP: Rs. 1,650.00
You Pay: Rs. 1,480.00
You save: Rs. 170.00 ( 10% )
Usually ships in 2-3 days
Reward points: 14 points
⚠️ Ships only in Bangladesh, Bhutan, India, Nepal, and Sri Lanka.
Description
📖 How to activate your license key
To activate the key, please follow the steps listed below.
- Go to www.sap-press.com and login to your account.
- Click on the “Library” icon located next to the shopping cart.
- Copy and paste the license key number into the white box that says, “Enter license key”
- Press the yellow button that says “Add Product”
- Choose which option you would like for the book — Read Online, Download E-book, or Additional Data (not all books have this available).
Read Online allows you to read the book directly through our website. If you choose to download, you will be given 3 options:
- PDF – download and save this to your computer. From there, you can add it to different electronic devices for your own use
- EPUB – download to tablets and devices.
- MOBI – download this format to transfer to your Kindle
Whether 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!
- Master SQL programming for database management and manipulation
- Learn to use the five SQL sublanguages: DDL, DML, TCL, DQL, and DCL
- Define 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 database structures, 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.
- Databases
- Schemas
- Tables
- Views
- Keys
- PostgreSQL
- Data definition language (DDL)
- Data manipulation language (DML)
- Transaction control language (TCL)
- Data query language (DQL)
- Data control language (DCL)
- Entity-relationship diagrams (ERD)
About the Author
Dr. Kerem Koseoglu is a seasoned software engineer, author, and educator with extensive experience in global software development projects. In addition to his expertise in ABAP, he is also proficient in database-driven development using Python and Swift. He is the author of Design Patterns in ABAP Objects (SAP PRESS), as well as several best-selling technical books in Turkey. He has a Ph.D. in organizational behavior.