Learn T-SQL From Scratch For SQL Server Administrator
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
- Preview13:32
- Preview12:15
- Preview06:13
- Preview12:31
- Preview10:22
- Preview02:50
- 03:11HOW TO ACCESS EXTRACT A ZIF FILE FOR DOCS AND SQL SCRIPTS
- 07:49Introduction to Becoming a Production SQL Server Administrator
- 03:30What is TSQL
- 08:11POST ADDENDUM
- 07:34APPLICATIONS NEEDED
- 18:22CREATE A VIRTUAL MACHINE
- 09:43INSTALL SQL SERVER 2017
- 08:13ADD ADVENTUREWORKS2017 DATABASE
- 02:38SQL SERVER 2014 AND 2017 COMPARISON
- 10:30SQL Express 2012 Install
- 04:13SQL AdventureWorks2012 Database
- 11:52What is Database and a Table
- 08:36Select
- 09:05Where
- 08:23Where With Like
- 06:48Order By
- 01:02Quiz 1
- 09:33Insert Into
- 09:00Update
- 08:02Delete
- 02:43IN Operator
- 08:55Between
- 01:40Quiz 2
- 05:53Create Database
- 08:40Create Table
- 15:12Create Temp Table
- 10:46Constraints Part 1
- 11:00Constraints Part 2
- 06:55Aliases
- 02:02Quiz 3
- 17:42Joins
- 03:01Quiz 4
- 09:00Union
- 16:19Aggregates
- 13:17Group By and Having
- 10:10Alter
- 05:18Null
- 03:07ISNULL
- 01:42Quiz 5
- 07:04Select Into
- 08:41Subquery
- 11:50Data Type
- 10:44Cast and Convert
- 19:50String Function
- 15:15Numeric and Date Function
- 02:49Quiz 6
- 11:43Views
- 11:20Case
- 16:04Indexes
- 16:18Stored Procedure
- 01:11Quiz 7
- 13:33Triggers
- 07:12Design Query Editor
- 08:41Rank
- 02:14Extra Quiz with answers
- 02:18SQL Server Administration Part 1
- 03:47BONUS LECTURE: GET GUIDENCE TO BECOMING A SQL DBA
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
Instructor
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. I love SQL Administration and all that is involved in managing and creating a stable SQL architecture environment. I want to pass that experience and information to my students.