SQL Tutorials
Learn essential SQL concepts, from database basics to advanced queries, with hands-on practice using MySQL. Ideal for beginners starting their data science journey.
SQL for Beginners Tutorial - Learn SQL in 4.2 Hours
Comprehensive SQL tutorial covering database fundamentals, PostgreSQL, table creation, data manipulation, querying, constraints, joins, and advanced concepts for beginners.
Decision Support Systems
Explore decision support systems, from basic concepts to advanced techniques like expert systems and neural networks, enhancing your ability to make informed business choices.
REST API - Web Service Tutorial
Comprehensive tutorial on building RESTful web services using Java, Jersey, and Spring. Covers API basics, resource creation, HTTP methods, JSON/XML handling, and database integration.
Spring Security Tutorial
Comprehensive guide to Spring Security, covering authentication, MySQL integration, password encoding, form login, and OAuth 2.0 implementation for robust application security.
Postgres and MySQL Use Cases on Azure - Migrations, Analytics, and E-commerce
Explore developers' use of Postgres & MySQL on Azure for e-commerce, analytics, and SaaS. Learn about migrations, real-time analytics, and popular applications like Magento and Moodle on Azure's managed services.
Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live
Explore advanced query performance enhancements in Azure SQL and SQL Server 2022, including Intelligent Query Processing, Parameter-sensitive Plans, and Cardinality Estimation Feedback, with live demonstrations and expert insights.
Citus Cluster Zero-Downtime Migration - Algolia's Experience
Algolia engineers share their zero-downtime migration strategy from Citus Cloud to Azure, detailing planning, execution, and key takeaways for seamless analytics infrastructure transition.
Developing IO Prefetching for PostgreSQL
Explore IO prefetching in PostgreSQL, including algorithm development, simulation advantages, and evaluation techniques for improving database performance and efficiency.
PostgreSQL - More Relevant Than Ever
Explore PostgreSQL's enduring relevance in modern IT, its evolution, and why it remains a top choice for databases, with insights from a core team member and consultant.
Lesser Known Features of PostgreSQL
Discover lesser-known PostgreSQL features for efficient data manipulation, testing, and querying. Learn practical tips to enhance your database skills and streamline development workflows.
Citus 11 - New Features and Enhanced Query Throughput Scalability
Explore Citus 11's enhanced query throughput scalability, new features, and benchmark results. Learn about querying from any node, automatic schema syncing, and distributed sequences in this technical deep dive.
OSSom: Better Oracle to Postgres Migration Assessments
Introducing OSSom: A user-friendly tool for assessing Oracle to PostgreSQL migrations. Learn about its architecture, features, and see a live demo to simplify your database transition process.
Citus Con: An Event for Postgres - EMEA Livestream
Explore PostgreSQL's relevance, features, and applications in this event featuring expert talks on migration, assessments, Azure integration, and Citus 11, offering valuable insights for database professionals.
Citus Con - An Event for Postgres - APAC Livestream
Livestream replay featuring expert talks on PostgreSQL, covering distributed databases, queues, security, localization, and connection pooling. Gain insights from industry leaders.
Citus Con - An Event for Postgres - Americas Livestream
Livestream replay featuring expert talks on PostgreSQL optimization, performance analysis, distributed databases, and geospatial applications. Gain insights from industry leaders on advanced Postgres topics.
Top 10 Reasons to Choose Flexible Server for Azure Database for PostgreSQL
Explore 10 key advantages of Azure Database for PostgreSQL Flexible Server, including improved performance, high availability, cost optimization, and enhanced control over server configurations.
Data Modeling for Saving Time and Money in PostgreSQL - Best Practices and Optimization
Optimize PostgreSQL performance through data modeling, governance, and best practices. Learn to choose ideal indexes, data types, and Azure scaling for successful projects and cost savings.
Optimizing Autovacuum - PostgreSQL's Vacuum Cleaner
Learn to optimize PostgreSQL's autovacuum for efficient database maintenance. Understand its workings, troubleshoot issues, and implement effective solutions to prevent bloat in production environments.
Fixing String Inconsistencies in PostgreSQL
Explore PostgreSQL's string handling features to improve data quality. Learn pattern matching, regular expressions, and advanced extensions for fixing inconsistencies and ensuring accurate results.
Loading at Hyperscale: Advanced Data Import Techniques for Citus - Citus Con 2022
Explore advanced data import techniques for Citus, including microbatching, data ordering, distributed triggers, and direct worker loading, to optimize large-scale data operations in PostgreSQL.