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)

1 - Introduction

1 - Introduction

2 - Welcome to Udemy.html

3 - The Udemy Interface

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

5 - Curriculum

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

8 - Which version of SSMS should I use.html

9 - Opening and Exploring SSMS

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

10 - 31i 31j The SELECT clause

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

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

13 - Practice Activity Number 1 The Solution

14 - 11 Entities rowsrecords columnsfields NULL and NOT NULL

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

15 - 32bg 32in The WHERE clause Part 1

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

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

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

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

20 - Practice Activity Number 2 The Solution

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

23 - 32a The ORDER BY clause

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

25 - Practice Activity Number 3 The Solution

6 - Lets explore tables

26 - 13 Choose data types Introduction

27 - 13 Numeric Data Types including Boolean values

28 - 13 Datetime Data Types

29 - 13 Character Types

30 - 13 Other Field Types

31 - Examining existing tables fields

7 - Creating our own tables

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

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

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

35 - Entering data using GUI and TSQL

36 - Creating a second table the Transaction table

8 - Joining tables

37 - The need for relational database management systems RDBMS

38 - How relations are established

39 - 31a JOINing two tables using an INNER JOIN

40 - 31b31e extract data by using joins other JOINs

41 - Find missing data using IS NULL

42 - 31f Self joins

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

9 - 13 Understand normalization

46 - 15a Understand the reasons for normalization

47 - 15b the first three common levels of normalization

48 - Adding altering and removing columns

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

50 - Practice Activity Number 5 The Solution

10 - 14 Understand primary and composite keys

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

52 - Primary keys shortcut

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

54 - More about IDENTITY

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

56 - Practice Activity Number 6 The Solution

11 - 14 Understand foreign keys and other constraints

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

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

59 - 14b Entityrelationship diagrams ERDs

60 - Practice Activity Number 7 Foreign keys.html

61 - Practice Activity Number 7 The Solution

12 - Data Manipulation language DML

62 - What is DML and its role in databases

63 - Understand how data is inserted into a database

64 - 41b How to use INSERT statements VALUES

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

66 - Practice Activity Number 9 INSERT statements.html

67 - Practice Activity Number 9 The Solution

13 - Data Manipulation language DML UPDATE and DELETE

68 - Understand how data is updated in a database

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

70 - 42 update by using a table

71 - 43 Delete data from single or multiple tables

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

73 - Practice Activity Number 10 The Solution

14 - 4 Data Definition Language DDL Views

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

75 - 22b Understand when to use views

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

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

78 - Updating rows using views or Inserting or Deleting

79 - Views WITH CHECK OPTION

80 - View WITH SCHEMABINDING

81 - Practice Activity Number 11 Views.html

82 - Practice Activity Number 11 The Solution

15 - Data Definition Language DDL Other Objects

83 - 23a 23c Create stored procedures

84 - 23a Getting an OUTPUT value from Stored Procedures

85 - 23b Scalar Functions

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

86 - pa12outline.zip

87 - Practice Activity Number 12 The Solution

16 - Other topics

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

89 - 24a Clustered and nonclustered indexes

90 - Practice Activity Number 13 Other topics.html

91 - Practice Activity Number 13 The Solution

17 - 16 Understand database security concepts

92 - Understand the need to secure a database

93 - 16e User accounts and roles

94 - 16b What objects canshould be secured

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

96 - 16aiii Principle of least privilege

18 - Understand database backups and restore

97 - 16ai Importance of backups

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

99 - 16aii How to restore a database

100 - Practice Activity Number 14.html

101 - Practice Activity Number 14 The Solution

19 - Conclusion

1 - Practice Test.html

102 - Whats next

103 - Congratulations

20 - Extra videos

104 - Extra videos.html

105 - Other constraints NOT NULL and DEFAULT

106 - Other constraints UNIQUE and CHECK

107 - Practice Activity Number 8 Other Constraints.html

108 - Practice Activity Number 8 The Solution

109 - AFTER Triggers

110 - INSTEAD OF Triggers

111 - Insert Snippets

112 - Practice Activity Number 12b Triggers.html

113 - Practice Activity Number 12b The Solution.html

114 - Normal Forms 4 and 5

21 - Bonus Lecture

115 - Bonus Lecture

115 - idodatabonuslecture230113.zip

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training