The T-SQL Toolbox [Beginner to Intermediate]

A Practical course to learning T-SQL

Created by: Kristian Lofts
T-SQL Developer

What Will I Learn?

• What are your career options by learning T-SQL
• The History and evolution of relational databases
• Installing SSMS + ERD Notation Software
• Designing a database within a ERD software
• Understanding the difference between certain data types
• Becoming Familiar with the SSMS environment (Hotkeys, Shortcuts etc)
• Creating Tables and inserting data based on certain constraints
• The Basic T-SQL Statements (SELECT,FROM,GROUP BY,HAVING,ORDER BY)
• Different types of joins which can limit or expand your dataset
• Windows Function to add sophistication to your queries
• Storing data temporarily through CTES,Derived Table or #Temp tables
• Hands on T-SQL experience through fun quizzes and CHALLENGING assignments.

Requirements

• No programming experience required.
• A great attitdue towards learning and progressing your skills

Target audience

• 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