SQL Tutorial - Full Database Course for Beginners
Why Stack Overflow recommends it
Stack Overflow users point beginners to it as a free, complete SQL starting point, and many learners cite it as the tutorial they were following when they hit MySQL setup problems.
Recommended by 4 people across 4 different months, 2018 to 2022.
What it is
A 4h20m beginner course by Mike Dane on freeCodeCamp covering relational database basics and SQL using MySQL. It walks through installation, creating tables, CRUD operations, joins, nested queries, triggers and ER diagram design, using a sample company database.
What people said
Recommends Eric Hepperle - CodeSlayer2010 · 2018-12 · Stack Overflow · on “Disable ONLY_FULL_GROUP_BY”
This is exactly what I was looking for! Thanks for providing a simple WAMP Server solution! I needed this while trying to do #aggregation in this tutorial: [this video]
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 [LINK] , or here [LINK] , or here [this video] . Best of luck.
Recommends mattheeew · 2019-11 · Stack Overflow · on “need some resource on database learning”
I would recommend a SQL Tutorial by freeCodeCamp which is available on YouTube SQL Tutorial - Full course for beginners [this video]
Recommends SamBroGaming · 2020-10 · Stack Overflow · on “How to make a discord.py bot store info on users?”
The way I do it, and I use MySQL is to use mysql.connector. Honestly, I watched freecodecamp's video ( [this video] ) on how to set the db itself up. Then you follow Oracle's rather vague instructions on how to setup MySQL Connector, and then you use it by pulling stuff from it like ```people = mycursor.execute("SELECT discord_id FROM discordpy.pumpkinvalues")```
Cites Marek Juraszek · 2019-06 · Stack Overflow · on “How to delete rows from tables with foreign keys in SAP ASE Sybase 16”
I am trying to perform a row deletion from a table employee that has a primary key set on 'emp_id' column and is referenced by other tables with their foreign keys. Sybase does not allow me to perform the deletion. The example msg back is : Dependent foreign key constraint violation in a referential integrity constraint. dbname = 'giraffe', table name = 'branch', constraint name = 'client_800002850'. Command has been aborted. With MySQL it is possible to easily make this kind of deletion if you specifiy foreign keys with ON DELETE clause, but this is not supported by Sybase. The only optional clause for foreign keys in this RDBMS is 'MATCH FULL' How can one delete rows or set values to NULL
Cites ajp.gp4life · 2020-04 · Stack Overflow · on “What are the bash commands to setup or recognize a MySQL installation on a Mac?”
first post on so; let me know any advice on better asking Anyways, my current bash profile is: # added by Anaconda3 2019.10 installer # >>> conda init >>> # !! Contents within this block are managed by 'conda init' !! __conda_setup="$(CONDA_REPORT_ERRORS=false '/opt/anaconda3/bin/conda' shell.bash hook 2> /dev/null)" if [ $? -eq 0 ]; then \eval "$__conda_setup" else if [ -f "/opt/anaconda3/etc/profile.d/conda.sh" ]; then . "/opt/anaconda3/etc/profile.d/conda.sh" CONDA_CHANGEPS1=false conda activate base else \export PATH="/opt/anaconda3/bin:$PATH" fi fi unset __conda_setup # <<< conda init <<< ‘export PATH=/usr/local/mysql/bin:$PATH' I was getting this info from the tutorial, [this video] , ~1 ho
Cites DatMan · 2021-01 · Stack Overflow · on “MySQL 8.0 Command Line Client starts and stops immediately”
I have started this SQL Tutorial: [this video] and I installed MySQL and when I try to launch MySQL 8.0 Command Line Client it starts and stops immediately. I want to specify that during the instalation it never asked me to set a root password for the database like it asks the person in the video.
Cites TheShin · 2022-01 · Stack Overflow · on “MySQL 8.0 Command Line Client closes after I input my password”
I'm a total beginner at this, and I just installed mySQL by following a tutorial [this video] . My problem is that the mysql command line crashes after I input my password without any error messages. It just straights up exits itself after I enter the password. I've tried the following solution based on what I've found on the internet: Windows key + R and type services.msc Double click MySQL80 Change its startup type to Automatic But the steps above don't work for me. What else can I do? (If possible, can you please give me a step-by-step guide?) Thanks