▲
0
0

report

Udemy - Course 11: SQL Server 2019 on Windows Server 2019 Series

seeders: 4
leechers: 1
Download torrent
Added 5 years ago by tutsnode in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - Course 11: SQL Server 2019 on Windows Server 2019 Series (Size: 4.38 GB)
  .pad
  0 54.87 KB
  1 77.27 KB
  2 610.6 KB
  3 647.15 KB
  4 924.85 KB
  5 356.19 KB
  6 564.23 KB
  7 514.56 KB
  8 963.54 KB
  9 901.54 KB
  10 921.98 KB
  11 437.43 KB
  12 1006.27 KB
  13 277.73 KB
  14 928.34 KB
  15 804.62 KB
  16 165.45 KB
  17 598.4 KB
  18 325.89 KB
  19 438.21 KB
  20 130.64 KB
  21 972.38 KB
  22 654.05 KB
  23 135.87 KB
  24 982.63 KB
  25 237.25 KB
  26 984.77 KB
  27 287.65 KB
  28 651.7 KB
  29 749 KB
  30 855.99 KB
  31 57.24 KB
  32 827.11 KB
  33 468.28 KB
  34 578.68 KB
  35 389.89 KB
  36 55.07 KB
  37 38.54 KB
  38 317.62 KB
  39 760.19 KB
  40 352.86 KB
  41 647.13 KB
  42 361.34 KB
  43 171 KB
  44 409.58 KB
  45 588.7 KB
  46 248.65 KB
  47 380.86 KB
  48 190.67 KB
  49 204.82 KB
  50 444.29 KB
  51 403.11 KB
  52 779.55 KB
  53 33.93 KB
  54 798.24 KB
  55 827.82 KB
  56 715.94 KB
  57 2.87 KB
  58 2.6 KB
  59 549.78 KB
  60 466.27 KB
  61 159.3 KB
  62 311.59 KB
  63 557.55 KB
  64 40.68 KB
  65 631.95 KB
  66 886.21 KB
  67 213.57 KB
  68 338.26 KB
  69 172.62 KB
  70 811.48 KB
  71 65.87 KB
  72 84.71 KB
  73 135.11 KB
  74 361.46 KB
  75 790.84 KB
  76 1002.64 KB
  77 785.26 KB
  78 82.27 KB
  79 113.62 KB
  80 735.44 KB
  81 632.71 KB
  82 87.51 KB
  83 781.46 KB
  84 352.87 KB
  85 830.16 KB
  86 120.86 KB
  87 331.49 KB
  TutsNode.com.txt 63 B
  [TGx]Downloaded from torrentgalaxy.to .txt 585 B
  [TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series
  1. Introduction
  1. SQL course introduction.mp4 71.05 MB
  1. SQL course introduction.srt 6.86 KB
  2. SQL Server Admin tasks.mp4 80.21 MB
  2. SQL Server Admin tasks.srt 15.49 KB
  3. Features of SQL Server 2019.mp4 85.73 MB
  3. Features of SQL Server 2019.srt 11.2 KB
  10. BikeStore project
  1. Introduction.mp4 4.68 MB
  1. Introduction.srt 2.7 KB
  10. Structure query part 2.mp4 87.1 MB
  10. Structure query part 2.srt 16.09 KB
  11. Build DataBase structure.mp4 39.81 MB
  11. Build DataBase structure.srt 7.32 KB
  12. Input data query.mp4 95.5 MB
  12. Input data query.srt 11.24 KB
  13. Complex query.mp4 86.57 MB
  13. Complex query.srt 15.98 KB
  14. Join query.mp4 128.92 MB
  14. Join query.srt 15.08 KB
  2. Initial report - ERD.mp4 22.83 MB
  2. Initial report - ERD.srt 5.78 KB
  3. Staff table design.mp4 46.37 MB
  3. Staff table design.srt 9.82 KB
  4. Customer table design.mp4 34 MB
  4. Customer table design.srt 6.18 KB
  5. Store table design.mp4 70.36 MB
  5. Store table design.srt 13.6 KB
  6. Product table design.mp4 60.27 MB
  6. Product table design.srt 10.33 KB
  7. Order Table design.mp4 74.42 MB
  7. Order Table design.srt 11.53 KB
  8. Main project diagram.mp4 21.87 MB
  8. Main project diagram.srt 4.97 KB
  9. Structure query part 1.mp4 89.06 MB
  9. Structure query part 1.srt 16.21 KB
  11. Maintenance
  1. Simple backup and restore.mp4 60.16 MB
  1. Simple backup and restore.srt 18.18 KB
  2. Backup and High Availability.mp4 16.89 MB
  2. Backup and High Availability.srt 4.57 KB
  12. SQL 2019 Fail Over Cluster
  1. FOC plan.mp4 25.38 MB
  1. FOC plan.srt 8.14 KB
  10. Fix MPIO.mp4 48.96 MB
  10. Fix MPIO.srt 8.28 KB
  11. Fail over cluster creation.mp4 58.19 MB
  11. Fail over cluster creation.srt 10.68 KB
  12. Fail over cluster role.mp4 35 MB
  12. Fail over cluster role.srt 2.7 KB
  13. FOC SQL 2019.mp4 15.28 MB
  13. FOC SQL 2019.srt 2.74 KB
  2. FreeNAS.mp4 16.92 MB
  2. FreeNAS.srt 4.24 KB
  3. Fix SQL nodes IPs.mp4 71.87 MB
  3. Fix SQL nodes IPs.srt 13.13 KB
  4. Secure channel.mp4 41.6 MB
  4. Secure channel.srt 8.1 KB
  5. NAS installation.mp4 65.04 MB
  5. NAS installation.srt 16.68 KB
  6. NAS quick scan.mp4 36.22 MB
  6. NAS quick scan.srt 9.98 KB
  7. NAS ISCSI configuration.mp4 40.76 MB
  7. NAS ISCSI configuration.srt 11.89 KB
  8. NAS ISCSI storage.mp4 65.87 MB
  8. NAS ISCSI storage.srt 19.29 KB
  9. Fail over test.mp4 82.09 MB
  9. Fail over test.srt 15.34 KB
  13. Fail over cluster SQL 2019 installation
  1. Create service accounts.mp4 126.4 MB
  1. Create service accounts.srt 21 KB
  2. Install 1st instance.mp4 137.04 MB
  2. Install 1st instance.srt 20.06 KB
  3. Install 2nd instance and check HA.mp4 33.46 MB
  3. Install 2nd instance and check HA.srt 6.76 KB
  2. Network preparation and Check points
  1. Overview of Lab.mp4 21.65 MB
  1. Overview of Lab.srt 5.06 KB
  2. Clone SQL 2019 box.mp4 21.92 MB
  2. Clone SQL 2019 box.srt 5.8 KB
  3. ICT & Updates.mp4 48.26 MB
  3. ICT & Updates.srt 11.36 KB
  4. Network checkpoints plan.mp4 37.24 MB
  4. Network checkpoints plan.srt 11.08 KB
  5. Network checkpoints, Part - I.mp4 72.68 MB
  5. Network checkpoints, Part - I.srt 13.79 KB
  6. Network checkpoints, Part - II.mp4 46.66 MB
  6. Network checkpoints, Part - II.srt 9.66 KB
  3. SQL 2019 prerequisite
  1. SQL 2019 prerequisite.mp4 75.84 MB
  1. SQL 2019 prerequisite.srt 12.61 KB
  10. SQL domain group.mp4 41.43 MB
  10. SQL domain group.srt 7.86 KB
  2. Download SQL server 2019.mp4 14.38 MB
  2. Download SQL server 2019.srt 2.71 KB
  3. Installation interface first impression.mp4 23.67 MB
  3. Installation interface first impression.srt 4.44 KB
  4. Detect .NET Framework version.mp4 101.65 MB
  4. Detect .NET Framework version.srt 16.02 KB
  5. System configuration checker.mp4 39.57 MB
  5. System configuration checker.srt 8.32 KB
  6. Installation prior check.mp4 88.12 MB
  6. Installation prior check.srt 17.89 KB
  7. Address firewall problem.mp4 99.45 MB
  7. Address firewall problem.srt 15.55 KB
  8. GPO firewall.mp4 61.72 MB
  8. GPO firewall.srt 8.86 KB
  9. Create local SQL admin account.mp4 21.23 MB
  9. Create local SQL admin account.srt 3.91 KB
  4. SQL installation - 1st instance
  1. Install first SQL 2019 instance - Part I.mp4 62.04 MB
  1. Install first SQL 2019 instance - Part I.srt 11.17 KB
  2. Install first SQL 2019 instance - Part II.mp4 51.95 MB
  2. Install first SQL 2019 instance - Part II.srt 10.87 KB
  3. Installation center tools.mp4 86.02 MB
  3. Installation center tools.srt 16.69 KB
  4. Install (SSMS) SQL Server Mgmt Studio 18.mp4 39.8 MB
  4. Install (SSMS) SQL Server Mgmt Studio 18.srt 10.56 KB
  5. SMSS update, PC1 SMSS, Remote Access.mp4 31.84 MB
  5. SMSS update, PC1 SMSS, Remote Access.srt 6.25 KB
  6. Fix remote access.mp4 10.66 MB
  6. Fix remote access.srt 3.55 KB
  7. Authorize SQL admins.mp4 28.96 MB
  7. Authorize SQL admins.srt 6.93 KB
  8. Arm SQL with PS modules.mp4 37.61 MB
  8. Arm SQL with PS modules.srt 10.41 KB
  9. Time for new snapshot.mp4 41.83 MB
  9. Time for new snapshot.srt 10.19 KB
  5. Introduction to Databases
  1. Add sample data.mp4 72.57 MB
  1. Add sample data.srt 15.47 KB
  1.1 BikeStores Sample Database - create objects.sql 3.46 KB
  1.2 BikeStores Sample Database - load data.sql 1.24 MB
  1.3 BikeStores Sample Database - drop all objects.sql 751 B
  2. What is relational database.mp4 60.36 MB
  2. What is relational database.srt 16.22 KB
  3. Build DB diagram.mp4 35.3 MB
  3. Build DB diagram.srt 9.09 KB
  4. OLTP.mp4 13.91 MB
  4. OLTP.srt 3.36 KB
  5. DataBase types.mp4 36.97 MB
  5. DataBase types.srt 13.47 KB
  6. Data analysis.mp4 9.19 MB
  6. Data analysis.srt 5.13 KB
  7. SQL languages.mp4 17.23 MB
  7. SQL languages.srt 5.77 KB
  8. Basic SQL query practise.mp4 32.54 MB
  8. Basic SQL query practise.srt 7.71 KB
  6. Data Modeling
  1. ERD TPA.mp4 21.94 MB
  1. ERD TPA.srt 8.25 KB
  2. ANSI-SPARC DB model.mp4 21.02 MB
  2. ANSI-SPARC DB model.srt 7.8 KB
  3. ERM model - Primary vs Foreign key.mp4 56.54 MB
  3. ERM model - Primary vs Foreign key.srt 18.18 KB
  4. ERM model - Relationships & Notations.mp4 12.24 MB
  4. ERM model - Relationships & Notations.srt 5.88 KB
  5. Lab - Model & Design a Database - Part 1.mp4 103.1 MB
  5. Lab - Model & Design a Database - Part 1.srt 13.95 KB
  6. Lab - Model & Design a Database - Part 2.mp4 126.37 MB
  6. Lab - Model & Design a Database - Part 2.srt 16.11 KB
  7. Normalization & Denormalization
  1. Importance of normalization.mp4 36.19 MB
  1. Importance of normalization.srt 10.87 KB
  10. Referential integrity & relationships.mp4 48.69 MB
  10. Referential integrity & relationships.srt 14.92 KB
  2. Dependencies.mp4 31.46 MB
  2. Dependencies.srt 8.06 KB
  3. 5 Normal forms.mp4 59.94 MB
  3. 5 Normal forms.srt 16.45 KB
  4. GUI build schema and data table.mp4 63.77 MB
  4. GUI build schema and data table.srt 17.45 KB
  5. Data Types.mp4 54.43 MB
  5. Data Types.srt 9.78 KB
  6. Creating database using queries.mp4 42.65 MB
  6. Creating database using queries.srt 10.66 KB
  7. Working with database.mp4 31.7 MB
  7. Working with database.srt 8.16 KB
  8. Data insertion.mp4 24.13 MB
  8. Data insertion.srt 5.47 KB
  9. Denormalization.mp4 53.62 MB
  9. Denormalization.srt 18.04 KB
  8. Performance
  1. Index.mp4 23.79 MB
  1. Index.srt 8.81 KB
  2. Joins.mp4 22.21 MB
  2. Joins.srt 10 KB
  3. Concurrency.mp4 8.88 MB
  3. Concurrency.srt 2.83 KB
  9. SQL object types
  1. DataBase objects.mp4 40.63 MB
  1. DataBase objects.srt 16.34 KB

Description



Description

The students who have taken our previous courses know that we like to go deep with all the technologies we work on and therefore to fulfill that need we develop courses in big series and this chain of courses help students to not only understand the technology itself but confidently implement it in their enterprise, prepare for and crack any interviews and also update their skills.

This SQL series is comprising of 3 courses containing more than 30 Hours of intensive training. These courses are as follows:

Course 11: SQL Server 2019 on Windows Server 2019 & Fail over cluster.

Course 12: SQL Server 2019 on Linux & Azure.

Course 13: SQL Server 2019 Administration.

Course outline :

Before checking the course outline we would like to add very important note, The Network and Infrastructure used in this course was created in our Course 1: Set Windows server 2019 network -Microsoft series, where we created the virtual environment for all the courses we have developed so far.

Why we did that ?

Simply because we don’t want to waste your time by creating the Source virtual machine, network adapters, router and other infrastructure again and again. We want to give you REAL-TIME Industry experience by integrating different technologies in one BIG NETWORK and it will allow students to apply computer and technology skills to learning and problem-solving.

Now let us discuss the course outline in details.

This is SQL Fundamentals course for Beginners comprises of theories and LABS.

This course is divided into 4 segments:

Segment 1: Prepare your Network to install SQL SERVER 2019 on Windows server 2019

Starting from Section 1 to Section 4, you will learn about,

– New features of SQL server 2019

– Understanding the prerequisites to install SQL server 2019 on existing network which we created together in course 1: Set Windows server 2019 network -Microsoft series

– Installing 1st instance of single SQL server 2019, SQL Server Management studio 18

– Perform remote access and create snapshots.

Segment 2 : Get your basics sorted for advance topics

From Section 5 to Section 9, this segment will teach you about fundamentals of database. As an administrator it is required to understand all the terminologies related to databases for better administration of the product. We will learn the basics of following topics:

Module 1: ‘Introduction to Databases’ introduces key database concepts in the context of SQL Server 2019

Module 2: ‘Data Modelling’ describes a number of data modelling techniques.

Module 3: ‘Normalization’ introduces the concept of normalization and describes normalization and denormalization techniques.

Module 4: ‘Relationships’ describes the different types of relationship and their effects in database design.

Module 5: ‘Performance’ describes the effects of database design on performance.

Module 6: ‘Database Objects’ introduces commonly used database object.

** Expect to have some theories which might be a bit boring

Segment 3: Let us perform Hands-on with loads and loads of LABS

Section 10 is very interesting because we have prepared LABS(Project) for you to practice all the concepts that we learned together in Segment 2.

Segment 4: SQL Server 2019 Fail over clustering

Starting from Section 11 we will perform the following LABS

A- Create domain service accounts

B- Install 1st Fail over cluster instance of SQL server 2019

C- Install 2nd Fail over cluster instance of SQL server 2019

D- Test the reliability of SQL Server 2019 Fail over cluster.

E- Move DB from single SQL server 2019 into SQL server 2019 fail over cluster to achieve High Availability.

By finishing this course , you will be prepared and ready to take next Course 12: SQL Server 2019 on Linux & Azure.
Who this course is for:

The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies.
Individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Requirements

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Students might have to attend Course 1: Set Windows Server 2019 Network – Microsoft series, if you want to create the network from scratch.
No technical experience is required.

Last Updated 11/2019

Related Torrents

torrent name size uploader age seed leech
Udemy - The Complete Course for Reading and Writing Arabic Posted by freecoursewb in Other
2.2 GB freecoursewb 1 week 0 0
Udemy - Qi Gong Instructor Certificate Renewal Course Posted by freecoursewb in Other
1.3 GB freecoursewb 1 week 12 2
Udemy - Lean Six Sigma Yellow Belt Certification Course Posted by freecoursewb in Other
857.7 MB freecoursewb 2 weeks 20 4
Udemy - Beatbox - Complete Beginner to Advanced Course Posted by freecoursewb in Other
4 GB freecoursewb 2 weeks 0 0
Udemy - Ultimate 11 + Verbal Reasoning Complete Course Posted by freecoursewb in Other
3.9 GB freecoursewb 3 weeks 11 1