SQL tricks and concepts you didn't know about - Aleksandra Sikora I Prisma Day 2022

Uploaded By: Myvideo

Published on

24 Jun 2022

4 views

0

0 votes

0

About Share Download Add to

This talk was recorded on #PrismaDay | June 16th, 2022. Prisma Day is a community-focused hybrid conference on modern application development and databases. Did you know that some SQL variants are Turing complete and let you write any program in SQL? Of course, no one's that crazy... But what are the limits of SQL? What are some crazy things we can do with it? I'm going to go over a few of them in this talk. It won't be only fun stuff, though! I'm going to show some more practical but lesser-known concepts too. Let's discover some hidden SQL traits together! Aleksandra is a software engineer based in Wrocław, Poland. She's worked as a full-stack developer with many different languages such as Elixir, Golang, Python, and TypeScript. She was previously a tech lead for the Hasura Console, and now she's a lead maintainer of . Connect with Aleksandra:

Share with your friends

Link:

Embed:

<iframe width="640" height="360" src="//myvideo.cc/embed/YVJRaXZicFdwaFllSlJmNUxla1FPeDQwb2JXVHZ5aVB3VU9WVmtEQ2VQYz0" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>

Video Size:

Custom size:

x

Autoplay video

Hide player controls

Hide resume playing

Add to Playlist:

Favorites

My Playlist

Watch Later

Quickly View SQL Queries in Laravel with DB::listen (No Debugbar)

3 months ago

00:02:02

Quickly View SQL Queries in Laravel with DB::listen (No Debugbar)

3 35%

6 Query Tuning Techniques - Solve 75% SQL Server Performance Problems (by Amit Bansal)

5 months ago

01:37:51

6 Query Tuning Techniques - Solve 75% SQL Server Performance Problems (by Amit Bansal)

1 93%

Королевская склпка #tricks #спорт #calisthenics #тренировка

5 months ago

00:00:14

Королевская склпка #tricks #спорт #calisthenics #тренировка

1 34%

3 Eloquent Tips: Raw SQL, Latest and Condition Brackets

11 months ago

00:03:37

3 Eloquent Tips: Raw SQL, Latest and Condition Brackets

6 37%

AI & LLMs ЗАМЕНЯТ РАЗРАБОВ. ГОТОВЬСЯ УЖЕ СЕЙЧАС

1 year ago

01:39:49

AI & LLMs ЗАМЕНЯТ РАЗРАБОВ. ГОТОВЬСЯ УЖЕ СЕЙЧАС

1 70%

SQL Injecting Beyond Strict Filters - Union Without Comma

1 year ago

00:36:21

SQL Injecting Beyond Strict Filters - Union Without Comma

12 47%

Korg SQ-1 Trick - Keyboard mode!

1 year ago

00:02:40

Korg SQ-1 Trick - Keyboard mode!

1 33%

Dynamic Data Filtering | Dynamic Where Condition | Filter data based on dynamic criteria | D-SQL

1 year ago

00:14:11

Dynamic Data Filtering | Dynamic Where Condition | Filter data based on dynamic criteria | D-SQL

1 63%

Dynamic Data Sorting | Sorting data based on parameterized column name | Use of Dynamic SQL Query

1 year ago

00:03:19

Dynamic Data Sorting | Sorting data based on parameterized column name | Use of Dynamic SQL Query

1 59%

HackTheBox - Pikatwoo

1 year ago

02:15:49

HackTheBox - Pikatwoo

10 9%

Dynamic Schema Name | Fetching Data from Dynamic Schema | Fetch the data from Parameterized Schema

1 year ago

00:03:36

Dynamic Schema Name | Fetching Data from Dynamic Schema | Fetch the data from Parameterized Schema

1 36%

70 книг по IT, которые надо прочесть. Как писать хорошо, языки, тесты, БД, безопасность, soft skills

1 year ago

01:06:03

70 книг по IT, которые надо прочесть. Как писать хорошо, языки, тесты, БД, безопасность, soft skills

8 62%

Dynamic Source Database | Fetching Data from Parameterized Dynamic Database | Use of Dynamic SQL

1 year ago

00:04:05

Dynamic Source Database | Fetching Data from Parameterized Dynamic Database | Use of Dynamic SQL

1 75%

Dynamic Source Table | Fetching Data from Dynamic Table | Dynamic SQL Query | Use of Dynamic SQL

1 year ago

00:05:27

Dynamic Source Table | Fetching Data from Dynamic Table | Dynamic SQL Query | Use of Dynamic SQL

1 29%

Dynamic DDL Command | Creating Table at Runtime | Creating database at Runtime | Use of Dynamic SQL

1 year ago

00:02:50

Dynamic DDL Command | Creating Table at Runtime | Creating database at Runtime | Use of Dynamic SQL

1 80%

How To Use Sqlite Database With Python

1 year ago

00:11:41

How To Use Sqlite Database With Python

3 82%

Dynamic Output Column Name | Returning Data From Dynamic Column | Use of Dynamic SQL | D-SQL

1 year ago

00:02:24

Dynamic Output Column Name | Returning Data From Dynamic Column | Use of Dynamic SQL | D-SQL

1 28%

Dynamic Alias Name | Returning Dynamic Alias Name from Stored Procedure | Use of Dynamic SQL

1 year ago

00:03:04

Dynamic Alias Name | Returning Dynamic Alias Name from Stored Procedure | Use of Dynamic SQL

1 24%

CSV Parameters in SQL SP | Returning matching records for CSV parameter | Use of Dynamic SQL

1 year ago

00:09:35

CSV Parameters in SQL SP | Returning matching records for CSV parameter | Use of Dynamic SQL

1 39%

The right way to ADD data MANUALLY to Power BI | Challenges & Solutions @ObnexTechnologiesAB

2 years ago

00:08:40

The right way to ADD data MANUALLY to Power BI | Challenges & Solutions @ObnexTechnologiesAB

3 70%

CI/CD Build Test and Deploy to Azure with Azure Pipelines as Code & YAML Live Webinar May 16, 2020

2 years ago

01:11:43

CI/CD Build Test and Deploy to Azure with Azure Pipelines as Code & YAML Live Webinar May 16, 2020

24 7%

How to Install and configuration PostgreSQL on Ubuntu Linux

2 years ago

00:15:19

How to Install and configuration PostgreSQL on Ubuntu Linux

19 36%

Beginners PostgreSQL database Tutorial 1 - Installing and Setting up PostgreSQL ( pgAdmin )

2 years ago

00:13:09

Beginners PostgreSQL database Tutorial 1 - Installing and Setting up PostgreSQL ( pgAdmin )

4 38%

Типичные вопросы на собеседовании по SQL_2

2 years ago

00:21:19

Типичные вопросы на собеседовании по SQL_2

2.4K 68%

0 Comments

Guest