Basic computer skills.
Ability to install software on system.
Computer that can run PostgreSQL ( I will show you how to install ).
Açıklama
Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.
I want to teach you how to use PostgreSQL. We will walk through
Basic selection statements
Joining multiple tables together
Grouping records to get aggregate data
Inserting, updating and deleting records
Creating tables and indexes
Constraining data input using field and table constraints
Hedef kitle kimdir?
Some wanting to master PostgreSQL and SQL query language
Master one of the great open source databases.
Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.
I want to teach you how to use PostgreSQL. We will walk through
Curriculum:
- Introduction
- Installing PostgreSQL and pgAdmin
- Simple Selection of All Records
- Using WHERE to Select Records
- Intermediate SELECT Statements
- Joining multiple tables together
- Group By and Unions
- Subqueries
- Modifying Data In Tables: INSERT, UPDATE and DELETE
- Modifying Databases, Tables, and Indexes
- Table Constraints
- Thanks and Good Luck