Learn SQL from scratch and become a database developer-Part1
3.6 (7 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.
679 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL from scratch and become a database developer-Part1 to your Wishlist.

Add to Wishlist

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.6 (7 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.
679 students enrolled
Last updated 5/2014
English
Current price: $10 Original price: $25 Discount: 60% off
16 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • No prior SQL knowledge is required.
  • Desire to learn new things.
  • Microsoft SQL Server Express
Description

Updates:

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

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 9 Lectures Collapse All 9 Lectures 03:51:28
+
Introduction
1 Lecture 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.

Preview 08:12
+
Concepts and Overview
1 Lecture 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

Preview 16:46
+
SELECT Basics
1 Lecture 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.

Preview 30:40
+
Filtering data
1 Lecture 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.

WHERE - IN - BETWEEN
35:14
+
Scalar Functions
1 Lecture 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

Scalar and non-scalar functions Deterministic and non-deterministic functions
30:19
+
Aggregate Functions
1 Lecture 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.

Aggregates, GROUP BY - HAVING
31:15
+
Advanced Tricks
1 Lecture 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.

TOP - LIMIT - CAST- CONVERT - DISTINCT and Subqueries
32:59
+
Inserting updating and deleting data
1 Lecture 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.

INSERT - UPDATE - DELETE
25:18
+
Joining Multiple Tables
1 Lecture 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.

INNER JOIN - OUTER JOIN - CROSS JOIN
20:45
About the Instructor
Cristian Astalos
4.1 Average rating
35 Reviews
1,380 Students
4 Courses
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.