The T-SQL Toolbox [Beginner to Intermediate]

Udemy The T-SQL Toolbox [Beginner to Intermediate]

Register & Get access to index
4645684-447e-3.jpg

A Practical course to learning T-SQL

Description​

This course is intended for those with little to no experience and who would like to learn practical database design skills + specific T-SQL scripting knowledge.

The Benefits of this course

  • Highly practical
    • The concepts shared throughout this course are related to my real-world experience as a T-SQL developer
    • What I wish I would have known before starting T-SQL
  • High-Quality Audio
    • This course is recorded with a RODE PODMIC - which is one of the highest quality microphones for auditory dictation
  • Quizzes and Assignments
    • This course contains quizzes and assignments for each new topic introduced to ensure learning is fortified by the student
The course structure

  • Exploring Career Pathways
    • Providing Incentive to continue your T-SQL development
  • Relational database History
    • Understanding how relational databases evolved
  • Database design theory
    • Fundamental knowledge of how to design tables with the use of constraints
    • Cardinality (1-m, m-n,1-1) relationships
  • Joining other tables
    • Learning the difference between the main type of joins, to limit or expand our data set.
  • Windows Functions
    • Diving deep into the syntax and theory of windows functions. So the student can have a sound knowledge of how to implement windows functions.
  • Storing Data temporarily
    • At times T-SQL developers are required to hold onto a dataset for various reasons - I will explain 3 key ways to do so.

The intended audience

  1. Managers who would like to become more technical
  2. Analysts/Engineers who would like to revisit the fundamentals.
  3. Anybody curious about T-SQL and would like to learn more
  4. Students currently studying a database management course.

Thank you and all the best,
Kristian Buddy

Who this course is for:​

  • Data Engineers
  • Business/Data Analysts
  • Business Intelligence Analyst
  • Managers who would like to level up their skill in T-SQL
  • Anyone who is curious about T-SQL
Author
Satoru Gojo
Downloads
36
Views
469
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from Satoru Gojo