Introduction to SQL

Learn the basics of the most popular programming language designed for managing data
4.4 (247 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,243 students enrolled
Instructed by Holczer Balazs IT & Software / Other
$19
$20
5% off
Take This Course
  • Lectures 25
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

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

What are the requirements?

  • We will perform the queries with the help of an online platform, so no previous software installations are required

What am I going to get from this course?

  • Understand the basic concepts of databases
  • Get a good grasp of SQL queries

What is the target audience?

  • This course is mean for newbies who are not familiar with SQL syntax or just want to refresh the knowledge

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
01:22
Databases introduction
Preview
03:34
Transactions and ACID properties
05:09
Section 2: Table Manipulation
SQL console
Preview
01:10
Creating a table
Preview
03:00
Inserting into a table
Preview
04:38
Delete row from a table
02:24
Updating a row
03:55
Drop tables
01:00
Section 3: Basic SQL
SELECT
02:10
WHERE
02:03
IN
01:57
BETWEEN
02:07
NOT - negation in SQL
01:46
Logical operators
03:38
Wildcards
03:29
Functions
06:28
ORDER BY
02:59
GROUP BY
04:23
HAVING
03:06
JOIN
04:36
JOIN II - Group by customers
04:13
JOIN III - Group by country
02:37
Sub queries
03:49
Section 4: Coupons
Coupon codes - get other courses for a discounted price
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Holczer Balazs, 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.

Ready to start learning?
Take This Course