Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.
Rating: 4.4 out of 5 (30,744 ratings)
326,724 students
Introduction to Databases and SQL Querying
Rating: 4.4 out of 5 (30,744 ratings)
326,724 students
Query a database, Create Tables and Databases and be proficient with basic SQL querying

Requirements

  • There is absolutely no pre-requisites for the course. We will walk through very basic installation to setting up your environment to creating your first table and writing 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-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.

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
Course content
5 sections • 11 lectures • 2h 17m total length
  • Lecture 1: Introduction to Databases
    10:51
  • Installing / Setting up Environment / SQL Management Studio
    11:04
  • Creating your First SQL Table
    12:13
  • Installing Sample Database (Adventure Works) and Querying
    05:15
  • Lets Start Writing some SQL code
    17:41
  • Deep Dive into SQL Querying
    13:45
  • SQL Joins (1/2)
    13:35
  • SQL Joins (2/2)
    22:56
  • TSQL Date Functions
    10:51
  • TSQL Aggregation and String Functions
    14:57
  • Lecture 11: Conclusion
    04:03

Instructor
Over 260,000 Students
Rakesh Gopalakrishnan
  • 4.4 Instructor Rating
  • 57,070 Reviews
  • 512,010 Students
  • 7 Courses

I am a coder, manager, educator and a gamer. I love data and analytics. In my day job, I work with database technologies including SQL , Big Data and Tableau. I am passionate about technologies and love coding and managing teams. In my spare time I like to teach Big Data analytics, Databases, Programming etc. I am currently working on certain machine learning and Data Science projects and love to explore more in the Statistics field.