SQL SERVER Procedures&Concepts - Raise Above Beginner Level

SQL SERVER Procedures&Concepts - Raise Above Beginner Level

Join this course and learn the concepts below by building 8 Stored Procedures.

First of all, learn how to build Stored Procedures, then, slowly add logic and functionality according to real-life scenarios that you are asked to complete as an SQL Server Developer.

The entire course is designed so that it explains every line of code that is written and also get a good knowledge of all the added Transact constructs, in a practical approach.

More or less, the T-SQL concepts that we will be working with and the constructs (like Stored Procedures) are probably the main features that you'll be using in your planned career either you choose to become a SQL developer or a Web Developer/App Developer.

Not the last, the 8th Stored Procedure will create with a click of a button a fully Many-to-Many relational database, so that means will also be dealing with concepts like PK, FK and Identity Incrementation.

As a summary, please read below some of the main subjects that this course deals with, and remember, you can freely browse the course for 30 days, because, if it is not what you searched for, you can ask a refund.

UNDERSTAND and APPLY inside Stored Procedures T-SQL concepts like:

3 Ways of Creating Dynamic Queries

Execute Dynamic Queries

The concept and utility of Cursors

SQL Server Pivot Operator

ROW_NUMBER() and create multiple Partitions

UPDATE with JOIN inside the same query 

OUTPUT clause, OUTER and CROSS APPLY

Create with a Procedure Many-to-Many relational database 

XML Parsing and master XML selection of Data 

Build Stored Procedures, Dynamic Queries, Clauses, Pivot Operator, XML parsing, building Database templates and others

Url: View Details

What you will learn

• Understand the concept of a Stored Procedure in a practical manner and embed inside of it other concepts like:
• Cursors, Dynamic Queries, Pivots, XML Parsing, Clauses and others
• Gain programming creativity

Rating: 4.4

Level: All Levels

Duration: 5.5 hours

Instructor: Stan Silviu Valentin