Introduction to Databases and SQL Querying
About Course
- his 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.
Requirements
Computing for Data Analysis Introduction to Analytics Modeling Basic Programming Proficiency Probability Statistics Linear algebra Basic Calculus
What I will learn?
- Introduction and Setup
- Introduction to Querying
- Deep Dive into Querying
- SQL Joins
- Dates/Aggregation and String Functions