The Microsoft SQL Server & T-SQL Course for Beginners

1 Review
138 Enrolled
4 Hours
$14.99$199.00
You save 92% -

42 Lessons (4h)

  • Your First Program
  • 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

AG
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

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.