Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The T-SQL Toolbox [Beginner to Intermediate]
Rating: 4.3 out of 5(2 ratings)
6 students

The T-SQL Toolbox [Beginner to Intermediate]

A Practical course to learning T-SQL
Created byKristian Lofts
Last updated 9/2022
English

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.

Course content

8 sections • 16 lectures • 2h 31m total length

  • Introduction to the course11:52

    Welcome to the first lecture.
    Im glad you are enrolled in this course.
    My goal is to make learning about T-SQL fun, challenging and a feasible career option for you.
    Please review the resources section to view the lecture notes.

  • Career Pathways by Learning T-SQL12:10

    • Different Job Titles you can acquire by being competent in T-SQL

    • Around the world Salary Comparison

    • A motivational lecture that will give you more drive to achieve your dream career

      **Please install SSMS before opening the Create + Insert file
      You Can watch the installation of the SSMS lecture to install SSMS.
      We will be using SQL Server Management Studio Version 18.7


  • Installation of SSMS (T-SQL Software)6:02

    A practical lecture on installing my favourite DBMS SSMS
    Please use the online SQL compiler if your OS is NOT windows - alternatively, you can use MYSQLWorkbench to follow along

  • Installation of ERD Notation Software1:56

    • Installation guide for the ERD Notation software

    • ERD Notation software is ER assistant

      Being familiar with ERD Software is important for anybody working with T-SQL. To Allow organised thinking to take place. If you document your databases well then being able to retrieve certain information from your diagram is simple

  • The Evolution of DB and DBMS Technologies8:59

    In this lecture, we cover basic definitions such as
    What is a database?
    What is a DBMS?
    And we take a look at the exciting history of DBMS/DB evolution since 3500BC!

  • ERD Notation8:01

    Covering concepts such as cardinality and an ERD diagram breakdown

  • Introduction to the SSMS Environment12:37

    An introduction to the environment of SSMS, including how to change your onscreen font size,enabling dark mode + more

  • Data Types10:35

    Introduction to commonly used data types within the SQL universe.
    Using the Cast function and practice with some SQL Statements

  • Quiz 1
  • Assignment 1

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 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

Report abuse