The ‘Learn T-SQL From Scratch For SQL Server Administrator’ Udemy course provides an in-depth knowledge of T-SQL from scratch. In this course, you will learn about all the skills, roles, tasks, and responsibilities a SQL Production Database Administrator does on a daily basis.
By the end of this course, you’ll be able to navigate and manage your SQL Server Environment. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘Learn T-SQL From Scratch For SQL Server Administrator’ for INR 499.
Who all can opt for this course?
- Beginners, Developers, Business analysts, and Financial consumers who wish to learn T-SQL.
- Anyone interested in data manipulation can benefit from taking this course.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 08 Hours |
| Rating | 4.6/5 |
| Student Enrollment | 16,024 students |
| Instructor | Raphael Asghar |
| Topics Covered | SQL, T-SQL, SQL Server Administration |
| Course Level | Beginner |
| Total Student Reviews | 2,493 |
Learning Outcomes
- Create databases, tables, views, and stored procedures.
- Update data, delete data, and filter data.
- Learn to create sophisticated joins.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Become a Production SQL Server Database Administrator (08 hours 57 minutes) | SQL SERVER 2019 PART 1 |
| SQL SERVER 2019 PART 2 | ||
| SQL SERVER 2019 PART 3 | ||
| SQL SERVER 2019 PART 4 | ||
| SQL SERVER 2019 PART 5 | ||
| SQL SERVER 2019 PART 6 | ||
| HOW TO ACCESS EXTRACT A ZIF FILE FOR DOCS AND SQL SCRIPTS | ||
| Introduction to Becoming a Production SQL Server Administrator | ||
| What is TSQL | ||
| POST ADDENDUM | ||
| APPLICATIONS NEEDED | ||
| CREATE A VIRTUAL MACHINE | ||
| INSTALL SQL SERVER 2017 | ||
| ADD ADVENTUREWORKS2017 DATABASE | ||
| SQL SERVER 2014 AND 2017 COMPARISON | ||
| SQL Express 2012 Install | ||
| SQL AdventureWorks2012 Database | ||
| What is Database and a Table | ||
| Select | ||
| Where | ||
| Where With Like | ||
| Order By | ||
| Quiz 1 | ||
| Insert Into | ||
| Update | ||
| Delete | ||
| IN Operator | ||
| Between | ||
| Quiz 2 | ||
| Create Database | ||
| Create Table | ||
| Create Temp Table | ||
| Constraints Part 1 | ||
| Constraints Part 2 | ||
| Aliases | ||
| Quiz 3 | ||
| Joins | ||
| Quiz 4 | ||
| Union | ||
| Aggregates | ||
| Group By and Having | ||
| Alter | ||
| Null | ||
| ISNULL | ||
| Quiz 5 | ||
| Select Into | ||
| Subquery | ||
| Data Type | ||
| Cast and Convert | ||
| String Function | ||
| Numeric and Date Function | ||
| Quiz 6 | ||
| Views | ||
| Case | ||
| Indexes | ||
| Stored Procedure | ||
| Quiz 7 | ||
| Triggers | ||
| Design Query Editor | ||
| Rank | ||
| Extra Quiz with answers | ||
| SQL Server Administration Part 1 | ||
| BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA |
Resources Required
- No prior knowledge of programming is required.
- Access to a desktop or laptop.
Featured Review
Pius Adamu (5/5) : I learnt a lot, am also very happy that Mr. Raphael provided all the scripts/syntax needed. They come very handy. Thanks Raphael
Pros
- Felix Gyamfi (5/5) : You are a great teacher! I have learned a great deal of stuff!
- Debi Croney (5/5) : Raphael’s classes are some of the best SQL and MS SQL classes I have taken in my career.
- Olusesan DADA (5/5) : Great and applicable examples of SQL commands to use and go over I wish I took this course sooner!
- Wendy Grazier (5/5) : I’m very impressed with the price of this course for the value of the instruction.
Cons
- J sai T. (1/5) : the content which is not related to DBA
- Pedro (1/5) : stop sending mesages to review your course I already did.
- Nathan M. (1/5) : I do not have enough memory on my machine to partition my hard drive and download so many versions of the same program. I am expecting to learn SQL not how to download 30 programs
- Reshad (1/5) : The Author explains lots of courses such as TSQL, SQLADMINSTRATION, SSIS,SSRS at intro video. This is what I saw and got interested to buy, but when I bought the course, there was only 1/4 of what is on the intro.
About the Author
The instructor of this course is Raphael Asghar who is a Production SQL Database Administrator. With 4.5 Instructor Rating and 26,633 Reviews on Udemy, Raphael Asghar offers 25 Courses and has taught 133,348 Students so far.
- Raphael Asghar has worked for more than 15 years for several businesses, including Neutrogena, BakeMark, Solutions2Go, and NextGen, as a Production SQL Database Administrator and developer.
- Raphael Asghar assist those students who require more than just the fundamentals of SQL.
- Raphael Asghar adore maintaining and constructing a reliable SQL architecture environment, which is what SQL administration is all about.
Comparison Table
| Parameters | Learn T-SQL From Scratch For SQL Server Administrator | SQL Server Administration Part1 | SQL Server Administration Part 2 |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 9 hours | 10 hours | 10 hours |
| Rating | 4.6/5 | 4.6/5 | 4.6/5 |
| Student Enrollments | 16,024 | 20,583 | 14,608 |
| Instructors | Raphael Asghar | Raphael Asghar | Raphael Asghar |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this