Introduction to SQL Coding with PostgreSQL Part 1: Basics
 |
Description
Book Introduction
Everyone has a similar feeling when they first encounter a database.
Where should I start? What should I learn? How great would it be to have someone experienced right next to you, kindly explaining everything step by step and guiding you through these situations?
Googling can provide a wealth of information, but fragmented knowledge can be overwhelming for beginners.
For beginners and non-majors in need of a guide that will provide systematic knowledge and step-by-step learning, as well as entry-level developers who need to develop database-based applications, this book will be a valuable guide that will guide you into the world of SQL with joy.
Where should I start? What should I learn? How great would it be to have someone experienced right next to you, kindly explaining everything step by step and guiding you through these situations?
Googling can provide a wealth of information, but fragmented knowledge can be overwhelming for beginners.
For beginners and non-majors in need of a guide that will provide systematic knowledge and step-by-step learning, as well as entry-level developers who need to develop database-based applications, this book will be a valuable guide that will guide you into the world of SQL with joy.
index
Author's Note
Chapter 1: Introduction to SQL
1.1 What is SQL?
1.2 History of SQL
1.3 SQL and Standard SQL
1.4 Data and Databases
1.4.1 What is the difference between data, information, and knowledge?
1.4.2 Databases and Database Systems
1.4.3 Database Management System
1.4.4 Types of Databases
1.5 Basic data storage structure of RDBMS, table
1.6 SQL, From Beginner to Expert
Chapter 2 Creating a DB for Example
2.1 Why is database design necessary?
2.1.1 What is database design?
2.1.2 How to design a database?
2.1.3 Characteristics of a Well-Designed Database
2.2 Business Specification for Example DB Design
2.3 Designing an Example DB
2.3.1 Step 1: Analysis of the job description
2.3.2 Step 2: Design the logical data model
2.3.3 Step 3: Convert to a physical data model
2.3.4 Step 4: Create a table
Chapter 3: Mastering SQL Basics
3.1 Types of SQL
3.1.1 DDL (Data Definition Language)
3.1.2 Checking table information
3.1.3 DML·Adding, Deleting, and Updating Data
3.2 Data Retrieval (Select) Basics
3.2.1 Basic structure of SELECT statement
3.2.2 Execution order of SELECT statements
3.2.3 Controlling which columns to output
3.2.4 Conditional clauses
3.2.5 Extended search and join of sets
3.2.6 Comment processing
Search
Chapter 1: Introduction to SQL
1.1 What is SQL?
1.2 History of SQL
1.3 SQL and Standard SQL
1.4 Data and Databases
1.4.1 What is the difference between data, information, and knowledge?
1.4.2 Databases and Database Systems
1.4.3 Database Management System
1.4.4 Types of Databases
1.5 Basic data storage structure of RDBMS, table
1.6 SQL, From Beginner to Expert
Chapter 2 Creating a DB for Example
2.1 Why is database design necessary?
2.1.1 What is database design?
2.1.2 How to design a database?
2.1.3 Characteristics of a Well-Designed Database
2.2 Business Specification for Example DB Design
2.3 Designing an Example DB
2.3.1 Step 1: Analysis of the job description
2.3.2 Step 2: Design the logical data model
2.3.3 Step 3: Convert to a physical data model
2.3.4 Step 4: Create a table
Chapter 3: Mastering SQL Basics
3.1 Types of SQL
3.1.1 DDL (Data Definition Language)
3.1.2 Checking table information
3.1.3 DML·Adding, Deleting, and Updating Data
3.2 Data Retrieval (Select) Basics
3.2.1 Basic structure of SELECT statement
3.2.2 Execution order of SELECT statements
3.2.3 Controlling which columns to output
3.2.4 Conditional clauses
3.2.5 Extended search and join of sets
3.2.6 Comment processing
Search
Detailed image
GOODS SPECIFICS
- Publication date: November 27, 2018
- Page count, weight, size: 191 pages | 492g | 190*240*20mm
- ISBN13: 9788995447451
- ISBN10: 8995447451
You may also like
카테고리
korean
korean
![GQ KOREA Mark (Monthly): December [2025]](http://librairie.coreenne.fr/cdn/shop/files/8ef265dbbfbf186523ed75ba7319009d.jpg?v=1765340328&width=3840)
