Become A Production Sql Server Administrator

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

Last updated 2022-01-10 | 4.5

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

* 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

Course content

1 sections • 63 lectures

Become a Production SQL Server Database Administrator 63 lectures

SQL SERVER 2019 PART 1 Preview 13:32

SQL SERVER 2019 PART 2 Preview 12:15

SQL SERVER 2019 PART 3 Preview 06:13

SQL SERVER 2019 PART 4 Preview 12:31

SQL SERVER 2019 PART 5 Preview 10:22

SQL SERVER 2019 PART 6 Preview 02:50

HOW TO ACCESS EXTRACT A ZIF FILE FOR DOCS AND SQL SCRIPTS Preview 03:11

Introduction to Becoming a Production SQL Server Administrator Preview 07:49

What is TSQL Preview 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