001 Introduction.mp4 (50.92 MB)
MP4
003 How to get the best out of your Udemy course.mp4 (19.89 MB)
MP4
005 Curriculum.mp4 (39.72 MB)
MP4
001 Getting a free trial of Microsoft Azure.mp4 (18.57 MB)
MP4
002 Creating Azure SQL Database with sample data.mp4 (51.22 MB)
MP4
003 Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS.mp4 (63.76 MB)
MP4
004 Review 6 principal clauses of the SELECT statement.mp4 (22 MB)
MP4
005 Review JOINs.mp4 (30.43 MB)
MP4
001 57 determine the appropriate type of execution plan.mp4 (16.62 MB)
MP4
002 57 Different types of loops used in execution plans, and Scan and Seek.mp4 (18.48 MB)
MP4
003 57 identify problem areas in execution plans.mp4 (28.63 MB)
MP4
001 54 identify and implement index changes for queries.mp4 (36.21 MB)
MP4
002 53 DMVs which gather query performance information.mp4 (65.11 MB)
MP4
003 53 determine the appropriate DMVs to gather performance information.mp4 (54.12 MB)
MP4
004 55 recommend query construct modifications based on resource usage.mp4 (32.62 MB)
MP4
005 56 assess the use of hints for query performance.mp4 (36.4 MB)
MP4
001 1 deploy database offerings on selected platforms.mp4 (10.76 MB)
MP4
002 2 configure customized deployment templates.mp4 (62.87 MB)
MP4
003 5 evaluate requirements and functional benefitsimpact for the deployment.mp4 (68.6 MB)
MP4
004 5, 6 evaluate scalability and security aspects.mp4 (18.62 MB)
MP4
005 5 HADR of the possible database offerings.mp4 (54.23 MB)
MP4
006 70, 73 Automate deployment by using Azure Resource Manager (ARM) templates.mp4 (34.82 MB)
MP4
007 70, 73 Automate deployment by using Bicep - Install Visual Studio Code.mp4 (9.22 MB)
MP4
008 70, 73 Automate deployment by using Bicep - Creatingdeploying Bicep code.mp4 (62.84 MB)
MP4
009 71, 73 Automate deployment by using PowerShell.mp4 (29.41 MB)
MP4
010 72, 73 Automate deployment by using Azure CLI.mp4 (8.84 MB)
MP4
001 9 configure Azure SQL Database for scale and performance.mp4 (17.35 MB)
MP4
002 9, 62, 65 vCore-based purchasing model.mp4 (61.47 MB)
MP4
003 9, 62, 65 DTU-based purchasing model, Server vs Serverless.mp4 (41.66 MB)
MP4
004 9, 62, 65 Serverlessprovisioned and elastic pools.mp4 (31.78 MB)
MP4
005 9, 62, 65 Other Azure SQL Database configuration settings.mp4 (10.17 MB)
MP4
006 9 calculate resource requirements, including Elastic pool requirements.mp4 (11.32 MB)
MP4
007 7, 8, 12 database sharding and table partitioning.mp4 (67.98 MB)
MP4
008 13 evaluate the use of compression for tables and indexes.mp4 (44.48 MB)
MP4
009 20 set up SQL Data Sync.mp4 (44.16 MB)
MP4
001 14, 15 evaluate requirements and strategies for the migration.mp4 (55.46 MB)
MP4
002 16, 21 Azure Migrate.mp4 (10.19 MB)
MP4
003 16, 21 SQL Server Migration Assistant (SSMA).mp4 (15 MB)
MP4
004 16, 21 Data Migration Assistant (DMA).mp4 (28.12 MB)
MP4
005 16, 21 Azure Database Migration Service (DMS).mp4 (15.91 MB)
MP4
006 22 Implement a migration between Azure SQL services - export data.mp4 (14.65 MB)
MP4
007 22 Implement a migration between Azure SQL services - Other methods.mp4 (34.59 MB)
MP4
008 18 Perform post migration validations.mp4 (21.08 MB)
MP4
001 23 configure Azure AD authentication.mp4 (42.42 MB)
MP4
002 24 create users from Azure AD identities.mp4 (30.39 MB)
MP4
003 25, 29 configure security principals - roles.mp4 (34.64 MB)
MP4
004 25, 29 configure security principals - GRANTREVOKEDENY.mp4 (10.97 MB)
MP4
005 25, 29 configure security principals - individual permissions.mp4 (14.57 MB)
MP4
006 25, 29 configure security principals - the ALL permission.mp4 (14 MB)
MP4
007 29 configure permissions by using custom roles.mp4 (15.27 MB)
MP4
008 27 apply principle of least privilege for all securables.mp4 (7.52 MB)
MP4
001 30 implement Transparent Data Encryption (TDE).mp4 (10.21 MB)
MP4
002 31, 33 implement object-level encryption and Always Encrypted.mp4 (80.27 MB)
MP4
003 31, 33 More about Always Encrypted.mp4 (53.91 MB)
MP4
004 Always Encrypted versus Transparent Data Encryption.mp4 (6.12 MB)
MP4
005 34 implement Dynamic Data Masking.mp4 (30.41 MB)
MP4
006 32 configure server and database-level firewall rules.mp4 (49.09 MB)
MP4
007 35 Configure Transport Layer Security (TLS).mp4 (18.56 MB)
MP4
001 36 apply a data classification strategy.mp4 (41.29 MB)
MP4
002 37 configure server and database audits.mp4 (21.05 MB)
MP4
003 38 implement data change tracking - Change Tracking.mp4 (75.54 MB)
MP4
004 38 implement data change tracking - Change Data Capture.mp4 (49.18 MB)
MP4
005 39 perform a vulnerability assessment.mp4 (32.44 MB)
MP4
001 40 Manage database resources by using Azure Preview - theory + credentials.mp4 (31.52 MB)
MP4
002 40 Manage data resources by using Azure Purview - sources and scans.mp4 (15.24 MB)
MP4
003 41 Implement Azure SQL Database ledger - Theory.mp4 (21.26 MB)
MP4
004 41 Implement Azure SQL Database ledger - Creating Updateable ledger table.mp4 (20.66 MB)
MP4
005 41 Implement Azure SQL Database ledger - Append-only table and verifying.mp4 (62.13 MB)
MP4
006 42 Implement row-level security.mp4 (78.83 MB)
MP4
007 43 Configure Advanced Threat Protection Microsoft Defender for SQL.mp4 (24.05 MB)
MP4
001 44 prepare an operational performance baseline - Metrics Explorer.mp4 (16.23 MB)
MP4
002 44 prepare an operational performance baseline - Other ways.mp4 (34.03 MB)
MP4
003 77 create event notifications for Azure resources.mp4 (32.27 MB)
MP4
004 45 determine sources for performance metrics.mp4 (30.87 MB)
MP4
005 46 interpret performance metrics.mp4 (37.04 MB)
MP4
006 47 assess database performance by using Intelligent Insights.mp4 (10.07 MB)
MP4
007 47 configure and monitor activity and performance.mp4 (23.67 MB)
MP4
008 48 Monitor by using SQL insights - Theory and deploying components.mp4 (16.66 MB)
MP4
009 48 Monitor by using SQL insights - Implementation.mp4 (38.83 MB)
MP4
001 58 implement index maintenance tasks.mp4 (48.66 MB)
MP4
002 59 implement statistics maintenance tasks.mp4 (8.02 MB)
MP4
003 61, 75 configure database auto-tuning and automate performance tuning.mp4 (17.95 MB)
MP4
004 manage storage capacity.mp4 (15.92 MB)
MP4
005 assess growthfragmentation and report on database free space.mp4 (21.85 MB)
MP4
001 50, 51, 57 Query Store - an introduction.mp4 (21.22 MB)
MP4
002 50, 51, 57 configure Query Store, extract query plans.mp4 (42.31 MB)
MP4
003 52 identify sessions that cause blocking.mp4 (37.3 MB)
MP4
004 Isolation Levels.mp4 (17.63 MB)
MP4
005 assess performance-related database configuration parameters.mp4 (25.6 MB)
MP4
006 66 configure Intelligent Query Processing (IQP).mp4 (40.94 MB)
MP4
001 74 What is Elastic Job Agent.mp4 (16.2 MB)
MP4
002 74 automate database maintenance tasks.mp4 (30.04 MB)
MP4
003 Full, differential and transaction log backups.mp4 (13.95 MB)
MP4
004 82, 86 perform a database restore to a point in time - test DR.mp4 (20.32 MB)
MP4
005 87 configure long-term backup retention.mp4 (11.21 MB)
MP4
001 79 recommend HADR strategy based on RPORTO requirements.mp4 (17.65 MB)
MP4
002 81 evaluate Azure-specific HADR solutions.mp4 (38.58 MB)
MP4
003 89 configure replication - Active Geo-replication.mp4 (69.61 MB)
MP4
004 82, 91 configure auto-failover groups and test HA by using failover.mp4 (27.22 MB)
MP4
001 60 evaluate database health using DMVs - overall resource usage.mp4 (57.6 MB)
MP4
002 60 evaluate database health using DMVs - other topics.mp4 (18.82 MB)
MP4
003 60 evaluate server health using DMVs.mp4 (9.56 MB)
MP4
004 60 perform database consistency checks by using DBCC.mp4 (21.79 MB)
MP4
005 55 review database configuration options.mp4 (11.44 MB)
MP4
001 5, 6 Evaluating MIs and VMs based on specific requirements.mp4 (47.56 MB)
MP4
002 10, 62, 65 configure Azure SQL Managed Instance for scale and performance.mp4 (14.06 MB)
MP4
003 More about Azure SQL Managed Instance.mp4 (33.66 MB)
MP4
004 Accessing Azure SQL Managed Instance in SSMS.mp4 (32.14 MB)
MP4
005 11, 62, 65 configure SQL Server in Azure VMs - Part 1.mp4 (23.22 MB)
MP4
006 11, 62, 65 configure SQL Server in Azure VMs - Part 2.mp4 (13.6 MB)
MP4
007 Logging into SQL Server on Azure Virtual Machines.mp4 (17.6 MB)
MP4
008 11 Adding additional disks to the Azure Virtual Machine.mp4 (19.48 MB)
MP4
001 24, 29 create users from Azure AD identities (MIs and VMs).mp4 (25.77 MB)
MP4
002 29 manage certificates using T-SQL.mp4 (10.43 MB)
MP4
003 26, 29 configure database and object-level permissions using GUI.mp4 (8.99 MB)
MP4
004 25, 29 configure security principals (MIs and VMs).mp4 (24.82 MB)
MP4
005 65 recommend table, index storage inc filegroups (MI and VMs).mp4 (39.22 MB)
MP4
001 77 create event notifications based on metrics.mp4 (6.42 MB)
MP4
002 68 configure notifications for task successfailurenon-completion.mp4 (18.46 MB)
MP4
003 67 manage schedules and automate maintenance jobs.mp4 (17.24 MB)
MP4
004 77 create alerts for server configuration changes.mp4 (15.07 MB)
MP4
005 77 split and filter event notifications for Azure resources.mp4 (7.97 MB)
MP4
001 45 determine sources for performance metrics.mp4 (18.07 MB)
MP4
002 58 implement index maintenance tasks (Database Engine Tuning Advisor).mp4 (11.04 MB)
MP4
003 49 Monitor activity SQL Profile, Extended Events, Performance Dashboard.mp4 (28.97 MB)
MP4
004 63 configure Resource Governor for performance (VMMI).mp4 (32.06 MB)
MP4
001 3, 75 apply patches and updates for hybrid and IaaS deployment.mp4 (12.65 MB)
MP4
002 34 implement Azure Key Vault and disk encryption for Azure VMs.mp4 (9.53 MB)
MP4
003 75 configure multi-server automation.mp4 (8.32 MB)
MP4
004 75 implement policies by using automated evaluation modes.mp4 (18.13 MB)
MP4
005 76 Automate database workflows by using Azure Logic Apps.mp4 (44.03 MB)
MP4
006 76 Expanding our Logic App.mp4 (35.7 MB)
MP4
001 75 automate backups.mp4 (10.55 MB)
MP4
002 84 perform a database backup with options.mp4 (15.24 MB)
MP4
003 88 database (and transaction log) backups with options.mp4 (20.14 MB)
MP4
004 85, 86 perform a database restore with options.mp4 (38.98 MB)
MP4
005 88 perform restore of user databases in T-SQL.mp4 (8.37 MB)
MP4
006 88a backup and restore to and from cloud storage.mp4 (25.8 MB)
MP4
001 89 configure replication - Transactional replication.mp4 (20.26 MB)
MP4
002 4, 80, 81 evaluate HADR for hybrid and Azure-specific deployments.mp4 (21.56 MB)
MP4
003 Creating Virtual Machines for Failover Cluster and Always On Availability Group.mp4 (17.23 MB)
MP4
004 Connecting Virtual Machines to a Domain.mp4 (86.31 MB)
MP4
005 93 Configure failover cluster instances on Azure VMs.mp4 (37.52 MB)
MP4
006 90 Checking SQL Server Installation and preparing for AO.mp4 (25.12 MB)
MP4
007 92 configure quorum options for a Windows Server Failover Cluster.mp4 (54.69 MB)
MP4
008 90 create an Availability Group.mp4 (24.6 MB)
MP4
009 82, 90 Failover, integrate database into Always On Availability Group.mp4 (11.4 MB)
MP4
010 90 configure an Always On Availability Group listener.mp4 (5.14 MB)
MP4
011 94 Log shipping theory and creating folders.mp4 (16.78 MB)
MP4
012 94 Configure log shipping.mp4 (22.05 MB)
MP4
013 94 Testing log shipping and troubleshooting.mp4 (71.13 MB)
MP4
001 What's Next.mp4 (13.37 MB)
MP4
002 Well done.mp4 (12.91 MB)
MP4
002 validate data types defined for columns.mp4 (31.89 MB)
MP4
003 identify data quality issues with duplication of data.mp4 (18.38 MB)
MP4
004 identify normal form of database tables - Normal Forms 1 to 3.mp4 (27.9 MB)
MP4
005 identify normal form of database tables - Normal Forms 4 to 5.mp4 (22.62 MB)
MP4
006 evaluate requirements and strategies for the upgrade.mp4 (11.23 MB)
MP4
007 implement an online and offline upgrade strategy.mp4 (30.22 MB)
MP4
001 Bonus Lecture.mp4 (29.23 MB)
MP4