Advanced Databases

Advanced Databases and SQL Querying

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

Advanced Databases and SQL 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.

What you´ll learn

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"

Course content

º Introduction
Introduction
º SQL Views
SQL Views - An Introduction
SQL Views - Deep Dive into Querying
º SQL Triggers
SQL Triggers - An Introduction
SQL Triggers - Deep dive into Querying
º SQL Computed
SQL Computed Columns - An Introduction
SQL Computed Columns - Deep dive into Querying
º SQL Stored
SQL Stored Procedures - An Introduction
SQL Stored Procedures - Deep dive into Querying
º SQL User Defined
SQL User Defined Functions - An Introduction
SQL User Defined Functions - Deep dive into Querying
º SQL Transactions
SQL Transactions and Error Handling - An Introduction
SQL Transactions and Error Handling - An Introduction (Continued)
SQL Transactions and Error Handling - Deep Dive into Querying
º SQL Grouping
SQL Grouping Sets and Common Table Expressions
SQL Ranking Functions - An Introduction
SQL Ranking Functions - Deep Dive into Querying
º SQL XML
SQL XML Datatype - An Introduction
SQL XML Datatype - Deep Dive into Querying
º SQL Partitions
SQL Partitions - An Introduction
SQL Partitions - Deep Dive into Querying
º SQL Dynamic
SQL Dynamic Queries and Pivots - An Introduction
SQL Dynamic Queries and Pivots - Deep dive into QUerying
º SQL Filestream
SQL Filestream
SQL Free-Text Search
º SQL Geometry
Geometry and Geography Data Types
º Conclusion
Conclusion and Next Steps






Our task is to centralize the largest number of courses, training, tutorials, videos to make it easier for you to search when you want to train.
Generally, we incorporate those that are free, but if we find some interesting ones that are paid, we add them so that your training is more profitable and professional.
Keep training yourself to become a better professional or simply for personal achievements, cheer up, don't give up and go ahead !!!.
Good luck !!! The team of: