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.

How taking a course works

Discover

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

(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

Lecture 3

SQL Express 2012 Install

10:30

Lecture 4

SQL AdventureWorks2012 Database

04:13

Lecture 5

What is Database and a Table

11:52

Lecture 6

Select

08:36

Lecture 7

Where

09:05

Lecture 8

Where With Like

08:23

Lecture 9

Order By

06:48

Lecture 10

Quiz 1

Article

Lecture 11

Insert Into

09:33

Lecture 12

Update

09:00

Lecture 13

Delete

08:02

Lecture 14

IN Operator

02:43

Lecture 15

Between

08:55

Lecture 16

Quiz 2

Article

Lecture 17

Create Database

05:53

Lecture 18

Create Table

08:40

Lecture 19

Create Temp Table

15:12

Lecture 20

Constraints Part 1

10:46

Lecture 21

Constraints Part 2

11:00

Lecture 22

Aliases

06:55

Lecture 23

Quiz 3

Article

Lecture 24

Joins

17:42

Lecture 25

Quiz 4

Article

Lecture 26

Union

09:00

Lecture 27

Aggregates

16:19

Lecture 28

Group By and Having

13:17

Lecture 29

Alter

10:10

Lecture 30

Null

05:18

Lecture 31

ISNULL

03:07

Lecture 32

Quiz 5

Article

Lecture 33

Select Into

07:04

Lecture 34

Subquery

08:41

Lecture 35

Data Type

11:50

Lecture 36

Cast and Convert

10:44

Lecture 37

String Function

19:50

Lecture 38

Numeric and Date Function

15:15

Lecture 39

Quiz 6

Article

Lecture 40

Views

11:43

Lecture 41

Case

11:20

Lecture 42

Indexes

16:04

Lecture 43

Stored Procedure

16:18

Lecture 44

Quiz 7

Article

Lecture 45

Triggers

13:33

Lecture 46

Design Query Editor

07:12

Lecture 47

Rank

08:41

Lecture 48

Extra Quiz with answers

Article

Lecture 49

SQL Server Administration Part 1

02:18

Students Who Viewed This Course Also Viewed

Loading

Loading

Loading

SHARE

Instructor Biography

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.