Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React CSS Angular Node.Js PHP HTML5 Django
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate Microsoft AZ-900
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence Blockchain MySQL Data Analysis
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Mobile Game Development
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Canva Art Composition Design Theory
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Freelancing Business Plan Startup Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Email Marketing Copywriting YouTube Marketing Advertising Strategy
2021-11-12 03:22:50

Database Design & Development SQL

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Learn SQL and Database Development to work effectively in DBMS like MySQL, SQL Server, Oracle, PostgreSQL, DB2 etc.
Rating: 4.2 out of 54.2 (1,801 ratings)
9,452 students
Created by Pradnyankur Nikam
Last updated 11/2021
English
English

What you'll learn

  • Understand the Database terminology & Structured Query Language fundamentals.
  • At the end of this course, You will be able to use SQL statements in any database management system.
  • You will learn from SQL basics to advanced topics like JOINS, Database Relationships, Database Normalization.
  • You will learn each topic step by step with practical examples.
  • You will learn the skills useful for professional Database Development (Database Modeling) and Database Management.
  • You will also learn about MySQL Workbench, a unified visual tool for database architects, developers, and Database Administrators.

Course content

19 sections • 127 lectures • 10h 46m total length

  • Preview02:23
  • Preview02:17
  • Quiz 1: Introduction
    12 questions

  • Download & Install MySQL 8.0.11 on Windows 10 Operating System
    Preview16:33
  • Install MySQL database server on Mac operating system (MySQL 5.7.20)
    12:32
  • Install MySQL database server on Linux operating system (MySQL 5.7.20)
    06:28
  • How to add a new database user and add privileges
    08:53
  • Quiz 2: Setup a Testing Environment
    10 questions

  • What is DBMS and RDBMS?
    03:02
  • Difference between Database Engine, Database Server and Database Software
    02:31
  • What is a database? How to create and use a database?
    Preview05:53
  • What is a database table? How to create and use a database table?
    08:44
  • How to add the data rows to a database table?
    07:19
  • Understand Keywords, Identifiers, Constants and Clauses
    02:56
  • Learn about SQL Statements
    01:30
  • Data Definition Language(DDL) and Data Manipulation Language(DML)?
    02:34
  • Quiz 3: An Overview of SQL
    38 questions

  • Preview10:50
  • Learn about SQL SELECT Clause
    05:33
  • SQL SELECT DISTINCT Statement
    05:16
  • Learn about SQL FROM Clause
    03:10
  • Learn about SQL WHERE Clause
    04:56
  • Quiz 4: Important SQL Clauses
    10 questions

  • Preview04:18
  • SQL False Condition
    04:42
  • SQL AND Operator
    05:59
  • SQL OR Operator
    06:58
  • SQL IN Operator
    05:09
  • SQL EXISTS Condition
    07:49
  • SQL NOT IN or NOT EXISTS? Conditions
    04:48
  • SQL Comparison Operators
    04:17
  • SQL LIKE Operator
    05:40
  • SQL BETWEEN Operator
    04:35
  • SQL Numeric Operators
    04:14
  • SQL Concatenation Operator
    02:22
  • SQL Temporal Operator
    01:59
  • Quiz 5: Conditions and Operators
    22 questions

  • Preview07:34
  • Learn about SQL HAVING Clause
    05:45
  • Learn about SQL ORDER BY Clause
    04:53
  • SQL LIMIT or TOP Clause
    02:55
  • SQL Wildcards
    04:56
  • SQL Aliases
    06:05
  • SQL Dates
    04:07
  • Quiz 6: Data grouping, sorting, select and dates
    15 questions

  • Preview06:04
  • SQL INSERT INTO SELECT Statement
    06:10
  • Update data rows using UPDATE Statement
    07:10
  • Delete data rows using DELETE Statement
    03:38
  • What is SQL Injection and How to secure a database?
    05:49
  • Quiz 7: Insert, Read, Update, Delete the Data Rows (Data Manipulation Language)
    22 questions

  • What are JOINS in SQL? Types of SQL JOINS
    05:01
  • Preview10:32
  • Learn about LEFT OUTER JOIN in SQL
    07:31
  • Learn about RIGHT OUTER JOIN in SQL
    07:32
  • Learn about FULL OUTER JOIN in SQL
    03:52
  • Learn about CROSS JOIN in SQL
    04:29
  • SQL UNION Operator
    04:31
  • SQL VIEWS
    08:12
  • Derived Tables or Inline Views
    05:22
  • Quiz 8: SQL JOINS (Data Manipulation Language)
    33 questions

  • Functions in SQL and Types of SQL functions
    01:17
  • Preview05:44
  • SQL FIRST() Function
    02:26
  • SQL LAST() Function
    02:47
  • SQL SUM() Function
    02:52
  • SQL MIN() Function
    03:27
  • SQL MAX() Function
    03:14
  • SQL AVG() Function
    03:12
  • SQL UCASE() Function
    02:27
  • SQL LCASE() Function
    02:13
  • SQL MID() Function
    02:51
  • SQL LEN() Function
    02:25
  • SQL ROUND() Function
    03:23
  • SQL FORMAT() Function
    02:48
  • SQL SUBSTRING() Function
    03:05
  • SQL COALESCE() Function
    02:43
  • SQL CHAR_LENGTH() Function
    02:45
  • SQL CAST() Function
    03:41
  • SQL CASE() Function
    06:25
  • SQL NULLIF() Function
    06:12
  • Quiz 9: SQL Functions
    75 questions

  • Preview02:04
  • Integer Numbers in SQL (Exact Values)
    03:01
  • Fixed-Point Numbers in SQL (Exact Values)
    03:30
  • Floating-Point Numbers in SQL (Approximate Values)
    03:12
  • CHAR and VARCHAR in SQL (String Values)
    02:47
  • NCHAR and NVARCHAR in SQL (String Values)
    01:12
  • CLOB and BLOB in SQL (String Values)
    00:57
  • DATE, TIME and TIMESTAMP in SQL (Temporal Values)
    01:33
  • Quiz 10: SQL Data Types
    36 questions

  • No coding, design or technical knowledge required.
  • A computer with any operating system installed on it.
  • Basic computer knowledge is required to learn from this course.
  • You don't need to buy any software. We will install and use MySQL which is absolutely free.

