Introduction to Transact SQL

Course Feature

Cost

Free
Provider

Udemy
Certificate

Paid Certification
Language

English
Start Date

On-Demand
Learners

No Information
Duration

2.00
Instructor

QuickStart Learning Inc.

Add to Favorites

Next Course

4.5

1 Ratings

Explore the essentials of Introduction to Transact SQL

Show All

Go to class

Course Overview

❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [May 19th, 2023]

Introduction to Transact SQL

What you'll learn:

SQL Dialects
ASCII vs Unicode
Data Types
Case-Sensitive Collation
Filtering Records with the Where Clause
Sorting Result Sets

This free course is only an introduction of Transact SQL, to give you an idea about how Transact SQL database queries are performed in Visual Studio. This course is not intended to make you an expert in Transact-SQL, instead the course is designed to give you a basic idea to help you plan your future learning and project.
Transact SQL or T-SQL is a standardized computer language for querying, altering and defining relational databases, using declarative statements. While this course is specifically focused on Microsoft product, most of what you learn will be applicable to any SQL based database including Oracle, DB2, MySQL etc.
This course does not assume that you have any prior knowledge of T-SQL. If you understand relational database concepts it will be a benefit, however it is not a prerequisite.

Show All

Pros & Cons

Course broken down into nice chunks.
In depth review of T SQL basics.
Simple and short explanation.

No DML, no DDL, no functions.
Spelling accuracy needs to be checked.
Limited usage of SSMS.

Show All

Recommended Courses

SQL Tutorial - Full Database Course for Beginners

5.0

freeCodeCamp 13 learners

Learn More

This SQL Tutorial - Full Database Course for Beginners is an online course designed to teach beginners the basics of SQL. It covers topics such as what a database is, tables and keys, SQL basics, MySQL installation, creating tables, inserting data, constraints, updating and deleting data, basic queries, company database introduction, creating a company database, more basic queries, functions, wildcards, union, joins, nested queries, on delete, triggers, ER diagrams introduction, designing an ER diagram, and converting ER diagrams to schemas. This course is comprehensive and provides a great introduction to SQL for beginners.

Beginners Introduction to SQL and Databases

4.5

Udemy 3 learners

Learn More

This online course is a great introduction to SQL and databases for beginners. It covers the basics of SQL and databases, how to connect to MySQL, and an introduction to MySQL. It is a comprehensive course that will help students understand the fundamentals of SQL and databases. It is well-structured and easy to follow, making it a great starting point for those new to the subject. The course is also suitable for those who want to refresh their knowledge of SQL and databases. Overall, this is an excellent course for anyone looking to learn the basics of SQL and databases.

SQL you need as a Data Scientist

2.0

Youtube 0 learners

Learn More

This course provides an introduction to SQL for data scientists. It covers topics such as SELECT, JOIN, WHERE, Aggregations, CASE WHEN Statements, Common Table Expressions CTEs, Window Functions, and two applications: Time Series Forecasting and Fraud Prediction. It is designed to help data scientists gain the skills they need to work with SQL.

SQL- The Complete Introduction to SQL programming

4.3

Udemy 169,188 learners

Learn More

This course is the perfect introduction to SQL programming. It covers everything you need to know to get started, from setting up the software to understanding the basics of manipulating data and creating databases. With this course, you'll learn the theory behind SQL and how to think like a programmer. You'll also get plenty of practice to help you reach your full potential. Plus, the course is designed for those with no prior programming experience. And with a 100% satisfaction guarantee, you can't lose - enrol now and start learning today!