Don't like banners? Log in and we will make sure you see no banners. For free.
No cover art

Udemy - Postgresql Tutorial For Data Analysis And Administration

Other
Size
3.5 GB
Seeders
0
Leechers
0
Files
54
Category
Other
Added
at 11:19pm GMT+1
Infohash
03a14d07c50d64684c63b59358bf10c356ad88c3
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
[ DevCourseWeb.com ] Postgresql Tutorial For Data Analysis And Administration



If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com







Last updated 6/2020

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz

Language: English | Size: 3.54 GB | Duration: 6h 30m



Learn Basics of PostgreSQL for Database Administration and Data Anlaysis .



What you'll learn

Using PostgreSQL for Management and Administration of Databases

Creating Databases for Organizations or Applications

Data Analysis using PostgreSQL Queries

Create, Read, Update and Delete Records in a Database

Requirements

Basic understanding of databases

Description

Syllabus of the Course Lecture 1: Introduction and Installation of PostgreSQLLecture 2: Creating First Database and First Table using UI in PostgreSQLLecture 3: PostgreSQL creating a Database using SQL queryLecture 4: Primary Key Constraint and Setting it on already created tableLecture 5: Inserting Records in PostgreSQL using QueriesLecture 6: Updating Records in PostgreSQLLecture 7: Deleting Records in PostgreSQL AND and OR OperatorsLecture 8: Importing an External Database in PostgreSQL from SQL CodeLecture 9: Comparison Operators in PostgreSQL with Where ClauseLecture 10: Comparison and Logical Operators Together in PostgreSQL With Where ClauseLecture 11: Between Operator in PostgreSQL with WHere ClauseLecture 12: IN and NOT IN with Where Clause in PostgreSQLLecture 13: LIKE Operator for Pattern Matching in PostgreSQLSection 2: Multiple Schools Management System Database ExampleLecture 14: Creating Multiple School Management System DB in PostgreSQLLecture 15: Concept of Foreign Key and FK Constraint in PostgreSQLLecture 16: Creating students table with 2 foreign keys in database using PostgresqlLecture 17: Inserting dummy values in tables and testing foreign key constraintLecture 18: Joins in PostgreSQL - Inner, Left, Right, FullSection 3: Deleting or Dropping Databases and ColumnsLecture 19: How to Delete or Drop Database in PostgreSQLLecture 20: Dropping Regular Columns and those with Foreign Key ConstraintSection 4: Stored Procedures or FunctionsLecture 21: Variables in PostgreSQLLecture 22: Functions or Stored Procedures in PostgreSQL - Part 1Lecture 23: Functions or Stored Procedures in PostgreSQL - More ExamplesLecture 24: Views in PostgreSQLSection 5: MiscLecture 25: Aggregate Functions in PostgreSQLLecture 26: GROUP BY in PostgreSQL for Data Analysis



Overview



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...



Image error



Image error

