SQL for Beginners in under 3 hours
4.1 (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.
13,413 students enrolled

SQL for Beginners in under 3 hours

Learn the basics of SQL using the freely downloadable SQL Server in less than 3 hours
4.1 (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.
13,413 students enrolled
Created by Ram Mohan
Last updated 11/2018
English
English [Auto]
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 6 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
  • Write basic SQL queries
  • Gain knowledge about databases
  • Be positioned to enter into a field that could potentially earn 6-figures
Requirements
  • Windows Based Computer to run and install SQL Server
  • No knowledge of SQL or databases are required
Description

Have you ever wondered if there is a course to help you learn the basics of SQL quickly without getting bogged down in details? This is the course for you then! We cover all the basics of SQL and even take on a few advanced topics - all in less than 3 hours. Join in and you'll end up being a confident SQL user at the end!

Sample of reviews from students:

Navyashree N - "Firstly thank you for the course.The course helped me a lot about basics of SQL and the way of lecturing is good."

Mohamed Afridi - "It was very usefull in short time. I learn something i don't known thanks you for your course"

Lakshmikumar kongaru - "its really gave me a good understanding on sql and its really interesting to know about it."

Richard Conaway - "Informative and straightforward. Great introduction into the subject."

Tafara Shamu - "Enough for a refresher course, and amazing for a beginner."

Who this course is for:
  • Beginners who are taking their first step into SQL
  • A little bit of experience in IT is helpful though not mandatory
Course content
Expand all 32 lectures 02:59:46
+ Introduction to Datasbases and SQL
6 lectures 20:11

Understand a bit more about the lecturer

Preview 01:38

Understand about what a database is and why it is important in the field of computers

What is a database?
04:27

What is SQL and why do I need to know about it? What are the benefits to learning SQL

Preview 02:37

How to install SQL server and the SQL Server Management Studio on your laptop to practice your learnings

Installation of SQL Server and Management Studio
07:00

Guide to alternate resources that you can use to learn SQL if you cannot install SQL Server on your laptop/desktop

Alternatives to installing SQL Server
02:06

Recap of what was learnt in this section

Recap
02:23

Quiz to reinforce learnings in this section

Test your knowledge of databases and SQL
4 questions
+ Reading data from tables
7 lectures 01:00:47

Understand the definitions of DDL, DML, DCL and TCL

Types of SQL commands
03:29

How to download and install Adventure Works database for use in our lessons

Installing Sample Database for our exercises
02:39

Understand Simple Select Queries and Select Distinct keywords

Preview 06:44

Select queries with Where Clause, AND, OR and NOT Operators

Conditional Select Queries
15:03

Select queries with functions like Min(), Max() etc

Select queries with functions
12:14

How to query multiple tables using the select query

Queries using multiple tables
18:46

A recap of the concepts learned in this section

Recap
01:52

to test the understanding around Types of Queries and Select queries

Test your knowledge about Types of Queries and Select queries
5 questions
+ Defining , creating and modifying tables
6 lectures 43:11

How to create a table in SQL

Create table
10:32

Changing an existing table

Preview 07:37

Deleting a table

Delete table
02:52

Various constraints that can be placed on a table with examples

SQL constraints
07:20

The difference between primary key, foreign key and how to correctly use them

Primary Key vs Foreign Key
13:29

Recap on DDL

Recap
01:21

Quiz to test learning

Test your knowledge about creating, deleting and modifying tables
4 questions
+ Add new data and update existing data
5 lectures 21:17

Add new data using Insert statement

Adding new data
10:25

Update already existing data in a table

Preview 04:04

How to delete data from existing tables

Delete existing data
02:17

How indexes, keys and other constraints affect data manipulation

Pitfalls to watch out for
03:20

Recap on how to add new data and modify existing data

Recap
01:11

Quiz to test knowledge

Test your knowledge about adding, removing and altering data in tables
4 questions
+ Introduction to Advanced SQL Topics - Transactions, commits, rollbacks
4 lectures 20:39

Definition of RDBMS and ACID properties

What is a RDBMS
06:24

How to create checkpoints and rollback to a checkpoint

Commits and rollbacks
07:10

Introduction to Stored Procedures and Triggers

Stored Procedures and Triggers
06:10

Recap of RDBMS, Commit, checkpoints and rollbacks

Preview 00:55

Quiz to test knowledge

Test your knowledge on advanced SQL topics
4 questions
+ Extras Section - Optimization, Documentation and Student Challenge
4 lectures 13:41

Factors to consider when designing tables

Preview 04:22

Explain plan, AWR Reporting, TKProf

Query Optimization
03:11

Come up with a Database of Udemy (or your favorite site), populate with some sample data and retrieve the same

Handy resources and Additional Challenge
04:34
Goodbye and thank you
01:34