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.
672 students enrolled
$19
$25
24% 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

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 2/2014 English

Course Description

Updates:

  • Course last updated: May 2016
  • 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

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

Curriculum

Section 1: Introduction
08:12

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
16:46

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
30:40

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
35:14

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
30:19

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
31:15

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
32:59

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
25:18

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
20:45

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, Writer, Founder of EasyWaySQL

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

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