Introduction to Databases and SQL Querying

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

What you’ll learn

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

Requirements

There are absolutely no pre-requisites for the course. We will walk through a very basic installation set up your environment create your first table and write queries against it. All videos are recorded in Windows OS. You can however follow this course on MAC/Linux if you have a Win VM setup

Description

This is an introductory course on Databases and SQL Querying. There are no pre-requisites 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.

Who this course is for:

This course is for beginners with absolutely no experience is database. The course will make you familiar with SQL Syntax and introduce you to the concept of databases. No Prior Programming experience is required. This course is probably not for you if you’re looking to learn more advanced and complex queries