mcAfee-secured website

Course name Databases Courses SQL and PostgreSQL: Introductions Course for Beginners: SQL and PostgreSQL: Introductions Course for Beginners

SQL and PostgreSQL: Introductions Course for Beginners Video Course

SQL and PostgreSQL: Introductions Course for Beginners Video Course is developed by Databases Courses Professionals to help you pass the SQL and PostgreSQL: Introductions Course for Beginners exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass SQL and PostgreSQL: Introductions Course for Beginners exam.

Curriculum For This Course

  • 1. Introduction to SQL 4 Videos 00:21:11
    • Section Introduction 01:14
    • Databases and SQL 03:25
    • Installing PostgreSQL 06:01
    • Setting Up the Database 10:34
  • 2. Selecting from a Table in SQL 14 Videos 01:17:33
    • Section Introduction 02:10
    • Select 05:32
    • Select Where 06:12
    • Multiple Wheres 09:36
    • Solution 1: Selecting From a Table 03:46
    • In, Not In 07:21
    • Between 05:31
    • CODE: SQL for BETWEEN 07:40
    • Like 05:46
    • Solution 2: Selecting From a Table 07:31
    • Order By 06:04
    • Limiting Number of Results 05:25
    • Distinct 05:06
    • Setting a Column Name Alias 04:32
  • 3. Selecting from Multiple Tables in SQL 12 Videos 01:30:00
    • Section Introduction 00:54
    • Joins in SQL 02:24
    • Inner Join Part 1 04:04
    • Inner Join Part 2 03:35
    • Solution 1: Selecting from Multiple Tables 03:59
    • Left Join 03:03
    • Right Join 11:44
    • Full Join 03:45
    • Solution 2: Selecting from Multiple Tables 05:59
    • Joining More Than Two Tables 13:47
    • Union 11:34
    • Solution 3: Selecting from Multiple Tables 06:30
  • 4. Aggregate Functions in SQL 9 Videos 00:39:21
    • Section Introduction 00:54
    • What are Aggregate Functions 02:24
    • Count 04:04
    • Min and Max 03:35
    • Sum 03:59
    • Average 03:03
    • Group By 11:44
    • Having 03:45
    • Solution: Aggregate Functions 05:59
  • 5. Data Definition Language 13 Videos 01:02:05
    • Section Introduction 01:00
    • What is Data Definition Language? 01:23
    • Data Types 07:54
    • Primary Keys 03:00
    • Foreign Keys 02:50
    • Creating Tables: Part 1 10:39
    • Creating Tables: Part 2 08:51
    • Solution 1: Data Definition Language 03:41
    • Modifying Tables: Adding and Removing Columns 05:29
    • Modifying Tables: Modifying Columns 10:12
    • Removing Tables 01:42
    • Deleting All Rows from Tables 01:58
    • Solution 2: Data Definition Language 03:35
  • 6. Data Manipulation Language 6 Videos 00:29:07
    • Section Introduction 00:36
    • What is Data Manipulation Language? 00:56
    • Inserting Data into Tables 09:16
    • Updating Data in Tables 07:44
    • Deleting Data from Tables 04:31
    • Solution: Data Manipulation Language 06:06