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
English
Current price: $12 Original price: $20 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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.
Description

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
01:39:50
+
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
00:02

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

Introduction & Terminology
03:08

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

Preview 08:26

Quiz
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
04:55

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

Inserting multiple records
02:09

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

Explains the usage of where clause in the query.

Filtering Data
06:44

Explains how to use order by with the query.

Arranging the data before display
01:50

Demonstrates query processing sequence from query designer perspective.

Memorising queries - 1
02:06

Quiz
4 questions
+
Updating and deleting records
2 Lectures 03:57

Explains about update command usage.

Updating the data
02:19

Explains how to use the delete command.

Deleting the data
01:38

Quiz
3 questions
+
Constraints and Identity
6 Lectures 24:11

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

Primary Constraints
05:16

Explains foreign key constraint and its usage. 

Referential Integrity
06:05

Explains how to set auto increment for an identity column.

Identity Column
02:27

Explains about designing tables for cardinality

  • One - to - One
  • One - to - Many
  • Many - to - Many
Relationship and Cardinality
04:23

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

Constraints over multiple columns
02:40

Explains the terms

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

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

Explains about aggregate functions.

Aggregate functions
01:44

Explains how to use group by clause in query.

Grouping and applying aggregate functions
02:11

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

Filtering groups
02:04

Fine tunes query oriented thinking.

Memorising queries 2
01:20

Quiz
3 questions
+
Joins and Sub Queries
3 Lectures 15:17

Explains what is join.

Joins Introduction
05:29

Explains how to inner and outer joins.

Inner and Outer Joins
05:17

Explains the usage of sub queries.

Subqueries
04:31

Quiz
6 questions
+
Misc
4 Lectures 13:38

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

ALTER command
02:28

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

Views
03:05

Explains what is an Index and demonstrates the following,

  1. Index creation
  2. Unique Index
  3. Dropping Index
Index
03:31

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

Transactions
04:34

Quiz
7 questions
+
Source
1 Lecture 00:12
Scripts
00:12
+
Conclusion
1 Lecture 00:18
Wrap Up
00:18
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.