$75 | Created by Nelson Djalo | Last Updated 5/2019
Duration: 4 hours | Video: h264, 1280×720 | Audio: AAC, 44 KHz, 2 Ch | 2.3 GB
Genre: eLearning | Language: English + Sub | 60 Lectures
The Modern and Most Used Relational Database
What you’ll learn
What PostgreSQL is
SQL
SQL Joins and Relationships
Aggregate Data
Work with SQL Dates
Database Constraints
How Sequence data type works internally
CRUD Operations
SQL Error Handling
Create and Connect To Database
The Right Way To Create Tables
Export Query Results to CSV File
SQL Arithmetic Operators
Data Types
Requirements
Be able to use computer
Description
Overview
PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems.
Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.
The Goal of this course is to help anyone to become familiar with Relational Databases and learn most common used SQL statements, allowing you execute queries agains any relational database.
Course Road Map
Introduction to PostgreSQL
Setup your environment and get ready to start coding for both MacOS and Windows
Create, Read, Update & Delete (CRUD) commands
Learn about different ways of filtering data using where clause
Work with Date and Timestamps
Lean how to to Join and Left Join to combine data from one more tables
Postgres extensions and how sequences are managed
Learn how to create tables with the right constraints
Learn how to export data to CSV files
Congratulations. You will be ready to right SQL and have a great understanding of Postgres database
Let’s get started now
Who this course is for:
Passionate student who want to learn about databases
Password/解压密码-0daydown
Download rapidgator
https://rapidgator.net/file/5cb3ae21eb383b1985d47517b1512fd7/UpandRunningWithPostgreSQL11.part1.rar.html
https://rapidgator.net/file/6075e2677f9973c35dec308b2e072913/UpandRunningWithPostgreSQL11.part2.rar.html
https://rapidgator.net/file/16928568bd87c3bfbd205872f32c97a4/UpandRunningWithPostgreSQL11.part3.rar.html
https://rapidgator.net/file/51f31d3f941faa152a8b4466f7dd6b2a/UpandRunningWithPostgreSQL11.part4.rar.html
Download nitroflare
http://nitroflare.com/view/32264BDEDF3D6B4/UpandRunningWithPostgreSQL11.part1.rar
http://nitroflare.com/view/2C2A92C2930466B/UpandRunningWithPostgreSQL11.part2.rar
http://nitroflare.com/view/196A08A7126A06F/UpandRunningWithPostgreSQL11.part3.rar
http://nitroflare.com/view/0AC4F20F808BB82/UpandRunningWithPostgreSQL11.part4.rar
Download 百度云
你是VIP 1个月(1 month)赞助会员，