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 Personal Development Mindfulness Meditation Personal Transformation 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 Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing 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
Development Database Design & Development MySQL

SQL Course For Beginners: Learn SQL Using MySQL Database

Learn SQL From Scratch Using MySQL Databases, A Complete SQL Course For Beginners
Rating: 4.5 out of 54.5 (1,491 ratings)
9,223 students
Created by Ashutosh Pawar
Last updated 4/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Understand what are database and why they are used.
  • How to write SQL queries to insert, update and delete data into database.
  • How to write SQL queries to manipulate data.
  • How to write complex SQL queries to obtain useful information from the database.
  • Learn how to create database tables using SQL commands.
  • Learn SQL operators to write complex SQL queries.
  • Learn how to perform different types of join operations.
  • Learn about different SQL functions and constrains.

Course content

11 sections • 76 lectures • 4h 51m total length

  • Preview03:11

  • What are databases and why do we need them
    Preview05:19
  • Preview01:43

  • Installation steps for Windows users
    05:41
  • Installation steps for Mac users
    05:07
  • Installation steps for MAC
    01:14
  • Installation steps for Linux
    00:37

  • Creating a new database
    05:19
  • Creating a table in database
    05:57
  • Preview05:01
  • Using the SELECT clause
    04:36
  • Using the SELECT DISTINCT clause
    03:27
  • Using the WHERE clause
    03:14
  • True condition
    02:45
  • False condition
    03:24
  • Quiz 1: Introduction To SQL
    3 questions
  • Coding Challenge Part -1
    03:08
  • Preview09:16
  • Summary & Notes For Section 3
    00:24

  • SQL AND Operator
    04:29
  • SQL OR Operator
    03:21
  • SQL LIKE Operator
    05:02
  • SQL Between Operator
    02:44
  • SQL CONCAT Operator
    04:09
  • SQL Numeric Operator
    03:41
  • SQL Comparision Operator
    02:56
  • Quiz 2: Test What you have learned in this section
    4 questions
  • Coding Challenge Part-3
    02:39
  • Coding Challenge Part-3 Solution
    09:15
  • Summary & Notes For Section 4
    00:42

  • Inserting data using the Insert
    05:31
  • Insert into select statement
    05:09
  • Updating data using Update
    04:41
  • Deleting data using delete
    03:58
  • Quiz 3
    4 questions
  • Coding Challenge Part-4
    02:30
  • Coding Challenge Part-4 Solution
    05:59
  • Summary & Notes For Section 5
    00:14

  • Introduction to Joins
    08:45
  • Inner Join
    03:45
  • Left Outer Join
    05:00
  • Right Outer Join
    04:00
  • Full Outer Join
    04:58
  • Cross Join
    03:07
  • Quiz 4
    4 questions
  • Coding Challenge Part-5
    00:29
  • Coding Challenge Part-5 Solution
    02:12
  • Summary & Notes For Section 6
    00:40

  • SQL AVG() Function
    04:21
  • SQL Count() Function
    03:54
  • SQL Min() Function
    03:50
  • SQL Max() Function
    02:15
  • SQL Sum() Function
    03:13
  • SQL Ucase() Function
    03:05
  • SQL Lcase() Function
    02:29
  • SQL Mid() Function
    04:12
  • SQL LEN() Function
    02:36
  • Quiz 5
    5 questions
  • Coding Challenge Part-6
    03:07
  • Coding Challenge Part-6 Solution
    10:00
  • Summary & Notes For Section 7
    00:18

  • Constrains In SQL
    02:17
  • Not Null Constrain In SQL
    05:17
  • Unique Constrain In SQL
    04:50
  • Primary Key Constrain In SQL
    03:00
  • Foreign Key Constrain In SQL
    04:26
  • Foreign Key Example
    07:52
  • Default Constrain In SQL
    03:42
  • Auto Increment Constrain In SQL
    03:55
  • Quiz 6
    5 questions
  • Summary & Notes For Section 8
    00:55

  • Practice Example Part 1
    00:13
  • Practice Example Part 1 Solution
    09:33
  • Practice Example Part 2
    00:15
  • Practice Example Part 2 Solution
    08:20
  • Practice Example Part 3
    00:09
  • Practice Example Part 3 Solution
    06:04
  • Practice Example Part 4
    00:12
  • Practice Example Part 4 Solution
    04:30
  • Practice Example Part 5
    00:17
  • Practice Example Part 5 Solution
    11:23

Requirements

  • No coding, or technical knowledge required.
  • A computer with internet connection.
  • No paid tools are required as the tools required for this course are free.
  • Passion and curiosity to learn someting new.

Description

SQL Course For Beginners: Learn SQL Using MySQL Database

Here Is What You Get By Enrolling In This Course:

Word-By-Word Explanation: In the entire course, I explain each line of code, without skipping a single line of code.

Practice Examples:  Special set of practice examples included at the end of each section.

Awesome Quality Content: Over 5+ hours of HD(1080p) Videos.

Well Structured & Easy To Learn: Course has been specially designed to make it easy for the students to learn SQL.

24 X 7 Support: I will always be there to guide you in your journey to become SQL expert.

Note: Student queries and problems will be answered immediately.

_________________________________________________________________________

Here Is Everything You Will Learn In This Complete Course:

What are databases and why databases are used.

What is SQL and how it can be used to manipulate data into database.

What are the different types of data definition queries used to create tables.

What are the different types of data manipulation queries which can be used to manipulate data.

We first begin the course with the basic introduction about databases and understand what exactly are databases and why they are used. We then learn how to install the required tools which will allow us to create our own databases and add data into it.

Moving along, we learn some SQL operators, and we also learn how these operators can be used in SQL queries which allows us to form more complex queries.

Moving along we learn how SQL statements can be used to insert, update and delete data into the database. Once it is done, we move forward to learn about joins and learn what are different types of joins.

Once we complete each and every concept in SQL, we finally have a set of practice examples, which will allow you to practice SQL queries on your own.

_________________________________________________________________________

So let's begin the journey of becoming an expert in SQL.

In addition to the Udemy 30-day money back guarantee,you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!

_________________________________________________________________________

Make sure to enroll in the course before the price changes.

Take yourself one step closer towards becoming a professional SQL developer by clicking the "take this course button" now!

Join the journey.

Sincerely,

Ashutosh Pawar


Who this course is for:

  • Beginners who want to learn SQL.
  • Database developers and database administrators.
  • Mobile application developers.
  • Web developers.
  • Students who wish to learn a new skill to develop their career.

Instructor

Ashutosh Pawar
Entrepreneur, Python, Java & Android Geek
Ashutosh Pawar
  • 4.4 Instructor Rating
  • 15,838 Reviews
  • 317,582 Students
  • 11 Courses

Ashutosh Pawar is the director of Optimum Solutions, a software firm based in Pune India which works in providing software solutions to small and medium enterprises across the globe and have catered to over 200+ clients globally.

He holds a bachelor's degree in Information Technology (Computer Science) Engineering and has over 8+ years of developing scalable software infrastructure across multiple domains which include real estate, medicine & finance.

Along with being a businessperson, he always had a passion for teaching and his goal is to pass on his knowledge to his students and empower them to achieve their goals in the IT sector.


  • 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.