SQL Crash Course for beginners - Learn SQL with MySQL
4.6 (204 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,132 students enrolled

SQL Crash Course for beginners - Learn SQL with MySQL

Master the SQL statements that every software developer or data analyst needs for designing and developing databases
4.6 (204 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,132 students enrolled
Created by Islam Elgaeidy
Last updated 4/2020
English
English [Auto-generated]
Current price: $86.99 Original price: $124.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Dozens of targeted exercises with full explanations and solutions from beginner level right up to advanced.
  • Every SQL statement you need is covered thoroughly
  • Straight to the point, no time wasted
  • Every module contains information and activities that are relevant to real-life jobs or the kind of tasks you may get on interview
Course content
Expand all 36 lectures 01:37:43
+ Data Manipulation
13 lectures 49:43
Relational Databases
01:27
The Course Databases and brief Introduction
09:35
Create Statement
03:03
Insert Statement
03:52
Alter Table Statement
02:05
Update Statement
03:46
Delete Statement
02:00
Constraints
03:00
Summary
01:44
QUIZ
9 questions
+ Queries And Operators
13 lectures 29:34
Select
02:20
AS keyword
01:45
Like Operator
03:52
Null Operators
01:24
Between Operator
03:17
AND Operator
01:56
OR Operator
01:30
Order By clause
02:33
LIMIT clause
01:57
Case Statement
03:00
Summary
01:19
QUIZ
10 questions
+ Aggregate Functions
10 lectures 18:26
Introduction
01:41
SUM Function
01:39
MAX & MIN
01:17
AVG
01:16
ROUND
01:36
GROUP BY Part1
02:46
GROUP BY Part2
02:19
HAVING
03:00
Summary
01:00
QUIZ
10 questions
Requirements
  • No Prior Knowledge Needed
  • For those with some development and database experience, you can jump in at the relevant module that fits your current level, as the course is designed sequentially.
Description

Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few.

So, to be a successful developer or data scientist you need to know SQL inside-out.

But - SQL can seem complicated. Especially if you’re a beginner or more familiar with other programming languages. Don’t worry - there’s some good news…

SQL isn’t complicated - or at least it doesn’t need to be, so long as you learn it the right way.

Problem is - too many other courses out there jump around, skipping important concepts or simply teaching things badly.

That’s why this course goes further than most. You’ll get in-depth knowledge and skills that are built-up sequentially to make sure you don’t have any gaps.

Who this course is for:
  • Become an SQL all-rounder who’s a valuable asset to any company that hires developers or database specialists.
  • SQL really is everywhere. When you log in to pretty much any web app, your data is retrieved from a database using SQL queries. We live in a big data society and SQL is powering it. This means there’s a huge demand for SQL developers and data scientists with SQL skills.
  • Oh, and when you have a huge demand for a specialist skill this means one thing - big salaries!
  • The latest research shows that the average salary for an SQL developer is more than $84,000 per year. Not bad, especially when you consider that in a recent analysis of 25k developer job listings, over 35% specifically request SQL skills.
  • In fact, SQL is now the second most popular programming language, second only to JavaScript. All in all, it’s pretty clear that now is definitely the right time to get your SQL game on!