PostgreSQL Tutorial For Beginners | Learn PostgreSQL | Introduction to PostgreSQL | Edureka

1:46 What is DBMS
4:16 What is SQL?
5:22 What is PostgreSQL?
6:16 Features of PostgreSQL
8:56 Install PostgreSQL
15:54 SQL Command Categories
17:26 DDL Commands
22:46 ER Diagram
33:22 Entity & Attributes
42:27 Keys in Database
45:46 Constraints in Database
52:36 Normalization
58:21 DML Commands
1:17:30 Operators
1:18:21 Nested Queries
1:19:26 Set Operations
1:20:36 Special Operators
1:22:56 Aggregate Functions
1:23:41 Limit, Offset & Fetch
1:46:48 Joins
1:50:50 Views
1:54:28 Procedures
1:58:35 Triggers
2:05:12 DCL Commands
2:07:45 TCL Commands
2:10:46 Export/ Import Data
2:11:51 UUID Datatype

#edureka #edurekasql #postgresql #postgresqltutorial #postgresql

--------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
How does it work?

1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!

- - - - - - - - - - - - - -

About the Course

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions, etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

- - - - - - - - - - - - - -

Who should go for this course?

This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
- - - - - - - - - - - - - -

Project

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM:-

• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

- - - - - - - - - - - - - -

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.

[srinivasankanniah]

Good training delivery, thank you Edureka for sharing

[PoojaSharma]

Thank you for making it easy for the beginners.

[oluwaseunfashedemi]

Good training delivery and very easy to follow. Thanks Edureka for sharing this lesson.

[yashvimehta]

Thanks a lot for this video, it was really helpful for me

[rabiulalikhan]

Thank you. Good content and training delivery style.

[bhekamazwanezwane]

This is amazing, POSTGRES made easy. Thank You.

[jimmytrivedi]

Thanks Sahiti, your explanation is really good!

[PadamAgrawal]

thank you for such as informative tutorial .

[VictorOdera]

This is really neat and informative. Thank you.

[frankconte]

Thank you for the great introduction to PostgreSQL.

[pratulshah]

Thanks Sahiti for this video
Very useful information. thanks

[jain-daksh]

Hi thank you! I think the session has clarity and it's easy to follow along. Would it be okay to ask for the scripts used on here?

[humayunhimu]

Edureka deliver something very standard!

[vikasgaddam]

best video it covers all the topics required to master dbms subject

[khanzarinashinwari]

This is amazing, excellent ways to teaching.really impressive

[rajagowtham]

Can anyone please tell how to specify specicific size to the integer data type in postgresql

[khalinder]

Excellent and thanks for your providing details session. Appreciated if you could provide the scripts used in these sessions.