SQL for beginners with :( PostgreSQL, MySQL, SQL Server )

Master the basics of querying databases and manipulating data

4.50 (260 reviews)
Udemy
platform
English
language
Databases
category
SQL for beginners with :( PostgreSQL, MySQL, SQL Server )
24,510
students
8 hours
content
Oct 2021
last update
$19.99
regular price

What you will learn

Install and setup PostgreSQL Database Server

Install and setup MySQL Database Server

Install and setup Microsoft SQL Server

Query databases

Perform Database Table Joins

Filter Data

Sort Data

Aggregate Functions

Group Data

Description

SQL is a standard language for accessing and manipulating databases.

SQL is one of the most  in-demand tech skill used across many industries.

What is SQL?

SQL stands for Structured Query Language


What Can SQL do?

  • SQL lets you access and manipulate databases

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can create views in a database

  • SQL can filter data returned from a database

  • SQL can sort data returned by a database.

  • SQL can be used to truncate and drop tables.

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.


MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database.


SQL SERVER is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database.

SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).

T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capabilities of declaring variable, exception handling, stored procedure, etc.

SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments.





Content

Introduction

Introduction
What is SQL
What is a query
What is PostgreSQL
What is MySQL
What is SQL Server
Database Concepts

PostgreSQL Database Server Setup

Minimum Installation Requirements
Installing PostgreSQL on Windows
Installing Python on Macs
Installing PostgreSQL on Linux
Installing PgAdmin Tool on MacOS
Installing PgAdmin Tool on Linux
Connect to PostgreSQL Database Server
Load Sample Database
Querying all single column
Querying a single column

PostgreSQL: Filtering Rows

Filtering with WHERE
Filtering with Comparison Operators
Filtering with BETWEEN Operator
Filtering with NOT BETWEEN Operator
Filtering with OR Operator
Filtering with AND Operator
Flittering with combined AND | OR Operators
Filtering with LIKE Operators
Filtering with IN Operator
Filtering with NOT Operator
Filtering with LIMIT Operator
Filtering with UNION Operator
Filtering with UNION ALL Operator
Filtering with INTERSECT Operator
Filtering with EXCEPT Operator

PostgreSQL Aggregate Functions

What are aggregate functions
AVG Aggregate function
COUNT Aggregate function
MAX Aggregate function
MIN Aggregate function

PostgreSQL: Sorting and Grouping Data

Sorting Data with ORDER BY
Grouping Data with GROUP BY
Summarize groups with HAVING

MySQL Database Server Setup

MySQL Download and Installation for Windows
MySQL Download and Installation for Macs
MySQL Workbench
Installing MySQL Workbench for mac
Database Schema

MySQL: Query Columns | Remove Duplicates

Querying columns
Querying columns but excluding duplicates

MySQL: Querying data from multiple tables

INNER JOIN
LEFT Join
RIGHT JOIN
SELF JOIN

MySQL Aggregate Functions

Introduction to Aggregate Functions
AVG Aggregate function
COUNT Aggregate function
SUM Aggregate function
MIN Aggregate function
MAX Aggregate function

MySQL: Filtering |Sorting | Grouping Data

Filtering data with WHERE clause
Sorting data
Grouping Data using GROUP BY Clause
Summarize groups with HAVING

MySQL: Querying data with Subqueries

What is a subquery
Nested Subqueries
Derived Tables

Microsoft SQL Server Setup

SQL Server Hardware and Software Requirements
SQL Server Editions
Download SQL Server
Install SQL Server
Install SSMS
Connecting to SQL Server
Load sample database
What is T-SQL

Ms SQL Server: Sorting Data

The ORDER BY Clause
Sorting data by ascending
Sorting data by descending
Sorting by multiple columns

Reviews

Lakshmi
August 11, 2021
The content is good. The teacher takes a long time explaining some things. It's a good course to gain a basic level of understanding of PostgreSQL. I found the installation instructions the least useful, as things have changed for the newer version and I had to make external research to be able to install everything adequately, but this is to be expected.
Mangesh
June 30, 2021
Actually I don't give feedbacks, but this Course is Awesome. All concepts are crystal clear now. Everything is well organized and excellently taught. Thank you
Jesus
June 22, 2021
Buen curso para aprender los básico sobre SQL, me gusto que se toma el tiempo para enseñar a instalar los programas y los servers
Dev
June 17, 2021
Content is good, explanation is also fine but the quality of addressing the content is average, sir you can increase your speed, its very slow.

Coupons

DateDiscountStatus
6/12/2021100% OFF
expired

Charts

Price

SQL for beginners with :( PostgreSQL, MySQL, SQL Server ) - Price chart

Rating

SQL for beginners with :( PostgreSQL, MySQL, SQL Server ) - Ratings chart

Enrollment distribution

SQL for beginners with :( PostgreSQL, MySQL, SQL Server ) - Distribution chart

Related Topics

4069432
udemy ID
5/22/2021
course created date
6/8/2021
course indexed date
Bot
course submited by