Learn SQL Made Simple
4.0 (134 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,468 students enrolled

Learn SQL Made Simple

Taught using whiteboard teaching method. Makes learning easy. Use SQL to properly execute queries in a database.
4.0 (134 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,468 students enrolled
Created by Prem K
Last updated 2/2019
English
English [Auto-generated]
Current price: $15.99 Original price: $24.99 Discount: 36% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Code in SQL
  • Properly execute queries in a database using SQL
Requirements
  • Able to install software in PC
Description

From the creator of SAP LSMW Made Simple, comes another beginner's course. Follow the instructor as he shows you step-by-step on how to properly execute queries in a database using SQL. This introductory course assumes you have no prior knowledge of SQL.

The lectures are organised in an 'easy-to-learn' format so as to make learning fun. It is important that you go through the lectures in the sequence given, i.e. from the very first lecture to the last one. Additionally, in this course, the instructor will teach by writing over the screen. This simulates what you might have experienced in a traditional classroom-setting.

The instructor recommends that you view each lecture in its entirety first. Immediately after watching each lecture, practice in the database - using the same example used in that lecture - to 'lock-in' the new material. To facilitate this, you will be shown where to download and more importantly, how to install both the SQL Server and the Database. (Both are free.)

At the end of the course, you will acquire not only a taste and appreciation of the potential of SQL.You will also be more than ready to properly execute queries in a database using SQL.

Disclaimer: We are not associated or affiliated with Microsoft in any way. For details regarding Microsoft and/or its products, you may contact them directly.

Who this course is for:
  • First-time users of SQL
  • Those seeking to refresh their knowledge of introductory-level SQL
Course content
Expand all 25 lectures 01:32:51
+ Installation of Software
3 lectures 10:12
Installing Microsoft SQL Server 2014 Express Edition
04:08
Installing Microsoft SQL Server Management Studio
02:45
Installing AdventureWorks2014
03:19
+ SELECT Statement and FROM Clause Explained
6 lectures 28:13
SELECT Pre-Chosen Columns
04:27
SELECT TOP 50 *
03:37
SELECT TOP 50 of Pre-Chosen Columns
04:57
Using SELECT Statement with AS
02:57
Using Comments
06:38
+ Understanding WHERE Clause
8 lectures 28:28
Using WHERE Clause with =
02:08
Using WHERE Clause with = AND >
04:06
Using WHERE Clause with = OR <
03:34
Using WHERE Clause with BETWEEN
06:10
Using WHERE Clause with LIKE
03:04
Using WHERE Clause with IS NOT NULL
03:40
Using WHERE Clause with IS NULL
00:49
+ ORDER BY Clause Explained
3 lectures 09:12
Using ORDER BY Clause (Order by Column Name in Descending Order)
04:49
Using ORDER BY Clause (Order by Position of Column Name)
02:12
Using ORDER BY Clause (Order by Alternate Name of Column in Descending Order)
02:11
+ How To Use WHERE and ORDER BY Clauses Together
1 lecture 06:07
Using WHERE and ORDER BY Clauses Together
06:07