Learn T-SQL From Scratch For SQL Server Administrator

Offered byUDEMY

Learn T-SQL From Scratch For SQL Server Administrator
at
UDEMY
Overview

All the information needed within the courses to set yourself for a successful career as a SQL Production DBA

Duration	9 hours
Total fee	₹1,280
Mode of learning	Online
Credential	Certificate

Learn T-SQL From Scratch For SQL Server Administrator
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Get a 30 days money back guarantee on the course
Get full lifetime access of the course material
Learn from 8 articles and 46 downloadable resources

Learn T-SQL From Scratch For SQL Server Administrator
at
UDEMY
Course details

Who should do this course?

For the beginners, developers, business analysts, financial users and anyone interested or has a need to manipulate data

What are the course deliverables?

Able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables

More about this course

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

Learn T-SQL From Scratch For SQL Server Administrator
at
UDEMY
Curriculum

Become a Production SQL Server Database Administrator

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

Insert Into

Update

Delete

IN Operator

Between

Create Database

Create Table

Create Temp Table

Constraints Part 1

Constraints Part 2

Aliases

Learn T-SQL From Scratch For SQL Server Administrator
at
UDEMY
Faculty details

Raphael Asghar

Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA.