Sql Server: Learn T-Sql In 9 Hours (Its-201, 98-364)

For SELECT queries, views, procedures, indexes, backing up databases and more. IT Specialist OD 201 (previously 98-364)

What you'll learn

create tables in a database, normalize the tables, and ALTER columns in the table.

Know what data type to use in various situations.

retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

JOIN two tables together, finding missing data.

INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.

Create constraints, views, procedures and triggers

Create backups and restore data, and investigate security

Requirements

You need to know how to use a computer, and hopefully know how to use a spreadsheet.

No prior knowledge of SQL Server required.

SSMS cannot be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.

You don't even need SQL Server installed - I'll show you how to install it on your computer for free!

There is a 30-day refund policy on this Udemy course - see Udemy's refund policy.

Why not have a look at the curriculum below and see what you can learn?

Description

This course is the foundation for the IT Specialist Certification OD 201 "Databases Fundamentals" (which previously was Microsoft's 98-364 exam), and focuses on Microsoft SQL Server. Learn in just a few hours how to create tables, queries, views, procedures and more.What do people like you say about it?Seme says "Thank you very much for your valuable course . I really enjoyed this course . Packed a lot of information , I found it very interesting and useful . Thank you ."Gasper says "Phillip always does a great job, this is my third course from him. Passionate and informed, I will take as many courses as I can from him."Jonas says "Explaining SQL on a very easyway! Takes you though everything you need to know nice and calm."We start off by installing for free on your Windows desktop or laptop SQL Server, and learning how the six clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.We'll examine how data is stored in tables, and see why normalisation is important for the proper building of tables.We'll then look at constraints, which allows you to set up rules for your data. Following this, how can we insert, update and delete data? We'll also create views, procedures, functions, and have a look at triggers.Finally, we'll investigate how to speed up your queries using indexes, add security, and back up your data.No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!There are regular quizzes to help you remember the information, so you can be sure that you are learning.Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with a bit of practice, you could also go for the official IT Specialist exam - wouldn’t that certificate look good on your CV or resume?

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Welcome to Udemy

Lecture 3 The Udemy Interface

Lecture 4 Do you want auto-translated subtitles in more languages?

Lecture 5 Curriculum

Lecture 6 Resources

Section 2: Installing SQL Server and SQL Server Management Studio (SSMS)

Lecture 7 Downloading SQL Server Express 2022 back end

Lecture 8 Which version of SSMS should I use?

Lecture 9 Opening and Exploring SSMS

Section 3: 3.2. Select data - Utilize SELECT queries to extract data from one table

Lecture 10 3.1i, 3.1j. The SELECT clause

Lecture 11 The FROM clause (one table), and how to save and export queries

Lecture 12 Practice Activity Number 1 - SELECT and FROM clauses

Lecture 13 Practice Activity Number 1 - The Solution

Lecture 14 1.1. Entities, rows/records, columns/fields; NULL and NOT NULL

Section 4: [3.2]. Select data - Utilize SELECT queries to extract data - WHERE and GROUP BY

Lecture 15 3.2b-g, 3.2i-n. The WHERE clause - Part 1

Lecture 16 3.2b-g, 3.2i-o. The WHERE clause - Part 2 - using a subquery

Lecture 17 3.2m, 3.2n. The WHERE clause - Part 3 - Text and dates

Lecture 18 3.1h, 3.2h, 3.3a, 3.3c-g. The GROUP BY clause

Lecture 19 Practice Activity Number 2 - WHERE and GROUP BY clauses

Lecture 20 Practice Activity Number 2 - The Solution

Section 5: [3.2]. Select data - Utilize SELECT queries to extract data -HAVING and ORDER BY

Lecture 21 Changing to the msdb database

Lecture 22 3.3b. The HAVING clause

Lecture 23 3.2a. The ORDER BY clause

Lecture 24 Practice Activity Number 3 - The HAVING and ORDER BY clauses

Lecture 25 Practice Activity Number 3 - The Solution

Section 6: Let's explore tables

Lecture 26 1.3. Choose data types - Introduction

Lecture 27 1.3. Numeric Data Types, including Boolean values

Lecture 28 1.3. Date/time Data Types

Lecture 29 1.3. Character Types

Lecture 30 1.3. Other Field Types

Lecture 31 Examining existing tables' fields

Section 7: Creating our own tables

Lecture 32 Creating Database and 2.1a. how to create a table

Lecture 33 2.1ai, 2.1b. Designing the Employee table, determining the right fields to use

Lecture 34 2.1aii, 2.1aiii. Alter and drop tables by using proper ANSI SQL syntax

Lecture 35 Entering data using GUI and T-SQL

Lecture 36 Creating a second table, the Transaction table

Section 8: Joining tables

Lecture 37 The need for relational database management systems (RDBMS)

Lecture 38 How relations are established

Lecture 39 3.1a. JOINing two tables using an INNER JOIN

Lecture 40 3.1b-3.1e. extract data by using joins - other JOINs

Lecture 41 Find missing data using IS NULL

Lecture 42 3.1f. Self joins

Lecture 43 Creating new tables for Practice Activities

Lecture 44 Practice Activity Number 4 - Joining tables

Lecture 45 Practice Activity Number 4 - The Solution

Section 9: 13. Understand normalization

Lecture 46 1.5a. Understand the reasons for normalization

Lecture 47 1.5b. the first three common levels of normalization

Lecture 48 Adding, altering and removing columns

Lecture 49 Practice Activity Number 5 - Adding columns, altering and removing columns

Lecture 50 Practice Activity Number 5 - The Solution

Section 10: 14. Understand primary and composite keys

Lecture 51 1.2a. What are Primary keys? and Creating Primary Keys

Lecture 52 Primary keys shortcut

Lecture 53 1.2b. Select appropriate fields for composite keys, and IDENTITY

Lecture 54 More about IDENTITY

Lecture 55 Practice Activity Number 6 - Primary keys and IDENTITY

Lecture 56 Practice Activity Number 6 - The Solution

Section 11: 14. Understand foreign keys and other constraints

Lecture 57 1.4a. What are Foreign keys? and creating Foreign Keys

Lecture 58 1.4c. understand the relationship between foreign and primary keys

Lecture 59 1.4b. Entity-relationship diagrams (ERDs)

Lecture 60 Practice Activity Number 7 - Foreign keys

Lecture 61 Practice Activity Number 7 - The Solution

Section 12: Data Manipulation language (DML)

Lecture 62 What is DML and its role in databases

Lecture 63 Understand how data is inserted into a database

Lecture 64 4.1b. How to use INSERT statements - VALUES

Lecture 65 4.1a. How to use INSERT statements - from tables and INSERT INTO

Lecture 66 Practice Activity Number 9 - INSERT statements

Lecture 67 Practice Activity Number 9 - The Solution

Section 13: Data Manipulation language (DML) - UPDATE and DELETE

Lecture 68 Understand how data is updated in a database

Lecture 69 4.2. How to write the updated data to the database using UPDATE

Lecture 70 4.2. update by using a table

Lecture 71 4.3. Delete data from single or multiple tables

Lecture 72 Practice Activity Number 10 - UPDATE and DELETE statements

Lecture 73 Practice Activity Number 10 - The Solution

Section 14: 4. Data Definition Language (DDL) - Views

Lecture 74 2.2b. Understand how T-SQL can be used to create database objects

Lecture 75 2.2b. Understand when to use views

Lecture 76 2.2a. How to create a view by using T-SQL or a graphical designer

Lecture 77 2.2aii, 2.2aiii. Alter and drop views by using proper ANSI SQL syntax

Lecture 78 Updating rows using views (or Inserting or Deleting)

Lecture 79 Views WITH CHECK OPTION

Lecture 80 View WITH SCHEMABINDING

Lecture 81 Practice Activity Number 11 - Views

Lecture 82 Practice Activity Number 11 - The Solution

Section 15: Data Definition Language (DDL) - Other Objects

Lecture 83 2.3a, 2.3c. Create stored procedures

Lecture 84 2.3a. Getting an OUTPUT value from Stored Procedures

Lecture 85 2.3b. Scalar Functions

Lecture 86 Practice Activity Number 12 - Procedures, Functions and Triggers

Lecture 87 Practice Activity Number 12 - The Solution

Section 16: Other topics

Lecture 88 3.1g. combine result sets by using UNION, INTERSECT and EXCEPT

Lecture 89 2.4a. Clustered and non-clustered indexes

Lecture 90 Practice Activity Number 13 - Other topics

Lecture 91 Practice Activity Number 13 - The Solution

Section 17: 16. Understand database security concepts

Lecture 92 Understand the need to secure a database

Lecture 93 1.6e. User accounts and roles

Lecture 94 1.6b. What objects can/should be secured?

Lecture 95 1.6. GRANT, WITH GRANT OPTION, REVOKE and principle of least privilege

Lecture 96 1.6aiii. Principle of least privilege

Section 18: Understand database backups and restore

Lecture 97 1.6ai. Importance of backups

Lecture 98 1.6ai. Understand various backup types, such as full and incremental

Lecture 99 1.6aii. How to restore a database

Lecture 100 Practice Activity Number 14

Lecture 101 Practice Activity Number 14 - The Solution

Section 19: Conclusion

Lecture 102 What's next?

Lecture 103 Congratulations

Section 20: Extra videos

Lecture 104 Extra videos

Lecture 105 Other constraints - NOT NULL and DEFAULT

Lecture 106 Other constraints - UNIQUE and CHECK

Lecture 107 Practice Activity Number 8 - Other Constraints

Lecture 108 Practice Activity Number 8 - The Solution

Lecture 109 AFTER Triggers

Lecture 110 INSTEAD OF Triggers

Lecture 111 Insert Snippets

Lecture 112 Practice Activity Number 12b - Triggers

Lecture 113 Practice Activity Number 12b - The Solution

Lecture 114 Normal Forms 4 and 5

Section 21: Bonus Lecture

Lecture 115 Bonus Lecture

This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.,This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.,By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official 98-364 exam.,Wouldn't the "MTA: Database Fundamentals" certification look good on your CV or resume?