Advanced Databases and SQL Querying
4.4 (2,251 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.
47,760 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
4.4 (2,251 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.
47,760 students enrolled
Last updated 4/2017
English
English [Auto-generated]
Price: Free
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Write complex TSQL queries.
  • Know the different TSQL functionalities that exist
  • Write more efficient TSQL code
View Curriculum
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
03:20:38
+
Introduction
1 Lecture 02:31

Welcome this course! We revisit some concepts from the previous course (Introduction to Databases and Querying) and walk you through the agenda for this course

Introduction
02:31
+
SQL Views
2 Lectures 14:02

A brief walkthrough of the concept of SQL views.

SQL Views - An Introduction
05:43

SQL Views - Deep Dive into Querying
08:19
+
SQL Triggers
2 Lectures 13:41
SQL Triggers - An Introduction
04:33

SQL Triggers - Deep dive into Querying
09:08
+
SQL Computed Columns
2 Lectures 05:20
SQL Computed Columns - An Introduction
03:03

SQL Computed Columns - Deep dive into Querying
02:17
+
SQL Stored Procedures
2 Lectures 26:33
SQL Stored Procedures - An Introduction
09:27

SQL Stored Procedures - Deep dive into Querying
17:06
+
SQL User Defined Functions (UDF)
2 Lectures 15:07
SQL User Defined Functions - An Introduction
04:33

SQL User Defined Functions - Deep dive into Querying
10:34
+
SQL Transactions and Error Handling
3 Lectures 23:59
SQL Transactions and Error Handling - An Introduction
05:07

SQL Transactions and Error Handling - An Introduction (Continued)
05:17

SQL Transactions and Error Handling - Deep Dive into Querying
13:35
+
SQL grouping functions and Ranking functions
3 Lectures 19:56
SQL Grouping Sets and Common Table Expressions
09:57

SQL Ranking Functions - An Introduction
04:09

SQL Ranking Functions - Deep Dive into Querying
05:50
+
SQL XML data-types
2 Lectures 21:02
SQL XML Datatype - An Introduction
05:51

SQL XML Datatype - Deep Dive into Querying
15:11
+
SQL Partitions
2 Lectures 16:15
SQL Partitions - An Introduction
04:19

SQL Partitions - Deep Dive into Querying
11:56
4 More Sections
About the Instructor
Rakesh Gopalakrishnan
4.4 Average rating
9,181 Reviews
102,539 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.