SQL Course for Beginners [Full Course]

What people said

Recommends Bob Jarvis - Слава Україні · 2019-07 · Stack Overflow · on “Unable to populate secondary table from concatenated info from primary table in SQL Plus”

I strongly suggest you spend some time learning SQL. There are many free online resources to help you with this - for example here [this video] , or here [LINK] , or here [LINK] . Best of luck.

Recommends Phillip Rekhotho · 2021-01 · Stack Overflow · on “Is there a way changes to a variable is permanent?”

I suggest learning the very basics of MySQL, here is the link for a youtube video moshHamedani [this video] OR you can download a book called MySQL notes for professionals, here MySQLNotesForProfessional [LINK] . Bare in mind that in order to use a database you will need a knowladge of serversite scripting. Good luck

Recommends Lizzo · 2021-02 · Stack Overflow · on “mySQL - populating the tables in EER diagram and generating .sql file”

if you have logged into MySQL workbench [LINK] then tried going to the schema tab (on the left) and hitting the two arrows that make a circle -- that should populate any tables that you've inserted into terminal. if not you can manually add the script file using one of the button on the top left "open a SQL script file". Check out this tutorial [this video] for more info.

Cites sogu · 2019-05 · Stack Overflow · on “Error Message: Cannot Connect to Database Server”

I am trying to set up my SQL environment: MacOS Sierra 10.12.6 MySQL Community Server 8.0.16 - macOS 10.14 (x86, 64-bit), DMG Archive (I have't found lower version) MySQL Workbench 8.0.16 mysql-workbench-community-6.3.10-macos-x86_64.dmg I am following this guide: [this video] For me when I click on "Test Connection" it gives the following error message: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found Please: 1 Check that mysql is running on server 127.0.0.1 2 Check that mysql i

Cites sogu · 2019-05 · Stack Overflow · on “Error Message: Cannot Connect to Database Server”

@nacho I am new to programing. I just know how to follow that video. I used the same password when it has asked for it. I have created that advanced password as well as in the video [this video]

Cites Benitez97 · 2020-06 · Stack Overflow · on “Compound Join doesn't display any data. MySQL”

So, I've been following a tutorial: [this video] And when i do the compound join it just doesn't display any data just the column names. code: SELECT * FROM order_item_notes oin JOIN order_items oi ON oi.order_id = oin.order_id AND oin.product_id = oi.product_id What the MySQL Workbench displays. [LINK] I couldnt find any issue similar to my problem, but maybe is the way it works this join? but it wouldnt make sense to me anyways, HELP ME. thx in advance. :) Edit: data from the tables that should be displaying. Table order_items [LINK] Table order_item_notes [LINK] Solved in the comments.

Cites Manoj · 2021-04 · Stack Overflow · on “ORDER BY without column name”

Solved Is it possible to execute a ORDER BY clause without column name? I am following this tutorial on mysql: [this video] (At 1 hour, 18 minutes in) MySQL Tutorial for Beginners [LINK] In this tutorial it is mentioned that if no column name is specified with the ORDER BY clause it considers primary key as the column by default. but this dosen't seem to work when I try this: SELECT * FROM customers ORDER BY as said in the tutorial. [Note] customer_id is the primary key in the customers table.**

Cites user11838329 · 2021-10 · Stack Overflow · on “Is SELECT * clear enough to specify which query we are referring to?”

I am new to mySQL. I am following Mosh's tutorial [this video] to familiarize myself to SQL. Here's my question for the following code. SELECT * FROM order_items WHERE order_id = 6 AND unit_price*quantity > 30 When I looked up about SELECT * , it says: * means to return all all columns of the queried tables. Then I think SELECT * means that it grabs all tables from all schema. My question is : Isn't it a bit inefficient and confusing to return all column provided my understanding is right? If the database become bigger and bigger, it will consume unnecessary effort to look up the keyword, so I think SELECT should specify what table it is referring to. Thanks for reading!

Cites bobsmith76 · 2022-07 · Stack Overflow · on “MySQl Error Code: 1273. Unknown collation: 'utf8mb4_0900_ai_ci'”

I realized this question has been asked many times but all of the available solutions I've tried are not working. I'm getting an error code: CREATE TABLE `payment_methods` ( `payment_method_id` tinyint(4) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`payment_method_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8mb4_general_ci Error Code: 1253. COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8' For some reason that does not stop the code but later I'm get another error which actually does stop the code CREATE TABLE `payment_methods` ( `payment_method_id` tinyint(4) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY

Cites bobsmith76 · 2022-07 · Stack Overflow · on “Cannot find mysql bin file in macos”

I am having a lot of problems with mysql on macos 10.14. It started with trying to reset my password. Back when I collaborated with someone in 2018 my collaborator used mysql but I did not know how to work it. I have a feeling that the password I used for mysql is not the typical password I used because my attempts to log in failed. watching this video [this video] I was told at 9:12 that the password would be set on installation but that turned out to be false. I was never asked for a password upon downloading but perhaps that is because I had part of mysql already downloaded on my computer but I did not have the workbench installed. All of my attempts to reset the password failed. So I then tri