Advanced Databases and SQL Querying

Name: Advanced Databases and SQL Querying
Rating: 4.4 (12653 reviews)

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

Free tutorial

(12,653 ratings)

246,318 students

3hr 21min of on-demand video

Created by Rakesh Gopalakrishnan

English

English [Auto]

Write complex TSQL queries.

Know the different TSQL functionalities that exist

Write more efficient TSQL code

Requirements

People should have worked with SQL server and know how to query using management studio.All videos are recorded in Windows OS. You can however follow this course on MAC/Linux, if you have a Win VM setup
They should be able to setup their databases and environments.
Must be comfortable writing TSQL code and must know basic syntax like SELECT, INSERT, UPDATE etc.
If you are an absolute newbie, please watch my previous course titled "Introduction to Databases and Querying"

Description

This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.

Who this course is for:

This SQL course is meant for people who have some experience in writing TSQL code. If you are a newbie, I recommend watching my previous course titled "Introduction to databases and Querying". This course covers advanced topics like views, triggers, dynamic queries, pivots etc. If you are an absolute starter, this course is not for you.

Featured review

Soumyadip C.

255 courses

14 reviews

2 years ago

Short, Simple, and most efficient! Unlike plenty of other courses out there, Rakesh does not exaggerate. He explains the theory behind each concept exactly to the point, which is followed by a nice application of codes fulfilling requirements of use case scenarios. Kudos to such an amazing content creator!!!

Rakesh Gopalakrishnan

Over 600,000 Students

4.5 Instructor Rating
82,568 Reviews
778,767 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.