The Beginners Guide to SQL and PostgreSQL

The Beginners Guide to SQL and PostgreSQL

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 5.5 Hours | 673 MB

Master SQL and PostgreSQL by Creating Databases and Writing SQL Queries using PostgreSQL.

Learn how to master SQL and PostgreSQL with this best selling course.

SQL is one of the most in-demand tech skills across many industries so learning SQL is one of the best ways to boost your career! After taking this course you will be comfortable putting SQL and PostgreSQL on your resume/CV.

PostgreSQL is one of the most popular and widely used database systems in the world. Companies who use PostgreSQL include Apple, Cisco, Fujitsu, Skype and IMDb.

You will learn how to:

  • Retrieve data from database tables using SQL SELECT queries.
  • Use WHERE clauses in SQL to filter your data.
  • ORDER your SQL queries.
  • LIMIT the number of rows returned from your SQL queries.
  • Use SQL JOINs to retrieve data from multiple tables.
  • Use SQL aggregate functions and group data.
  • Use SQL to CREATE, ALTER and DROP databases and tables.
  • Use SQL to INSERT, UPDATE and DELETE data from tables.
Table of Contents

Overview
1 Course Overview

Introduction to SQL
2 Section Introduction
3 Databases and SQL
4 Installing PostgreSQL
5 Setting Up the Database

Selecting from a Table in SQL
6 Section Introduction
7 Select
8 CODE SQL for Select
9 Select Where
10 CODE SQL for Where
11 Multiple Wheres
12 CODE SQL for Multiple Wheres
13 Exercise 1 Selecting From a Table
14 Solution 1 Selecting From a Table
15 CODE Solution 1 Selecting From a Table
16 In Not In
17 CODE SQL for IN NOT IN
18 Between
19 CODE SQL for BETWEEN
20 Like
21 CODE SQL for LIKE
22 Exercise 2 Selecting From a Table
23 Solution 2 Selecting From a Table
24 CODE Solution 2 Selecting From a Table
25 Order By
26 CODE SQL for Order By
27 Limiting Number of Results
28 CODE SQL for Limit
29 Distinct
30 CODE SQL for Distinct
31 Setting a Column Name Alias
32 CODE SQL for Setting a Column Name Alias
33 Exercise 3 Selecting From a Table
34 Solution 3 Selecting From a Table
35 CODE Solution 3 Selecting From a Table

Selecting from Multiple Tables in SQL
36 Section Introduction
37 Joins in SQL
38 Inner Join Part 1
39 CODE SQL for Inner Joins Part 1
40 Inner Join Part 2
41 CODE SQL for Inner Joins Part 2
42 Exercise 1 Selecting From Multiple Tables
43 Solution 1 Selecting from Multiple Tables
44 CODE Solution 1 Selecting From Multiple Tables
45 Left Join
46 CODE SQL for Left Joins
47 Right Join
48 CODE SQL for Right Joins
49 Full Join
50 CODE SQL for Full Joins
51 Exercise 2 Selecting from Multiple Tables
52 Solution 2 Selecting from Multiple Tables
53 CODE Solution 2 Selecting from Multiple Tables
54 Joining More Than Two Tables
55 CODE SQL for Joining More Than Two Tables
56 Union
57 CODE SQL for Union
58 Exercise 3 Selecting from Multiple Tables
59 Solution 3 Selecting from Multiple Tables
60 CODE Solution 3 Selecting from Multiple Tables

Aggregate Functions in SQL
61 Section Introduction
62 What are Aggregate Functions
63 Count
64 CODE SQL for Count
65 Min and Max
66 CODE SQL for Min and Max
67 Sum
68 CODE SQL for Sum
69 Average
70 CODE SQL for Average
71 Group By
72 CODE SQL for Group By
73 Having
74 CODE SQL for Having
75 Exercise Aggregate Functions
76 Solution Aggregate Functions
77 CODE Solution Aggregate Functions

SQL – Data Definition Language
78 Section Introduction
79 What is Data Definition Language
80 Data Types
81 Primary Keys
82 Foreign Keys
83 Creating Tables Part 1
84 CODE SQL for Creating Tables Part 1
85 Creating Tables Part 2
86 CODE SQL for Creating Tables Part 2
87 Exercise 1 Data Definition Language
88 Solution 1 Data Definition Language
89 CODE Solution 1 Data Definition Language
90 Modifying Tables Adding and Removing Columns
91 CODE SQL for Adding and Removing Columns
92 Modifying Tables Modifying Columns
93 CODE SQL for Modifying Columns
94 Removing Tables
95 CODE SQL for Removing Tables
96 Deleting All Rows from Tables
97 CODE SQL for Deleting All Rows from Tables
98 Exercise 2 Data Definition Language
99 Solution 2 Data Definition Language
100 CODE Solution 2 Data Definition Language

SQL – Data Manipulation Language
101 Section Introduction
102 What is Data Manipulation Language
103 Inserting Data into Tables
104 CODE SQL for Inserting Data into Tables
105 Updating Data in Tables
106 CODE SQL for Updating Data in Tables
107 Deleting Data from Tables
108 CODE SQL for Deleting Data from Tables
109 Exercise Data Manipulation Language
110 Solution Data Manipulation Language
111 CODE Solution Data Manipulation Language

Bonus Material
112 All Courses