153
64 157

15:07

TYPES OF PARAMETERS IN SP TSQL

23:37

SQL Sub Queries Nested Queries(PART-2)

14:02

working with non correlated subqueries

13:20

SQL Sub Queries Nested Queries Part 1

9:37

Ranking Functions in SQL Server DBA | PART 18 |

14:34

Complex Views in SQL Server

Complex Views in SQL Server

มุมมอง: 11

วีดีโอ

15:07

VIEWS IN SQL

มุมมอง 3114 วันที่ผ่านมา

VIEWS IN SQL

23:37

TYPES OF PARAMETERS IN SP TSQL

มุมมอง 1614 วันที่ผ่านมา

TYPES OF PARAMETERS IN SP TSQL

14:02

SQL Sub Queries Nested Queries(PART-2)

มุมมอง 914 วันที่ผ่านมา

SQL Sub Queries Nested Queries(PART-2)

13:20

working with non correlated subqueries

มุมมอง 2014 วันที่ผ่านมา

working with non correlated subqueries

9:37

SQL Sub Queries Nested Queries Part 1

มุมมอง 2514 วันที่ผ่านมา

SQL Sub Queries Nested Queries Part 1

Ranking Functions in SQL Server DBA | PART 18 |

14:34

Ranking Functions in SQL Server DBA | PART 18 |

มุมมอง 3528 วันที่ผ่านมา

This video explores the powerful ranking functions in SQL Server: RANK(), DENSE_RANK(), and ROW_NUMBER(). These functions allow you to assign a rank or order to each row within a result set, enabling you to perform advanced data analysis and reporting. Key topics covered: Understanding Ranking Functions: How ranking functions work within the context of window functions. The importance of the OV...

Snowflake Complete Trainings [Part - 24] | Snow Pipe Demo |

30:54

Snowflake Complete Trainings [Part - 24] | Snow Pipe Demo |

มุมมอง 4528 วันที่ผ่านมา

This video provides a live demo of Snowflake Snowpipe, a powerful feature that automates the loading of data from cloud storage (like AWS S3, Google Cloud Storage, and Azure Blob Storage) into your Snowflake tables. In this demo, you'll see: Setting up Snowpipe: Creating a storage integrator and configuring Snowpipe to monitor your cloud storage location. Loading Data: Demonstrating how Snowpip...

Snowflake Complete Trainings [Part - 23] | Loading Unloading PARQUET and JSON data |

1:07:43

Snowflake Complete Trainings [Part - 23] | Loading Unloading PARQUET and JSON data |

มุมมอง 6628 วันที่ผ่านมา

This video demonstrates how to efficiently load and unload data in Snowflake using popular file formats: Parquet and JSON. You'll learn best practices for data ingestion and extraction, optimizing performance and minimizing costs. Key topics covered: Loading Data: Parquet: Loading Parquet files from various sources (S3, GCS, Azure Blob Storage) using the COPY command. Optimizing Parquet loading...

Snowflake Complete Trainings [Part - 22] | SQL Server Performance Tuning |

50:43

Snowflake Complete Trainings [Part - 22] | SQL Server Performance Tuning |

มุมมอง 60หลายเดือนก่อน

This video dives deep into the critical aspects of SQL Server performance tuning. Learn how to optimize your database queries and improve overall system performance for faster data retrieval and better resource utilization. Key topics covered: Identifying Performance Bottlenecks: Monitoring server resource usage (CPU, memory, disk I/O). Analyzing query execution plans using the EXPLAIN plan. Id...

Snowflake Complete Trainings [Part - 21] | Snowflake System Tables |

1:09:56

Snowflake Complete Trainings [Part - 21] | Snowflake System Tables |

มุมมอง 39หลายเดือนก่อน

This video explores the powerful Snowflake System Tables, a valuable resource for gaining deep insights into your data warehouse. Learn how to leverage system tables to monitor performance, troubleshoot issues, and optimize your data warehouse operations. Key topics covered: Understanding System Tables: What are system tables and how they provide metadata about your Snowflake environment. Key S...

IMPLEMENTING TABLE-VALUED FUNCTION IN STORED FUNCTIONS | PART 17 |

18:11

IMPLEMENTING TABLE-VALUED FUNCTION IN STORED FUNCTIONS | PART 17 |

มุมมอง 27หลายเดือนก่อน

This video explores the powerful concept of Table-Valued Functions (TVFs) in SQL Server. Unlike scalar functions that return a single value, TVFs return a set of rows, similar to a table. Key topics covered: Understanding TVFs: What are TVFs and how they differ from scalar functions and stored procedures. Types of TVFs: Inline TVFs and Multi-Statement TVFs. Creating TVFs: Defining TVFs using th...

Implementing Scalar-Valued Functions in SQL Stored Functions | PART 16 |

19:48

Implementing Scalar-Valued Functions in SQL Stored Functions | PART 16 |

มุมมอง 19หลายเดือนก่อน

This video demonstrates how to effectively use scalar-valued functions within your SQL Server stored procedures. Learn how to enhance code reusability, improve performance, and improve code readability by incorporating these powerful functions. Key topics covered: Understanding Scalar-Valued Functions: Definition and purpose of scalar-valued functions. How they return a single scalar value. Cre...

Snowflake Complete Trainings [Part - 20] | Stream Snowflake and Task Snowflake |

57:14

Snowflake Complete Trainings [Part - 20] | Stream Snowflake and Task Snowflake |

มุมมอง 49หลายเดือนก่อน

This video explores the powerful combination of Streams and Tasks in Snowflake, enabling you to build efficient and near real-time data pipelines. Key topics covered: Snowflake Streams: Understanding how Streams capture changes in your tables. Creating and managing Streams for change data capture. Snowflake Tasks: Defining and scheduling tasks to execute SQL statements and stored procedures. Tr...

Snowflake Complete Trainings [Part - 19] |what is Snowflake Pipeline |

50:34

Snowflake Complete Trainings [Part - 19] |what is Snowflake Pipeline |

มุมมอง 29หลายเดือนก่อน

This video explores the concept of data pipelines in Snowflake, demonstrating how to automate data loading, transformation, and processing within the Snowflake platform. Key topics covered: Understanding Data Pipelines: What are data pipelines and why are they important? Key components of a Snowflake data pipeline. Snowpipe for Automated Loading: Leveraging Snowpipe for continuous data ingestio...