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+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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 Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business 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 Business Analytics & Intelligence SQL

SQL/MySQL Database Developer: Zero to Expert||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.1 out of 54.1 (155 ratings)
5,535 students
Created by Dr. Ahmad Mohsin PhD
Last updated 11/2020
Hindi
30-Day Money-Back Guarantee

What you'll learn

  • Create Complex Many to Many Relational Databases
  • Build A Web App Using Most Powerful Web Frame Work Django and mySQL
  • Write Complex SQL Quarries
  • Get the Most In demand Skill of the Time.
  • Learn Most Famous Database MySQL
  • Analyse Data using SQL Quarries

Requirements

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

Description

As Ex-Assistant Professor,I distilled all my experience in this course,This course is not watch me over the shoulder, but full of exercises, challenges and quizzes and you will get your hands dirty with coding from the beginning.

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,and many more.

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 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- Analysed a Linkedin Database

2- Write Quarry and Built Udemy Course review App.

3- Built MySQL/SQL powered Web Application as Bonus Section.

4- Solve More than 120 Exercises and Challenges.

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

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

7- Entire Sections Dedicated to Exercises and Challenges which will test your Knowledge.

8- You will learn about Django Web Frame work and How to connect it with MySQL as Bonus

9- You will learn how to write and Execute SQL Quarries in Python code As Bonus.


Here is what other Students like you say about this course.

Aditya Bohra-5 Stars

  • Easy Explanation given by the sir, I am very thankful to the sir because the fear of coding for me is gone now , The way of teaching is really awesome. This course is really good for the beginners.


Gaurav kumar-5 Stars

  • this great course in Hindi. you should make a course for python.


Prasad Gundelli-5 Stars

  • I literally loved the way of explanation.


Sajid Shaikh-5 Stars

  • Explanations were crystal clear and tutor is friendly as well, really loved this course. Would recommend for people who speak Urdu and Hindi


Xmart Rocky-5 Stars

  • Amazing Course With Funniest Teacher.



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.

Course content

17 sections • 183 lectures • 17h 22m total length

  • Preview06:51
  • Preview07:23
  • About Quizzes and Exercise
    01:28
  • COURSE CHEAT SHEET DOWNLOAD
    00:01

  • Preview00:59
  • Please Don't Skip this
    00:22
  • Installing-MySQL
    09:07
  • MySQL-Workbench-Interface
    07:20
  • MySQL Shell_IMPORTANT
    03:55
  • What is Database?
    08:46
  • SQL vs mySQL
    06:08

  • Preview07:32
  • Dropping Databases
    06:51
  • Using Databases
    05:19
  • Introduction to Tables
    05:56
  • Intro to Tables P_2: Basic Datatypes
    08:06
  • Datatypes Homework
    01:29
  • Creating Your Own Tables
    08:33
  • How to Know if Tables Created
    04:23
  • Dropping Tables
    04:48
  • Dropping Tables Exercise
    05:03

  • Preview01:18
  • Inserting Data
    09:42
  • Inserting Multiple Entries
    03:09
  • Solution Exercise Multiple Entries
    03:33
  • Errors and Warnings
    04:51
  • What is NULL and NOT NULL
    09:18
  • Setting Default Values
    11:07
  • Unique ID of Data
    15:19
  • Section 4 Exercise and Solution
    07:00

  • Introduction to CRUD
    02:03
  • Preparing Our Data
    04:05
  • Official Introduction to SELECT
    04:38
  • Introduction to WHERE
    04:14
  • SELECT Challenges Solution
    05:43
  • Introduction to Aliases
    04:30
  • The UPDATE Command
    06:21
  • UPDATE Challenges Solution
    06:49
  • Introduction to DELETE
    05:39
  • DELETE Challenges Solution
    03:49

  • Preview06:45
  • READ Exercise and Solution
    03:04
  • UPDATE Exercise and Solution
    06:58
  • DELETE Exercise and Solution
    05:04

  • Section Road Map
    01:34
  • THE SOURCE Command
    11:02
  • Loading Books Data
    07:24
  • CONCAT Explained
    18:14
  • SUBSTRING Explained
    13:16
  • REPLACE Explained
    08:31
  • REVERSE Explained
    01:09
  • CHAR_LENGHT and UPPER Explained
    04:02
  • STRINGS Exercise BASIC
    10:49
  • STRINGS Exercise ADVANCED
    11:21

  • Preview02:34
  • CODE:ADDING BOOKS DATA
    00:06
  • Accessing DISTINCT Entries
    06:35
  • CODE:Accessing DISTINCT Entries
    00:13
  • Organizing Data with ORDER BY
    14:21
  • CODE: ORDER BY
    00:14
  • Limiting Data
    11:19
  • CODE: Limiting Data
    00:11
  • LIKE and WILD cards PARt_1
    08:14
  • LIKE and WILD cards PART_2
    09:19
  • code:LIKE and WILD cards
    00:07
  • EXERCISE and SOLUTION Part_1
    06:54
  • EXERCISE and SOLUTION Part_2
    19:25
  • CODE: Sec 8 Solutions
    00:14

  • Preview01:46
  • COUNT(*) Function Magic
    08:59
  • Code:COUNT(*) Function
    00:08
  • GROUP BY
    12:01
  • CODE:GROUP BY
    00:07
  • Spices of MIN and MAX
    10:36
  • CODE:MIN and MAX
    00:08
  • MIN and MAX with GROUP BY
    04:33
  • CODE: MIN and MAX with GROUP BY
    00:03
  • Abundance of SUM
    06:03
  • Code:SUM
    00:07
  • AVG of Average NOT bad
    06:16
  • CODE:AVG
    00:04
  • SEC_9 MEGA EXERCISES and SOLUTION
    15:08
  • CODE:SEC_9 MEGA EXERCISES and SOLUTION
    00:09

  • Diving Deep into DataTypes.
    08:21
  • REFERENCE GUIDE TO DATETIME FUNCTIONS
    01:31
  • CODE Diving Deep into DataTypes
    00:12
  • Breaking Numbers
    07:04
  • If You Cant FLOAT then DOUBLE
    03:10
  • CODE FLOAD and DOUBLE
    00:04
  • Its ALL ABOUT TIME
    05:52
  • Employees Attendance DATABASE
    05:36
  • CODE:Employees Attendance DATABASE
    00:09
  • POWER OF NOW()
    13:39
  • CODE:POWER of NOW
    00:12
  • WHEN DAYS ARE NUMBERED
    11:36
  • CODE: Arithmetic on DATETIME
    00:07
  • STAMP IT WITH TIME
    08:55
  • CODE: STAMP IT WITH TIME
    00:09
  • MEGA KING KONG EXERCISE with SOLUTION
    11:07
  • CODE:MEGA KING KONG EXERCISE with SOLUTION
    00:15

Instructor

Dr. Ahmad Mohsin PhD
Engineer ,Programmer and Tutor
Dr. Ahmad Mohsin PhD
  • 4.4 Instructor Rating
  • 1,928 Reviews
  • 52,838 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
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.