Description

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Why should you take this SQL course?

  • Subtitles: English Captions or Subtitles for all the lectures are available.

  • This course is one of the biggest, best rated and top selling SQL course on Udemy Marketplace!

  • You will learn SQL with practical examples. By learning structured query language, you will be able to work in any database system like MySQL, PostgreSQL, SQL Server, DB2, Oracle etc.

  • You will learn Database designing, Database modeling, SQL RDBMS concepts, Database relationships and much more, everything by using SQL commands.

  • You get a SQL video tutorial course which will teach you how to use structured query language statements in MySQL command line client tool. The SQL statements are common to all major database management systems.

  • The course includes 15 Quizzes with 350 SQL Questions and Answers for the Job interview.

  • Lightning fast support to all your queries: I personally respond to all
    the students queries via PM or on the discussion board within 1 hour to 24 hours. I respond on weekends too. So If you have any question feel free to PM me or ask on the discussion board.

  • Lifetime access to all the content and future updates of this course.

  • 30 days money back guarantee. (I am sure you will never need this.)


You will understand how SQL works and learn effective database design for your applications.

In this course we'll learn SQL with practical example on every topic. We will learn in more detail about,

  • Database Installation and SQL fundamentals.

  • Data Definition Language(DDL) and Data Manipulation Language(DML).

  • SQL Joins, SQL functions and SQL data types.

  • Database Relationships and Database Normalization.

  • Database Export and Import.

  • MySQL workbench.


Do you know the Benefits of learning SQL?

Learning the Structured Query Language gives you a powerful tool which can be implemented in variety of application development including web, desktop and mobile application development. SQL is ANSI standard and used in all major database management systems.

SQL skill opens a new dimension in the jobs where you can work as a database administrator in IT companies or you can work as a freelancer. Database development is very important factor in any application development So learning database development skill is very beneficial for you.

Checkout this SQL tutorial Overview

  • The section 1 to 3 covers Introduction, Database Installation, SQL Overview and learn terminology used in Structured Query Language.

  • In section 4 to 9 we will learn Data Manipulation Language, Clauses, Various Conditions and Operators, Data Filtering and sorting, SQL Joins and the most Important SQL Functions.

  • In section 10 to 13 we will understand SQL Data Types in more detail, Data Definition Language, Database Normalization & Database Export and Import functionality.

  • The section 15 covers MySQL Workbench a unified visual tool for database development.

  • The section 16 contain bonus lecture.


