Intermediate ASP.NET Core Tutorial - Refactoring Cart and Database - Episode 38
Optimize cart functionality and balance database-service interactions in ASP.NET Core. Learn refactoring techniques to enhance your online shop's performance and maintainability.
Views in SQL - Create View from Single Table - Multiple Tables - Drop View
Learn to create and manage SQL views from single or multiple tables, including syntax for creation and deletion, enhancing database query efficiency and data organization.
Queries on Sailors, Boats & Reserves Table in SQL
Learn SQL queries for sailors and boats database, covering joins, subqueries, and aggregate functions to extract specific information from multiple tables.
Group By and Having Clause in SQL Commands
Explore GROUP BY and HAVING clauses in SQL for data aggregation and filtering. Learn to analyze student data by branch, gender, and performance metrics using practical examples.
Select Command in SQL - DML Commands - Where Clause - Order By
Learn SQL SELECT command syntax, WHERE clause, ORDER BY, and practice with various examples to master data retrieval and manipulation in relational databases.
Constraints in SQL - Primary Key, Not Null, Default, Check, Unique, Foreign Key, DBMS
Comprehensive guide to SQL constraints including primary key, not null, default, check, unique, and foreign key. Learn to enforce data integrity in database management systems.
Types of Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key
Comprehensive overview of key types in database management systems, including super, candidate, primary, foreign, alternate, and unique keys.
The Architecture of a Forever Free, Serverless SQL Database
Explore the internals of a serverless database, including automatic scaling, transaction isolation, resilience, data localization, and cost-effective usage in CockroachDB Serverless.
Tyqu - Typesafe SQL Queries in Scala
Introducing Tyqu: A Scala library for type-safe SQL queries. Leverages Scala 3 features for convenient, functional-style database interactions with compile-time checks and runtime code generation.
Oracle SQL All-in-One Quick Start Tutorial Series
Comprehensive Oracle SQL tutorial covering essential concepts, syntax, and practical applications for database management and querying in just 4 hours.
User Auth and Roles With Hasura - Learn With Jason
Explore user authentication and role-based permissions in Hasura with Vladimir Novick. Learn to integrate Auth0 for seamless authentication and leverage Hasura's powerful data management capabilities.
Build an Internal App Without Learning Mobile App Dev
Learn to create custom internal mobile apps using Retool without mobile development expertise. Build, track, and manage team processes efficiently with this no-code solution for businesses lacking mobile developers.
Introduction to Timescale - Getting Started with Time-Series Data
Comprehensive introduction to TimescaleDB, covering setup, data import, querying, and advanced geospatial time series analysis with hands-on demonstrations and expert insights.
SQL Tutorials for Beginners - Structured Query Language Tutorials - DBMS
Comprehensive SQL tutorial covering essential concepts, commands, and practical applications for beginners. Learn to create, manipulate, and query databases effectively.
Create Command in SQL - DDL Commands - Create Database - Create Table - MySQL - Create Query
Learn to create databases and tables in MySQL using SQL DDL commands. Covers database creation, table structure, and basic syntax for defining and organizing data.
Query Optimization and Evaluation 2 - Worst-Case Optimal Join Algorithms
Explore worst-case optimal join algorithms for efficient query processing, focusing on advanced techniques to enhance database performance and optimize complex data operations.
Connecting to SQL Databases From VS Code
Learn to create and connect to SQL databases using VS Code extensions, and modify them with Python and SQLAlchemy in this hands-on tutorial featuring Azure and PostgreSQL.
Modern SQL - Evolution of a Dinosaur
Explore SQL's evolution beyond relational algebra, featuring advanced capabilities like graph processing, XML/JSON handling, versioning, and time series analysis using modern techniques.
Build and Use APIs for Android Apps - Full-Stack Development with Flask, SQL, and Android Studio
Learn to build and integrate APIs for Android apps using Flask, SQL, and Android Studio. Covers server setup, API creation, and app development with Kotlin.
Working with SQL and Databases in IntelliJ IDEA
Learn SQL query writing and database management in IntelliJ IDEA. Covers code completion, data editing, import/export, navigation, and advanced features for efficient database development.
Data Wrangling Using SQL - Data Cleaning in SQL
Learn essential SQL data wrangling techniques for querying, joining, appending, filtering, and creating new fields in datasets. Gain practical skills to efficiently prepare and transform data for analysis.