$75 | Created by Nelson Djalo | Last Updated 5/2019Duration: 4 hours | Video: h264, 1280×720 | Audio: AAC, 44 KHz, 2 Ch | 2.3 GBGenre: eLearning | Language: English + Sub | 60 LecturesThe Modern and Most Used Relational DatabaseWhat you’ll learnWhat PostgreSQL isSQLSQL Joins and RelationshipsAggregate DataWork with SQL DatesDatabase ConstraintsHow Sequence data type works internallyCRUD OperationsSQL Error HandlingCreate and Connect To DatabaseThe Right Way To Create TablesExport Query Results to CSV FileSQL Arithmetic OperatorsData TypesRequirementsBe able to use computerDescriptionOverviewPostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems.

Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

The Goal of this course is to help anyone to become familiar with Relational Databases and learn most common used SQL statements, allowing you execute queries agains any relational database.

Course Road MapIntroduction to PostgreSQLSetup your environment and get ready to start coding for both MacOS and WindowsCreate, Read, Update & Delete (CRUD) commandsLearn about different ways of filtering data using where clauseWork with Date and TimestampsLean how to to Join and Left Join to combine data from one more tablesPostgres extensions and how sequences are managedLearn how to create tables with the right constraintsLearn how to export data to CSV filesCongratulations. You will be ready to right SQL and have a great understanding of Postgres databaseLet’s get started nowWho this course is for:Passionate student who want to learn about databases