Introduction to Databases and SQL Querying
4.4 (6,856 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
81,335 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Databases and SQL Querying to your Wishlist.

Add to Wishlist

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.
4.4 (6,856 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
81,335 students enrolled
Last updated 7/2017
English
English [Auto-generated]
Price: Free
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Query a database, Create Tables and Databases and be proficient with basic SQL querying
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
02:17:12
+
Introduction and Setup
2 Lectures 21:55

This is the first lesson of the multi-part series in Introduction to Databases and SQL. The course is aimed at providing 101 level introduction to Databases and writing basic queries. There is no pre-requisite to this course.

Lecture 1: Introduction to Databases
10:51

Here we look at how to setup your database environment. We Download and install SQL 2014 express edition and walk through SQL management studio. This will help viewers of this course to follow along with me.

Installing / Setting up Environment / SQL Management Studio
11:04
+
Introduction to Querying
2 Lectures 17:28

Here we walk through how to create your first SQL table. We look at inserting some basic data and basic querying.

Creating your First SQL Table
12:13

We walk through installing some sample databases, especially the adventure works database. This will help us the viewers to follow along with me. Adventure works database is a sample database provided by Microsoft.

Installing Sample Database (Adventure Works) and Querying
05:15
+
Deep Dive into Querying
2 Lectures 31:26

We introduce basic SQL syntax and look at some code. We query the adventure works database and look at the following clauses:

SELECT, WHERE , GROUP BY , HAVING, ORDER BY, IN, BEWTEEN , DISTINCT, CALCULATED COLUMN, TEMP TABLES and INSERT, DELETE , UPDATE

Lets Start Writing some SQL code
17:41

Deep Dive into SQL Querying
13:45
+
SQL Joins
2 Lectures 36:32

We introduce the concept of SQL Joins here. We walk through concepts of INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN AND CROSS JOIN.

SQL Joins (1/2)
13:35

We look at SQL syntax for SQL Joins here. We walk through syntax for INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN AND CROSS JOIN.

SQL Joins (2/2)
22:57
+
Dates / Aggregation and String Functions
3 Lectures 29:51

Next we start looking at SQL Date functions. Date functions like DATEADD(), DATEDIFF(), DATEPART() , GETDATE() are useful functions and makes it easier to easily query data having dates.

TSQL Date Functions
10:51

Next we walk through aggregation functions like SUM(), COUNT(), AVG(). We also walk through some String functions like LEFT(), RIGHT(), LTRIM(), RTRIM(), CONCAT(), UPPER(), LOWER(), LEN()

TSQL Aggregation and String Functions
14:57

We conclude our series of lectures on Introduction to Databases and Querying.

Rewind:

Introduction to Databases and Querying

(Database concepts, Table concepts , Basic Queries, SELECT , CRUD, JOINS, AGGREGATIONS, Dates Etc.)

Next Steps:

-Stored Procedures, Customer Functions, Triggers, Views, Temporary Tables

Advanced Concepts

-Database Tuning, Query Tuning, Indexing, CLR, Profiler, Loading Very large datasets

ETL

SSIS - Transferring data between systems and cleaning it up (beginners, Intermediate, Advanced)

Reporting

SSRS, Tableau

Big Data Analytics

Hadoop for beginners, Intermediate and Advanced

Lecture 11: Conclusion
04:03
About the Instructor
Rakesh Gopalakrishnan
4.4 Average rating
9,066 Reviews
101,784 Students
3 Courses
Over 100,000 Students

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.