Introduction to Databases and SQL Querying

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

4.51 (46016 reviews)

Udemy

platform

English

language

Other

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

Aboubacar

July 29, 2023

This course is really amazing, i am now able to use relational database queries very easily. Thanks a lot

Neda

July 27, 2023

Such a great course. They explain everything very clear and make it simple to understand it easily. Thanks so much for the course.

Bollepogu

July 19, 2023

The course is designed in an efficient manner which is helpful to the people who dont have basic knowledge . i suggest to keep some assignmens so that it wille be more efficient.

Digital

July 10, 2023

It's realy simply SQL! Highly recommend this course. You'll get clear understanding of basic principles and operations with SQL data.

Fraser

July 4, 2023

very informative, couple of areas that could have done with a bit clearer explanation but on the whole good and helpful

Anatoli-Maria

June 12, 2023

Sehr viele Beispiele, Query-Befehle mit Ergebnissen, leicht und verständlich, visualisiert und erklärt. Hervorragende Struktur, erstmal die Basic erklärt, die Installierung, danach SQL Code, später fortgeschrittene Abläufe, am Ende alle JOINS dargestellt und PRAXIS-Beispiele gezeigt. Super

Khusi

June 10, 2023

Throughout the course, the concepts were explained with ample amount of examples thus, it was quite easier to learn and understand, how the things happen while we write query for them.

Arjun

May 22, 2023

Need to be more explanatory with example, I was feeling tough initially to understand but later I got it

Malathi

May 21, 2023

Yes. This video is really helpful to me to learn more about basics of SQL. I want to learn advanced concepts of triggers, query tuning and so on. And I need real time experience. Thanks

Jarika

May 13, 2023

First off, this is FREE, and it is full of very helpful information and examples. I appreciate the instructor's presentation of information. I used this as a refresher for a job interview, and I feel much more prepared now. Thank you, Rakesh!!!

Khwab

May 4, 2023

It was a pretty good course for digging your roots into SQL. It helped me a lot to get started with SQL and to grease off the resistance that one have when starting to learn a new technology.

Harshita

May 2, 2023

The course was very informative with proper formulations and databases to practice with. My one request would be to be more careful with the video zooming as some parts of the screen where data was present were cut off and the continuous zooming in and out was a little difficult to catch and confusing.

PHANISHANKAR

April 22, 2023

The Subtitles are so wrong and 40% of the words are not written right but very very wrong. This should be improved.

Jacqueline

February 22, 2023

It is good, once i got used to the accent yet im still worried i wont know what to type in....so maybe that will come next in the course

Werner

January 22, 2023

A course that has a clear and concise explanation of SQL. I started a new job which require SQL and server set up and this course is makes everything easier for me. I cant believe it free too. Highly recommended.

Charts

Price

Rating

Enrollment distribution

Introduction to Databases and SQL Querying - Distribution chart