Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

PostgreSQL: From Beginner to Intermediate

person icon Blink Data

4.6

PostgreSQL: From Beginner to Intermediate

Learn Databases and SQL From Zero to Intermediate, Become able to Create a whole database from scratch.

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Blink Data

English [CC]

category icon Development,PostgreSQL

Lectures -41

Duration -2 hours

4.6

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course is mainly focused on Coding, You will use SQL coding in the Terminal (Command Prompt) step-by-step, No software will be in use where you click on buttons, only coding!

It is almost impossible not to interact with a database daily, Every Mobile Application or Website you use uses a database to commit your request, You just don't know it, Which makes you wonder, What is a database? Why is it important?  how can I communicate with it?  and most importantly, What's SQL?

SQL is a Standard Structured Query Language that you can use to code queries to interact with a database. PostgreSQL is a database management system that uses SQL to interact with the database.

SQL is by far the most coding skill in demand in the tech industry and it is one of the fastest ways to improve your career prospects, Whether you're a Mobile developer, A Web Developer, A Data Scientist, A Data Analyst, or Even New to the tech industry, You have to learn Databases and SQL.

and SQL is not only related to PostgreSQL, You can use SQL in many database management systems such as Microsoft SQL Server, MySQL, Oracle, and More

Hence, This course is designed to teach you Databases and SQL intellectually by answering the basic important questions starting from What's a database? and technically through purely coding SQL from Zero to Intermediate.

Here's what you will learn throughout the course:

  • Learn what's a database and what are the database management systems available?

  • What are a Relational Database and A Non-Relational database?

  • What's SQL?

  • What are constraints and data types in SQL?

  • How to code SQL to create a database, Tables, and Users?

  • How to insert data into a database/table through coding SQL?

  • How to code SQL to update the structure of a database and tables?

  • How to remove a database, tables, and Users?

  • How to grant and revoke privileges from a User?

  • How to manipulate data in a database using SQL?

  • How to sort and group data in a database using SQL?

  • Join Clauses

Finally, This course is concise and to the point, It aims to teach you the basics of Databases and SQL from Beginner to Intermediate bearing in mind how valuable is your time.

Goals

  • Learn what's a database and what are the database management systems available?

  • What are a Relational Database and A Non-Relational database?

  • What's SQL?

  • What are constraints and data types in SQL?

  • How to code SQL to create a database, Tables, and Users?

  • How to insert data into a database/table through coding SQL?

  • How to code SQL to update the structure of a database and tables?

  • How to remove a database, tables, and Users?

  • How to grant and revoke privileges from a User?

  • How to manipulate data in a database using SQL?

  • How to sort and group data in a database using SQL?

  • Join Clauses

  • Practice SQL along the way through Quizzes, Practice Tests, and Assignments

Prerequisites

  • No Experience Needed
PostgreSQL: From Beginner to Intermediate

Curriculum

Check out the detailed breakdown of what’s inside the course

Getting Started
5 Lectures
  • play icon PostgreSQL: From Beginner to Intermediate 00:23 00:23
  • play icon Course Introduction 03:13 03:13
  • play icon Introduction to Database 03:11 03:11
  • play icon Relational VS Non-Relational Databases 03:14 03:14
  • play icon Introduction to SQL 04:47 04:47
Necessary Softwares (Download/Installation)
5 Lectures
Tutorialspoint
SQL: Data Defination Language
10 Lectures
Tutorialspoint
SQL: Data Control Language
3 Lectures
Tutorialspoint
SQL: Data Manipulation Language
18 Lectures
Tutorialspoint

Instructor Details

Blink Data

Blink Data


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515