Главная
Study mode:
on
You
History
Saved
In progress 0 courses
compleat 0 courses
#Art & Design #Adobe #ChatGPT #GitHub

#T-SQL

Showing: 27 courses
Microsoft

Azure SQL Database: Grouping Sets and Windowing Functions for Developers

0 rewiews
Explore Grouping Sets and Windowing Functions in Azure SQL Database to enhance code efficiency and solution performance. Learn practical tips for developers to leverage these powerful features.
Add to list
5 Lesons
27 minutes
On-Demand
Free-Video
PASS Data Community Summit

Workarounds for T-SQL Restrictions and Limitations

0 rewiews
Aprenda técnicas criativas para superar limitações do T-SQL, incluindo cálculos de mínimo/máximo entre colunas, números de linha únicos e reutilização de aliases, com o especialista Itzik Ben-Gan.
Add to list
1 Lesons
1 hour 3 minutes
On-Demand
Free-Video
PASS Data Community Summit

Building Your T-SQL Tool Kit - Window Function Fundamentals

0 rewiews
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Add to list
1 Lesons
1 hour 14 minutes
On-Demand
Free-Video
PASS Data Community Summit

10 Dicas para Escrever Codigos T SQL Melhores

0 rewiews
Aprenda 10 dicas essenciais para aprimorar seus códigos T-SQL, melhorando a eficiência e qualidade das suas consultas e procedimentos armazenados.
Add to list
1 Lesons
1 hour 3 minutes
On-Demand
Free-Video
PASS Data Community Summit

Offline Database Development and Unit Testing with SSDT

0 rewiews
Explore offline database development, unit testing, and customization in SQL Server Data Tools. Learn to create test projects, write T-SQL unit tests, and extend functionality with C#.
Add to list
9 Lesons
48 minutes
On-Demand
Free-Video
PASS Data Community Summit

New Features and Capabilities

0 rewiews
Explore new features and capabilities of Appliance Update 2, covering T-SQL to HDInsight, enhancing your SQL Server knowledge and skills.
Add to list
1 Lesons
42 minutes
On-Demand
Free-Video
PASS Data Community Summit

Using Data to Make Decisions

0 rewiews
Learn practical techniques for leveraging data to simplify complex decisions, from buying cars to choosing healthcare, using precision questions, machine learning, and common tools like Excel and T-SQL.
Add to list
1 Lesons
58 minutes
On-Demand
Free-Video
PASS Data Community Summit

Bug or Feature?

0 rewiews
Explore unique T-SQL behaviors, distinguishing between bugs and features while uncovering key principles of this relational language.
Add to list
1 Lesons
1 hour 28 minutes
On-Demand
Free-Video
PASS Data Community Summit

Common Data Science Mistakes

0 rewiews
Explore common pitfalls in data science, from data preparation to analysis. Learn to avoid mistakes in statistics, outlier handling, and visualization for more accurate insights and predictions.
Add to list
22 Lesons
55 minutes
On-Demand
Free-Video
PASS Data Community Summit

Improving Database Code Quality with Unit Tests

0 rewiews
Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.
Add to list
1 Lesons
1 hour 12 minutes
On-Demand
Free-Video
PASS Data Community Summit

Azure DevOps Pipelines for BI

0 rewiews
Learn to implement DevOps practices for SQL databases, Analysis cubes, and SSIS packages using Azure DevOps Pipelines. Discover techniques for code tracking, compile-time checking, and efficient deployments.
Add to list
1 Lesons
1 hour 20 minutes
On-Demand
Free-Video
PASS Data Community Summit

Increase Deployment Flexibility with Feature Flags

0 rewiews
Learn to use feature flags for flexible database deployments, enabling dark deployments and reducing production impact. Includes T-SQL code examples and demonstrations of implementation in deployment processes.
Add to list
20 Lesons
1 hour
On-Demand
Free-Video
PASS Data Community Summit

Getting Started with Azure Data Studio

0 rewiews
Learn to use Azure Data Studio: customize, create insights, use extensions, work with notebooks, and develop your own extensions. Master this cross-platform tool for data-related tasks and T-SQL editing.
Add to list
1 Lesons
47 minutes
On-Demand
Free-Video
PASS Data Community Summit

