CG数据库 >> Intro To PostgreSQL Databases With PgAdmin For Beginners

.MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + .VTT | Duration: 2 hours | Size: 1.92 GBIntro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4What you'll learnUnderstand how to use PostgreSQL Database with PgAdmin 4Understand the basics of what a Database can doHow to Install PostgreSQL and PgAdmin 4You'll Learn How To Create a Database and TableHow to put data in and take data out using PgAdminHow to update and delete data from the databaseHow to explore what's in the database whenever you wantHow to create basic reports with the data from your databaseSQL Commands such as SELECT, WHERE, AND, OR, NOT, ORDER BY, and INSERT INTOSQL Commands like UPDATE, DELETE, LIMIT, INNER JOIN, and moreAll about Primary KeysAll About Foreign KeysHow To Backup and Restore DatabaseHow To Backup and Restore TablesRequirementsYou don't need any special tools, we'll download everything we need for free. You just need a Windows, Mac, or Linux computerYou don't need any prior database experience, I'll walk you through everythingDescriptionIn this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface!There's a reason why Postgres is so popular, find out why in this course!You have many databases to choose from, and even many free databases to choose from.

But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between.

Postgres is pretty easy to use! You'll be amazed at how quick and easy it is to dive in and get started!In this course, you learn to:Install pgAdmin and PostgreSQLWhat Is A DatabasepgAdmin OverviewCreate Table ColumnsAdd Data To A TablePostgreSQL Select StatementsPostgreSQL Where ClausePostgreSQL WildcardsPostgreSQL AND OR NOTPostgreSQL Order ByPostgreSQL Insert IntoPostgreSQL UpdatePostgreSQL DeletePostgreSQL LimitpgAdmin Menu WalkthruPostgreSQL Foreign KeysPostgreSQL Inner JoinPostgreSQL Join Where HackPostgreSQL Delete TablePostgreSQL Import and Export TablesPostgreSQL Backup and Restore DatabaseAnd More!This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.

And as always, we offer a 100% money back guarantee if you aren't completely happy with the course. No questions asked!My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I've been writing code and developing neat things online for over 20 years and I'd love to teach you what I know!What are you waiting for, let's learn some PostgreSQL database wizardry!-John ElderCEO Codemy. comWho is the target audience?Anyone who wants to use the PostgreSQL database with the PgAdmin 4 Interface


Intro To PostgreSQL Databases With PgAdmin For Beginners的图片1
Intro To PostgreSQL Databases With PgAdmin For Beginners的图片2

发布日期: 2018-10-21