Introduction to SQL and MySQL
4.3 (625 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.
10,289 students enrolled

Introduction to SQL and MySQL

Learn the basics of the most popular programming language designed for managing data
4.3 (625 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.
10,289 students enrolled
Created by Holczer Balazs
Last updated 4/2019
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 8 articles
  • 7 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
  • Understand the basic concepts of databases
  • Get a good grasp of SQL queries
Requirements
  • We will perform the queries with the help of an online platform, so no previous software installations are required
Description

Learn the basic concepts and functions that you will need to make queries with the most popular data manipulating programming language, SQL. This course is about SQL commands in the main. You will learn the basics of queries. This is a fundamental part of databases so it is definitly worth learning.

Section 1:

  • setting up the environment

  • installing MySQL

  • relational databases theory

Section 2:

  • SQL and MySQL basics

  • creating databases and database tables

  • updating tables

  • dropping tables

Section 3:

  • basic SQL and MySQL commands

  • select, where and wildcards

  • ORDER BY and GROUP BY commands

Section 4:

  • joining multiple database tables

Section 5:

  • advanced SQL and MySQL

  • subqueries

  • transactions (ACID principles)

  • views

  • indexes and constraints

Learning the fundamentals of SQL is a good choice and puts a powerful tool at your fingertips. SQL is easy to learn as well as it has excellent documentations.

The most important fact about SQL that it is used in almost every speciality from software engineering to financial analysis, so understanding the concepts and basic language features can prove to be very marketable.

Thanks for joining the course, let's get started!

Who this course is for:
  • This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge
Course content
Expand all 70 lectures 03:40:36
+ Table Manipulation
8 lectures 29:37
Delete row from a table
04:52
Updating a row
02:46
Changing table structure
03:14
Drop tables
02:09
Chapter summary & source code
00:03
+ Basic SQL
14 lectures 43:10
SQL dump - the city and country tables
03:30
SELECT
02:41
WHERE
02:28
IN
02:12
BETWEEN
03:28
NOT - negation in SQL
02:07
Logical operators
04:03
Wildcards
03:27
Functions
05:51
ORDER BY
04:40
GROUP BY example I
03:05
GROUP BY example II
02:33
HAVING
03:02
Chapter summary & source code
00:03
+ Joining Multiple Tables
14 lectures 37:57
Configuring the database tables - PERSON and UNIVERSITY
02:55
Inner join introduction
04:46
Inner join example
03:55
Left join introduction
03:05
Left join example
02:15
Right join introduction
01:36
Right join example
01:28
JOIN example - number of cities
05:12
JOIN example - total population by continent
03:23
Online SQL console
01:03
JOIN example - customers and orders
02:53
JOIN example - number of orders by customers
03:18
JOIN example - number of orders by country
02:05
Chapter summary & source code
00:03
+ Advanced SQL - Subqueries
7 lectures 19:15
Subqueries introduction
06:36
Non-correlated scalar subquery
02:05
Non-correlated multiple-row subquery
02:45
Correlated subquery
02:50
Subqueries and joins
01:52
Transforming subquery into join
03:04
Chapter summary & source code
00:03
+ Advanced SQL - Transactions
7 lectures 29:14
Transactions introduction - locking
09:25
Transactions introduction - transactions
03:37
ACID principles
03:39
Transaction example - COMMIT
04:28
Transaction example - ROLLBACK
02:32
Transaction example - SAVEPOINT
05:30
Chapter summary & source code
00:03
+ Advanced SQL - Views
6 lectures 14:28
Views introduction
04:54
Views example - initialize database
01:38
Views example - create views
03:57
Views example - update views
02:59
Views example - dropping views
00:57
Chapter summary & source code
00:03
+ Advanced SQL - Indexes And Constraints
5 lectures 18:35
Indexes introduction
06:32
Indexes example
04:37
Constraints introduction
01:23
Primary keys
03:08
Unique constraints
02:55