Comprehensive SQL Bootcamp : Beginner to Advanced

Comprehensive SQL Bootcamp : Beginner to Advanced

Learn SQL from scratch and become an expert

What you’ll learn

  • Understand PostgreSQL Database Objects
  • Perform CRUD Operations
  • Creating a database using PostgreSQL GUI
  • Creating tables with PostgreSQL GUI and SQL Commands
  • Use SQL to insert records in a database
  • Use SQL to execute queries against a database
  • Use SQL to retrieve data from a database
  • Use SQL to update records in a database
  • Use SQL to delete records from a database
  • Use SQL to create stored procedures in a database
  • Use SQL to create views in a database
  • Use SQL to filter and sort data returned from a database
  • Query and eliminate duplicate records
  • Joining and querying data from multiple tables
  • Using various aggregate functions and grouping data
  • Using various Operators to query data
  • Using various Analytic Functions

Requirements

  • No prior experience required

Who this course is for:

  • Beginners to SQL
  • Beginners to PostgreSQL

Tags:

Tutorial Bar
Logo