SQL for Beginners in under 3 hours

Name: SQL for Beginners in under 3 hours
Rating: 4.4 (227 reviews)

Learn the basics of SQL using the freely downloadable SQL Server in less than 3 hours

Created byRam Mohan

Last updated 3/2022

English

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

Course content

6 sections • 33 lectures • 3h 0m total length

Introduction to lecturer and the course1:38
Understand a bit more about the lecturer
What is a database?4:27
Understand about what a database is and why it is important in the field of computers
What is SQL (Structured Query language) and why should I care about it?2:37
What is SQL and why do I need to know about it? What are the benefits to learning SQL
Installation of SQL Server and Management Studio7:00
How to install SQL server and the SQL Server Management Studio on your laptop to practice your learnings
Alternatives to installing SQL Server2:06
Guide to alternate resources that you can use to learn SQL if you cannot install SQL Server on your laptop/desktop
Recap2:23
Recap of what was learnt in this section
Test your knowledge of databases and SQL

Types of SQL commands3:29
Understand the definitions of DDL, DML, DCL and TCL
Installing Sample Database for our exercises2:39
How to download and install Adventure Works database for use in our lessons
Simple Select Queries6:44
Understand Simple Select Queries and Select Distinct keywords
Conditional Select Queries15:03
Select queries with Where Clause, AND, OR and NOT Operators
Select queries with functions12:14
Select queries with functions like Min(), Max() etc
Queries using multiple tables18:46
How to query multiple tables using the select query
Recap1:52
A recap of the concepts learned in this section
Test your knowledge about Types of Queries and Select queries

Create table10:32
How to create a table in SQL
Alter table7:37
Changing an existing table
Delete table2:52
Deleting a table
SQL constraints7:20
Various constraints that can be placed on a table with examples
Primary Key vs Foreign Key13:29
The difference between primary key, foreign key and how to correctly use them
Recap1:21
Recap on DDL
Test your knowledge about creating, deleting and modifying tables

Adding new data10:25
Add new data using Insert statement
Update existing data4:04
Update already existing data in a table
Delete existing data2:17
How to delete data from existing tables
Pitfalls to watch out for3:20
How indexes, keys and other constraints affect data manipulation
Recap1:11
Recap on how to add new data and modify existing data
Test your knowledge about adding, removing and altering data in tables

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

SQL for Beginners in under 3 hours

What you'll learn

Explore related topics

Course content

Introduction to Datasbases and SQL6 lectures • 20min

Reading data from tables7 lectures • 1hr 1min

Defining , creating and modifying tables6 lectures • 43min

Add new data and update existing data5 lectures • 21min

Introduction to Advanced SQL Topics - Transactions, commits, rollbacks4 lectures • 21min

Extras Section - Optimization, Documentation and Student Challenge5 lectures • 14min

Requirements

Description

Who this course is for: