SQL

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 Security

Ethical Hacking: Injecting Code into Notepad with Python

In this video watch how to inject your own python code as well as a python interpreter into Notepad.exe and even injecting code into Command Prompt.

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
Data

Redis in 100 Seconds

Redis is an extremely fast in-memory database often used as a cache. It has evolved into a multi-model database with support for graphs, JSON documents, full-text search, and more. Fireship explains it all in 100 seconds.

Read More
Developer

What is the Fastest Computer Language?

A constant source of debate for computer geeks, retired Microsoft engineer Dave Plummer takes us on a guided tour of 45 different computer languages and drag races each against one another using a prime sieve benchmark.

Read More
Azure SQL SQL Server

A Tour of SQL Workshops

Join Anna Hoffman and Buck Woody as they take a tour of the incredible learning resource the Microsoft Engineering team has put together. From labs to full hands-on workshops and much more, you’ll find a wealth of high-quality, free-cost training. You’ll also learn about many of the other valuable references and assets you can find […]

Read More
Data Security

Basics of SQL Injection – Penetration Testing for Ethical Hackers

In case you’re wondering why I am posting a lot of security related content today, the reason is simple: it impacts everyone. If you’re a data engineer and think that you are immune to security concerns, think again. SQL injection is a common hacking technique used to retrieve or destroy data from a database without […]

Read More
Azure SQL

Azure SQL from the Edge to the Cloud

SQL Server started as a departmental database engine. It is now a modern data platform and a force in the industry. In this episode of Data Exposed with Bob Ward, learn how Microsoft is innovating SQL Server from IOT edge devices to your data center to the Azure cloud. Resources: SQL Server and Azure SQL […]

Read More