Course Content
Introduction
Tools
Data Types & Functions
Understanding Queries
Database Creation & Management
Assessment
Final Words
MySQL for Beginners
Muhammad Usama, BSC-IT, MSCS-DS
Learn MySQL inside out & jumpstart your career in field of data analysis and database management
Play Video
31
Successful Students
60 min
Course length
408
Enrollments
Course Language
Urdu
Course Description
SQL is used everywhere Almost all of the biggest names in tech use SQL. Uber, Netflix, Airbnb — the list goes on. Even within companies like Facebook, Google, and Amazon, which have built their own high-performance database systems, data teams use SQL to query data and perform analysis. Everything uses SQL or a derivative of SQL. It’s in high demand because so many companies use it. SQL is still the most popular language for data work in 2021. In this course we will start with installation of workbench and Xampp and basics of MYSQL. What is DBMS and how we can create database and its table after that we will discuss datatypes and functions of MySQL. We will also discuss insert, update, delete and fetch query in this course. After that we will discuss that how nested queries work and how we can fetch data from more than two tables. How we can modify database and its tables. How to add relation between these tables using primary and foreign key. All these topics we will cover in this course with implementation.
Course Goals
The goal of this course is to learn about the fundamentals of relational DBMS i.e. how to Design relational databases, use a relational database, build a relational database, be able to create, access, and manipulate a database through SQL and from an application. Also to make concepts of normalization clear in order to build a good relational schema. To make students efficient enough to understand the problems and make out a relational database for the problem situation.
Audience
Anyone with an interest to start a career in databases as
Topics Covered
Requirements
No Pre-requisites required. You just have basic knowledge of database.
Instructor
Muhammad Usama is an aspiring data scientist. He has completed his BSC in IT and now currently pursuing MSCS in data sciences. He has good experience of developing web and mobile applications. He is also a full time instructor.
You can contact him on LinkedIn here: Muhammad Usama
He also runs a YouTube channel here
His GitHub repository is located here
Other Courses by Instructor
What you will get upon completion
You will know how to write SQL queries and how to perform all important SQL tasks. After course completion, you can also get a course certificate for a fee that you can show to your prospective or current employer to demonstrate your proof of competency and skill on this subject.
This is your sample QR verifiable certificate
Special offers
No special offers are available at this moment.
5 star
78%
4 star
17%
3 star
6%
2 star
0%
1 star
0%
Reviews
ByCreated Suyog Rane (2022-11-04 19:36:05)
Whole Course
ByCreated Muhammad Nawab (2022-11-04 03:54:29)
This was a great course .I learned new things .The instructor was sincere and he explained everything step by step..Really this was a good time with osama
ByCreated Syeda Arooj Fatima (2022-09-23 20:29:31)
Very informative
ByCreated Faran Ahmad (2022-04-01 11:44:18)
It really amazing to learn SQL basics , thanks
ByCreated Mirza Toheed Arsal (2021-12-26 07:57:55)
Good Couse To Learn
ByCreated mobeen butt (2021-11-29 08:45:46)
excellent explanation. good effort by sir usama.
ByCreated Muhammad Nawab (2021-11-14 04:55:06)
This was a great chance for me to learn .usama is a great teacher .He thaught everything step by step I learned everything .thanx usama .may live long.thanx
ByCreated Muhammad Shahzad DAUD (2021-11-06 03:46:02)
Good
ByCreated Muhammad Sufyan (2021-06-08 03:13:00)
Excellent
ByCreated MUHAMMAD Yousuf (2021-05-31 11:52:34)