Brief Introduction
Practical SQL Programming To Manipulate DatabasesDescription
SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server,Oracle, MySQL, MariaDB, and PostgreSQL. SQL skills is in the Top 3 of requested IT Skills by recruiters and companies all over the world.
T-SQL is also popularly referred to as T-Sequel .In this course you will learn all the basics of T-SQL. We will discuss the T-SQL features step by step. We will be using SQL Server Express 2014 (which is a free download). As a sample, we will use AdventureWorks 2014 as our database.
Along the way, we will be creating our own T-SQL queries to get data into a database and also out of a database. But AdventureWorks 2014 will be our main focus. As far as T-SQL, we will start with the simple select statements and add new features as we go.
This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures. You will also be familiar with SQL Server Management Studio 2014 also known in the tech industry as SSMS. This is the tool you will use to write and see the output of your T-SQL queries.
This beginner course provides an introduction to this core programming language.
Learn how to:
Request data from a server,
Limit and sort the data responses
Get single output value using aggregate functions
Combine data from multiple tables with joins
Modify data: Add, Update and Delete
Filter records and remove duplicates
Write basic T-SQL Statements
Understand T-SQL TOP Command
Understand Normalisation
Requirements
- Requirements
- You should be comfortable using a computer
- You should be comfortable navigating the internet.
Skill Tree
4.2 Raiting
Microsoft SQL from A to Z
- 4.6
-
![]()
![]()
![]()
![]()
![]()
The Complete Guide to SQL Querying This course is an extension of our previous course, "Microsoft SQL for Beginners". If so, then this course is for you!...
Computing for Data Analysis
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A hands-on introduction to basic programming principles and practice relevant to modern data analysis, data mining, and machine learning. In the course, you’ll see how computing and mathematics come together....
The Complete Social Engineering, Phishing, OSINT & Malware
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn how hackers hack Windows, Linux & Android by using Social Engineering and protect yourself from phishing attacks This is what gray hat hackers do....
Basic Skills in Constructive Communication
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Insufficiently developed skills in constructive communication lead to misunderstandings and conflicts between employees and managers. The course will help to: • Improve interaction with people around - increase its effectiveness...
