Working With SQL Databases From R: Introduction & Connecting To Databases

The portal.sqlite file can be downloaded here: ndownloader.figshare.com/file...
Notes on how to create a file like this from CSV files are available here: datacarpentry.org/semester-bi...

[@snaponsmile4938]

This video answered all my questions , great instructor

[@weecology]

Thanks!

[@swghavoc]

Thank you for making it simple to understand.

[@helenindianara897]

Muito Obrigada por este vídeo! Simples e fácil! Parabéns!

[@julianamendes9943]

Thanks so much for your video, your expplaining way is very easy even for a brazilian person, great teaching method.

[@weecology]

Glad it was helpful!

[@karthikkumarkarthikkumar3531]

such easy way of teaching ,your teaching skills amazed me understanding such difficult thing easier. thank you so much

[@weecology]

Thanks! I so glad it is helpful!

[@Dingelkorn]

thanks for the introduction!

[@weecology]

You're welcome!

[@shichengguo8064]

Great video!! It will be great to make the 1st step as how to prepare the portal.sqlite

[@weecology]

Glad it's helpful. I added a link to download that file and another link describing how to create one in the video description. Let me know if you need anything else.

[@Hipno70]

On point. Thanks!

[@weecology]

You're welcome!

[@marianklose1197]

great video, thank you!

[@weecology]

Thanks!

[@birasafabrice]

thank you for the tutorial!

[@weecology]

you're welcome!

[@Antowan]

Great video Thanks!

[@weecology]

You're welcome!

[@cuysaurus]

Nice ASMR, bro.

[@hell_Lofi.musicx]

if i have a superstore CSV file and I want to select max sales where Region should be South/East/west/North with Order dates b/w (i.e:- 01-02-2019 to 01-01-2021).

[@vincentchirimwami6599]

Hello. Could you, please, put numbers on the videos? I am not sure which video to go to after watching a video. Great teaching by the way.

[@weecology]

Thanks! The quickest way to give you an answer is that the order is the same as in this playlist kzbin.info/aero/PLD8eCxFKntVH5EJmTBaZXWaU8cM_T9Lfl The Working with SQL Databases is all the way down at the bottom of the playlist. Hope that helps!

[@weecology]

And I just added a playlist with just the Working with SQL Databases from R in the right order for you as well: kzbin.info/aero/PLD8eCxFKntVG4WztMnn3khib9v7TTgPTT

[@FJ-ow5lm]

Do you have the video that connects to MySQL Workbench? I saw the database from MySQL Workbench on the "Connections' pane but when I use 'dbListTables (dbname), it says this: Error in h(simpleError(msg, call)) : error in evaluating the argument 'conn' in selecting a method for function 'dbListTables': object 'spear' not found

[@weecology]

I don’t. Sorry. It’s been a few years since I worked with MySQL.

[@joshstat8114]

Creating SQL Database connection using connection panel in RStudio?

[@AlphaRhoDelta]

What do you mean "path to database file"?

[@weecology]

The location of the database file on your computer. We’ve got a video on paths that might be useful in figuring out how to write this kzbin.info/www/bejne/aKS1loCjibKMfM0

[@common_wolf]

what if I'm using SSMS?

[@weecology]

To connect to SQL Server you’ll need to use the ODBC package. There’s a brief introduction here solutions.posit.co/connections/db/getting-started/connect-to-database/ Hope it helps!

[@stephensaucedo2746]

Getting character(0) when I show tables. Do you know how to fix this? :/

[@weecology]

If this is happening when using dbListTables this probably means you didn’t connect to our database file and so R created an empty one. Check that you’ve downloaded the file linked in the description, that it is in your working directory, and that the name when you run dbConnect() matches the file name exactly (including the file extension)

[@stephensaucedo2746]

Hello thank you for your help. The tables are now showing, but now I have a new error. When I reference a table it says object not found. Do you know why this is happening? The tables were working fine at first but I had to close and reopen R and that is when the problem arose.@@weecology

[@weecology]

@stephensaucedo2746 since you restarted R you’ll need to rerun all of the code to recreate the connection to the database