SQL Essentials for Beginners
4.6 (11 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.
69 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Essentials for Beginners to your Wishlist.

Add to Wishlist

SQL Essentials for Beginners

A step by step guide for learning essential SQL commands for IT professionals.
4.6 (11 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.
69 students enrolled
Last updated 9/2017
Current price: $12 Original price: $20 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 3 Articles
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Create tables and establish relations among them.
  • Manipulate information in the table such as insert, update and delete.
  • Design queries, apply aggregations and combine information from multiple tables by means of joins.
  • Along side you will also understand what is a view, index and transaction control commands.
View Curriculum
  • You need to download and install either MySQL or SQL Server and should have the environment setup in your machine. For general users community editions are available for both the products which are free.

This course is all about creating the tables, applying the constraints and establishing the relationship among the tables, it also covers basics related to keys, indexes, views along with other essential topics. Most critical of the lot includes designing queries for information retrieval and joins. 

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.

You can learn it at your own pace, if you are determined you can complete this in a Day as well.

This course is apt for you if you are an absolute beginner to SQL or you may want to fine tune your SQL foundations. It is structured in a step by step manner which will help you understand even the tough topics through simplified examples. 

Who is the target audience?
  • If you are a newbie to SQL and looking forward to understand it through step by step approach or you would like to finetune your SQL foundations, this course is apt for you.
  • It is NOT for you if you are familiar with SQL and looking for advanced topics.
Compare to Other SQL Courses
Curriculum For This Course
31 Lectures
Getting Started
4 Lectures 12:48

High level introduction about the contents of the course.

Preview 01:12

Step by step Installation guide for MySQL (Windows).

MySQL Installation Guide

Explains the key terms like database, schema and key components of DBMS.

Introduction & Terminology

Demonstrates how to get started with MySQL workbench, database creation along with sample table creation, insertion and query.

Preview 08:26

7 questions
Insertions and Projections
3 Lectures 11:29

Explains how to project the required columns using the query.

Preview 04:25

Explains how to use the insert command to insert data into the table.

Insert data into the table

Explains how select command could be used in conjunction with insert to insert multiple records at one go.

Inserting multiple records

4 questions
Filtering and ordering the data
3 Lectures 10:40

Explains the usage of where clause in the query.

Filtering Data

Explains how to use order by with the query.

Arranging the data before display

Demonstrates query processing sequence from query designer perspective.

Memorising queries - 1

4 questions
Updating and deleting records
2 Lectures 03:57

Explains about update command usage.

Updating the data

Explains how to use the delete command.

Deleting the data

3 questions
Constraints and Identity
6 Lectures 24:11

Explains what is a primary key, unique, not null and check constraints.

Primary Constraints

Explains foreign key constraint and its usage. 

Referential Integrity

Explains how to set auto increment for an identity column.

Identity Column

Explains about designing tables for cardinality

  • One - to - One
  • One - to - Many
  • Many - to - Many
Relationship and Cardinality

Explains how to apply constraints over multiple columns. It distinguishes column constraints and table constraints.

Constraints over multiple columns

Explains the terms

  1. Candidate Key
  2. Primary Key
  3. Secondary Key
  4. Surrogate Key
What is a Key?

11 questions
Grouping and aggregating the information
4 Lectures 07:19

Explains about aggregate functions.

Aggregate functions

Explains how to use group by clause in query.

Grouping and applying aggregate functions

Explains how to filter groups with having clause in the query.

Filtering groups

Fine tunes query oriented thinking.

Memorising queries 2

3 questions
Joins and Sub Queries
3 Lectures 15:17

Explains what is join.

Joins Introduction

Explains how to inner and outer joins.

Inner and Outer Joins

Explains the usage of sub queries.


6 questions
4 Lectures 13:38

Explains how to use Alter command to add, modify and drop a column for an existing table. 

ALTER command

Explains the significance of views and teaches how to create view using CREATE VIEW command and query the view.


Explains what is an Index and demonstrates the following,

  1. Index creation
  2. Unique Index
  3. Dropping Index

Explains how to begin a transaction and perform commit and rollback operations along with save points concept.


7 questions
1 Lecture 00:12
1 Lecture 00:18
Wrap Up
About the Instructor
Purna Chandra Vidya Sagar Uppuluri
4.5 Average rating
19 Reviews
86 Students
2 Courses
Software Architect

Sagar an M.Tech graduate from ANU a passionate application developer and a trainer apart from being a good learner and a listener, started his career as a trainer and later he was part of design and development of several software projects and products. Earned his reputation as a hard core Java developer and Systems Integration Specialist and was instrumental in success of several projects with his technical, leadership and mentoring skills.