Developing GraphQL API in Django Using Graphene
Learn to build efficient GraphQL APIs in Django using Graphene. Explore ObjectTypes, Queries, Mutations, and pagination while understanding the advantages over REST APIs.
Full Stack Type Safety
Explore full-stack type safety in Python web projects, focusing on enforcing consistency between frontend and backend using REST/Swagger and GraphQL. Includes practical demos and discusses various design approaches.
Leveraging Linked Data Using Python and SPARQL
Explore Python and SPARQL to extract structured knowledge from Wikipedia, creating datasets and corpora for data science projects without traditional web scraping techniques.
Python Security Best Practices
Discover essential Python security practices, covering input validation, XML parsing, assert statements, temporary files, and data serialization. Learn to identify vulnerabilities and implement robust defenses.
Elephants, Ibises and a More Pythonic Way to Work with Databases
Explore a Pythonic approach to database interactions using Ibis, comparing it with traditional SQL methods and showcasing its versatility across various database engines.
GraphQL Subscriptions - Real-time Data with WebSockets and Strawberry
Explore real-time data delivery using GraphQL Subscriptions and WebSockets with Strawberry. Learn to design subscription schemas, handle server-side events, and enhance client-side experiences with seamless updates.
GraphQL as an Umbrella for Microservices
Explore how GraphQL can simplify complex microservices architectures, serving as an effective API gateway for modern single-page applications and distributed systems.
DuckDB - Bringing Analytical SQL Directly to Your Python Shell
Explore DuckDB's seamless integration with PyData ecosystem, enabling efficient analytical SQL queries without a server. Live demo showcases performance and usability alongside Pandas for data science tasks.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Index Fragmentation - Internals, Analysis, and Solutions
Explore index fragmentation in SQL Server, covering internal structures, analysis techniques, and practical solutions for optimizing database performance and query efficiency.
Analizando patrones con SQL, Excel, Azure ML, R y más
Explora técnicas avanzadas de análisis de patrones utilizando SQL, Excel, Azure ML y R para obtener insights valiosos y mejorar la toma de decisiones en ciencia de datos.
10 Dicas para Escrever Codigos T SQL Melhores
Aprenda 10 dicas essenciais para aprimorar seus códigos T-SQL, melhorando a eficiência e qualidade das suas consultas e procedimentos armazenados.
SQL Bad Practices
Aprenda práticas inadequadas de SQL e como evitá-las para melhorar o desempenho e a manutenção de seus bancos de dados.
Offline Database Development and Unit Testing with SSDT
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#.
Common Table Expressions - Advanced
Explore advanced Common Table Expressions: recursive queries, hierarchical data, data manipulation, common use cases, performance considerations, and classic recursive algorithms in SQL Server.
Database Design - Solving Problems Before They Start
Explore key database design principles to prevent future issues. Learn about data types, normalization, and naming conventions through live demos, enhancing your TSQL skills and decision-making abilities.
Making the Leap from Developer to DBA
Discover strategies for transitioning from developer to DBA, including essential skills and knowledge needed for success in database administration.
Introduction to Microsoft Azure DocumentDB
Learn to create and manage Azure DocumentDB instances, work with JSON documents, and develop application logic using JavaScript for efficient NoSQL database operations.
New Features and Capabilities
Explore new features and capabilities of Appliance Update 2, covering T-SQL to HDInsight, enhancing your SQL Server knowledge and skills.
Real-Time Big Data Analytics with R
Explore real-time big data analytics using R, covering data distillation, model development, validation, deployment, refresh, and scoring. Learn to integrate R with Hadoop and database systems.
Using Data to Make Decisions
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.