fbpx

MySQL for Beginners

Muhammad Usama, BSC-IT, MSCS-DS
Learn MySQL inside out & jumpstart your career in field of data analysis and database management
MySQL for Beginners - Person 18 4.72 18
MySQL Course
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

  • Data analyst
  • Business analyst
  • System analyst
  • Data engineer
  • Data Scientist
  • Database developer
  • Database administrator
  • Full stack developer

  • Topics Covered

  • Overview of MYSQL
  • MYSQL client and Server model
  • MYSQL Command line tool
  • MYSQL workbench
  • Data Types
  • Functions
  • Basic Queries
  • Complex Queries
  • Union & joins
  • Subqueries
  • Create Database & Tables RDBMS
  • Modifying Tables & Database
  • Securing Database
  • Backup Database & Trouble shooting in database

  • Requirements

    No Pre-requisites required. You just have basic knowledge of database.

    Muhammad Usama MySQL Course Trainer

    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.

    Course Ratings & Reviews

    MySQL for Beginners - Person
    18 4.72 18
    4.72 out of 5 stars

    5 star 78%
    4 star 17%
    3 star 6%
    2 star 0%
    1 star 0%

    Reviews

    Scroll to Top