Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

4.51 (46853 reviews)
Udemy
platform
English
language
Other
category
Introduction to Databases and SQL Querying
547,367
students
2.5 hours
content
Jan 2018
last update
FREE
regular price

What you will learn

Query a database, Create Tables and Databases and be proficient with basic SQL querying

Description

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

Content

Introduction and Setup

Lecture 1: Introduction to Databases
Installing / Setting up Environment / SQL Management Studio

Introduction to Querying

Creating your First SQL Table
Installing Sample Database (Adventure Works) and Querying

Deep Dive into Querying

Lets Start Writing some SQL code
Deep Dive into SQL Querying

SQL Joins

SQL Joins (1/2)
SQL Joins (2/2)

Dates / Aggregation and String Functions

TSQL Date Functions
TSQL Aggregation and String Functions
Lecture 11: Conclusion

Reviews

Carlos
October 26, 2023
Reallly easy to understand, everything is explained very well so is hard to get lost even if this course is so old, i'm seing on 2023 and working with SQL server 2022 from microsoft and everything works well so is great for start learning SQL. But it was the only difficulty to download everything with current versions of everything, after that everything good
Anoop
October 20, 2023
Could you please provide some additional exercises and materials, I think that would be much more helpful.
Gabrielle
September 20, 2023
The instructor did a great job of thoroughly explaining the content and showing great examples as well as exercises.
Vincent
September 18, 2023
The voice in general and all the mouth noises between sentences or slides, for me, it was difficult to not give attention to thoses noises in my headphone. I am not very good in english so with the accent, it was more difficult...I would prefer AI voice instead. But thats just me and i dont write comments often but it was really annoying. Sorry. Still, the course is free so im lucky watch it, i just turn off the sound and watch subtitles. Thank you.
Alfred
September 17, 2023
All Content of this course are clear and easy to follow, I hope more Free Courses in the future. Godbless
Hendrik
September 14, 2023
The course matches to its title. So you can go hands on and experiment on sql queries after you watched some of the tutors videos. Straight forward material of 2.5 total hours. Theres not much overall information around databases or designing them. So you will want to pick a book or another course after this one to understand more of the topic. Its a course to start out for me. Still I wouldn't undeerstimate the value of understanding you achive from taking this course.
Richard
September 13, 2023
May be a little outdated for 2023, and lacks some depth, but it seems like a neat and concise introduction to the topic despite being made in 2015.
Andrea
September 12, 2023
I am understanding this course. The instructor is very knowledgeable, and give great examples to help you understand the subject.
Manzoor
September 6, 2023
One of the finest and most highly informative courses on SQL I have ever seen. Being a beginner in SQL, I learned a lot from this course for Free. I highly recommend this course, IT IS OUTSTANDING
Rajat
August 27, 2023
Very good course for beginners. I thought to refresh my knowledge, and it helped me boost my confidence for the next step.
Andhika
August 18, 2023
It's an excellent course for beginners who have no prior knowledge of SQL and Databases. However, it is a bit outdated so new users will probably have to adjust or consult other websites during the environment setup.
Arthi
August 11, 2023
Its more in to practical, it would be more understandable and good if the author gives an introduction about DDL, DML, etc..
NIRMAL
August 8, 2023
Very nice course and in a simple way all the important things are covered. Thanks for this ultimate course.
Lisa
August 8, 2023
The instructor explains everything clearly and makes it easy to understand. I would recommend for beginners as it will give you a great introduction into what to expect if you want to take your learning on this topic further.
Joy
August 4, 2023
I like the presentation, very detailed and tailored for a layman beginner analyst to properly understand. Kudos to you for assisting us!

Charts

Price

Introduction to Databases and SQL Querying - Price chart

Rating

Introduction to Databases and SQL Querying - Ratings chart

Enrollment distribution

Introduction to Databases and SQL Querying - Distribution chart
552672
udemy ID
7/12/2015
course created date
8/9/2019
course indexed date
Bot
course submited by