Data Analysis
A simple & concise MSSQL course (applicable to any SQL), perfect for data analysis, data science, business intelligence.
About this Course
This course is a selection of material from our larger Web Development course.
This course the fundamentals of data management with SQL and MySQL in this course. Learn all you need to know about SQL, the most widely used computer language for handling data. Essentially, this course is about SQL commands. You’ll discover the fundamentals of inquiries.
Included Product
Rich Learning Content
Taught by Industry Pros
Self-Paced Learning
What You Will Learn
MODULE 1
DBMS
-
Understanding and installation
-
Access, Create and Update data stored in a Database
-
Perform complex queries by learning essential query keywords and functionality.
N10,000
MODULE 2
DBMS
-
Database Administration
-
Administrator duties and creating users
-
Expand your SQL skills by constructing and manipulating databases with several connected tables.
N10,000
Outcome
Upon successful completion of this course, you should be able to:
- Utilize the MySQL DBMS to build and modify relational databases with SQL.
- Understand MySQL database maintenance tasks.
- Create relationships between tables using primary and foreign keys.
SKILLS YOU WILL GAIN
- Data Management
- Database (DMBS)
- Relational Database
- Database Administration
- MySQL
