Databases in Sinhala -Introduction

Databases in Sinhala -Introduction

Sorry for the mistake.SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured Query Language SQL=Structured […]

Read More »
SQL and NoSQL Databases – CompTIA Security+ SY0-401: 4.1

SQL and NoSQL Databases – CompTIA Security+ SY0-401: 4.1

Every organization has data. There is generally a database where you’re going to keep all of this information. And one of the most common database types is a SQL database, or S-Q-L database you may hear it called. It stands for Structured Query Language. It’s a standard way of getting information and storing it in […]

Read More »
SysTools SQL Decryptor Tool | Decrypt SQL Server Database Objects

SysTools SQL Decryptor Tool | Decrypt SQL Server Database Objects

SQL database encryption helps in enhancing security by limiting data loss, Database are encrypted for security purposes, Once encrypted it becomes quite difficult to decrypt your database objects. In order to decrypt SQL Server database, you have to rely on a trustable solution. We bring you the best solution with SysTools SQL Decryptor Software. Now […]

Read More »
Database Performance Tuning With Machine Learning

Database Performance Tuning With Machine Learning

Threshold-based alerting and anomaly detection can create too much noise for DBAs, and often causes more work than necessary. SolarWinds Database Performance Analyzer uses machine learning to reduce the noise and help you focus on what’s important. Machine-learning algorithms get smarter over time and can predict when something in your environment needs your attention. In […]

Read More »
Intro to PowerShell notebooks for Azure SQL | Data Exposed

Intro to PowerShell notebooks for Azure SQL | Data Exposed

>>You’ve probably heard about Notebooks by now, but what you might not know is that you can run PowerShell in them. Anna is here to show us how today on Data Exposed. [MUSIC].>>Hi and welcome to another episode of Data Exposed. I’m your host Jeroen and today I have Anna here with me. Welcome back.>>Thanks.>>We’re […]

Read More »
Setup Prisma and connect it to a database (1/5)

Setup Prisma and connect it to a database (1/5)

Welcome! In this video you will learn how you can connect Prisma to a Postgres database and introspect the database schema to get your Prisma data model. The data model is needed to generate Prisma Client which can be used send to queries to your database from TypeScript and Node.js! As a first step, I’m […]

Read More »
Send database queries with Prisma Client  (4/5)

Send database queries with Prisma Client (4/5)

Welcome! In this video you will learn how to send various queries to read and write data in a database using Prisma Client. For this demo, I’ll also use Prisma Studio to get a graphical view on my data. Right now, I have two `User` records in the database. One of them already is connected […]

Read More »
Introspect a database with Prisma (2/5)

Introspect a database with Prisma (2/5)

Welcome! In this video you will learn how to introspect a Postgres database to generate a Prisma data model. For this demo, I’m using a Postgres database that’s running on my local machine. You can see here in Postico that it has two tables called `User` and `Post`. Note that the `Post` table has a […]

Read More »