Learn T-SQL From Scratch For SQL Server Administrator
11,166 students enrolled
Learn T-SQL From Scratch For SQL Server Administrator
All the information needed within the courses to set yourself for a successful career as a SQL Production DBA
Bestseller
11,166 students enrolled
Current price: $13.99
Original price: $19.99
Discount:
30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
- 8.5 hours on-demand video
- 8 articles
- 45 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Training 5 or more people?
Get your team access to 4,000+ top Udemy courses anytime, anywhere.
Try Udemy for Business
What you'll learn
- Students will be able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables
Course content
Expand
63 lectures
08:57:56
+
–
Become a Production SQL Server Database Administrator
63 lectures
08:57:55
HOW TO ACCESS EXTRACT A ZIF FILE FOR DOCS AND SQL SCRIPTS
03:11
Introduction to Becoming a Production SQL Server Administrator
07:49
03:30
POST ADDENDUM
08:11
APPLICATIONS NEEDED
07:34
CREATE A VIRTUAL MACHINE
18:22
INSTALL SQL SERVER 2017
09:43
ADD ADVENTUREWORKS2017 DATABASE
08:13
SQL SERVER 2014 AND 2017 COMPARISON
02:38
SQL Express 2012 Install
10:30
SQL AdventureWorks2012 Database
04:13
What is Database and a Table
11:52
Select
08:36
Where
09:05
Where With Like
08:23
Order By
06:48
Quiz 1
01:02
Insert Into
09:33
Update
09:00
Delete
08:02
IN Operator
02:43
Between
08:55
Quiz 2
01:40
Create Database
05:53
Create Table
08:40
Create Temp Table
15:12
Constraints Part 1
10:46
Constraints Part 2
11:00
Aliases
06:55
Quiz 3
02:02
Joins
17:42
Quiz 4
03:01
Union
09:00
Aggregates
16:19
Group By and Having
13:17
Alter
10:10
Null
05:18
ISNULL
03:07
Quiz 5
01:42
Select Into
07:04
Subquery
08:41
Data Type
11:50
Cast and Convert
10:44
String Function
19:50
Numeric and Date Function
15:15
Quiz 6
02:49
Views
11:43
Case
11:20
Indexes
16:04
Stored Procedure
16:18
Quiz 7
01:11
Triggers
13:33
Design Query Editor
07:12
Rank
08:41
Extra Quiz with answers
02:14
SQL Server Administration Part 1
02:18
BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA
03:47
Requirements
- The software and materials will be provided by following the videos. Downloads for SQL Express is downloadable and I provide instructions in videos on how to get them
Description
These individual courses will take you step by step in learning what it takes to become a SQL Production Database Administrator and will teach you the skills, roles, tasks, and responsibilities a SQL Production Database Administrator does on a daily basis. The great benefit of these courses is that you can navigate to one site to learn all that is needed to manage your SQL Server Environment.
Who this course is for:
- This course is designed for the beginners, developers, business analysts, financial users and anyone interested or has a need to manipulate data
Featured review
C Tejaswini
(
8 courses,
2 reviews
)
a year ago
It's an wonderful course ever, he teaches very cool and understandable.
I would even like to add that i have gained lot of confidence on myself and i would like to upgrade myself with Query with T-SQL certification too after this course.Thank you very much for wonderful guidance Raphael.