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
4.7 (186 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5,564 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 49
  • Length 7 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course 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.

What are the 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

What am I going to get from this course?

  • 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

What is the target audience?

  • This course is designed for the beginners, developers, buisness analysts, financial users and anyone interested or has a need to manipulate data

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Become a Production SQL Server Database Administrator
Introduction to Becoming a Production SQL Server Administrator
Preview
07:49
03:30

(Course 1 of 5 ) An introduction to Transact SQL language. At the end of this course, the user will be able to build databases, query data with joins, insert, update and delete data from tables created by the user

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
Article
Insert Into
09:33
Update
09:00
Delete
08:02
IN Operator
02:43
Between
08:55
Quiz 2
Article
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
Article
Joins
17:42
Quiz 4
Article
Union
09:00
Aggregates
16:19
Group By and Having
13:17
Alter
10:10
Null
05:18
ISNULL
03:07
Quiz 5
Article
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
Article
Views
11:43
Case
11:20
Indexes
16:04
Stored Procedure
16:18
Quiz 7
Article
Triggers
13:33
Design Query Editor
07:12
Rank
08:41
Extra Quiz with answers
Article
SQL Server Administration Part 1
02:18

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Raphael Asghar, Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 10 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Created five courses for those students who want a simple path to becoming a SQL DBA.I love SQL Administration and all that is involved in managing and creating a stable SQL architecture enviroement. I want to pass that experience and information to my students.

Ready to start learning?
Take This Course