Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Entrepreneurship MySQL

MySQL/SQL Data Analytics: Beginner to Advance ||Hindi|Urdu||

Learn to write Complex SQL Quarries with MySQL EASIEST WAY in Hindi , Get Most In Demand Skill to Upgrade Your Career.
Rating: 4.5 out of 54.5 (78 ratings)
4,472 students
Created by Dr. Ahmad Mohsin PhD
Last updated 11/2020
Hindi
30-Day Money-Back Guarantee

What you'll learn

  • Write Complex SQL Quarries
  • Create Complex Many to Many Relational Databases
  • Get the Most In demand Skill of the Time.
  • Learn Most Famous Database MySQL
  • Analyse Data using SQL Quarries
  • Get all the Concepts in-details of SQL
  • Become Proficient MySQL DBMS

Requirements

  • PC or Laptop with Internet Connection
  • No SQL, or MySQL Experience required
  • No Programming Experience Required
  • A Smile...:)

Description

I distilled all my experience in this course,This course is not watch me over the shoulder, but you will get your hands dirty with coding from the beginning. This Entire course is developed in your mother tongue and learning MySQL or SQL can never be easier than this.

Are your Confused about MySQL and SQL? MySQL is Database Management System, while SQL is a language.

Do you want to learn SQL and but you dont know where to start.Do you want to learn MySQL but are too intimidated. Skills you will learn here can apply to MongoDB, PostgresSQL,Oracle SQL and Microsoft SQL.

You want to get the most in demand skill  by recent employer Survey,but, don't know which is the most comprehensive course. Congratulations.

You have made the right choice,

This course will take you from beginner  from No, Coding or Database experience in SQL and MySQL to an professional level where You will easily be able to understand and use concepts like Aggregate functions, Many to Many relations , Stored Procedures, and User defined Functions and Much More advanced concepts  along with their application to real world databases which will be provided in the course.

In this course along with many things, you learn


1- Learn to Write MySQL Quarries

2- Learn More Advanced Concepts like Aggregate functions,Many to Many relations,Stored Procedures and User defined Functions.

3- Learn to Use Tableau to Visualize Data and Make Smart Decisions

4- You will work with large databases mimicking real world application.

5- 9 Hours of exhaustive SQL Programming in which you will learn to see data from different perspective.

6- Last Three Sections Dedicated to Challenges to test your skills to the limit.


Abir Shaw

  • you are great teacher...But please make screen size bigger to see the code properly.


Divya Sharma

  • this was very great experience. Good course. i learned a lot.


Hrishi Bargal

  • The way of teaching is Excellent..!


Souman Shit

  • The course was very good, He has put each and every topic in a proper and detailed manner. One of the best courses i have ever done.

  • Keep it up Mohsin! Looking forward for more training from you.


Bibek Gupta

  • Excellent course for mysql.


Akkesh

  • nice explanation. good hear amazing voice


This course comes with Udemy's 30 days Money Back guarantee, This is the deal you can never go wrong


I have 100% response rate , so I will always be there to respond to your questions. And of course after Completing this course not only you will built your portfolio but also get Certificate of completion which you can post on your linked Profile and Attract potential Employers.


Enroll now and lets get started...

Who this course is for:

  • SQL Developer, Database administrator , Data Scientists and Machine Learning Students
  • People Looking to Solve Complex Business Problems using Power of Data and Generate Reports
  • Sales and Marketing Personnel looking to enhance their Capability using Power of Data and Generate Reports
  • Web App Developer looking to Build Web Apps for the Future
  • People Interested in getting the most in demand Skill and Upgrade their Career.
  • Business Managers and Entrepreneurs Who are looking to get more insight from Data

Course content