A Self-Tuning Fill Factor Technique for SQL Server

0 rewiews
Discover a technique for optimizing SQL Server index fill factors, reducing fragmentation and bad page splits, leading to significant performance improvements in OLTP databases.
Add to list
1 Lesons
50 minutes
On-Demand
Free-Video
PASS Data Community Summit

Unlocking The Data Lake With Azure Synapse SQL Serverless

0 rewiews
Explore and transform massive data in Azure data lakes using SQL Serverless for Synapse. Learn to leverage T-SQL for analytics, BI, and ML at petabyte scale.
Add to list
1 Lesons
58 minutes
On-Demand
Free-Video
PASS Data Community Summit

Developer Best Practices in SQL Server

0 rewiews
Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.
Add to list
1 Lesons
1 hour 11 minutes
On-Demand
Free-Video
PASS Data Community Summit

From Docker to Big Data Cluster - A New Era for SQL Server

0 rewiews
Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.
Add to list
1 Lesons
1 hour 3 minutes
On-Demand
Free-Video
PASS Data Community Summit

Get Your Optimizer to Give Up All Its Secrets

0 rewiews
Uncover SQL Server's query optimization process, from parsing to rule application. Learn to analyze parse trees and memos for more efficient T-SQL writing and improved query performance.
Add to list
1 Lesons
1 hour
On-Demand
Free-Video
PASS Data Community Summit

Data Warehouse Automation Using Agile Methods

0 rewiews
Explore agile data warehouse development using Data Vault design and metadata-driven automation for faster delivery, flexible architecture, and improved documentation in business intelligence projects.
Add to list
1 Lesons
2 hours 3 minutes
On-Demand
Free-Video
PASS Data Community Summit

Introducing SQL Server 2022

0 rewiews
Explore SQL Server 2022's new features: cloud connectivity, disaster recovery, analytics, security enhancements, and T-SQL extensions. Learn about Intelligent Query Processing and SQL Server Ledger with live demos and expert Q&A.
Add to list
16 Lesons
1 hour 10 minutes
On-Demand
Free-Video
Devoxx

Introduction to Kusto

0 rewiews
Explore Kusto for interactive Big Data analytics on Azure. Learn advanced querying, monitoring, and debugging techniques used at DocuSign through practical examples and demonstrations.
Add to list
44 Lesons
46 minutes
On-Demand
Free-Video
SQLBits

Beware of Nondeterministic T-SQL Code

0 rewiews
Explore the implications of nondeterministic T-SQL calculations and learn best practices to avoid potential issues in your database development.
Add to list
1 Lesons
51 minutes
On-Demand
Free-Video
SQLBits

GitHub Copilot for SQL Development - Integrating AI into Database Development

0 rewiews
Discover how to leverage GitHub Copilot as an AI assistant for efficient SQL coding and database development, enhancing your daily workflow.
Add to list
1 Lesons
47 minutes
On-Demand
Free-Video
SQLBits

When to Stop Tuning a Query - Optimization Techniques and Challenges

0 rewiews
Explore SQL query tuning techniques, challenges, and optimization strategies to determine when a query is sufficiently optimized.
Add to list
1 Lesons
53 minutes
On-Demand
Free-Video
SQLBits

JSON as a First-Class Citizen in Azure SQL Database

0 rewiews
Explore new T-SQL features in Azure SQL Database, focusing on JSON as a first-class data type. Learn to query and manipulate JSON data, enhancing data management capabilities.
Add to list
1 Lesons
45 minutes
On-Demand
Free-Video
SQLBits

Writing T-SQL Code for the Engine - Performance Optimization Techniques

0 rewiews
Optimize T-SQL queries for better engine performance through strategic rewriting techniques. Learn powerful scenarios to enhance database efficiency.
Add to list
1 Lesons
52 minutes
On-Demand
Free-Video
SQLBits

Welcome to the World of SQL Copilots - Latest Innovations in AI Companions for SQL Development

0 rewiews
Explore AI companions transforming SQL development. Learn about GitHub Copilots for T-SQL and Azure SQL management assistance. Discover the latest innovations in SQL Copilot technology through demos.
Add to list
1 Lesons
45 minutes
On-Demand
Free-Video