Understanding MS SQL Server Magic -- Beginners' Course

Rating 4.5 out of 5 (2 ratings in Udemy)

What you'll learn

Installing SQL & SSMS
Data Concepts -- Tables, Views, Temp Tables, Keys, Stored Procs
Best Practices Naming, Coding (Tabs, 1=1, Using [], Etc.)
SELECT, WHERE, LIKE, ORDER BY, GROUP BY, HAVING, UNION/ALL, EXCEPT, INTERCEPT, JOINs
Basic Functions (SUM, AVG, MIN, MAX, LEN ....)
Intermediate Functions (SUBSTRING, COALESCE)
CREATE/ALTER TABLE
INSERT/UPDATE/SELECT INTO
Deep-dive into technicalities: sys schema, data storage, heaps, …

Rating 4.5 out of 5 (2 ratings in Udemy)

What you'll learn

Installing SQL & SSMS
Data Concepts -- Tables, Views, Temp Tables, Keys, Stored Procs
Best Practices Naming, Coding (Tabs, 1=1, Using [], Etc.)
SELECT, WHERE, LIKE, ORDER BY, GROUP BY, HAVING, UNION/ALL, EXCEPT, INTERCEPT, JOINs
Basic Functions (SUM, AVG, MIN, MAX, LEN ....)
Intermediate Functions (SUBSTRING, COALESCE)
CREATE/ALTER TABLE
INSERT/UPDATE/SELECT INTO
Deep-dive into technicalities: sys schema, data storage, heaps, indexes (in detail), fragmentation

Description

This course is designed for those that are completely new to SQL or would like to brush up on their skills. If you don't yet know how you'll be using SQLin the future, if you'll go into analysis, development or anything else, this course is for you! We'll be using v2019 and start at the installation of SQLServer as well as the tools and databases we'll be using(SSMSand AdventureWorks, which is Microsoft's "teaching" database).

The course has been designed with efficiency as a prime driver so we'll be talking a fair bit about what to do and what not to do as well as some theory on data storage, data types, etc so that you get an understanding of why certain things are the way they are rather than "just do". Apart from Section 7, the lectures are designed to be not too technical for beginners' level, while S7 is a bit more technical but will be very beneficial for your better understanding of what is going on in the background.

In terms of style/delivery: UKEnglish, bit of added sarcasm (very minimal), generally cool and avoiding buzz. Also I tend to use "you" ("if you have a look at this/do that") rather us ("let us do this/that") in most cases. It's just to say some people prefer one or the other so you know what to expect. Furthermore I don't use "I'm going to go ahead and...". Just saying. :)

Course structure:

1: Intro to SQL and SSMS

What’s SQL, Uses, Dialects, Analysis, Development Purposes…
Install SQL Server, SSMS
Quick intro to SSMS
Get AdventureWorks
Settings & line numbers

2: Data Concepts

Data Concepts -- Tables, Views, Temp Tables
Data Concepts -- Keys
Data Concepts -- Stored Procs
Data Types Short & NULL Values
Indexes Short
Best Practices Naming, Coding (Tabs, 1=1, Using [], Etc.)

3: Basic Commands

SELECT/DISTINCT & TOP++ Where data goes (onto the screen that is.)
WHERE, <>, =, !=, AND/OR/NOT, text (‘’) -- relation to indexes
LIKE, %
ORDER BY -- when not to use it
GROUP BY & HAVING
UNION/UNION ALL/INTERSECT/EXCEPT
JOINs

4: Basic Functions

COUNT
SUM, AVG
MIN, MAX
LEN
LTRIM/RTRIM
UCASE/LCASE
SUBSTRING
COALESCE

5: Table Operations

CREATE TABLE
SELECT INTO
ALTER TABLE (drop col, add col, change data type, add index)
DROP TABLE vs DELETE FROM vs TRUNCATE

6: Modifying Data

INSERT (gui, manual, insert from elsewhere)
UPDATE

7: Tech Deep-Dive

sys tables for finding information
Data storage
More About Heaps
More About Indexes & Fragmentation

Duration 4 Hours 58 Minutes

Paid

Self paced

Beginner Level

English (UK)

Rating 4.5 out of 5 (2 ratings in Udemy)

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.