₦airaland Forum

Welcome, Guest: RegisterLoginWith GoogleTrendingRecentNew

Stats: 3,325,003 members, 8,419,885 topics. Date: Thursday, 04 June 2026 at 06:18 AM

Toggle theme

SQL -MySQL Tutorial for Data Analytics and Business Intelligence - Programming - Nairaland

Nairaland ForumScience/TechnologyProgrammingSQL -MySQL Tutorial for Data Analytics and Business Intelligence (1569 Views)

1 Reply (Go Down)

SQL -MySQL Tutorial for Data Analytics and Business Intelligence by dauddy97(op):
MySQL is a platform for writing query languages.
Brief introduction, Installing MySQL
and Getting Acquainted with the Interface.


The program we will be working with in this course is called MySQL
Workbench. It is the Oracle visual tool for database design, modelling,
creation, manipulation, maintenance, and administration. Professionals
refer to this type of software as “Integrated Development Environment”
or IDE. So, Workbench will be our IDE.

And, if you wonder what Oracle is,
this is the software company that owns
the MySQL version of SQL.

You could also wonder why we would need a server. Sticking to the basic
theory of operation of computer networks, MySQL Workbench acts as a
client program – a client of a MySQL Server. The server is, practically, nothing more than a machine that provides
data and services to the same or other computers.

The data could be provided locally or online. Regardless whether the
server is installed locally on your computer or is being accessed
remotely over the internet from another computer, you will need a Server
to use MySQL. In our case, we installed the server locally. Briefly, the server will perform all calculations and operations you execute in
Workbench. You will be writing queries through the Workbench interface, in the
form of raw code, which MySQL server understands and processe.
Finally, when it finalizes its calculations, it will bring the respective
results back to you in the form of an output displayed on your screen.
Watch this YouTube video on how to download and install MySQL
https://www.youtube.com/watch?v=WuBcTJnIuzo
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by dauddy97(op):
Tutorial continue tomorrow.....I am not gonna rush anything, I will try and explain to the last letter. typing no easy.
Topic to cover tomorrow - Terminologies in MySQL.
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by dauddy97(op):
.pls, pardon me for not continuing. I have been busy
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by dauddy97(op): 2:08pm On Jan 12, 2020
.h
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by dauddy97(op): 2:09pm On Jan 12, 2020
h
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by dauddy97(op): 2:09pm On Jan 12, 2020
hj
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by NIKEDEEDS(m): 2:42pm On Jan 12, 2020
Am in
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by untoldtools: 3:47pm On Jan 12, 2020
You got a follower bro.

Please kept at it. Thank you.
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by MyChoice1: 5:45pm On Jan 12, 2020
dauddy97:
Tutorial continue tomorrow.....I am not gonna rush anything, I will try and explain to the last letter. typing no easy.
Topic to cover tomorrow - Terminologies in MySQL.
Great! I'm in
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by yusufobinna1(m): 7:29pm On Jan 12, 2020
I'm game
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by id2011(m): 7:38pm On Jan 12, 2020
Okay
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by Folaoni(m): 10:20pm On Jan 12, 2020
Following
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by Enzymes101(m): 1:17pm On Jan 13, 2020
i stand gidigbam with you on this one Bro
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by IceColdVeins(m): 1:40pm On Jan 13, 2020
Following
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by yusufobinna1(m): 7:39pm On Jan 16, 2020
Following bro
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by Knox123(m): 8:03am On Jan 18, 2020
grin
Re: SQL -MySQL Tutorial for Data Analytics and Business Intelligence by Pato5(m): 8:53am On Jan 18, 2020
@OP your statement is not correct.
Microsoft owns MySQL not Oracle.
Oracle owns SQL and PL/SQL
I used the later at work.
While the both work the same way, their key words and syntax differ a bit. if you can write scripts in one, you can understand the other.
1 Reply

My Data Analytics JourneySpring Boot Tutorial For BeginnersWho's Interested In Learning Python For Data Science (from Scratch)234

Project Topics HereCreating A SoftwareWhich Course Would You Pick?