What students say about this course? Checkout some of my students reviews for this course.

  • "I recommend this course to every student who want to learn SQL." - By Rachel

  • "The instructor was very methodical and would go step by step explaining a point, Overall a great staring point to know SQL." - By Tridib Pal

  • "It was a wonderful experience to learn from this course. What I really liked were the practicals in every section which were perfect and up to the mark! Also, all the topics in the course were covered in-depth and thus, I feel that the examples learned from this course would really help me while planning, managing and solving real world tasks at my workplace." - By Sagar Erande

  • "The instructor responds to questions very fast which is greatly appreciated. The instructor knows his subject. Overall well done and worth the investment of your time." - By Steven Grigsby

  • "This course is comprehensive, and has helped me refresh my (My)SQL knowledge. As such, I've provided a 5 star rating - the author has obviously spent a lot of time creating this course along with associated examples." - By James Johnson

  • "Very well structured course. I hope author releases more courses, because he for sure has a talent to teach! Bravo!" - By Iskko Iskkov

  • "Clear and to the point. He shows you what you need to help you get to where you want to be." - By Dustin Raphael

  • "This course is laid out well. The content and the examples were easy to follow. Pradnyankur Nikam responded quickly to my inquiries. I recommend this course to anyone that needs a refresher on SQL as well as beginners." - By Katende Kinene


  • "Exactly what I wanted. I loved learning SQL with this course." - By Sanchi Mishra

Note: Checkout more reviews in the Reviews section.

Watch introduction video and click the "Full Curriculum" link to see the list of all the sections and lectures included with this SQL course.

Who this course is for:

  • Database developers and database administrators.
  • Desktop & mobile application developers.
  • Network applications developers.
  • Graduate and undergraduate students for academic purpose.
  • People who love to learn new skills.
  • Non technical, startups and Job seekers.

Instructor

Pradnyankur Nikam
Freelance Web developer and Instructor, 8000+ Happy Students
Pradnyankur Nikam
  • 4.2 Instructor Rating
  • 1,836 Reviews
  • 9,615 Students
  • 2 Courses

Hi, I am Pradnyankur Nikam from Pune, Maharashtra, India. I'm an instructor, freelance web developer, PHP, MySQL & WordPress developer.

After completing my post graduation in 2008, I started developing websites for myself, where I used to sell affiliate games & software. I learned online marketing & SEO (search engine optimization) skills by using which promoted my websites. While marketing my websites, I started working on freelance projects, where I got opportunities to further improve my skills.

During my 10+ years freelancer carrier, I've helped hundreds of clients to build websites, APIs, troubleshoot errors, setup web servers and much more. I've practical experience of working on thousands of projects. And it would be my pleasure to share my experience with you.

Experience: 10+ years as web developer

Skills: Programming & Database Development (HTML5, CSS3, JavaScript, PHP, MySQL, WordPress)

Other Skills: Online Marketing & SEO (Search Engine Optimization)

Courses teaching: 2

No. of students: 8000+

No. of reviews: 1500+

Why should you take my courses?

The most important aspect in learning is PRACTICAL. As I told you above I've 10+ years of practical experience, I know how things are developed or how things work. In my courses I've taken practical approach to teach & explain course topics practically with examples. Also, There are Assignments, Quizzes, Do-It-Yourself coding challenges which will help you better understand the topics.

What students say about my courses?

Currently I've 2 courses with 1500+ reviews and hundreds of feedbacks. Checkout some of the feedbacks below,

"I took many courses on Udemy. I think this is my best course I took Instructor is very motivated and try to help all of us. I sent private messages. His reply was so quickly. His responses were prices. Thank you so much Ankur" - Mohammad Aboud

"I knew nothing about SQL before this course. I found it searching for how to install mysql. The course was very well structured and easy to follow. Thank you very much." - Mark DeNunzio

"A good course for beginners to learn MySQL. Very clear and sincere effort by the teacher in teaching the concept." - Pushkal Singh

"I believe this is providing a detailed and thorough approach to learning PHP and MySQL. It seems to take a logical "step at a time" learning." - Brian Mellady

"the instructor was more than helpful throughout the course, especially when starting out." - Ishan Mareddy

What are you waiting for?

Well, you can keep reading about me or keep browsing my courses. But the best way to know about me, my teaching style or course content is, to ENROLL. So, Enroll to my course and join me on this amazing learning journey.

  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2021 Udemy, Inc.