• Sunday , 20 August 2017

SQL for Beginners. Learn basics of SQL in 1 Hour

Code Canyon



SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and …

Original source

3d Ocean

Related Posts

36 Comments

  1. Bhavuk Jain
    July 27, 2017 at 11:21

    The Content Is Copied! Isn't It?

  2. Gezae Brhane Gebreamlak
    July 27, 2017 at 11:21

    Great job,

    Where can i get the codes?

  3. MySweetsGone
    July 27, 2017 at 11:21

    on the lesson at around minute 19:00 you created a table of dr.favorite right?, and the SELECTED FROM you had under was actually From excercise logs,Why not change it to SELECT FROM dr.favorite table directly?
    wouldnt it just be easier and automatically pull the updated data from dr favoirte and spare us the Command
    "WHERE type IN(SELECT type FROM dr.favorites)"
    hmm?

  4. Ming Yan
    July 27, 2017 at 11:21

    Is this MySQL or MS SQL or Oracle SQL?
    you only put it as SQL
    I think you could tell the viewers what exactly they are learning while watching.
    The syntax is different from each other. they only share the basic thing such as select from or create table
    while things like the data type "text", the suffix AUTOINCREMENT, is not shared by all of them.

  5. Geng Yuxiang
    July 27, 2017 at 11:21

    what is the sql platform you are using in the video???

  6. Jordan Ponder
    July 27, 2017 at 11:21

    6:30 I don't understand this.. so the wouldn't the cherries be in aisle 7 with the bananas even though they are both fruit but I'm supposed to believe they'd be with the peanut butter and dark chocolate? Looks like someone was makin a grocery list ;P

  7. E. Sage C. C.
    July 27, 2017 at 11:21

    This video help me understand more about SQL than a book and Virtual Academy. Thank you for the help.

  8. endritiger
    July 27, 2017 at 11:21

    the data type is on the right???? weeeeeeird…

  9. Ramboo339
    July 27, 2017 at 11:21

    CASE statement did not work for me. Got error " GROUP BY expression must contain at lease one column that is not an outer reference"

  10. Ramyashree C
    July 27, 2017 at 11:21

    which software ur are using

  11. K Field
    July 27, 2017 at 11:21

    "Pretty cool, huh?" I feel so familiar to this 🙂

  12. Rosimere Stringer
    July 27, 2017 at 11:21

    I loved  your class, you made easier to learn SQL

  13. Dimitris Vovlas
    July 27, 2017 at 11:21

    127 people don't like dark chocolate…

  14. HAMZA AMIR
    July 27, 2017 at 11:21

    can you give me the link of Sql editor which shows my whole program

  15. randdoom videos
    July 27, 2017 at 11:21

    this video saved my grade!! THANKS!!

  16. arafat hussain
    July 27, 2017 at 11:21

    which software you used for run sql?

  17. Yousif Shibeika
    July 27, 2017 at 11:21

    Does anyone know the name of this girl she is too damn good

  18. Lance Robert
    July 27, 2017 at 11:21

    Very helpful presentation and examples, and I like the way the presenter injects much-needed humor every so often. Had to pause the video to laugh when she said "milk chocolate is not even chocolate"! Made what could have been a very dry subject more interesting. Thank you, and please thank the presenter for me.

  19. Maria Turrubiartes
    July 27, 2017 at 11:21

    So what's the difference between making a table on SQL vs just making it on excel? What else can I do with SQL that I cannot do on excel?

    (My question is just based on this tutorial I don't know how to program in SQL but I can however code in C++)

  20. prajakta karandikar
    July 27, 2017 at 11:21

    Amazing Explanation!!

  21. Mary Thisexample
    July 27, 2017 at 11:21

    Thanks for video, it really taught me a lot about SQL and I think it's a great starting point for me

  22. nagi Himmed
    July 27, 2017 at 11:21

    Thank you so much for your videos you are a just an angel, God bless you,, everything it was clear ,.

  23. drkbrhds
    July 27, 2017 at 11:21

    This is a great video, even for someone who is simply brushing up on SQL. The commentary provided is also funny at times and has the ability to retain attention really well.

  24. Christian Kasongo
    July 27, 2017 at 11:21

    perfect

  25. Sam Goodwin
    July 27, 2017 at 11:21

    I stopped watching when she insulted milk chocolate.

  26. DJ Toomey
    July 27, 2017 at 11:21

    Does CONCAT not work in this program?

  27. Anything' Everything'
    July 27, 2017 at 11:21

    Thanks! Helpful awesome video. Easy to learn with fun. Can't believe that the speaker is 30!!!

  28. Moepi Maile
    July 27, 2017 at 11:21

    Help please
    How do you solve this question
    Write a single SQL statement to list albums with four columns: the title of the album, the total number of track in that album, the price of the album, and the discounted price of the album. All albums priced above forty dollars wpuld be given a ten percent discount.All other albums would be given a discounted price N/A in the output.
    Exclude albums that are priced lower than thirty dollars from the output. Rename the column headins appropritely and sort the output by price decendingly.
    Show less
    REPLY

  29. Dsatya gane
    July 27, 2017 at 11:21

    31:52 video time there created two tables
    1)students
    2)student_gradedes

    1)students
    on the students table inserting data–there need to give 'integer primary key ' (or)values can be set itself
    2)student_grades
    on this table also to give 'integer primary key ' values (or)values can be set itself

    there got an error to me. please

  30. Hassan Nur
    July 27, 2017 at 11:21

    this is the best  tutorial video  I ever watch  thanks your are awesome teacher

  31. watches whisky
    July 27, 2017 at 11:21

    why you have a voice like you just now wake up ? -_-

  32. Ariunsanaa
    July 27, 2017 at 11:21

    Is it different from MySQL?

  33. Cali9000
    July 27, 2017 at 11:21

    Wow, this was actually fun

  34. Aram Shakkour
    July 27, 2017 at 11:21

    I want to marry this girl

  35. Justin Pettit
    July 27, 2017 at 11:21

    "You have an error in your sql syntax; check the manual that corresponds to your Mariadb server version for the right syntax to use near ')' at line 1"

    I put everything exactly how you did and am getting errors and this note. I'm using Xampp btw.

  36. Mike Headley
    July 27, 2017 at 11:21

    You just taught me in an hour what university class took a semester for. Thank you.

Leave A Comment

You must be logged in to post a comment.