Azure SQL Updates and News - November 2021
Explore Azure SQL's November updates, including centralized Hybrid Benefit, REST & GraphQL implementation, and IoT solutions deployment. Gain insights from industry experts on the latest data trends and technologies.
Azure SQL Virtual Machines - Simplifying HA and DR Configuration - Episode 5
Explore simplified HA & DR configuration for Azure SQL VMs using multi-subnet approach. Learn deployment, maintenance, and improved failover time through demos and comparisons of available configurations.
Azure SQL - October 2021 New Updates and Features
Latest Azure SQL updates: new server roles, scalar UDF inlining, DMA 5.5, SSMA 8.22. Featuring product demos, Prisma integration, blogs, events, and learning resources for database professionals.
Cloud Summit 2021 - Day 4 Sessions
Explore Azure's latest innovations in hybrid cloud, machine learning, certifications, SQL, incident response, and VMware solutions through expert-led sessions at Microsoft's Cloud Summit.
Python Pandas Tutorial - Reading-Writing Data to Different Sources - Excel, JSON, SQL, Etc
Learn to import and export data from CSV, JSON, Excel, SQL, and more using Python Pandas. Master essential data handling techniques for various file formats in data science.
Azure SQL Security: The What, Why and How of Securing Your Data - Data Exposed Live
Comprehensive overview of Azure SQL security features, covering authentication, data protection, network security, governance, and threat detection, with practical insights for implementation.
MIN & MAX Functions for Alphanumeric - Text Values Report
Learn 8 methods to find MIN and MAX alphanumeric values in Excel, including VLOOKUP, array formulas, AGGREGATE, MINIFS/MAXIFS, Power Query, and SQL, with practical examples and explanations.
Backwards One to Many Relationship Report - Excel, Power Query or SQL?
Learn advanced Excel techniques for calculating average GPA across related tables using array formulas, DAX, Power Query, and SQL. Master data analysis skills for complex relationships.
Data Analysis Fundamentals - PivotTables, Power Query & Data Model
Master Excel data analysis with PivotTables, Power Query, and Data Model. Learn sorting, filtering, and advanced techniques to handle large datasets efficiently and create insightful reports.
Data Analysis Business Intelligence Terms - Microsoft Power Tools for Data Analysis Class
Comprehensive overview of data analysis and business intelligence concepts, including data types, models, and database structures for effective data management and analysis.
Ctrl - Shift - Enter- Excel Array Formulas - Formulas to Extract Records With Criteria
Master advanced Excel array formulas for efficient data extraction, including AND/OR criteria, INDEX, SMALL, and AGGREGATE functions. Optimize spreadsheet performance with practical examples and timing comparisons.
Ctrl - Shift - Enter - Excel Array Formulas - Review Formula Basics
Comprehensive tutorial on Excel array formulas, covering formula basics, advanced functions, and practical applications for efficient data analysis and problem-solving.
MySQL Tutorial for Beginners
Comprehensive introduction to MySQL, covering essential concepts and operations for beginners. Learn to write queries, manage databases, and extract valuable information efficiently.
How to Crack Analytics Interview in 2021
Comprehensive guide to acing analytics interviews, covering SQL, Python, Data Science, and NLP questions with detailed explanations and practical tips for success.
Azure SQL Database: Grouping Sets and Windowing Functions for Developers
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.
Access Connector for Dataverse and Power Platform GA Launch
Explore the integration of Microsoft Access with Power Platform, enabling hybrid solutions and mobile scenarios through Dataverse connectivity. Learn about migration, data export, and creating mobile apps.
Azure Cosmos DB - How to Design and Implement for SQL API
Explore Azure Cosmos DB SQL API design and implementation through demos, best practices, and monitoring techniques. Learn data modeling, query optimization, and issue identification for efficient database management.
Use Consistency Models in Azure Cosmos DB SQL API
Explore consistency models in Azure Cosmos DB SQL API, configure settings, and optimize performance through hands-on exercises and demonstrations.
Modernizing Applications with SQL Server 2022 and Azure SQL Innovations
Explore new features in SQL Server 2022 and Azure SQL enhancing security, performance, and availability. Learn about hybrid scenarios, real-time intelligence, and improved data governance for modern, intelligent application development.
Choose Azure SQL Database and Learn What Every Developer Should Know
Aprenda técnicas essenciais para desenvolvedores sobre segurança, escalabilidade e disponibilidade no Azure SQL Database, incluindo conectividade sem senha, indexação eficiente e processamento de dados JSON.
Implement Integrated Cache in Azure Cosmos DB SQL API
Implement and configure integrated cache in Azure Cosmos DB SQL API to optimize workload performance, enable caching, and manage cache staleness for improved efficiency.