SQL and PostgreSQL: Introductions Course for Beginners

SQL and PostgreSQL: Introductions Course for Beginners

BEST SELLER 58 Lectures 5h 5m 34s

Prepare for your examination with our training course. The course contains a complete batch of videos that will provide you with profound and thorough knowledge related to certification exam. Pass the test with flying colors.

$13.99 $24.99

Curriculum For This Course

4 lectures 21m 14s
  • 1. Section Introduction
    1m 14s
  • 2. Databases and SQL
    3m 25s
  • 3. Installing PostgreSQL
    6m 1s
  • 4. Setting Up the Database
    10m 34s

14 lectures 1h 22m 12s
  • 1. Section Introduction
    2m 10s
  • 2. Select
    5m 32s
  • 3. Select Where
    6m 12s
  • 4. Multiple Wheres
    9m 36s
  • 5. Solution 1: Selecting From a Table
    3m 46s
  • 6. In, Not In
    7m 21s
  • 7. Between
    5m 31s
  • 8. CODE: SQL for BETWEEN
    7m 40s
  • 9. Like
    5m 46s
  • 10. Solution 2: Selecting From a Table
    7m 31s
  • 11. Order By
    6m 4s
  • 12. Limiting Number of Results
    5m 25s
  • 13. Distinct
    5m 6s
  • 14. Setting a Column Name Alias
    4m 32s

12 lectures 1h 11m 18s
  • 1. Section Introduction
    54s
  • 2. Joins in SQL
    2m 24s
  • 3. Inner Join Part 1
    4m 4s
  • 4. Inner Join Part 2
    3m 35s
  • 5. Solution 1: Selecting from Multiple Tables
    3m 59s
  • 6. Left Join
    3m 3s
  • 7. Right Join
    11m 44s
  • 8. Full Join
    3m 45s
  • 9. Solution 2: Selecting from Multiple Tables
    5m 59s
  • 10. Joining More Than Two Tables
    13m 47s
  • 11. Union
    11m 34s
  • 12. Solution 3: Selecting from Multiple Tables
    6m 30s

9 lectures 39m 27s
  • 1. Section Introduction
    54s
  • 2. What are Aggregate Functions
    2m 24s
  • 3. Count
    4m 4s
  • 4. Min and Max
    3m 35s
  • 5. Sum
    3m 59s
  • 6. Average
    3m 3s
  • 7. Group By
    11m 44s
  • 8. Having
    3m 45s
  • 9. Solution: Aggregate Functions
    5m 59s

13 lectures 1h 2m 14s
  • 1. Section Introduction
    1m
  • 2. What is Data Definition Language?
    1m 23s
  • 3. Data Types
    7m 54s
  • 4. Primary Keys
    3m
  • 5. Foreign Keys
    2m 50s
  • 6. Creating Tables: Part 1
    10m 39s
  • 7. Creating Tables: Part 2
    8m 51s
  • 8. Solution 1: Data Definition Language
    3m 41s
  • 9. Modifying Tables: Adding and Removing Columns
    5m 29s
  • 10. Modifying Tables: Modifying Columns
    10m 12s
  • 11. Removing Tables
    1m 42s
  • 12. Deleting All Rows from Tables
    1m 58s
  • 13. Solution 2: Data Definition Language
    3m 35s

6 lectures 29m 9s
  • 1. Section Introduction
    36s
  • 2. What is Data Manipulation Language?
    56s
  • 3. Inserting Data into Tables
    9m 16s
  • 4. Updating Data in Tables
    7m 44s
  • 5. Deleting Data from Tables
    4m 31s
  • 6. Solution: Data Manipulation Language
    6m 6s
Hot Exams

Free Test Engine Player

How to open .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

Our test engine player will always be free.

DumpsArena Test Engine

Windows
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support