WEBVTT

0
00:01.110 --> 00:05.220
Welcome to The Complete Python and PostgreSQL course 2.0! 

1
00:05.220 --> 00:09.120
My name is Jose Salvatierra and I'll be your instructor in this course.

2
00:09.210 --> 00:14.190
I'm a software developer turned online teacher, with over 120,000

3
00:14.190 --> 00:15.170
students on Udemy.

4
00:15.210 --> 00:20.070
I'm also the founder of Teclado,  where I help my students level up their coding.

5
00:20.100 --> 00:26.670
Today I'm here to help you learn, use,  and eventually master PostgreSQL and how to use it from your

6
00:26.670 --> 00:33.120
Python apps from scratch. You'll need no PostgreSQL or database experience at all.

7
00:33.120 --> 00:37.940
Some Python or programming experience will be helpful, but we've got a complete Python refresher

8
00:37.980 --> 00:39.450
included in this course.

9
00:39.600 --> 00:44.240
Other than that you'll learn everything you need, from the ground up.

10
00:44.280 --> 00:50.280
PostgreSQL (also called just Postgres) is one of the top relational database systems in the world, used

11
00:50.280 --> 00:55.290
by giants such as Instagram, Skype, The Guardian and even Apple.

12
00:55.290 --> 01:00.510
But also, after taking this course on Postgres you'll find it really easy to learn other relational

13
01:00.510 --> 01:07.170
database systems, such as MySQL because the concepts are really similar. Postgres is so popular

14
01:07.350 --> 01:13.380
because it has excellent performance. It's also got advanced features such as JSON  and Key-value pair

15
01:13.380 --> 01:19.740
storage; and it's free and open-source with an excellent team of contributors making it better every

16
01:19.740 --> 01:23.180
single day. In each section of this course, you learn

17
01:23.190 --> 01:29.530
how to build and extend Python projects to add more and more database functionality to them. 

18
01:29.670 --> 01:34.610
You'll learn about the fundamentals of SQL, such as creating tables and retrieving data;

19
01:34.770 --> 01:37.710
what relational data really is and how to work with it using JOINs.

20
01:37.710 --> 01:44.970
We'll explore psycopg2 to interact with PostgreSQL using Python; advanced querying

21
01:44.970 --> 01:48.600
with nested queries, views, functions, and stored procedures;

22
01:48.600 --> 01:53.470
how to work with dates and times correctly so you don't run into some very common problems;

23
01:53.610 --> 02:00.690
how to plot graphs and charts with your data; and much much more. So by the end of this course,

24
02:00.700 --> 02:06.250
not only will you know and understand everything you need to know about databases, 

25
02:06.250 --> 02:10.070
you'll also have tons of practical experience using Postgres in your python apps.

26
02:10.300 --> 02:16.030
Whether you're a python developer who wants to start harnessing the power of databases, or maybe a sysadmin

27
02:16.030 --> 02:20.200
or data analyst who wants to take the best of both Python and Postgres,

28
02:20.200 --> 02:22.150
this course is for you!

29
02:22.150 --> 02:23.040
So there you have it.

30
02:23.080 --> 02:28.750
If you want to learn more about Python and databases and Postgres, join the course!

31
02:28.750 --> 02:29.220
I'll see you on the inside!