Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.
4.4 (1,169 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.
29,852 students enrolled
Free
Start Learning Now
  • Lectures 27
  • Length 3.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course 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.

What are the requirements?

  • People should have worked with SQL server and know how to query using management studio
  • 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"

What am I going to get from this course?

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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
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

Section 2: SQL Views
05:43

A brief walkthrough of the concept of SQL views.

SQL Views - Deep Dive into Querying
08:19
Section 3: SQL Triggers
SQL Triggers - An Introduction
04:33
SQL Triggers - Deep dive into Querying
09:08
Section 4: SQL Computed Columns
SQL Computed Columns - An Introduction
03:03
SQL Computed Columns - Deep dive into Querying
02:17
Section 5: SQL Stored Procedures
SQL Stored Procedures - An Introduction
09:27
SQL Stored Procedures - Deep dive into Querying
17:06
Section 6: SQL User Defined Functions (UDF)
SQL User Defined Functions - An Introduction
04:33
SQL User Defined Functions - Deep dive into Querying
10:34
Section 7: SQL Transactions and Error Handling
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
Section 8: SQL grouping functions and Ranking functions
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
Section 9: SQL XML data-types
SQL XML Datatype - An Introduction
05:51
SQL XML Datatype - Deep Dive into Querying
15:11
Section 10: SQL Partitions
SQL Partitions - An Introduction
04:19
SQL Partitions - Deep Dive into Querying
11:56
Section 11: SQL Dynamic Queries
SQL Dynamic Queries and Pivots - An Introduction
03:42
SQL Dynamic Queries and Pivots - Deep dive into QUerying
05:55
Section 12: SQL Filestream and Free-Text Search
SQL Filestream
07:27
SQL Free-Text Search
08:52
Section 13: SQL Geography and Geometry datatype
Geometry and Geography Data Types
11:22
Section 14: Conclusion and Next steps
Conclusion and Next Steps
04:54

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Ready to start learning?
Start Learning Now