SQL-for-Data-Analytics
SQL-for-Data-Analytics copied to clipboard
TrainingByPackt
Perform fast and efficient data analysis with the power of SQL
I have created the data base sqlda but when I try to load it with data using "psql -d sqlda data.dump" it gives me the following error: psql: error: FATAL:...
I initially tried to load this dump and received an error regarding the owner of the tables. I removed all references to Owner ben and the dump loaded correctly. This...
i cant download the data.dump, everytime i clicked the "download" button for it, it instead opened the file on the browser,I also tried but also couldn't,is there a way I...
how this book is different from same authors the applied analytics work shop ?
When doing a select * from sales_transaction_date, there is no "count" listed so the Step.2 fails to execute. in fact, bat_sales_daily does not exist either, but sales does exist. SELECT...
In the book, it states "To install the database on PostgreSQL, copy the data.dump file from the Datasets folder in the GitHub repository of the book.......Then, load the data.dump file...
Hi, Are the csv files still available. I am not able to download any of them. I do not see an option to. If I right click on the file...
Hi there, I'm getting an error in the line I'm writing. I get: ERROR: relation "customers" does not exist LINE 4: FROM customers BUT customers do exist. 
This code didn't work when I ran it. Is it because it is written as?: `sqlda$# END; $channel_avg$` and should be?: `sqlda$# END; $sales_avg$`
Metadata
Owner
Metadata
Perform fast and efficient data analysis with the power of SQL