The Learn to Code Full Stack Developer Certification Bundle

11 Reviews
3084 Enrolled
9 Courses & 51 Hours
$38.99$1,650.00
You save 97% -

What's Included

Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
Microsoft SQL Server & T-SQL Course For Beginners
  • Certification included
  • Experience level required: Beginner
  • Access 42 lectures & 4 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

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

Microsoft SQL Server & T-SQL Course For Beginners

AG
Avetis Ghukasyan

Avetis Ghukasyan is a web developer with a Bachelor of Computer Science from 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

Do you know that SQL developers earn salaries somewhere around 90,000 to $120,000? Knowing SQL is a pretty profitable skill — not just "these days" but today, tomorrow a year from now and even further down the road. This course is here to guide your way through SQL. With 42 lectures, you'll learn what SQL servers are, how to set them up, how data is stored, what DDL, DML, and DCL are, and work with practical SQL scenarios.

"Great course overall! The content is presented very clearly and solid examples are provided. Delivery was straightforward and easy to understand." - Fred B.

  • Access 42 lectures & 4 hours of content 24/7
  • Be crystal clear on why there are so many kinds of SQLs
  • Know the difference between the query language & the databases
  • Perform tasks similar to ones you would get at an actual company

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

  • Internet access required

Terms

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