SQL Advanced – Lesson3 – Functions – Part 1




About this tutorial:

Video duration: 18:55
This is Lesson 3 in the series of SQL Lessons. The tutorial has information about using Column and Table alias and also SQL Aggregate Functions.

Links to all SQL Lessons:

SQL Lesson 8 – Subqueries

SQL Lesson 7 – JOIN (Full, Self, Cross, Union)

SQL Lesson 6 – JOIN (INNER, LEFT, RIGHT)

SQL Lesson 5 – Constraints (Default, Primary Key, Foreign Key …)

SQL Lesson 4 – GROUP BY, HAVING, String Functions

SQL Lesson 2 – Logical,…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

31 thoughts on “SQL Advanced – Lesson3 – Functions – Part 1

    Amber Latif

    (January 12, 2019 - 12:42 pm)

    Thanks a million for posting your knowledge through this series of video
    Its very very helpful for me
    Plz keep sharing

    shivanshu gupta

    (January 12, 2019 - 12:42 pm)

    Where can I all tutorial get ?.. send link in my email id .. guptaashu092@gmail.com
    Plz..

    Nisha Hada

    (January 12, 2019 - 12:42 pm)

    Hi ! i have been taking sql class now but i am more clear watching your video , wondering if you provide 101 class?

    Walter Morpheus

    (January 12, 2019 - 12:42 pm)

    Great tutorial, provided me with everything I needed, thank you very much

    Davinder Monga

    (January 12, 2019 - 12:42 pm)

    Very effective lectures mam…thanks

    Shahed Shehadeh

    (January 12, 2019 - 12:42 pm)

    Hi Masti, would you please contact me , I want to take in depth private course with you in SQL

    shankar lingam

    (January 12, 2019 - 12:42 pm)

    Excellent teaching mam upload more videos about sql !!!

    mohd taj

    (January 12, 2019 - 12:42 pm)

    thank you very much mam.Excellent lecture, Could you please provide your institute address,

    Akshay Oza

    (January 12, 2019 - 12:42 pm)

    thanku very much mam.. great teaching via YouTube.. pls upload videos for C# .. pls pls pls

    Rajeshwari Anumalla

    (January 12, 2019 - 12:42 pm)

    very useful

    కవిత M

    (January 12, 2019 - 12:42 pm)

    Hi, can you pl upload all the parts of from lesson 1, 2, 3 &4 please……these videos are really helpful explanation is simple and very easy to understand. And when i tried to add both both the first_name and Last_name as a new column it gives the value 0 in all the rows.

    Pierre Kinfack Tetsowo

    (January 12, 2019 - 12:42 pm)

    Fantastic…You made my day on SQL…Keep it UP.

    Olena

    (January 12, 2019 - 12:42 pm)

    Thank you for tutorial! Please, make more videos.

    Eliza M

    (January 12, 2019 - 12:42 pm)

    Great, thank you!!

    ABHISHEK AMGOTH

    (January 12, 2019 - 12:42 pm)

    upload lesson on injection topic @masti supreme

    Narender kumar

    (January 12, 2019 - 12:42 pm)

    Excellent lecture .
    Can i get all the lesson of sql.
    this lecture is easy to understand………….
    thank you.

    Mr Epic Fancy

    (January 12, 2019 - 12:42 pm)

    You are a great teacher! Thank you for the good job you are doing through this videos..

    realfan91

    (January 12, 2019 - 12:42 pm)

    what's with the horns in the background? lool, so annoying

    NAEEM AHMED

    (January 12, 2019 - 12:42 pm)

    wow

    Venkatraju Talk Therapy

    (January 12, 2019 - 12:42 pm)

    Simply Excellent

    Muhammad Khan

    (January 12, 2019 - 12:42 pm)

    Very Helpful thanks

    ettienne gerwel

    (January 12, 2019 - 12:42 pm)

    Very good!!!!!!

    Chandu Sekhar

    (January 12, 2019 - 12:42 pm)

    Please upload more videos, Thanks

    Chandu Sekhar

    (January 12, 2019 - 12:42 pm)

    Thank u so much for better understanding , I would like to expect more videos like this

    Reddy Prasad Kidambi

    (January 12, 2019 - 12:42 pm)

    extraordinary teaching

    Mohammed Irshad SK

    (January 12, 2019 - 12:42 pm)

    mam!!for me query SELECT LAST_NAME + FIRST_NAME CONTACT_NAME FROM MAINCONTACTGIVES ME CONTACT_NAME AS 0 IN ALL ROWS ..Y ITS SHOWING LIKE THAT

    Robin Steendam

    (January 12, 2019 - 12:42 pm)

    What about group_by? ? ?

    Prageeth Perumbuli

    (January 12, 2019 - 12:42 pm)

    Actually nice Tutorials good woks 😀 😀

    John Ryder

    (January 12, 2019 - 12:42 pm)

    pls try to make more vids, we are looking forward for your vids, its really amaizing and precise to the point. and pls try to reduce saying the word "actually" too often. thnx grt vid

    Wasim Bader

    (January 12, 2019 - 12:42 pm)

    thank you for the basics concepts in SQL and made it easy to understand.

    MANISH MAHARJAN

    (January 12, 2019 - 12:42 pm)

    woh its great lessons .thank you so much

Leave a Reply

Your email address will not be published. Required fields are marked *