Getting Started with SurrealDB - Future of Cloud Databases
Explore SurrealDB, a versatile cloud-native database with key-value, relational, and graph capabilities. Learn installation, basic operations, and unique features for efficient data management.
SQL Tutorials
Comprehensive guide to SQL fundamentals, covering database creation, table management, and essential operations like INSERT, SELECT, UPDATE, and DELETE using PostgreSQL.
MySQL Stored Procedures All-in-One Quick Start Tutorial Series
Comprehensive tutorial on MySQL stored procedures, covering variables, table creation, and procedure implementation. Ideal for beginners seeking hands-on practice with database programming.
Db2 SQL All-in-One Quick Start Tutorial Series
Comprehensive introduction to Db2 SQL covering database fundamentals, data structures, CRUD operations, relationships, and normalization for beginners and intermediate users.
MySQL All-in-One Quick Concepts Tutorial Series
Comprehensive MySQL tutorial covering key concepts, installation, database design, relationships, and data integrity for beginners and intermediate users.
Oracle APEX All-in-One Tutorial Series
Comprehensive tutorial on Oracle APEX, covering installation, application creation, SQL Workshop, and database integration. Ideal for beginners and intermediate users seeking hands-on experience with this low-code development platform.
Oracle SQL Tutorial - Relationships and Primary and Foreign Keys - Database Design Primer
Learn Oracle SQL relationships, primary and foreign keys, and database design fundamentals. Explore entity-attribute concepts, various relationship types, and key database design principles.
SQL Database for Beginners
Comprehensive introduction to SQL databases covering fundamentals, table creation, data types, indexing, and advanced topics like JSON, XML, and Azure integration for beginners.
SQL Tutorial for Beginners - Advanced SQL Tutorials
Comprehensive SQL tutorial covering basics to advanced concepts, including database creation, querying, filtering, joins, and table management. Ideal for beginners aiming to master SQL.
Your First C++ CRUD App - DB + UI
Learn to build a C++ application with database integration and user interface, covering database creation, SQL coding, UI development, and styling in just 42 minutes.
Scala's Slick - A Library for Functional Database Access
Explore functional database access with Scala's Slick library. Learn to create collections, manipulate sequences, and drive transformations for elegant and efficient data handling.
Master SQL with Python: Maintaining Data in Oracle Using Merge - Lesson 14
Learn to maintain current data in Oracle using Merge statements, integrating with pandas for efficient data updates, inserts, and deletions in Python.
Master SQL with Python: Maintaining Data in PostgreSQL Using Upsert - Lesson 12
Learn efficient data maintenance in PostgreSQL using Upsert. Master inserting, updating, and deleting rows to keep your data current and optimize your data analysis workflow.
Understanding Aggregate Functions Performance - The Backend Engineering Show
Explore aggregate function performance in databases, focusing on COUNT, AVG, and MAX. Learn about clustering, sequential and random writes, and optimization strategies for improved query efficiency.
Keys in RDBMS
Explore various types of keys in RDBMS, including super, candidate, primary, alternate, unique, and foreign keys. Learn their importance and applications in database management.
Master Using SQL with Python - Introducing PostgreSQL - Lesson 8
Comprehensive exploration of PostgreSQL's features, strengths, and weaknesses, with insights from professional experience and practical demonstrations for Python developers.
Use Enterprise Relational Databases with R and ODBC
Learn to access and manipulate enterprise databases using R and ODBC, focusing on SQL Server integration for efficient data analytics and management.
Master Using SQL with Python - Create a Data Warehouse with SQLite
Learn to build a local SQLite data warehouse by extracting and transforming data from SQL Server and PostgreSQL, simplifying your data analysis workflow with Python.
Master Using SQL with Python - Using SQL with Pandas
Explore SQL querying in Python with Pandas, enabling efficient data analysis and manipulation using familiar database language skills.
Azure Databricks SQL Introduction and Deep Dive
Explore Azure Databricks SQL in notebooks, covering syntax, widgets, databases, and advanced techniques for efficient data manipulation and analysis.
SQL - MySQL and PostgreSQL Installation & Setup Guide for MacOS & Windows
Comprehensive guide for installing and setting up MySQL and PostgreSQL on MacOS and Windows, with step-by-step instructions and Visual Studio Code integration.