Buying for a Team? Gift This Course
Wishlisted Wishlist

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

Add to Wishlist

Introduction to SQL

Learn the basics of the most popular programming language designed for managing data
4.4 (259 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,263 students enrolled
Created by Holczer Balazs
Last updated 2/2017
English
$10 $50 80% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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 33 Lectures Collapse All 33 Lectures 01:45:53
+
Introduction
3 Lectures 10:05


Transactions and ACID properties
05:09
+
Table Manipulation
7 Lectures 23:20



Delete row from a table
04:44

Updating a row
03:44

Changing table structure
03:07

Drop tables
01:27
+
Basic SQL
15 Lectures 50:47
SELECT
02:18

WHERE
02:29

IN
02:25

BETWEEN
04:23

NOT - negation in SQL
02:34

Logical operators
03:29

Wildcards
03:13

Functions
05:56

ORDER BY
02:40

GROUP BY
04:04

HAVING
02:52

JOIN
04:20

JOIN II - Group by customers
04:03

JOIN III - Group by country
02:29

Sub queries
03:32
+
Advanced SQL
6 Lectures 21:33
Installing MySQL server
06:51

Configuring MySQL Workbench
04:11

Views introduction
02:38

Views example I - create
03:57

Views example II - update
02:59

Views example III - dropping views
00:57
+
Course Material & Coupons
2 Lectures 00:08
Course material
00:01

Coupon codes - get other courses for a discounted price
00:06
About the Instructor
4.4 Average rating
1,922 Reviews
20,934 Students
19 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!

Report Abuse