Somebody please help with where i can download SQL to my system. and which is best between MySQL and Microsoft SQL.

Thank you in advance.

Hello Guys! Please, are there more advanced MySQL functions out there, coz I feel like I know them all.... From "ranks" to "views" to "stored procedures" to more "advanced sub-queries". I am no expert, I just wanna learn something new and different on MySQL. Searching for advanced MySQL videos on YouTube still leads me to the ones I listed above or functions on other server like postgre, Microsoft server etc.. (which I don't use). I have done and posted few sample Data Analysis projects here on nairaland. Plz Kindly view my profile and see if there are more things I need to know and Improve on. Thank you.

Is this still on?
I am also interested.
I want a group that we can learn together as a beginner. I am at the verge of going to register for a course at a training school

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Raalsalghul:


What's up guys? I know it's been long since I posted here: been busy with going back to school, work and other stuff.

I remember giving the above advice the last nine months and I'll like to say that as of today, it still stands most especially from my experience working as a data analyst with an NGO while doing my MSc.

I can't emphasize it enough: learn your SQL. Again I repeat, learn your SQL if you are to switch to anything data related: whether a data analyst, scientist or engineer.

Most organizations have databases which you'll use SQL to interact with. I'm saying this because sometimes I feel there's too much emphasis on learning Python. Don't get me wrong; python is important in the world of data but it should be like number 4 on your learning list with spreadsheets and BI tools before it.

In addition to the above, I would advise you work with larger databases when practicing: the table I've been working with had about 120000 rows by 220 columns and it was just one table out of about 300 Quite large when you compare it to the ones used on your Udemy tutorial or YouTube or even Kaggle.

I'm not saying this to discourage anyone, just giving you an insider perspective. I would post more tidbits when I have the time.

Good evening boss.

I'll be going for NYSC once ASUU call off the strike. How can position myself for an opportunity to work with an NGO or any corporation as a data analyst during my service year?

I will appreciate your insights on this.

Thank you.

Rilwayne001:
Somebody please help with where i can download SQL to my system. and which is best between MySQL and Microsoft SQL.

Thank you in advance.

I don't know which is the best but you can download MySQL by searching "mySQL download" on Google.

You can check out a YouTube video on how to install it.

Hinokami:

Please who has done web scraping on indeed.
I want to scrape job listings as a project but when i parse the html it is different from what i see from the page inspect tool. Ie it is less.
Is there a way to get the real content of indeed.com so i can scrape it?

I have done that on two different occasions.

lovelybobo:


I have done that on two different occasions.

Thank you for replying.

I have an issue with the url per se.

When I run my code and view the scraped page using prettify, I don't get the same thing as when inspected on the original page.

Hence I am no able to get to the elements I need.

Any way around this?

Hinokami:


Thank you for replying.

I have an issue with the url per se.

When I run my code and view the scraped page using prettify, I don't get the same thing as when inspected on the original page.

Hence I am no able to get to the elements I need.

Any way around this?

You may need to use selenium to automate scrolling down so more job postings are loaded before scraping.

extendo:


You may need to use selenium to automate scrolling down so more job postings are loaded before scraping.

Let me rephrase my issue a bit clearly.

The raw html I see on document inspector isn't the same when I scrape it.

I have completed my project though. I used glassdoor even though it had lesser data points that I needed from indeed.

KlausMichaelson:



What I have noticed about Nigerian data analysts (mainly the show-offs) is that they all think data analysis is all about creating dashboards(visuals) as though they are graphic designers. And I can bet it that they didn't really do much of any cleaning and wrangling of data, otherwise they will show that part as well: trust Nigerians.

I don't see Whites post things like dashboards. To them, it's just a normal thing. The 70-80% of an analyst job is spent more on cleaning and preparing the data. This is where the knowledgeable of SQL, DAX, Pandas, Excel Functions comes in.


Simply put, Nigerian Data analysts are more of graphic designers while the white counterpart are much more than that: they are just like the scientists of the data itself. Your dashboards doesn't really tickle their fancy.


Follow them, you will understand that Data analysis has a long way to go in Nigeria.

Ps: I may be wrong, but that's my opinion.

Bro, you just said my mind.

You'll be surprised to know that most of these guys running up and down with dashboards don't really do more of data cleaning, not to talk of modelling, and some rich DAX.

Hello guys so I started learning frontend web development now I got a fully covered financial aid from Google to study data analysis for a period of 9months.
Though I plan on continuing my frontend web dev. So I will be learning both..

Guys what advice will you give me..

N:B , I'm a 200lv student of microbiology in a federal unu

FishFisher:

Boss.
Gooday ,
U fit help me send this book:
Automate the boring stuff with python(2015)
by
Al swelgart.

fisherwills@yahoo.com

Boss abeg you fit help me send the book....

ikojiee34@gmail.com na the Gmail

Honlucas:
Hello guys so I started learning frontend web development now I got a fully covered financial aid from Google to study data analysis for a period of 9months.
Though I plan on continuing my frontend web dev. So I will be learning both..

Guys what advice will you give me..

N:B , I'm a 200lv student of microbiology in a federal unu

pls how did u get the Google scholarship

Promises40:
pls how did u get the Google scholarship

Register Coursera you will see goggle data analysis... Click it don't enroll for it oooo

Goan apply for financial aid first wait till you get it..

You will write an essay of min150 words why u need financial aid..

The course cost about 380k

Honlucas:


Register Coursera you will see goggle data analysis... Click it don't enroll for it oooo

Goan apply for financial aid first wait till you get it..

You will write an essay of min150 words why u need financial aid..

The course cost about 380k

ok

Honlucas:


Register Coursera you will see goggle data analysis... Click it don't enroll for it oooo

Goan apply for financial aid first wait till you get it..

You will write an essay of min150 words why u need financial aid..

The course cost about 380k

Did you get the financial aid for the entire 8 courses or for just one out of the 8 courses?

Marveaux:

Did you get the financial aid for the entire 8 courses or for just one out of the 8 courses?

8courses the financial aid covers everything

Honlucas:


8courses the financial aid covers everything

Really?? When I tried applying I could only pick one out of the 8 courses, how did you do yours?

For each course in the program you have to apply for financial aid.

Marveaux:

Really?? When I tried applying I could only pick one out of the 8 courses, how did you do yours?

Hinokami:
For each course in the program you have to apply for financial aid.

Okay. Thanks

Marveaux:

Really?? When I tried applying I could only pick one out of the 8 courses, how did you do yours?

Bleep u don do mistake guy...

See this Is my whatapp number
07011149544

Make I explain am give you well with screenshot

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Wow, Im interested

WhatsApp. 07016049693

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

I am interested if this is not coming late.
0.8.zero.3.6.nine.7.1.seven.5.8

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

I am in for it. 09062163331.


God bless you.

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

Hello, is this still open?

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

INTERESTED BOSS
And what pdf will you recommend, Incase space don full make I usez that one hold body. Thanks in Advance Boss

Hinokami:

Please who has done web scraping on indeed.
I want to scrape job listings as a project but when i parse the html it is different from what i see from the page inspect tool. Ie it is less.
Is there a way to get the real content of indeed.com so i can scrape it?

I designed a web crawler for indeed. I didn't put time breaks in my code so i was extracting a lot of data per second and eventually my ip got banned. Indeed is relatively easy to scrape

Honlucas:
Hello guys so I started learning frontend web development now I got a fully covered financial aid from Google to study data analysis for a period of 9months.
Though I plan on continuing my frontend web dev. So I will be learning both..

Guys what advice will you give me..

N:B , I'm a 200lv student of microbiology in a federal unu

A lot of data analyst/ scientists come from social/biological sciences. But i believe you'll find it easier to get a web dev job

cochtrane:
I want to arrange a free SQL training for interested participants. Let me know if you are interested and depending on the number of participants we can put together a schedule.

I am also interested......

Raalsalghul:


Send me a P.M, I'll reply your mail with the username and password.

BABA ABEG MAKE I SEND YOU PM I NEED AM LIKE YESTERDAY I STUDY A COURSE

Please guys help...

I just started learning SQL and I'm using MySql Workbench.

I seem to have issues trying to create a simple table and each time I tried, I will get a syntax error message. I have watched videos but can't see what I'm doing wrong.

My code is;