وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

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
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 8198
    حجم: 3826 مگابایت
    مدت زمان: 551 دقیقه
    تاریخ انتشار: ۷ فروردین ۱۴۰۲
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید