Advanced SQL Tutorial | CTE (Common Table Expression)

In today’s Advanced SQL lesson we walk through how to use CTEs. ____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That’s what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Udemy Courses:
Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX
Statistics for Data Science – https://bit.ly/37jqDbq
SQL for Data Analysts (SSMS) – https://bit.ly/3fkqEij
NLP – Natural Language Processing with Python – https://bit.ly/30w7iCB

Coursera Courses:
Database and SQL for Data Science – https://bit.ly/2zUk0zL
Data Analysis with Python – https://bit.ly/3geiVDG
Data Analysis Specialization – https://bit.ly/3dYJ6w0
Tableau Data Visualization – https://bit.ly/2AHCNPd

Favorite Books:
Python for Data Analysis Book – https://amzn.to/3dDneGq
SQL Beginner’s Guide to Managing and Analyzing With SQL Book – https://amzn.to/2X5341B

*Please note I may earn a small commission for any purchase through these links – Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL – PATREON

Patreon Page – https://www.patreon.com/AlexTheAnalyst

Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support!
____________________________________________

Websites:
GitHub: https://github.com/AlexTheAnalyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

source by Alex The Analyst

sql

Mourad ELGORMA

Mourad ELGORMA

Fondateur de summarynetworks, passionné des nouvelles technologies et des métiers de Réseautique , Master en réseaux et système de télécommunications. ,j’ai affaire à Pascal, Delphi, Java, MATLAB, php …Connaissance du protocole TCP / IP, des applications Ethernet, des WLAN …Planification, installation et dépannage de problèmes de réseau informatique……Installez, configurez et dépannez les périphériques Cisco IOS. Surveillez les performances du réseau et isolez les défaillances du réseau. VLANs, protocoles de routage (RIPv2, EIGRP, OSPF.)…..Manipuler des systèmes embarqués (matériel et logiciel ex: Beaglebone Black)…Linux (Ubuntu, kali, serveur Mandriva Fedora, …). Microsoft (Windows, Windows Server 2003). ……Paquet tracer, GNS3, VMware Workstation, Virtual Box, Filezilla (client / serveur), EasyPhp, serveur Wamp,Le système de gestion WORDPRESS………Installation des caméras de surveillance ( technologie hikvision DVR………..). ,

26 réflexions sur “Advanced SQL Tutorial | CTE (Common Table Expression)

  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    This is very informative! My question is: in what business scenario could/would this be applicable? I'm a bit lost in that regard. Thanks!

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    I've been wondering what CTEs are and now my curiosity has been fulfilled! Good lesson, Alex. Given that they are temporary and not stored anywhere, what is the advantage of using this over sub-queries? Also, can sub-queries be stored? Thanks as always!

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Hello Alex, great video as usual. I have a question for you. Are online certificates from edx, coursera and udacity worth it? and which of those 3 is better and and has more credibility in real world?

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Started watching this channel knowing nothing about data analysis/science. Did someone online courses on SQL and now I can actually keep up with videos like this. Feels good man

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Hey man I’ve been acquiring analyst skills for a few months now and received some certifications, but I’ve haven’t gotten anywhere with getting entry level data analyst interviews, can you recommend maybe another job as a first step to becoming an analyst?

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    I was waiting for the SQL series to be continued after completing intermediate SQL tutorials. I am so glad you made it. Thank You! Keep Growing😊

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Question!
    When we use the select statement at the end of the CTE, so say if we have CTE.Column1, CTE.Column2 etc will the query become slower?
    I read that each reference to the CTE name will cause the query to re-run?

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    When you first learn through cousera udemy, did you take notes a lot? What method did you use to study?

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Best video about CTE, even put important points about CTE in 3 min video not just implementation. fast and to the point. Thank you Alex.

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    undoubtedly I am so ecstatic to make it till here!!! :))))
    Alex, I am just loving your tutorials and now want to practice and test myself!
    please suggest to me some assignments I can work upon to polish my SQL skills!

    edit: and yes..thank u❤ so much for connecting with me through linkedin. To be honest, I really need ur tips as u are already working as The Great Analyst (my dream profession!😊)

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    thank you for doing this tutorial series, it was quick, comprehensive, and put me up to speed on my knowledge of SQL..you need more subscribers and you just got one today…again thank you.

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Thank you Alex! This is very helpful. Are you planning to create Python training videos in the near future at all? Your way of teaching is very clear, and helpful, so I thought it will be great if you could create some Python beginner videos for data analysts! Thank you!

    Répondre
  • Avatar
    avril 23, 2021 à 9:07
    Permalien

    Hey Alex, really helpful video. So the Udemy course you mention in video info (SQL for Data Analysts (SSMS)) would be suitable to learn not only basics SQL but also some more advanced?

    Répondre

Laisser un commentaire