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 AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design 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 Coaching 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
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling 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
2020-12-03 21:22:22
30-Day Money-Back Guarantee

This course includes:

  • 8 hours on-demand video
  • 1 article
  • 23 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence SQL

The Complete MySQL Bootcamp: From SQL Beginner to Expert

Learn SQL. Learn SQL From Scratch using MySQL. SQL Database for Beginners. Master SQL Skills and Database Management.SQL
Rating: 4.7 out of 54.7 (127 ratings)
1,156 students
Created by Vertex Academy
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Create databases and interact with existing databases
  • Write SQL queries and generate reports
  • Use SQL for data analysis
  • Start using MySQL (#1 according to the latest Stack Overflow Survey)
  • Boost your resume with the most in-demand skill

Requirements

  • No prior experience is necessary. All you need a computer!

Description

Welcome to The Complete MySQL Bootcamp: From SQL Beginner to Expert.

According to the Stack Overflow Survey 2019, SQL takes third place (54.4%) among the most popular programming, scripting and markup languages.

Knowing SQL is a MUST for:

  • Web Developers

  • Node.js Developers

  • Python Developers

  • Java Developers

  • Business Analysts

  • Marketing Analysts

  • Data Science Specialists

  • Everyone working with databases and data analysis

Strengthen your resume now by learning SQL and find a better job by mastering the most in-demand skill used by tech giants like Google, YouTube, Amazon, PayPal, Netflix and others.


Do I need prior programming experience?

No prior programming experience is necessary. We will take you step by step through everything there is to know about SQL.


What if I have questions during the course?

In this SQL course you will never be alone. Our support team will be with you every step of the way, ready to answer your questions.


How will my lessons look?

Straight to the point, no time wasted!  Firstly, all theory will be explained on slides and after you get the concept, we show you how it works in practice.


Will I have lots of practice?

This course comes packed with lots of exercises to effectively practice and actually use SQL in order to help you advance quickly.


Will I learn MySQL or PostgreSQL?

SQL-language can be used with different databases such as MySQL, PostgreSQL, SQLite and many others.

According to the Stack Overflow Developer Survey 2019:

  • MySQL is the most commonly used database (54%)

  • PostgreSQL has taken the second spot (34.3%)

In this course you will be working with the MySQL database management system but the knowledge gained here can be applied to virtually every other database management system.


Will I get a certificate?

At the end of this SQL course, you will get a certificate which can be added to LinkedIn, adding a feather to your cap that employers will surely notice.


What’s more, you have a 30-day money-back guarantee. No questions asked.

So, what are you waiting for? Enroll today. We will help you gain the skills to be successful in the market for many years to come. Your future starts now!


Who this course is for:

  • Web Developers
  • Python Developers
  • Java Developers
  • Business Analysts
  • Marketing Analysts
  • Data Science Specialists
  • Anyone working with databases and data analysis

Featured review

Feraud Hamid
Feraud Hamid
832 courses
100 reviews
Rating: 5.0 out of 56 months ago
The style of teaching is unparallel. Concepts are first clearly explained and then the implementation follows. The same style of teaching exists in the Web Development course by Vertex. If you want a true grasp of the concepts and know exactly what you're typing, then this course fits the bill. Thank you Vertex.

Course content

9 sections • 90 lectures • 8h 8m total length

  • Preview00:50
  • Preview02:52
  • Installation - macOS
    04:15
  • Installation - Windows
    03:56
  • Installation - Ubuntu
    03:16

  • Video Quality - IMPORTANT!!!
    01:19
  • Preview04:32
  • Create a Table. INSERT INTO
    12:40
  • Inserting Multiple Rows
    02:32
  • NULL
    02:47
  • Preview03:20
  • Preview01:15
  • Exercise 1 - SOLUTION
    04:15
  • SELECT DISTINCT
    04:01
  • WHERE - Part 1
    05:15
  • WHERE - Part 2
    08:21
  • ORDER BY
    05:21
  • Exercise 2 - TASK
    02:01
  • Exercise 2 - SOLUTION
    04:51
  • UPDATE
    06:19
  • DELETE
    05:06

  • Aggregate Functions + ALTER TABLE
    08:42
  • GROUP BY
    08:14
  • Logical Operators: AND, OR, NOT
    07:28
  • HAVING
    03:46
  • ROLLUP
    02:16
  • LIMIT
    04:48
  • Exercise 3 - TASK
    01:35
  • Exercise 3 - SOLUTION
    05:49
  • ALTER TABLE
    06:21
  • DROP
    02:47
  • Exercise 4 - TASK
    01:57
  • Exercise 4 - SOLUTION
    04:42

  • Primary and Foreign Key
    02:47
  • Relationship Types (1:1, 1:many, many:many)
    08:06
  • What is JOIN
    02:40
  • INNER JOIN
    05:04
  • Exercise 5 - TASK
    02:35
  • Exercise 5 - SOLUTION
    04:20
  • LEFT JOIN
    04:22
  • Exercise 6 - TASK
    01:14
  • Exercise 6 - SOLUTION
    01:42
  • RIGHT JOIN
    05:03
  • Exercise 7 - TASK
    01:16
  • Exercise 7 - SOLUTION
    02:12
  • FULL JOIN
    03:32
  • CROSS JOIN
    06:57
  • Aliases
    04:36
  • UNION
    09:48

  • What Are Constraints?
    03:01
  • CONSTRAINTS: NOT NULL
    06:24
  • CONSTRAINTS: UNIQUE. DESCRIBE + AUTO_INCREMENT
    09:43
  • CONSTRAINTS: DEFAULT
    04:42
  • CONSTRAINTS: CHECK
    03:10
  • CONSTRAINTS: PRIMARY KEY & FOREIGN KEY
    07:31
  • Exercise 8 - TASK
    02:12
  • Exercise 8 - SOLUTION
    06:54
  • String Functions - Part 1
    11:03
  • String Functions - Part 2
    11:35
  • Exercise 9 - TASK
    01:58
  • Exercise 9 - SOLUTION
    08:33
  • Numeric Functions
    10:23
  • Date Functions - Part 1
    13:19
  • Date Functions - Part 2
    10:25
  • IFNULL
    04:10
  • IF
    03:04
  • CASE
    05:07
  • COALESCE
    04:41

  • What Is a Subquery?
    03:02
  • Subquery in the SELECT Clause
    06:13
  • Subquery in the FROM Clause
    05:19
  • Subquery in the WHERE Clause
    11:16
  • Correlated Subqueries
    08:15
  • Exercise 10 - TASK
    01:04
  • Exercise 10 - SOLUTION
    03:50

  • Views
    11:15
  • Stored Procedures
    07:34
  • Variables - Part 1 - System Variables
    06:50
  • Variables - Part 2 - User-Defined Variables
    04:58
  • Variables - Part 3 - Parameters and Local Variables
    02:55
  • Input and Output Parameters
    12:19
  • User-Defined Functions (2 examples)
    13:39
  • Triggers
    13:31
  • What Are Indexes?
    03:54
  • CREATE, READ and DELETE Indexes
    11:30

  • What Is a Database Normalization?
    05:22
  • 1st Normal Form
    06:52
  • 2nd Normal Form
    04:07
  • 3rd Normal Form
    02:47

  • Bonus Lecture
    00:16

Instructor

Vertex Academy
Professional software engineers with 9+ years’ experience
Vertex Academy
  • 4.6 Instructor Rating
  • 900 Reviews
  • 9,362 Students
  • 3 Courses

We are professional web development bootcamp instructors with 9+ years’ experience in software development and 5+ years’ experience of conducting highly-effective web development bootcamps. Our students become web developers from scratch in the shortest possible time thanks to our unique teaching method.

We have already helped thousands of students get their first job in web development. Our students work in top IT companies all over the world and also they work as successful freelancers.

Our courses have been developed by a truly international team. The team are experts in all popular programming languages such as JavaScript, Python, Java, PHP and have degrees from some of the most well respected universities. They also work for prestigious tech companies and conduct professional web development bootcamps.

Join us, and start your career in web development asap.


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