Udemybeginneren

Learn to Program with T- SQL

Learn SQL! Master database manipulation with practical SQL programming skills. Essential for data analysis and management. Get hands-on experience.

4.2(10)
505students
5h 32m
Certificate
Skill Tree
Skill TreeSkill based learning

Course Content

Learn to Program with T- SQL is a beginner-level Udemy course taught by Skill Tree. It runs 5h 32m, is taught in English, and includes a certificate of completion. Learners rate it 4.2 out of 5 from 10 reviews, with 505 students enrolled. It is a paid course, last updated June 2021.

Unlock the power of data with T-SQL (Transact-SQL)! This comprehensive course provides a solid foundation in SQL, a vital skill for anyone working with relational databases. You'll learn to effectively retrieve, manipulate, and manage data in popular database systems like SQL Server, Oracle, MySQL, MariaDB, and PostgreSQL.

Why is SQL so important? SQL skills consistently rank among the Top 3 most in-demand IT skills sought by recruiters and companies globally. This course focuses specifically on T-SQL, often referred to as T-Sequel, the proprietary extension of SQL developed by Microsoft for SQL Server.

We'll take a step-by-step approach, covering all the essential T-SQL features. You'll gain hands-on experience using SQL Server Express 2014 (a free download!) and the AdventureWorks 2014 database as your primary learning environment. We'll build practical T-SQL queries to extract data from and insert data into the database.

Starting with fundamental SELECT statements, we'll progressively introduce advanced concepts. You'll master techniques for:

  • Data Retrieval: Requesting data from a server and efficiently limiting and sorting data responses.
  • Data Filtering: Filtering records and removing duplicates to isolate the information you need.
  • Data Manipulation: Adding, updating, and deleting data within your database.
  • Data Aggregation: Using aggregate functions to obtain single output values from multiple rows.
  • Data Joining: Combining data from multiple tables using various join types.
  • T-SQL Command Structure: Writing basic T-SQL statements for various database operations.
  • T-SQL TOP Command: Understanding and utilizing the TOP command for limiting result sets.
  • Normalization: Grasping the principles of database normalization.

Throughout the course, you'll become proficient with SQL Server Management Studio 2014 (SSMS), the industry-standard tool for writing and executing T-SQL queries and viewing their output.

This beginner-friendly course is your gateway to understanding T-SQL and building a strong foundation in this core programming language. Whether you're a beginner or looking to solidify your SQL skills, this course will equip you with the knowledge and practical abilities to succeed.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

skillshare
skillshare
5.0(609)
51m
intermediate
skillshare
5.0
43m
beginner
pluralsight