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

سرفصل های دوره

Learn Advanced SQL Skills

1. PostgreSQL Setup

1. Introduction

2. What is PostgreSQL

3. Installing PostgreSQL on Windows

4. Installing PostgreSQL on Mac

5. Install PgAdmin on Mac

6. Connecting to PostgreSQL

7.1 dvdrental.zip

7. Restore sample database

8. Creating a new table

9. Populating a table

10. Query a table

2. PostgreSQL Triggers and Views

1. What are Triggers

2. Creating a trigger Part 1

3. Creating a trigger Part 2

4. Creating a trigger Part 3

5. Managing Triggers

6. What are views

7. Benefits of using views

8. Creating a view

9. Modifying and removing views

10. What are updatable views

11. Creating updatable views

12. What are materialized views

13. Creating materialized views

3. PostgreSQL Aggregate Function

1. What are Aggregate Functions

2. AVG Function

3. COUNT Function

4. MAX function

5. MIN Function

6. SUM Function

4. PostgreSQL Analytic Functions

1. What are Analytic Functions

2. Creating sample tables

3. Using AVG as a window function

4. Row number functions

5. Rank functions

6. Dense Rank function

7. First value function

8. Last Function

9. Lag function

10. Lead function

5. Microsoft SQL Server Setup

1. What is SQL Server

2. What is T-SQL

3. SQL Server Editions

4. Download SQL Server

5. Install SQL Server

6. Install SQL Server Management Studio

7. Connect SSMS to SQL Server

8. Restore sample database

9. Please Note.html

6. Query data in SQL Server with SET Operators

1. What are SET Operators.html

2. Query data with EXCEPT SET Operators

3. Query data with INTERSECT SET Operators

4. Query data with UNION SET Operators

7. SQL Server Stored Procedures

1. Introduction to stored procedures

2. Creating stored procedures

3. Modifying stored procedures

4. Properties page of a stored procedure

5. Viewing dependencies of a stored procedure

6. Deleting stored procedures

8. Using various SQL Server Functions

1. Using CAST Function

2. Using CONVERT Function

3. Using NTILE Function

4. Using SUBSTRING Function

5. Using CASE Expression

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training