Create a PHP REST API - Write a RESTful API from Scratch Using Plain, Object-Oriented PHP and MySQL
Develop a complete RESTful API using PHP and MySQL, covering essential concepts like routing, database operations, error handling, and data validation for efficient API creation.
Signup and Login with PHP and MySQL
Create a secure user authentication system with PHP and MySQL, covering signup, login, and logout functionalities using best practices and client-side validation.
Save HTML Form Data to a MySQL Database Using PHP
Learn to create HTML forms and save data to MySQL using PHP, covering form controls, data validation, SQL injection prevention, and database operations.
Data Lakehouse - An Introduction
Explore the Data Lakehouse concept, its comparison to traditional SQL warehouses, and its significance in modern data architecture.
Calling REST API's with Python - Talkwalker
Learn to make REST API calls to Talkwalker using Python and save results to SQLite. Covers API documentation, demo, master table creation, and upsert operations.
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.
Python and MySQL Tutorial
Learn to connect Python with MySQL databases, execute queries, and handle data efficiently using server-side and client-side cursors. Gain practical skills for database integration in Python applications.
Meet MySQL RAPID - Distributed, In-Memory, Columnar, Query Processing Engine by ORACLE
Explore MySQL RAPID: Oracle's distributed, in-memory columnar engine for OLAP & OLTP workloads. Learn its architecture, data loading, and how it revolutionizes data warehousing and ETL processes.
Relational Database ACID Transactions - Explained by Example
Comprehensive exploration of ACID properties in relational databases, covering atomicity, consistency, isolation, and durability with practical examples and in-depth explanations of read phenomena and isolation levels.
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.
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.
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.
SQL Crash Course for Beginners - MySQL & PostgreSQL
Comprehensive introduction to SQL, covering database fundamentals, syntax, data manipulation, relationships, joins, and advanced querying techniques for both MySQL and PostgreSQL.
Create a PHP Application - PHP MVC Project Tutorial
Build a PHP MVC application for student assignment tracking. Learn database setup, model-view-controller pattern, PDO connections, and SASS styling in this comprehensive tutorial.
How to Connect a Form to a Database in PHP - PDO Tutorial
Comprehensive tutorial on connecting PHP forms to MySQL databases using PDO, covering CRUD operations, SQL queries, and application flow with practical examples and styling tips.
SQL Crash Course - CRUD Operations - MySQL Tutorial
Learn essential CRUD operations in MySQL through a 10-step tutorial, covering SELECT, INSERT, UPDATE, and DELETE statements, as well as JOINs and complex queries for effective database management.
PHP Flash Cards Practice Project - PHP Tutorial for Beginners
Build a PHP Flash Cards app for multiplication practice, covering setup, file creation, styling with Sass, and accessibility testing in this hands-on tutorial.
Learn to Build Microservices - From Code to K8s Deployment in 60 Minutes
Comprehensive guide to building a movie database microservice using OpenAPI3.0, Postgres, and gORM, covering implementation, Docker containerization, and Kubernetes deployment.
SQL Crash Course - Learn Raw SQL for Beginners
Comprehensive SQL tutorial covering basics to advanced concepts. Learn data manipulation, relationships, joins, subqueries, and more. Hands-on practice with real-world examples and challenges.
TypeORM Crash Course - TypeScript & Node ORM
Learn TypeORM for Node.js: Create tables, perform CRUD operations, and manage relationships in databases like MySQL and Postgres using TypeScript. Covers setup, entities, data manipulation, and querying.
30 Years of Linux and Open Source - Chariot's Multi-Decade Journey
Explore Chariot's 20-year journey with open source, from Linux to modern frameworks. Learn how consultants contribute and leverage community-driven solutions for innovative software development.