Introduction to SQL and MySQL
4.5 (268 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,290 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to SQL and MySQL to your Wishlist.

Add to Wishlist

Introduction to SQL and MySQL

Learn the basics of the most popular programming language designed for managing data
4.5 (268 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,290 students enrolled
Created by Holczer Balazs
Last updated 3/2017
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 9 Articles
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the basic concepts of databases
  • Get a good grasp of SQL queries
View Curriculum
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.

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.

Who is the target audience?
  • This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 71 Lectures Collapse All 71 Lectures 03:40:16
+
Introduction
1 Lecture 01:32
+
Environment
1 Lecture 06:28
+
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
1 More Section
About the Instructor
Holczer Balazs
4.4 Average rating
2,573 Reviews
26,812 Students
21 Courses
Software Engineer

Hi!

My name is Balazs Holczer. I am from Budapest, Hungary. I am qualified as a physicist and later on I decided to get a master degree in applied mathematics. At the moment I am working as a simulation engineer at a multinational company. I have been interested in algorithms and data structures and its implementations especially in Java since university. Later on I got acquainted with machine learning techniques, artificial intelligence, numerical methods and recipes such as solving differential equations, linear algebra, interpolation and extrapolation. These things may prove to be very very important in several fields: software engineering, research and development or investment banking. I have a special addiction to quantitative models such as the Black-Scholes model, or the Merton-model. Quantitative analysts use these algorithms and numerical techniques on daily basis so in my opinion these topics are definitely worth learning.

Take a look at my website and join my email list if you are interested in these topics!