Advanced Databases and SQL Querying

Advanced Databases and SQL Querying, available at Free, has an average rating of 4.48, with 28 lectures, based on 13336 reviews, and has 285088 subscribers.

You will learn about Write complex TSQL queries. Know the different TSQL functionalities that exist Write more efficient TSQL code This course is ideal for individuals who are 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. It is particularly useful 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.

Enroll now: Advanced Databases and SQL Querying

Summary

Title: Advanced Databases and SQL Querying

Price: Free

Average Rating: 4.48

Number of Lectures: 28

Number of Published Lectures: 27

Number of Curriculum Items: 28

Number of Published Curriculum Objects: 27

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Write complex TSQL queries.
Know the different TSQL functionalities that exist
Write more efficient TSQL code

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: SQL Views

Lecture 1: SQL Views – An Introduction

Lecture 2: SQL Views – Deep Dive into Querying

Chapter 3: SQL Triggers

Lecture 1: SQL Triggers – An Introduction

Lecture 2: SQL Triggers – Deep dive into Querying

Chapter 4: SQL Computed Columns

Lecture 1: SQL Computed Columns – An Introduction

Lecture 2: SQL Computed Columns – Deep dive into Querying

Chapter 5: SQL Stored Procedures

Lecture 1: SQL Stored Procedures – An Introduction

Lecture 2: SQL Stored Procedures – Deep dive into Querying

Chapter 6: SQL User Defined Functions (UDF)

Lecture 1: SQL User Defined Functions – An Introduction

Lecture 2: SQL User Defined Functions – Deep dive into Querying

Chapter 7: SQL Transactions and Error Handling

Lecture 1: SQL Transactions and Error Handling – An Introduction

Lecture 2: SQL Transactions and Error Handling – An Introduction (Continued)

Lecture 3: SQL Transactions and Error Handling – Deep Dive into Querying

Chapter 8: SQL grouping functions and Ranking functions

Lecture 1: SQL Grouping Sets and Common Table Expressions

Lecture 2: SQL Ranking Functions – An Introduction

Lecture 3: SQL Ranking Functions – Deep Dive into Querying

Chapter 9: SQL XML data-types

Lecture 1: SQL XML Datatype – An Introduction

Lecture 2: SQL XML Datatype – Deep Dive into Querying

Chapter 10: SQL Partitions

Lecture 1: SQL Partitions – An Introduction

Lecture 2: SQL Partitions – Deep Dive into Querying

Chapter 11: SQL Dynamic Queries

Lecture 1: SQL Dynamic Queries and Pivots – An Introduction

Lecture 2: SQL Dynamic Queries and Pivots – Deep dive into QUerying

Chapter 12: SQL Filestream and Free-Text Search

Lecture 1: SQL Filestream

Lecture 2: SQL Free-Text Search

Chapter 13: SQL Geography and Geometry datatype

Lecture 1: Geometry and Geography Data Types

Chapter 14: Conclusion and Next steps

Lecture 1: Conclusion and Next Steps

Instructors

Rakesh Gopalakrishnan
Over 600,000 Students

Rating Distribution

1 stars: 122 votes
2 stars: 241 votes
3 stars: 1653 votes
4 stars: 5300 votes
5 stars: 6023 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu