Complete SQL Course with SQL Server for Beginners from Basic to Advanced In this course we will explore the SQL relational database language using the SQL Server Database Management System (DBMS). The course covers everything from installing SQL Server to creating database objects such as Indexes, Stored Procedures, Triggers and User-defined Functions, among many others. Help the channel by purchasing my courses on Udemy: Databases with Basic MySQL: https://bit.ly/35QdWE4 Programming Logic with Structured Portuguese: https://bit.ly/3QKPn22 Programming in Python from Scratch: https://bit.ly/python-boson Contribution via PIX: You can contribute any amount you want, very easily and practically, by making a transfer via PIX to the following key: EC25A929-A8C5-40C5-AEC0-3DD36D08A147 Also purchase books and other items at the Bóson Treinamentos store on Amazon and help the channel to maintain and grow: https://www.amazon.com.br/shop/bosont... Become a member of this channel and earn benefits: / @bosontreinamentos Contribute to Bóson Treinamentos!: https://www.bosontreinamentos.com.br/... By Fábio dos Reis Bóson Treinamentos: https://www.bosontreinamentos.com.br Instagram: / bosontreinamentos Linkedin: / f%c3%a1bio-dos-reis-06ba192a Quora: pt.quora.com/profile/Fábio-dos-Reis Pinterest: / bosontreina Other projects by the author: Diário do Naturalista: https://www.diariodonaturalista.com.br Bóson Ciências e Cultura: / bosonciencias Numismática e Finanças Pessoais: https://diarionumismatico.com.br/ #sqlserver #bancosdedados #sql #sqlservermanagementstudio 00:00:00 Opening 00:01:11 SQL Server Installation 00:21:25 Create Databases 00:41:20 Constraints 00:51:04 Create Tables 01:17:22 Alter and Delete Tables 01:30:43 Insert Records 01:49:47 Simple Queries (SELECT FROM) 02:08:17 Sorting Results 02:16:17 SELECT TOP 02:26:39 Filters with WHERE 02:36:49 Delete Records (DELETE) 02:46:23 Clear Tables (TRUNCATE) 02:55:16 Update Tables (UPDATE) 03:04:44 Aliases with AS 03:12:56 Logical Operators 03:26:29 UNION Operator 03:34:52 Aggregate Functions 03:46:14 LIKE Operator 04:03:57 Database Backup and Restore 04:18:30 INNER JOIN Clause 04:35:17 Exercises with INNER JOIN 04:54:54 OUTER JOINS 05:07:30 Views 05:23:51 Subqueries 05:39:52 Stored Procedures 06:10:46 Triggers 06:28:13 UDF Functions 06:44:04 Date and Time Functions 07:07:50 String Manipulation 07:40:05 Indexes 07:57:43 Closing