File list
  • Udemy - Postgresql Tutorial For Data Analysis And Administration
  • ~Get Your Files Here !/1 - Introduction/1 - Introduction and Installation of PostgreSQL English.vtt 14.2 KB
  • ~Get Your Files Here !/1 - Introduction/1 - Introduction and Installation of PostgreSQL.mp4 103.4 MB
  • ~Get Your Files Here !/1 - Introduction/10 - Comparison and Logical Operators Together in PostgreSQL With Where Clause English.vtt 19.7 KB
  • ~Get Your Files Here !/1 - Introduction/10 - Comparison and Logical Operators Together in PostgreSQL With Where Clause.mp4 193.4 MB
  • ~Get Your Files Here !/1 - Introduction/11 - Between Operator in PostgreSQL with WHere Clause English.vtt 6.7 KB
  • ~Get Your Files Here !/1 - Introduction/11 - Between Operator in PostgreSQL with WHere Clause.mp4 62.1 MB
  • ~Get Your Files Here !/1 - Introduction/12 - IN and NOT IN with Where Clause in PostgreSQL English.vtt 6.9 KB
  • ~Get Your Files Here !/1 - Introduction/12 - IN and NOT IN with Where Clause in PostgreSQL.mp4 54.4 MB
  • ~Get Your Files Here !/1 - Introduction/13 - LIKE Operator for Pattern Matching in PostgreSQL English.vtt 16.7 KB
  • ~Get Your Files Here !/1 - Introduction/13 - LIKE Operator for Pattern Matching in PostgreSQL.mp4 106.3 MB
  • ~Get Your Files Here !/1 - Introduction/2 - Creating First Database and First Table using UI in PostgreSQL English.vtt 34.5 KB
  • ~Get Your Files Here !/1 - Introduction/2 - Creating First Database and First Table using UI in PostgreSQL.mp4 408.3 MB
  • ~Get Your Files Here !/1 - Introduction/3 - PostgreSQL creating a Database using SQL query English.vtt 27.9 KB
  • ~Get Your Files Here !/1 - Introduction/3 - PostgreSQL creating a Database using SQL query.mp4 217.7 MB
  • ~Get Your Files Here !/1 - Introduction/4 - Primary Key Constraint and Setting it on already created table English.vtt 8.5 KB
  • ~Get Your Files Here !/1 - Introduction/4 - Primary Key Constraint and Setting it on already created table.mp4 58.5 MB
  • ~Get Your Files Here !/1 - Introduction/5 - Inserting Records in PostgreSQL using Queries English.vtt 15.6 KB
  • ~Get Your Files Here !/1 - Introduction/5 - Inserting Records in PostgreSQL using Queries.mp4 101 MB
  • ~Get Your Files Here !/1 - Introduction/6 - Updating Records in PostgreSQL English.vtt 16.4 KB
  • ~Get Your Files Here !/1 - Introduction/6 - Updating Records in PostgreSQL.mp4 109.1 MB
  • ~Get Your Files Here !/1 - Introduction/7 - Deleting Records in PostgreSQL AND and OR Operators English.vtt 16.8 KB
  • ~Get Your Files Here !/1 - Introduction/7 - Deleting Records in PostgreSQL AND and OR Operators.mp4 128.9 MB
  • ~Get Your Files Here !/1 - Introduction/8 - Importing an External Database in PostgreSQL from SQL Code English.vtt 14.5 KB
  • ~Get Your Files Here !/1 - Introduction/8 - Importing an External Database in PostgreSQL from SQL Code.mp4 131.7 MB
  • ~Get Your Files Here !/1 - Introduction/9 - Comparison Operators in PostgreSQL with Where Clause English.vtt 27.2 KB
  • ~Get Your Files Here !/1 - Introduction/9 - Comparison Operators in PostgreSQL with Where Clause.mp4 411.5 MB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/14 - Creating Multiple School Management System DB in PostgreSQL English.vtt 9.8 KB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/14 - Creating Multiple School Management System DB in PostgreSQL.mp4 62.2 MB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/15 - Concept of Foreign Key and FK Constraint in PostgreSQL English.vtt 8.4 KB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/15 - Concept of Foreign Key and FK Constraint in PostgreSQL.mp4 49 MB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/16 - Creating students table with 2 foreign keys in database using Postgresql English.vtt 12.7 KB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/16 - Creating students table with 2 foreign keys in database using Postgresql.mp4 121.1 MB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/17 - Inserting dummy values in tables and testing foreign key constraint English.vtt 15.6 KB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/17 - Inserting dummy values in tables and testing foreign key constraint.mp4 118.7 MB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/17 - schoodb.sql 2.9 KB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/18 - Joins in PostgreSQL English.vtt 34.9 KB
  • ~Get Your Files Here !/2 - Multiple Schools Management System Database Example/18 - Joins in PostgreSQL Inner Left Right Full.mp4 291.8 MB
  • ~Get Your Files Here !/3 - Deleting or Dropping Database and Columns/19 - How to Delete or Drop Database in PostgreSQL English.vtt 1.3 KB
  • ~Get Your Files Here !/3 - Deleting or Dropping Database and Columns/19 - How to Delete or Drop Database in PostgreSQL.mp4 14.8 MB
  • ~Get Your Files Here !/3 - Deleting or Dropping Database and Columns/20 - Dropping Regular Columns and those with Foreign Key Constraint English.vtt 2.8 KB
  • ~Get Your Files Here !/3 - Deleting or Dropping Database and Columns/20 - Dropping Regular Columns and those with Foreign Key Constraint.mp4 42.6 MB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/21 - Variables in PostgreSQL English.vtt 17.8 KB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/21 - Variables in PostgreSQL.mp4 115.6 MB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/22 - Functions or Stored Procedures in PostgreSQL English.vtt 13.5 KB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/22 - Functions or Stored Procedures in PostgreSQL Part 1.mp4 194.3 MB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/23 - Functions or Stored Procedures in PostgreSQL English.vtt 14.2 KB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/23 - Functions or Stored Procedures in PostgreSQL More Examples.mp4 130.3 MB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/24 - Views in PostgreSQL English.vtt 20.3 KB
  • ~Get Your Files Here !/4 - Stored Procedures or Functions/24 - Views in PostgreSQL.mp4 186.6 MB
  • ~Get Your Files Here !/5 - Misc/25 - Aggregate Functions in PostgreSQL English.vtt 16.8 KB
  • ~Get Your Files Here !/5 - Misc/25 - Aggregate Functions in PostgreSQL.mp4 132.4 MB
  • ~Get Your Files Here !/5 - Misc/26 - GROUP BY in PostgreSQL for Data Analysis English.vtt 9.9 KB
  • ~Get Your Files Here !/5 - Misc/26 - GROUP BY in PostgreSQL for Data Analysis.mp4 74.5 MB
  • ~Get Your Files Here !/Bonus Resources.txt 386 B

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
2.6 GB10
508 MB03
555 MB00
2 GB01
2 GB01
1.7 GB01
2.8 GB01
3.7 GB01
2.8 GB00
1.9 GB00
2.9 GB01
3.9 GB014
3.2 GB01
2.9 GB01
2.8 GB01