Published 2/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 2.61 GB | Duration: 4h 42m
SQL Developer (MS SQL / SSIS / Reports / T-SQL / DBA) What you'll learn Journey through the role of SQL Server DBA, ETL Developer and Reports Writer Writing SQL queries Creation of MS SQL Reports and SSIS ETL packages Overview of the SQL Server DBA duties Requirements Your passion to further your Microsoft SQL, SSIS, Reports Builder and DBA concepts Description Taking this Microsoft SQL Server centric course is a great approach to boosting your brand value, developing your database skills, and assisting your business in extracting valuable insights. We want you to be successful in your endeavors through this simplified curriculum. The benefits of Mastering Microsoft SQL Server platform includes advancing your SQL Server abilities. Build strong databases, learn to write advanced SQL queries, and understanding data warehousing principles for better data insight and wiser business choices.This is a comprehensive course that includes:* SQL Database Administrator Overview of SQL DBA Benefits of T-SQL in querying Introduction to Normalization in Database Design Performance Tuning an essential aspect of Database Administration Troubleshooting is an important skill of the DBA High Availability * SSIS Introduction to SSIS packages Loading and meg multiple files using SSIS Loading and Renaming multiple files using SSIS Events handlers in SSIS Scheduling SSIS packages* Report Builder SQL Server Report Builder Creating Report Builder VARCHAR Parameters Creating Report Builder Data Parameters Creating Report Builder Multi-parameterized Reports* SQL Introduction to SQL (T-SQL) SQL Server database environment (T-SQL) DDL - Create Alter and Drop commands (T-SQL) DML Insert Update and Delete commands (T-SQL) SELECT query syntax (T-SQL) SELECT distinct command (T-SQL) SELECT Where clause (T-SQL) SELECT Top (T-SQL) SELECT Joins (T-SQL) SELECT Group by (T-SQL) Overview Section 1: SQL and T-SQL Lecture 1 SQL - 1 - What is SQL_ Lecture 2 SQL - 2 - Finding a Database to run SQL Lecture 3 SQL - 3 - DDL - Create Alter Drop_ Lecture 4 SQL - 4 - DML - Insert Update Delete_ Lecture 5 SQL - 5- DDL & DML Review Lecture 6 SQL - 6 - SELECT Syntax - When to use SQL Lecture 7 SQL - 7 - SELECT DISTINCT Lecture 8 SQL - 8 - SELECT WHERE Clause Lecture 9 SQL - 9 - SELECT AND & OR Clause Lecture 10 SQL - 10 - SELECT LIKE Lecture 11 SQL - 11 - SELECT ORDER BY Lecture 12 SQL - 12 - SELECT GROUP BY Lecture 13 SQL - 13 - SELECT TOP Lecture 14 SQL - 14 - SELECT JOINS Section 2: SSIS - SQL Server Integration Services Lecture 15 SSIS 1 My first SSIS package Lecture 16 SSIS 2 Loading and meg multiple files Lecture 17 SSIS 3 Loading and renaming multiple files Lecture 18 SSIS 4 Event Handlers Lecture 19 SSIS 5 Scheduling SSIS packages Lecture 20 SSIS 6 Interview Preparation Section 3: Report Builder (SQL Server) Lecture 21 Report Builder 1 What to do with Report Builder Lecture 22 Report Builder 2 VARCHAR Parameter Lecture 23 Report Builder 3 Date Parameter Lecture 24 Report Builder 4 Multi parameterized report Section 4: SQL DBA (MS SQL Database Administrator) Lecture 25 DBA 1 Intro to Database Administration Lecture 26 DBA 2 Intro to benefits of SQL Lecture 27 DBA 3 Intro to Normalization Lecture 28 DBA 4 Intro to Performance Tuning Lecture 29 DBA 5 Intro to Troubleshooting Lecture 30 DBA 6 Intro to High Availability Lecture 31 DBA 7 Intro to Install Upgrade and Updates All levels passionate about learning MS SQL Server, DBA, Reports Builder, SSIS and T-SQL HomePage:
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.