The Microsoft SQL Server & T-SQL Course for Beginners

Name: The Microsoft SQL Server & T-SQL Course for Beginners
Brand: Avetis Ghukasyan
Price: 14.99 USD
Availability: InStock

1 Review

147 Enrolled

4 Hours

$14.99$60.00

You save 75%

42 Lessons (4h)

Your First Program
Preview

Thank You
What To Expect1:45
Common Misconceptions
What Is SQL?4:15
What Is SQL Server?4:10
Setting Up SQL Server & SSMS
Download SQL Server 20171:19
Install SQL Server 20172:56
Download SQL Server Management Studio1:00
Install SQL Server Management Studio0:49
Connect to SQL Server0:42
How Is Data Stored In SQL Server?
Simple Hierarchy6:51
Why Relational?10:19
Indexes10:35
DDL In SQL Server
Data Definition Language Commands1:24
How To Create?18:08
How To Modify?5:32
How To Truncate?1:46
How To Drop?4:08
Normalization9:57
Download and Import Adventure Works Database2:16
More On Index Creation7:57
DML In SQL Server
Data Manipulation Language Commands1:04
Begin With Retrieval8:58
Scalar Functions12:37
Sorting3:53
Column And Row Logic13:14
Joins13:47
Distinct Data3:08
Aggregate Functions16:59
SubQueries18:35
Set Operations9:01
Manipulate Data5:32
DCL in SQL Server
Data Control Language Commands2:36
Grant And Revoke2:36
Practical SQL Scenarios
Introduction To Section0:29
Problem 14:41
Problem 27:51
Problem 312:24
Problem 46:52
Problem 514:30
Problem 65:34
Problem 713:18
Problem 85:35
Resources
Source Code

Handle, Securely Store & Quickly Access Databases with 4+ Hours of Instruction on SQL Courses

Avetis Ghukasyan

Instructor

Avetis Ghukasyan is a full stack web developer with a Bachelor of Computer Science from the Wentworth Institute of Technology. He enjoys the field of computer science because he strongly believes that it forces one to think in a very logical and radically honest manner which has a very high potential of making one into a better person. That, in turn, helps one to write even better software creating an upward cycle for more growth.

Description

Knowing SQL is a highly profitable skill. This stable technology has been around for 20 years and used by developers, marketers, sales teams, product managers, and much more to handle data, store it securely, access it quickly, and more. If you have a business that you are trying to grow and have data that you are trying to handle, then Microsoft SQL Server (SQL Server) is a great choice which is another reason for you to learn this skill. This course will take you to the basics and hone you to be a valuable asset to your company.

5 stars on StackSkills: ★ ★ ★ ★ ★

Access 42 lectures & 4 hours of content 24/7
Be crystal clear on why there are many kinds of SQL
Know the difference between the query language & the databases
Understand how data is stored within the SQL Server
Create your own database objects, write data into them & access them after

Specs

Important Details

Length of time users can access this course: lifetime
Access options: web & mobile streaming
Certification of completion included
Redemption deadline: redeem your code within 30 days of purchase
Updates included
Experience level required: beginner
Have questions on how digital purchases work? Learn more here

Requirements

A computer that could run SQL Server 2017+
A computer that could run SQL Server Management Stduio 18.3.1+

Terms

Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.

Your cart is empty. Continue Shopping!

Processing order...