4.39 out of 5
4.39
9360 reviews on Udemy

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
Instructor:
Rakesh Gopalakrishnan
173,082 students enrolled
English [Auto]
Write complex TSQL queries.
Know the different TSQL functionalities that exist
Write more efficient TSQL code

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.

Introduction

1
Introduction

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

SQL Views

1
SQL Views - An Introduction

A brief walkthrough of the concept of SQL views.

2
SQL Views - Deep Dive into Querying

SQL Triggers

1
SQL Triggers - An Introduction
2
SQL Triggers - Deep dive into Querying

SQL Computed Columns

1
SQL Computed Columns - An Introduction
2
SQL Computed Columns - Deep dive into Querying

SQL Stored Procedures

1
SQL Stored Procedures - An Introduction
2
SQL Stored Procedures - Deep dive into Querying

SQL User Defined Functions (UDF)

1
SQL User Defined Functions - An Introduction
2
SQL User Defined Functions - Deep dive into Querying

SQL Transactions and Error Handling

1
SQL Transactions and Error Handling - An Introduction
2
SQL Transactions and Error Handling - An Introduction (Continued)
3
SQL Transactions and Error Handling - Deep Dive into Querying

SQL grouping functions and Ranking functions

1
SQL Grouping Sets and Common Table Expressions
2
SQL Ranking Functions - An Introduction
3
SQL Ranking Functions - Deep Dive into Querying

SQL XML data-types

1
SQL XML Datatype - An Introduction
2
SQL XML Datatype - Deep Dive into Querying

SQL Partitions

1
SQL Partitions - An Introduction
2
SQL Partitions - Deep Dive into Querying

SQL Dynamic Queries

1
SQL Dynamic Queries and Pivots - An Introduction
2
SQL Dynamic Queries and Pivots - Deep dive into QUerying

SQL Filestream and Free-Text Search

1
SQL Filestream
2
SQL Free-Text Search

SQL Geography and Geometry datatype

1
Geometry and Geography Data Types

Conclusion and Next steps

1
Conclusion and Next Steps
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
9360 Ratings

Detailed Rating

Stars 5
4080
Stars 4
3798
Stars 3
1207
Stars 2
192
Stars 1
83
e2cb64181142e178ab512b43cc0eb95f
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
This website uses cookies and asks your personal data to enhance your browsing experience.