×
Dodano do koszyka:
Pozycja znajduje się w koszyku, zwiększono ilość tej pozycji:
Zakupiłeś już tę pozycję:
Książkę możesz pobrać z biblioteki w panelu użytkownika
Pozycja znajduje się w koszyku
Przejdź do koszyka

Zawartość koszyka

ODBIERZ TWÓJ BONUS :: »

Essential PostgreSQL Swati Saxena

(ebook) (audiobook) (audiobook) Książka w języku angielskim
Essential PostgreSQL Swati Saxena - okladka książki

Essential PostgreSQL Swati Saxena - okladka książki

Essential PostgreSQL Swati Saxena - audiobook MP3

Essential PostgreSQL Swati Saxena - audiobook CD

Autor:
Swati Saxena
Ocena:
Bądź pierwszym, który oceni tę książkę
Stron:
342
Dostępne formaty:
     ePub
     Mobi
Description
PostgreSQL, a robust and versatile relational database management system (RDBMS), is gaining immense popularity due to its reliability, scalability, and rich feature set. This book is your indispensable companion to mastering PostgreSQL, helping you become a great PostgreSQL developer and create amazing database-driven applications.

This book provides a thorough introduction to PostgreSQL, covering the fundamentals of database creation and management to advanced topics like data modeling, query optimization, and performance tuning. Explore PostgreSQLs powerful features, including multi-version concurrency control (MVCC), data types, constraints, and indexing. Learn how to install, configure, and apply PostgreSQL in real-world scenarios. You will also develop essential SQL skills to manipulate and analyze data, design efficient schemas with normalization, and use stored procedures and triggers to automate tasks effectively.

By the end of this book, you will have a solid understanding of PostgreSQL's core concepts and best practices. You will be able to create complex database structures, write efficient SQL queries, optimize database performance, and implement robust data management strategies.

Key Features
A comprehensive overview of PostgreSQL, covering all essential topics from database fundamentals to advanced features.
Relates concepts to real-world scenarios, helping you understand how to apply PostgreSQL in practical applications.
Provides step-by-step instructions and guidance, making it easy to follow along and learn effectively. It also includes MCQs in each chapter to engage the readers.

What you will learn
Database fundamentals like creation, structure, data types, and constraints.
Data manipulation operations like insert, update, delete, retrieve, filter, and sort.
Subqueries, joins and data formats for advanced data manipulation.
Optimize database performance using indexes and views.
Examine closely advanced topics like transactions, procedures, functions, triggers, and administration.

Who this book is for
This book is for anyone who wants to learn or improve their skills in using PostgreSQL. It is suitable for developers, data analysts, database administrators, and students who are interested in working with databases and building data-driven applications.

Table of Contents
SECTION 1: Let Us Sail With PostgreSQL
1. Get Started with PostgreSQL
2. Working With Database
3. Working With Schema and Table
SECTION 2: DDL
4. Managing Table and Datatype
5. Understanding Constraints
6. Alter Table Structure
SECTION 3: DQL
7. Displaying Data from Database Tables
8. PostgreSQL Clauses and Operators
SECTION 4: DML
9. Adding Data to Tables
10. Updating and Deleting Rows
11. Fetching Data using Subquery and Joins
12. Increasing Performance Using Index and View
SECTION 5: TCL, DCL
13. Transaction Control Language
14. Data Control Language Commands
SECTION 6: PL/PgSQL
15. Anonymous Block and Postgres Procedure
16. Postgres Stored Functions and Triggers
17. AdministratorsResponsibilities
Appendix A: Postgres Connectivity with Java
Appendix B: String and Math Function
Appendix C: Northwind Database
Appendix D: Postgres Error Codes
Appendix E: Test Yourself

Wybrane bestsellery

Swati Saxena - pozostałe książki

BPB Publications - inne książki

Zamknij

Przenieś na półkę

Proszę czekać...
ajax-loader

Zamknij

Wybierz metodę płatności

Ebook
80,91 zł
Dodaj do koszyka
Zamknij Pobierz aplikację mobilną Ebookpoint
Zabrania się wykorzystania treści strony do celów eksploracji tekstu i danych (TDM), w tym eksploracji w celu szkolenia technologii AI i innych systemów uczenia maszynowego. It is forbidden to use the content of the site for text and data mining (TDM), including mining for training AI technologies and other machine learning systems.