Learn SQL from scratch and become a database developer-Part1

Become the next greatest DB Dev, administrator or report developer by learning SQL from scratch, the easy way. Part1
3.9 (5 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.
676 students enrolled
40% off
Take This Course
  • Lectures 9
  • Length 4 hours
  • Skill Level All Levels
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 2/2014 English

Course Description


  • More than 600 happy students
  • Most complete course on SQL Language on Udemy and growing
  • Full, Free lifetime access
  • All future extra lectures and upgrades are always included for FREE
  • Unconditional Udemy 30 money-back guarantee

Learn SQL language from scratch, the easy way, is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. This is the first part of a 2 parts course which covers the following topics:

  • Database Basics
  • Retrieving Data
  • Filtering Data
  • Scalar Functions
  • Aggregate Functions
  • Joining Tables
  • Grouping Data

For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out.

There are 2 sample databases provided with this course. SQLMain is used throughout the demonstrations. The second one is a Microsoft developed sample database that you can have fun with after you finish the course. Besides the video tutorials and sample databases, this course includes a 186 pages PDF book about SQL that I have written. Some of the concepts covered in the book will be demonstrated in this course leaving the remaining ones to be presented in part 2 of the course.

I myself started learning on my own with no mentor and no place where to get the exact information that I needed. This is one of the reasons this course is structured in such a way that you can start writing SQL code in hours with ease.

I recommend taking one lecture once every 2 or 3 days. This way you will have time to get used with the terminology and also have time to practice what you learned on your own. This course is not going to make you a SQL guru overnight. It takes practice and patience to get there.

Let's get started and learn SQL language together. The easy way.

Good to know:

  • In order to have a better learning experience please watch the videos in HD.
  • 30 days money back guarantee. No questions asked.

What are the requirements?

  • No prior SQL knowledge is required.
  • Desire to learn new things.
  • Microsoft SQL Server Express

What am I going to get from this course?

  • Understand basic/intermediate database concepts
  • Insert,Extract, Alter and Delete data from a database
  • Know how to use scalar and aggregate functions
  • Know how to perform all of the above using multiple tables

Who is the target audience?

  • This course can be used by technology professional as well as individuals who wish to become database administrators/designers or report developers or those that have a passion about data and wish to know how they can play with it.

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.


Section 1: Introduction

This lecture includes a presentation of all the video tutorials and chapters that will be covered in part 1 and part 2 of this course. You will also be able to download 2 sample databases. After installing Microsoft SQL Server make sure you restore the 2 sample DB. SQLMain is the main on used throughout this course.

Section 2: Concepts and Overview

As we are going to start from scratch, this lecture includes basic concepts about databases like what is a database, a table, a row, ANSI Standards, RDBMS Platforms and Relational Data

Section 3: SELECT Basics

In this lecture we are going to start querying data out of a database using the SELECT statement, filter and order data and also talk about some query toolset functionalities.

Section 4: Filtering data

In this lecture we are going to dive in the WHERE clause in a lot more detail. We will look at the IN and BETWEEN operators,the IS and IS NOT predicates, Boolean operators, how to properly delimit string and date data and a few other fun things.

Section 5: Scalar Functions

In this lecture we are going to talk about how to use functions within SQL queries. We will see the differences between scalar and non-scalar functions, deterministic and non-deterministic function. We will look at how to read the syntax in both MS SQL Server and MySQL. We'll also talk about how functions differ between platforms

Section 6: Aggregate Functions

In this lecture we are going to talk about aggregate functions which are different from the scalar functions that we talked about in the previous video.Specifically we are going to talk about SUM , MIN , MAX, AVG, COUNT and more.

Section 7: Advanced Tricks

In this lecture we are going to talk about the TOP keyword, (LIMIT/OFFSET in MySQL), we'll have a look at subqueries and how they work, column and table aliasing and we're also talk about the DISTINCT operator and casting and converting data.

Section 8: Inserting updating and deleting data

In this lecture we are going to talk about 3 of the basic DML queries that you will use in SQL. Insert data, update it and delete data from a database table.

Section 9: Joining Multiple Tables

In this lecture we are going to talk about multiple types of joins used to link multiple tables together and extract data from them.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Cristian Astalos, BI-DB Developer, Founder of EasyWaySQL.com and My-Car.co

I am a young but experienced and highly passionate BI Reporting Specialist and Database Developer,writer and founder of EasyWaySQL and MyCar mobile app.

I also have a Bachelor's degree in Business Administration and a Master's degree in Economic Decision Support Systems.

Other than that I am dedicated to share my knowledge with others and learn new technologies on the way.

Ready to start learning?
Take This Course