Advanced SQL – PostgreSQL /SQL Server/Functions/Triggers/etc

Advanced SQL – PostgreSQL /SQL Server/Functions/Triggers/etc, available at $54.99, has an average rating of 3.71, with 63 lectures, based on 7 reviews, and has 42 subscribers.

You will learn about Query data using Aggregate Functions Query data using Analytic Functions Create Stored procedures Create and manage Triggers Create and manage views Query data with SET Operators This course is ideal for individuals who are Beginners to more advanced SQL or Data Analyst or Data Scientist It is particularly useful for Beginners to more advanced SQL or Data Analyst or Data Scientist.

Enroll now: Advanced SQL – PostgreSQL /SQL Server/Functions/Triggers/etc

Summary

Title: Advanced SQL – PostgreSQL /SQL Server/Functions/Triggers/etc

Price: $54.99

Average Rating: 3.71

Number of Lectures: 63

Number of Published Lectures: 63

Number of Curriculum Items: 63

Number of Published Curriculum Objects: 63

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Query data using Aggregate Functions
Query data using Analytic Functions
Create Stored procedures
Create and manage Triggers
Create and manage views
Query data with SET Operators

Who Should Attend

Beginners to more advanced SQL
Data Analyst
Data Scientist

Target Audiences

Beginners to more advanced SQL
Data Analyst
Data Scientist

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

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 set permissions on tables, procedures, and views

SQL is a Standard – BUT…. Although SQL is an ANSI/ISO standard, there are different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!

Transact-SQL(T-SQL) is Microsoft’s and Sybase’s proprietary extension to the SQL used to interact with relational databases.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network

PostgreSQL is an object-relational database management system .

In this course you will learn how to build fairly complex SQL queries and use advanced SQL features.

Course Curriculum

Chapter 1: PostgreSQL Setup

Lecture 1: Introduction

Lecture 2: What is PostgreSQL

Lecture 3: Installing PostgreSQL on Windows

Lecture 4: Installing PostgreSQL on Mac

Lecture 5: Install PgAdmin on Mac

Lecture 6: Connecting to PostgreSQL

Lecture 7: Restore sample database

Lecture 8: Creating a new table

Lecture 9: Populating a table

Lecture 10: Query a table

Chapter 2: PostgreSQL Triggers and Views

Lecture 1: What are Triggers

Lecture 2: Creating a trigger : Part 1

Lecture 3: Creating a trigger : Part 2

Lecture 4: Creating a trigger : Part 3

Lecture 5: Managing Triggers

Lecture 6: What are views

Lecture 7: Benefits of using views

Lecture 8: Creating a view

Lecture 9: Modifying and removing views

Lecture 10: What are updatable views

Lecture 11: Creating updatable views

Lecture 12: What are materialized views

Lecture 13: Creating materialized views

Chapter 3: PostgreSQL Aggregate Function

Lecture 1: What are Aggregate Functions

Lecture 2: AVG Function

Lecture 3: COUNT Function

Lecture 4: MAX function

Lecture 5: MIN Function

Lecture 6: SUM Function

Chapter 4: PostgreSQL Analytic Functions

Lecture 1: What are Analytic Functions

Lecture 2: Creating sample tables

Lecture 3: Using AVG as a window function

Lecture 4: Row number functions

Lecture 5: Rank functions

Lecture 6: Dense Rank function

Lecture 7: First value function

Lecture 8: Last Function

Lecture 9: Lag function

Lecture 10: Lead function

Chapter 5: Microsoft SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: What is T-SQL

Lecture 3: SQL Server Editions

Lecture 4: Download SQL Server

Lecture 5: Install SQL Server

Lecture 6: Install SQL Server Management Studio

Lecture 7: Connect SSMS to SQL Server

Lecture 8: Restore sample database

Lecture 9: Please Note

Chapter 6: Query data in SQL Server with SET Operators

Lecture 1: What are SET Operators

Lecture 2: Query data with EXCEPT SET Operators

Lecture 3: Query data with INTERSECT SET Operators

Lecture 4: Query data with UNION SET Operators

Chapter 7: SQL Server Stored Procedures

Lecture 1: Introduction to stored procedures

Lecture 2: Creating stored procedures

Lecture 3: Modifying stored procedures

Lecture 4: Properties page of a stored procedure

Lecture 5: Viewing dependencies of a stored procedure

Lecture 6: Deleting stored procedures

Chapter 8: Using various SQL Server Functions

Lecture 1: Using CAST Function

Lecture 2: Using CONVERT Function

Lecture 3: Using NTILE Function

Lecture 4: Using SUBSTRING Function

Lecture 5: Using CASE Expression

Instructors

247 Learning
An investment in knowledge pays the best interest

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 2 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu