D4mations.com

SQL for Beginners. Learn basics of SQL in 1 Hour



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

d4mer

, , , , , , , , , , , ,

36 responses to “SQL for Beginners. Learn basics of SQL in 1 Hour”

  3. 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. 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.

  6. 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

  18. 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. 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++)

  23. 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.

  28. 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. 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

  35. "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.

Leave a Reply