SQL Tips & Tricks Every Data Professional Should Know | Best Coding Practices 2022 | LearnSQL

Показать описание

contact me ✨
📷 Instagram | @violetharmonyx

commonly searched tags ✨

disclaimer ✨
FTC: this video is sponsored by LearnSQL.com
all opinions expressed in this video and all videos on my YouTube channel are solely my own, and do not express or reflect the views or opinions of my employer. they also do not reflect the views of any of the brands that I may mention.

1817

candidly vivian

Рекомендации по теме

Комментарии

I really like your videos! Thank you! :)

divina.glitch

No puedo creer lo increíble que son estos trucos, thank you so much!

azulbahia

I came to the same conclusion about CTEs just based on my own experience. I had so much frustration with big complex queries more than 100 lines long. Couple of days later I couldn't understand my own query. CTEs make this problem so much easier to handle. Totally agree

sasstemir

You mentioned CTEs only need to be run once. Does that mean they're more for static data that doesn't change in that case? I have a nested select statement I would like to optimize, but the data changes frequently

jakemurphy

Can you make another one of these? pleaseeee! more tips and tricks. No matter how small 😊😊

andracoisbored

Much needed video! Thanks.
Do data scientists use procedures, function all the other T- Sql, PL/SQL stuff as well?
Awaiting your response.

TIA

reshmisiva

Hey can you recommend Coursera courses for statistics required for data science

Traumatised

Vivian
I took some lesson of statistic on Coursera for data science
M from a mechanical background
I found stats for data science very hard n it made me cry
What would u suggest
I have given up on idea of being a data science

Traumatised

THE CONTENT WAS GREAT ALSO YOU LOOK SO BEAUTIFUL😊

adityasharma

The CTE advice is not correct. If you reference it more than once SQL will in-line it and run it for each reference.

MiningForPies

Hello, your thumbnails are too crowded I cant even read in desktop so you may try using a single/simple background image only instead of collage, also I think you can try cutting some words, 4-5 words would be enough for the content I guess. quick tips from another youtuber, I hope you can stay steady please dont burnout :p

ardaburakcobankent

SQL Tips & Tricks Every Data Professional Should Know | Best Coding Practices 2022 | LearnSQL

SQL Tips & Tricks Every Data Professional Should Know | Best Coding Practices 2022 | LearnSQL

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

5 Ways to Improve Your SQL Queries

7 Mistakes Beginners Make with SQL

SQL Query Optimization - Tips for More Efficient Queries

SQL Explained in 100 Seconds

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

20 Years of SQL Advice in 11 Minutes

Mastering SQL: Tips and Tricks from a 12-Year Veteran

Advanced SQL Tutorial | Subqueries

Tips and Tricks for Using SQL Server Management Studio Effectively

Learn how to write SQL Queries(Practice Complex SQL Queries)

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

Approach to Complex SQL Queries

20 Tips for Oracle SQL Developer (To Save You Time)

BEST Websites to Learn SQL FAST 🏃🏽‍♂️💨

SQL Union and Union All - SQL Training Online - Quick Tips Ep49

Expert Level SQL Tutorial

SQL Workshop: SQL Patterns Every Analyst Should Know w/ Ergest Xheblati

Top PL/SQL Tips In Just One Hour

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

5 Basic SELECT Statement Queries in SQL

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

SQL Views In 4 Minutes: Super Useful! Wow! Crazy! Amazing! I'm Crying Tears Of SQL Joy.