Development
Programming Languages
SQL
Learn SQL in a simplified manner
4.3 (399 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.
11,365 students enrolled

Learn SQL in a simplified manner

Learn SQL in just four weeks, right from scratch !
4.3 (399 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.
11,365 students enrolled
Created by Parteek Bhatia
Last updated 5/2020
English
English [Auto-generated]
Preview this course
Learn SQL in a simplified manner
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 article
  • 24 downloadable resources
  • 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
  • SQL is one of the most in demand tech skills today, and learning SQL would surely be one of the fastest and most efficient way to improve ones career prospectus. After the completion of course, one will be able to read, write and comprehend simple to most complex queries of SQL, using which they could work upon any SQL database such as Oracle, Amazon Redshift and others.
Course content
Expand all 18 lectures 02:30:57
+ – Basics of SQL
3 lectures 24:14
Introduction to SQL
Preview 07:12

This video sessions shows how we can work on Oracle without installing this on machine. We just need Internet to access this over cloud server and we can execute SQL and PL/SQL code from browser.

Demonstartion of Live SQL (Cloud Platfrom to exceute SQL Commands)
04:03
Performing Basic Operations with SQL
Preview 12:59

This quiz will basically test your understanding of Section 1 : Introduction to SQL

Introduction to SQL
5 questions
+ – Creation of Tables with Constraints
6 lectures 44:35
Need of Constraints
04:43
Not Null, Unique and Primary Key Constraint
11:04
CHECK constraint
06:37
FOREIGN KEY Constraint
07:21
Demonstration of Foreign Key constraint
09:34
DEFAULT Constraint and Accessing Constraint information
05:16

This quiz will basically test your understanding of Section 2 : Creation of Table with constraints

Creation of Table with constraints
8 questions
+ – Table Alteration
2 lectures 14:35
Alter Table Add Option
06:56

After completion of this video learner will able to modify and drop existing constraints.

Alter Table: Modify and Drop Option
07:39
+ – Joining of Tables
3 lectures 25:58
Joining of tables and Its Types
09:12
OUTER JOIN
Preview 06:26
SELF JOIN
10:20

This quiz will basically test your understanding of Section 3 : Creation of Table with constraints

Table Alteration and SQL joins
6 questions
+ – Grouping of Data
4 lectures 41:34
GROUP BY Clause
11:29
GROUPING on more than one column
13:12
HAVING Clause
12:24
Inbuilt Functions of SQL
04:29

This quiz will basically test your understanding of Section 4 : Grouping of Data 

Grouping of Data
6 questions
Requirements
  • Zero prior technical experience is required! All you need is a computer with good Internet connectivity!
  • Although for running SQL queries, Oracle software is required.
Description

Learn SQL in a simplified manner is one of the best SQL course on Udemy crafted in a way that it would serve both the beginner and software professionals who want to learn or refresh their knowledge on one of the most in demand skill of tech world - SQL. The course is designed in a way that one could complete it in less than 4 weeks with 0 prior experience to programming. 

Who is the course for?

This course is designed for the learners who are:

  • beginners in this field

  • want to prepare for University examinations

  • want to prepare for placement interviews

  • software professionals who want to quick start there carrier as SQL expert

in a short time span.

What topics will this course cover?

  • Create Tables in SQL

  • Perform Basic Operations of database like Insert, Update, Delete and Retrieve with SQL

  • Integrity Constraints

  • Alteration in existing table structure

  • Learn to Join one and more Tables in the database

  • Learn Grouping of Data

What will you achieve?

By the end of the course, you'll be able to...

  • Design tables to store data

  • Demonstrate the use of Insert, Update, Delete and Retrieve operations on database

  • Apply integrity constraints during creation of tables

  • Perform alteration in structure of existing table

  • Access data from multiple tables with the use of Join operations

  • Perform grouping of data on one or more columns

  • Perform selection of groups

  • Explore the use of database in modern world

Learn and Explore the world of Database !

HAPPY LEARNING !!!!

Who this course is for:
  • Anyone who is interested in learning more about SQL.