The T-Sql Toolbox [Beginner To Intermediate]

A Practical course to learning T-SQL

What you'll 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
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 courseHighly 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-SQLHigh-Quality AudioThis course is recorded with a RODE PODMIC - which is one of the highest quality microphones for auditory dictation Quizzes and AssignmentsThis course contains quizzes and assignments for each new topic introduced to ensure learning is fortified by the studentThe course structure Exploring Career Pathways Providing Incentive to continue your T-SQL developmentRelational database History Understanding how relational databases evolvedDatabase design theoryFundamental knowledge of how to design tables with the use of constraintsCardinality (1-m, m-n,1-1) relationshipsJoining other tablesLearning the difference between the main type of joins, to limit or expand our data set.Windows FunctionsDiving 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 temporarilyAt 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 Managers who would like to become more technical Analysts/Engineers who would like to revisit the fundamentals. Anybody curious about T-SQL and would like to learn moreStudents currently studying a database management course.Thank you and all the best,Kristian Buddy

Overview

Section 1: Introduction

Lecture 1 Introduction to the course

Lecture 2 Career Pathways by Learning T-SQL

Lecture 3 Installation of SSMS (T-SQL Software)

Lecture 4 Installation of ERD Notation Software

Lecture 5 The Evolution of DB and DBMS Technologies

Lecture 6 ERD Notation

Lecture 7 Introduction to the SSMS Environment

Lecture 8 Data Types

Section 2: Create Table + Insert

Lecture 9 Create Table + Insert

Lecture 10 How to insert MOCK Data into your Tables

Section 3: How to query your database

Lecture 11 Insert Your Data

Lecture 12 Query Your Data

Section 4: JOINS

Lecture 13 Learning About JOINS!

Section 5: Windows Function

Lecture 14 Windows Function

Section 6: Storing Data Temporarily

Lecture 15 Temporary Results

Section 7: Professional Data Salary Survey 2022 Assignment

Section 8: Thankyou!

Lecture 16 Thankyou

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