17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Course 11 SQL Server 2019 On Windows Server 2019 Series
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
.pad/0
54.9 KB
.pad/1
77.3 KB
.pad/2
610.6 KB
TutsNode.com.txt
63 B
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/1. Introduction/1. SQL course introduction.srt
6.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/1. Introduction/2. SQL Server Admin tasks.srt
15.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/1. Introduction/3. Features of SQL Server 2019.srt
11.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/1. Introduction.srt
2.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/10. Structure query part 2.srt
16.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/11. Build DataBase structure.srt
7.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/12. Input data query.srt
11.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/13. Complex query.srt
16 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/14. Join query.mp4
128.9 MB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/14. Join query.srt
15.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/2. Initial report - ERD.srt
5.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/3. Staff table design.srt
9.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/4. Customer table design.srt
6.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/5. Store table design.srt
13.6 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/6. Product table design.srt
10.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/7. Order Table design.srt
11.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/8. Main project diagram.srt
5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/10. BikeStore project/9. Structure query part 1.srt
16.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/11. Maintenance/1. Simple backup and restore.srt
18.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/11. Maintenance/2. Backup and High Availability.srt
4.6 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/1. FOC plan.srt
8.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/10. Fix MPIO.srt
8.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/11. Fail over cluster creation.srt
10.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/12. Fail over cluster role.srt
2.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/13. FOC SQL 2019.srt
2.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/2. FreeNAS.srt
4.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/3. Fix SQL nodes IPs.srt
13.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/4. Secure channel.srt
8.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/5. NAS installation.srt
16.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/6. NAS quick scan.srt
10 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/7. NAS ISCSI configuration.srt
11.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/8. NAS ISCSI storage.srt
19.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/12. SQL 2019 Fail Over Cluster/9. Fail over test.srt
15.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/13. Fail over cluster SQL 2019 installation/1. Create service accounts.mp4
126.4 MB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/13. Fail over cluster SQL 2019 installation/1. Create service accounts.srt
21 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/13. Fail over cluster SQL 2019 installation/2. Install 1st instance.mp4
137 MB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/13. Fail over cluster SQL 2019 installation/2. Install 1st instance.srt
20.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/13. Fail over cluster SQL 2019 installation/3. Install 2nd instance and check HA.srt
6.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/2. Network preparation and Check points/1. Overview of Lab.srt
5.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/2. Network preparation and Check points/2. Clone SQL 2019 box.srt
5.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/2. Network preparation and Check points/3. ICT & Updates.srt
11.4 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/2. Network preparation and Check points/4. Network checkpoints plan.srt
11.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/2. Network preparation and Check points/5. Network checkpoints, Part - I.srt
13.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/2. Network preparation and Check points/6. Network checkpoints, Part - II.srt
9.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/1. SQL 2019 prerequisite.srt
12.6 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/10. SQL domain group.srt
7.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/2. Download SQL server 2019.srt
2.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/3. Installation interface first impression.srt
4.4 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/4. Detect .NET Framework version.srt
16 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/5. System configuration checker.srt
8.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/6. Installation prior check.srt
17.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/7. Address firewall problem.srt
15.6 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/8. GPO firewall.srt
8.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/3. SQL 2019 prerequisite/9. Create local SQL admin account.srt
3.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/1. Install first SQL 2019 instance - Part I.srt
11.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/2. Install first SQL 2019 instance - Part II.srt
10.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/3. Installation center tools.srt
16.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/4. Install (SSMS) SQL Server Mgmt Studio 18.srt
10.6 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/5. SMSS update, PC1 SMSS, Remote Access.srt
6.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/6. Fix remote access.srt
3.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/7. Authorize SQL admins.srt
6.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/8. Arm SQL with PS modules.srt
10.4 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/4. SQL installation - 1st instance/9. Time for new snapshot.srt
10.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/1. Add sample data.srt
15.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/1.1 BikeStores Sample Database - create objects.sql
3.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/1.3 BikeStores Sample Database - drop all objects.sql
751 B
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/2. What is relational database.srt
16.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/3. Build DB diagram.srt
9.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/4. OLTP.srt
3.4 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/5. DataBase types.srt
13.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/6. Data analysis.srt
5.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/7. SQL languages.srt
5.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/5. Introduction to Databases/8. Basic SQL query practise.srt
7.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/1. ERD TPA.srt
8.3 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/2. ANSI-SPARC DB model.srt
7.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/3. ERM model - Primary vs Foreign key.srt
18.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/4. ERM model - Relationships & Notations.srt
5.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/5. Lab - Model & Design a Database - Part 1.srt
13.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/6. Lab - Model & Design a Database - Part 2.mp4
126.4 MB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/6. Data Modeling/6. Lab - Model & Design a Database - Part 2.srt
16.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/1. Importance of normalization.srt
10.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/10. Referential integrity & relationships.srt
14.9 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/2. Dependencies.srt
8.1 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/3. 5 Normal forms.srt
16.4 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/4. GUI build schema and data table.srt
17.4 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/5. Data Types.srt
9.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/6. Creating database using queries.srt
10.7 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/7. Working with database.srt
8.2 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/8. Data insertion.srt
5.5 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/7. Normalization & Denormalization/9. Denormalization.srt
18 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/8. Performance/1. Index.srt
8.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/8. Performance/2. Joins.srt
10 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/8. Performance/3. Concurrency.srt
2.8 KB
[TutsNode.com] - Course 11 SQL Server 2019 on Windows Server 2019 Series/9. SQL object types/1. DataBase objects.srt
