Delete and Truncate: Databases for Developers #9

Delete and Truncate: Databases for Developers #9

Whether it’s unwanted junk, or stuff that’s just getting too old, often there’s rubbish you want to clear from your tables. It’s time for a delete. As the name suggests, deleting things removes information from the table matching the where clause. Once you’ve committed the data is gone, so take special care with your where […]

Read More »
Dangers of a Conscious Artificial Intelligence

Dangers of a Conscious Artificial Intelligence

I’m Sceptic. Welcome to my Channel. Yes, this isn’t a video at all. In due time, if the number of views justify it, I might publish a real video. The notion of singularity was applied by John von Neumann to human development, as the moment when technological development accelerates so much that changes our life […]

Read More »
Columns and Data Types: Databases for Developers #2

Columns and Data Types: Databases for Developers #2

Tables may be the foundation of your database, but you need something to hold them up. Columns! Every table in your database will have at least one column. Each of these should hold values for one aspect of the objects the table stores. For example, I’ve got my table of toys here and each toy […]

Read More »
Brightpearl Product: Reporting

Brightpearl Product: Reporting

Hey I’m John and I work at Brightpearl. We bring all your retail and wholesale activity into a single platform providing you with real-time access to data that spans your entire business. To make the day to day decisions that are going to grow your business you’ll need much more detail. You need to know […]

Read More »
Null: Databases for Developers #10

Null: Databases for Developers #10

In this episode we’re going to take a step into the unknown. It’s time to talk about The null value is a placeholder for missing or not applicable information Its inventor, Sir Tony Hoare, has famously described it as is billion dollar mistake. Why? Because using it brings huge complications to your code. Without null […]

Read More »
CoLOS® information management system |  Markem-Imaje

CoLOS® information management system | Markem-Imaje

How do you improve your packaging and coding operations to ensure compliance and end-to-end traceability with maximum efficiency? Typically, operators create complex messages –repeatedly– for many products … …and then input this content manually to each printer at production start-up. This must be done over and over again, each time the product variant changes, wasting […]

Read More »
Select and Where: Databases for Developers #4

Select and Where: Databases for Developers #4

I’ve got table full of data here. But how do I get the rows out of it? I need a select statement. To get the data all you need to write is: select star from and then put the name of your table. Run it and the database will return the entire contents of your […]

Read More »
Element AI Knowledge Scout

Element AI Knowledge Scout

Talented and experienced workers are retiring, taking decades of expertise with them. Knowledge transfer is becoming increasingly difficult. It’s time to empower our next generation of specialists with the experience they need to make decisions with confidence. We’ve developed Element AI Knowledge Scout, an IA solution that makes it easier to access enterprise information and […]

Read More »