SQL Server: Learn T-SQL in 9 hours (ITS-201, 98-364)

Focused View

Phillip Burton,I Do Data Limited

9:10:08

105 View

1 - Introduction

1 - Introduction.mp4

02:56

2 - Welcome to Udemy.html

3 - The Udemy Interface.mp4

02:00

4 - Do you want autotranslated subtitles in more languages.html

5 - Curriculum.mp4

05:24

6 - ConditionsAndDataTypes.pdf

6 - Data.xlsx

6 - ITS-OD-201-DatabasesCurriculum220622.pdf

6 - Normalization.pdf

6 - Resources.html

6 - T-SQLCodeUsed220708.docx

6 - createstampstables.zip

6 - createtables.zip

2 - Installing SQL Server and SQL Server Management Studio SSMS

7 - 003downloadingsqlserverbackend.zip

7 - Downloading SQL Server Express 2022 back end.mp4

09:59

8 - Which version of SSMS should I use.html

9 - Opening and Exploring SSMS.mp4

07:16

3 - 32 Select data Utilize SELECT queries to extract data from one table

10 - 31i 31j The SELECT clause.mp4

09:14

11 - The FROM clause one table and how to save and export queries.mp4

06:22

12 - Practice Activity Number 1 SELECT and FROM clauses.html

13 - Practice Activity Number 1 The Solution.mp4

03:00

14 - 11 Entities rowsrecords columnsfields NULL and NOT NULL.mp4

12:18

4 - 32 Select data Utilize SELECT queries to extract data WHERE and GROUP BY

15 - 32bg 32in The WHERE clause Part 1.mp4

06:45

16 - 32bg 32io The WHERE clause Part 2 using a subquery.mp4

06:16

17 - 32m 32n The WHERE clause Part 3 Text and dates.mp4

08:20

18 - 31h 32h 33a 33cg The GROUP BY clause.mp4

09:54

19 - Practice Activity Number 2 WHERE and GROUP BY clauses.html

20 - Practice Activity Number 2 The Solution.mp4

04:11

5 - 32 Select data Utilize SELECT queries to extract data HAVING and ORDER BY

4 - The HAVING and ORDER BY clauses.html

21 - Changing to the msdb database.html

22 - 33b The HAVING clause.mp4

05:41

23 - 32a The ORDER BY clause.mp4

06:45

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

25 - Practice Activity Number 3 The Solution.mp4

02:47

6 - Lets explore tables

26 - 13 Choose data types Introduction.mp4

05:08

27 - 13 Numeric Data Types including Boolean values.mp4

09:13

28 - 13 Datetime Data Types.mp4

08:10

29 - 13 Character Types.mp4

08:53

30 - 13 Other Field Types.mp4

03:06

31 - Examining existing tables fields.mp4

04:50

7 - Creating our own tables

32 - Creating Database and 21a how to create a table.mp4

03:37

33 - 21ai 21b Designing the Employee table determining the right fields to use.mp4

08:16

34 - 21aii 21aiii Alter and drop tables by using proper ANSI SQL syntax.mp4

06:06

35 - Entering data using GUI and TSQL.mp4

08:50

36 - Creating a second table the Transaction table.mp4

05:12

8 - Joining tables

37 - The need for relational database management systems RDBMS.mp4

04:30

38 - How relations are established.mp4

11:48

39 - 31a JOINing two tables using an INNER JOIN.mp4

08:22

40 - 31b31e extract data by using joins other JOINs.mp4

05:35

41 - Find missing data using IS NULL.mp4

04:36

42 - 31f Self joins.mp4

05:10

43 - Creating new tables for Practice Activities.html

43 - createstampstables.zip

44 - Practice Activity Number 4 Joining tables.html

45 - Practice Activity Number 4 The Solution.mp4

06:26

9 - 13 Understand normalization

46 - 15a Understand the reasons for normalization.mp4

05:43

47 - 15b the first three common levels of normalization.mp4

08:55

48 - Adding altering and removing columns.mp4

05:19

49 - Practice Activity Number 5 Adding columns altering and removing columns.html

50 - Practice Activity Number 5 The Solution.mp4

02:39

10 - 14 Understand primary and composite keys

51 - 12a What are Primary keys and Creating Primary Keys.mp4

10:35

52 - Primary keys shortcut.mp4

05:24

53 - 12b Select appropriate fields for composite keys and IDENTITY.mp4

08:59

54 - More about IDENTITY.mp4

03:33

55 - Practice Activity Number 6 Primary keys and IDENTITY.html

56 - Practice Activity Number 6 The Solution.mp4

03:48

11 - 14 Understand foreign keys and other constraints

