17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - Postgresql Tutorial For Data Analysis And Administration
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~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
