Best Free T Sql Courses

Find the best online Free T Sql Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings.

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 379414, Price: Free

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 198265, Price: Free

This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.

Microsoft SQL Server – An Introduction (2018 edition)

A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 27199, Price: Free

This course is a brief presentation of SQL Server.

We will install a version of SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.

No prior knowledge is required - just a willingness to learn.

See you on the course.

SQL Tutorial for Beginners – Learn SQL using 30 scenarios

A comprehensive course to teach you SQL on Mac and Windows using Azure Data Studio, Microsoft SQL Server and T-SQL

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 26188, Price: Free

SQL Tutorial for Beginners in 2020- Learn SQL quickly using 30 Scenarios on Mac and Windows

A comprehensive course to teach you SQL on Mac and Windows.

If you are looking for a complete SQL tutorial for beginners, this tutorial is a great way to learn SQL using 30 real-time scenarios.

You will be able to write SQL queries confidently by just practicing the 30 scenarios in this SQL Tutorial.

You can learn SQL on Mac and Windows from this SQL Tutorial. This SQL Tutorial will cover all the topics of Structured Query Language(SQL) starting from scratch. This tutorial is great for beginners who want to learn SQL and for professionals who want to brush up their SQL Skills.

Structured Query Language(SQL) is supported by various database management systems(DBMS).

In this SQL Tutorial, we will be using SQL Server to learn SQL on both Mac and Windows.

Microsoft's SQL Server is one of the most popular database management systems(DBMS) in the world and learning SQL using SQL Server can help you earn nearly $100,000 per year.Even if you use a different DBMS like MySQL, you can benefit a lot from this SQL Tutorial as more than 90% of the SQL skills you learn in this tutorial is easily transferable to other database management systems(DBMS).

What you'll learn from this SQL Tutorial:

1.Start from scratch installing SQL Server on Mac and Windows in 2020.

2.Learn SQL quickly using 30 real world Scenarios

3.Learn SQL using Azure Data Studio on Mac and Windows

4.Download and Restore a sample database(AdventureWorks) to SQL Server on Mac and Windows

5.Download and Install Azure Data Studio on Mac and Windows

6.Model real-world scenarios and write SQL queries across multiple tables

This beginner's course is for you if you want to learn SQL Skills in Mac or Windows.

Introduction to Transact SQL

Introduction to Transact SQL

Created by QuickStart Learning Inc. - QuickStart Learning Inc.

"]

Students: 8367, Price: Free

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.

SQL Beginner’s Level Course

Learn T-SQL using Microsoft SQL Server Environment

Created by Alexander Shafe - Data Consultant

"]

Students: 7262, Price: Free

This course takes you from having little or no knowledge of SQL towards becoming proficient in coding with SQL.

Knowing SQL is highly important if you intend working with data and the demand for SQL skills is ever growing.

You will learn SQL in a server environment which is most likely how you would use SQL in the real world. Not only would you learn SQL but you get to experience working with SQL in a real life setting.

This course is hands-on with practice tasks which allows you get comfortable and familiar with querying in SQL.

Course Requirement or Prerequisites

This course does not require any prior knowledge or specific academic background. The only requirement is having a laptop or desktop computer. All applications necessary for learning the course would be downloaded free from the internet.

Who is this course for?

Anyone looking to work with data personally or professionally.

Looking into a career as Data Analyst, Data Scientist, Business Analyst, Report Analyst, ETL Specialist, BI Consultant, Data Engineer or any Data related field.

Introduction to SQL

Learn T-SQL in MS SQL Server

Created by Michael Da Costa - Business Analyst

"]

Students: 1569, Price: Free

What Is This Course: Introduction to SQL

An introduction to the Structured Query Language. Although based around T-SQL this course is suitable for other variations of the language.

_________________________________________________________________________

What’s Included In This Course:

· Practice Examples: Each topic includes easy to follow examples.

· Real World Scenarios: Scenarios taken from real examples

· High Quality Content: Over 3+ hours of high quality videos.

· Support: On hand support to cover everything introduced in the course.

_________________________________________________________________________

What You Will Learn In This Course:

What are servers, databases and tables and why do we use them.

What is SQL and how can it be used to manipulate data within a database table.

What is a SQL query

How can we create, edit and remove database tables.

What types of SQL queries can we use to interrogate a database table

A look at how we can install a database and associated components in both a Windows PC environment as well as MAC OS environment

The basics of using operators which we can then use to construct more complex queries

The various SQL constraints are introduced and we look at how and why these are used and how we can use them within our queries to ensure data integrity.

The practice questions and scenarios provide a useful way to test what you have learnt in each module and consolidate your knowledge. These increase in difficulty and refer back to previous tutorials so you build on your existing knowledge.

_________________________________________________________________________

I hope this course is able to provide all you need to begin your experience of SQL.

Michael Da Costa