57 - 14a What are Foreign keys and creating Foreign Keys.mp4

07:29

58 - 14c understand the relationship between foreign and primary keys.mp4

10:52

59 - 14b Entityrelationship diagrams ERDs.mp4

05:04

60 - Practice Activity Number 7 Foreign keys.html

61 - Practice Activity Number 7 The Solution.mp4

06:08

12 - Data Manipulation language DML

62 - What is DML and its role in databases.mp4

02:46

63 - Understand how data is inserted into a database.mp4

06:33

64 - 41b How to use INSERT statements VALUES.mp4

05:06

65 - 41a How to use INSERT statements from tables and INSERT INTO.mp4

03:40

66 - Practice Activity Number 9 INSERT statements.html

67 - Practice Activity Number 9 The Solution.mp4

03:21

13 - Data Manipulation language DML UPDATE and DELETE

68 - Understand how data is updated in a database.mp4

03:09

69 - 42 How to write the updated data to the database using UPDATE.mp4

03:52

70 - 42 update by using a table.mp4

07:22

71 - 43 Delete data from single or multiple tables.mp4

08:16

72 - Practice Activity Number 10 UPDATE and DELETE statements.html

73 - Practice Activity Number 10 The Solution.mp4

03:45

14 - 4 Data Definition Language DDL Views

74 - 22b Understand how TSQL can be used to create database objects.mp4

02:26

75 - 22b Understand when to use views.mp4

05:05

76 - 22a How to create a view by using TSQL or a graphical designer.mp4

03:47

77 - 22aii 22aiii Alter and drop views by using proper ANSI SQL syntax.mp4

03:18

78 - Updating rows using views or Inserting or Deleting.mp4

07:02

79 - Views WITH CHECK OPTION.mp4

05:24

80 - View WITH SCHEMABINDING.mp4

04:08

81 - Practice Activity Number 11 Views.html

82 - Practice Activity Number 11 The Solution.mp4

05:27

15 - Data Definition Language DDL Other Objects

83 - 23a 23c Create stored procedures.mp4

06:08

84 - 23a Getting an OUTPUT value from Stored Procedures.mp4

03:20

85 - 23b Scalar Functions.mp4

07:26

86 - Practice Activity Number 12 Procedures Functions and Triggers.html

86 - pa12outline.zip

87 - Practice Activity Number 12 The Solution.mp4

04:57

16 - Other topics

88 - 31g combine result sets by using UNION INTERSECT and EXCEPT.mp4

08:26

89 - 24a Clustered and nonclustered indexes.mp4

12:33

90 - Practice Activity Number 13 Other topics.html

91 - Practice Activity Number 13 The Solution.mp4

03:52

17 - 16 Understand database security concepts

92 - Understand the need to secure a database.mp4

06:00

93 - 16e User accounts and roles.mp4

05:42

94 - 16b What objects canshould be secured.mp4

07:15

95 - 16 GRANT WITH GRANT OPTION REVOKE and principle of least privilege.mp4

06:35

96 - 16aiii Principle of least privilege.mp4

02:54

18 - Understand database backups and restore

97 - 16ai Importance of backups.mp4

02:24

98 - 16ai Understand various backup types such as full and incremental.mp4

08:47

99 - 16aii How to restore a database.mp4

11:31

100 - Practice Activity Number 14.html

101 - Practice Activity Number 14 The Solution.mp4

03:13

19 - Conclusion

1 - Practice Test.html

102 - Whats next.mp4

03:47

103 - Congratulations.mp4

01:07

20 - Extra videos

104 - Extra videos.html

105 - Other constraints NOT NULL and DEFAULT.mp4

04:07

106 - Other constraints UNIQUE and CHECK.mp4

05:59

107 - Practice Activity Number 8 Other Constraints.html

108 - Practice Activity Number 8 The Solution.mp4

03:35

109 - AFTER Triggers.mp4

08:56

110 - INSTEAD OF Triggers.mp4

06:19

111 - Insert Snippets.mp4

03:21

112 - Practice Activity Number 12b Triggers.html

113 - Practice Activity Number 12b The Solution.html

114 - Normal Forms 4 and 5.mp4

07:36

21 - Bonus Lecture

115 - Bonus Lecture.mp4

08:27

115 - idodatabonuslecture230113.zip

Description

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

Who is this for?

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?

More details

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?
Who this course is for:
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?

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Phillip Burton

Instructor's Courses

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 500,000 students and more than 40 video courses, including over a dozen Bestseller courses.My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

I Do Data Limited

Instructor's Courses

I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies. That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job. I Do Data courses are dedicated to enabling you to succeed.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.