20 sections • 178 lectures • 9h 10m total length

  • Preview04:50
  • Preview04:56
  • MYSQL Cheat Sheet DOWNLOAD
    00:01

  • Preview05:35
  • 2nd_Data Manipulation Language
    06:52
  • Preview03:05
  • 4th_Transaction Control Language
    05:54

  • Preview04:37
  • Database Design Basics
    06:07
  • Primary Key
    03:27
  • Preview04:16
  • Unique Keys.
    03:38
  • Data Base Relationships.
    05:21

  • Installing MySQL
    09:07
  • Preview07:20

  • CREATE DATABASE
    05:04
  • CODE:
    00:01
  • Introduction to Datatypes.
    02:58
  • String Datatypes Part_1
    03:48
  • String Datatypes Part_2
    04:32
  • Integer Datatypes
    03:43
  • Preview05:12
  • Floating Datatype
    05:38
  • DATETIME Datatype
    05:55
  • CODE DATATYPES
    00:02
  • Preview05:56
  • Understanding SELECT Command
    04:25
  • CODE SELECT
    00:03
  • Understanding DELETE COMMAND
    04:02
  • CODE Understanding DELETE COMMAND
    00:01

  • Primary Key
    04:30
  • Code Primary Key
    00:03
  • Preview06:39
  • FOREIGN Key Part_2
    03:24
  • CODE FOREIGN Key
    00:07
  • Unique Key
    03:46
  • CODE Unique Key
    00:04
  • Preview03:18
  • CODE
    00:04
  • CHECKING DEFAULT CONSTRAINT
    02:53
  • CODE : CHECKING DEFAULT CONSTRAINT
    00:14
  • NOT NULL
    02:47

  • SQL Tips Part_1
    05:26
  • Coding Tips Part_2
    05:33
  • Code
    00:09
  • LOADING DATABASE
    02:34

  • SELECT_FROM
    05:02
  • CODE_ SELECT FROM
    00:03
  • WHERE Command
    05:08
  • CODE:
    00:01
  • Preview03:52
  • CODE AND
    00:02
  • OR Operator
    04:49
  • Code:OR Operator
    00:02
  • OPERATOR PREFERENCES
    04:54
  • CODE:OPERATOR PREFERENCES
    00:02
  • IN Operator
    03:32
  • CODE:IN Operator
    00:04
  • Preview01:02
  • CODE:Operator
    00:04
  • LIKE_NOT_LIKE Operators
    04:34
  • Code:LIKE_NOT_LIKE Operators
    00:01
  • A Note on WILD CARDS
    01:27
  • BETWEEN_AND Operator
    02:38
  • CODE:BETWEEN_AND Operator
    00:02
  • IS NOT NULL OPERATOR
    02:22
  • Other COMPARISON OPERATORS
    06:01
  • CODE:Other COMPARISON OPERATORS
    00:01
  • SELECT DISTINCT
    01:45
  • CODE:
    00:01
  • Preview07:06
  • CODE: Aggregate Functions:
    00:01
  • ORDER BY OPERATOR
    03:14
  • CODE:ORDER BY
    00:01
  • GROUP BY OPERATOR
    06:39
  • CODE:GROUP BY
    00:02
  • Usage of Aliases
    02:37
  • CODE:Usage of Aliases
    00:02
  • HAVING
    04:36
  • CODE:HAVING
    00:03
  • WHERE vs HAVING Which One to USE
    05:31
  • CODE:WHERE vs HAVING Which One to USE
    00:03
  • LIMIT Operator
    05:11
  • Code:LIMIT Operator
    00:02

  • INSERT STATEMENT
    06:59
  • CODE: INSERT Statement
    00:02
  • Duplicating Data
    06:31
  • CODE:DUPLICATING TABLE
    00:04

  • START Transaction and ROLL BACK
    03:02
  • Preview05:51
  • CODE:UPDATING Table Entries
    00:04
  • ROLLBACK
    03:34
  • CODE:ROLLBACK
    00:03

Instructor

Dr. Ahmad Mohsin PhD
Engineer ,Programmer and Tutor
Dr. Ahmad Mohsin PhD
  • 4.4 Instructor Rating
  • 1,900 Reviews
  • 52,784 Students
  • 10 Courses

Founder of datascience.university. Mohsin Khalil Ahmad Served as Lecturer in Well reputed University and is linked to Academia for last 6 years. He is PhD in aerospace engineering. He has been using Python for scientific computing, Data Analysis and Machine Learning for last 10 years.

Mr. Mohsin Khalil have worked as Research Engineer in AeroTraNet2 Project which Included top European Aerospace Industries Like Airbus France, Von Karman Institute for Fluid Dynamics(VKI) Brussels  and Universities like Uni Leicester London,UK

Mr. Mohsin have won numerous awards, including ,Erasmas Mundas Scholar, Marie Curie Fellow, Italian National Research Award and counting and have authored numerous research articles.

You are being taught by the best of the best.



  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.