mySQL

Data

Transaction SQL tutorial : SQL Commit and Rollback

A great tutorial on the ACID capabilities of SQL. A transaction is the propagation of one or more changes to the database. For example, if you are creating a record or updating a record or deleting a record from the table, then you are performing transaction on the table. It is important to control transactions […]

Read More
Python

Sqlite Backend for Beginners – Create Quick Databases with Python and SQL

Sqlite, is a library known for its quick and simple databases. With the help of Python, we will cover all the basics of creating databases, tables, inserting data into those tables, selecting and fetching database rows, searching data within the database and manipulating this data inside our code. All this – in less than 15 […]

Read More
Developer

Web Applications for Everybody Course – Dr. Chuck Teaches HTML, PHP, SQL, CSS, JavaScript, and more!

This beginner’s course is a complete introduction to web application development. Learn how to build dynamic database-backed web sites in this free 14 hour course. Dr. Chuck will teach you how to use HTML, CSS, JavaScript, PHP, MySQL, jQuery, and Handlebars to build web and database applications. Time Stamps: ⌨️ (00:00:00) Web Applications and the […]

Read More
Azure Data

Introducing Flexible Server in Azure Database for PostgreSQL & MySQL

Sunil Kamath joins Scott Hanselman to discuss how you can run your MySQL or Postgres database as a managed database on Azure without giving up the control you want while taking advantage of the benefits of a PaaS offering. Related Links: What is Flexible Server in Azure Database for PostgreSQL What is Flexible Server in […]

Read More
Big Data Data

7 Database Paradigms

Learn about seven different database paradigms and what they do best. Contents: 00:00 Intro 00:45 Key-value 01:48 Wide Column 02:47 Document 04:05 Relational 06:21 Graph 07:22 Search Engine 08:27 Multi-model

Read More
Python

Python & MySQL Crash Course

Traversy Media provides a a beginner-based crash course on working with MySQL with the Python programming language. 

Read More
Data

SQL Joins Tutorial For Beginners

Here’s a great tutorial for beginners (or refresher for seasoned pros) on the basics of SQL Joins (Inner, Left, Right, Full Join).

Read More