CoursesData & Analytics

Data & Analytics

Azure SQL.

This show explores the foundational concepts and workings of Azure SQL.

Intermediate
Single courseR1,995.00

or R798.00 deposit + 3 × R399.00 monthly

6h 5m

Course overview.

This show explores the foundational concepts and workings of Azure SQL. We start by defining why you might decide to implement a hosted database in Azure SQL vs an on-premise solution; detailing some of the benefits of moving to Azure SQL. We then describe some of the more advanced benefits of using Azure SQL like using Resource Groups, Geo-Restore, Point-In-Time Restore, and Self-Service Restore. Finally they take a look at the performance tiers as well as Database Throughput Units or DTUs.

Four key topics

SQL database deploymentDatabase security and accessBackup, recovery and availabilityDatabase monitoring and performance

Course lesson outline

21 lessons
Azure SQL21 lessons
  1. Overview
  2. Introduction to Azure SQL
  3. Creating Your First Database
  4. Connecting Your Client
  5. Using Elastic Pools
  6. Migrating Databases to Azure
  7. Tables and Data
  8. Azure Automation
  9. Exporting Data
  10. Implementing Indexes
  11. Implementing Indexes Part 2
  12. Database Maintenance
  13. Monitoring Azure SQL
  14. Scaling Up/Down
  15. Geographical Redundancy
  16. Self-Service Restore
  17. Controlling Network Access
  18. Users and Roles
  19. Permissions and Schemas
  20. Database Auditing
  21. Deploying Applications

Related courses.

All courses

Ready for your next step?

Search courses

Use the down arrow to explore courses. Press Enter to view all matching courses, or Escape to close.

Popular courses

CompTIA A+ Core 1 & Core 2 (220-1201 / 220-1202)IT fundamentals BeginnerCompTIA Security+ (SY0-701)Cybersecurity IntermediateMicrosoft Azure Fundamentals (AZ-900)Cloud computing BeginnerCompTIA Network+ (N10-009)Cybersecurity BeginnerAWS Certified Cloud Practitioner CLF-C02Cloud computing BeginnerCisco CCNA (200-301)Networking IntermediateAbstracting with FunctionsSoftware Development BeginnerAccess 2016 EssentialsBusiness & Professional Skills BeginnerAccredited Agile Project Management Foundation (Scrum)Business & Professional Skills BeginnerAccredited Agile Scrum MasterBusiness & Professional Skills IntermediateAccredited DevOps FoundationBusiness & Professional Skills BeginnerAccredited DevOps ProfessionalBusiness & Professional Skills IntermediateAgile TestingBusiness & Professional Skills IntermediateAI EssentialsAI Training BeginnerAmazon Web ServicesCloud computing BeginnerApple Certified Support Professional macOS 11IT Support IntermediateAWS Big Data SkillsData & Analytics BeginnerAWS Certified DevOps Engineer - ProfessionalCloud computing ExpertAWS Certified Solutions Architect - Associate (SAA-C03)Cloud computing IntermediateAWS Certified SysOps Administrator - AssociateCloud computing IntermediateAZ-140: Microsoft Azure Virtual DesktopCloud computing IntermediateAZ-500: Microsoft Azure Security TechnologiesCloud computing ExpertAZ-800: Administering Windows Server Hybrid Core InfrastructureCloud computing IntermediateAZ-801: Configuring Windows Server Hybrid Advanced ServicesCloud computing ExpertAzure SQLData & Analytics IntermediateCCNA SecurityCybersecurity IntermediateCertified Associate in Project Management (CAPM)Business & Professional Skills IntermediateCertified Cloud Security ProfessionalCybersecurity ExpertCertified Ethical Hacker (CEH) v.12Cybersecurity IntermediateCertified Ethical Hacker v13Cybersecurity IntermediateCertified Hacking Forensic Investigator (CHFI) v9Cybersecurity ExpertCertified Incident Handler (ECIH) v2Cybersecurity IntermediateCertified Information Security Manager (CISM)Cybersecurity IntermediateCertified Support Professional 10.12IT Support BeginnerCertNexus Certified Internet of Things Practitioner (ITP-110)Networking IntermediateCISA: Certified Information Systems AuditorCybersecurity ExpertCisco CCNP Data Center DCCOR (350-601)Networking ExpertCisco CCNP Enterprise ENARSI (Exam 300-410)Networking ExpertCisco CCNP Enterprise ENCOR (350-401)Networking ExpertCisco CCNP Enterprise ENSLD (300-420)Networking ExpertCisco CCNP Security SCOR (Exam 350-701)Cybersecurity BeginnerCisco CCNP Security SNCF (Exam 300-710)Cybersecurity ExpertCisco CCT Routing and Switching (100-490)Networking BeginnerCisco Certified DevNet Associate (200-901)Software Development IntermediateCisco CyberOps Associate (200-201)Cybersecurity IntermediateCISSP: Certified Information Systems Security ProfessionalCybersecurity IntermediateCloud FundamentalsCloud computing BeginnerCOBIT 2019 FoundationBusiness & Professional Skills BeginnerCompTIA CASP+ (CAS-004)Cybersecurity ExpertCompTIA Cloud Essentials+ (CLO-002)Cloud computing BeginnerCompTIA Cloud+Cloud computing IntermediateCompTIA Cloud+ (CV0-004)Cloud computing IntermediateCompTIA CySA+ (CS0-003)Cybersecurity IntermediateCompTIA IT FundamentalsIT fundamentals BeginnerCompTIA IT Fundamentals+ (FC0-U61)IT fundamentals BeginnerCompTIA Linux+ (XK0-006)Systems Administration IntermediateCompTIA PenTest+ (PT0-003)Cybersecurity IntermediateCompTIA Project+ (PK0-005)Business & Professional Skills BeginnerCompTIA SecAI+ (CY0-001)AI Training ExpertCompTIA SecurityX (CAS-005)Cybersecurity ExpertCompTIA Server+ (SK0-005)Systems Administration BeginnerCompTIA Tech+ (FC0-U71)IT fundamentals BeginnerCPA – C++ Certified Associate ProgrammerSoftware Development IntermediateCPE – C++ Certified Entry-Level ProgrammerSoftware Development BeginnerCPP – C++ Certified Professional ProgrammerSoftware Development ExpertCRISC: Certified in Risk and Information Systems ControlCybersecurity ExpertCustomer Service Skills for TechiesIT Support BeginnerCyber Secure Coder (CSC-110)Software Development BeginnerCyberSec First Responder (CFR-310)Cybersecurity BeginnerCybersecurity FundamentalsCybersecurity BeginnerData Representation and SerializationSoftware Development BeginnerDesigning Microsoft Azure Infrastructure Solutions (AZ-305)Cloud computing ExpertDeveloping Solutions for Microsoft Azure (AZ-204)Cloud computing IntermediateDive into the Python Standard LibrarySoftware Development BeginnerDNSNetworking BeginnerExcel 2016 EssentialsBusiness & Professional Skills BeginnerExcel FunctionsBusiness & Professional Skills BeginnerGIAC Security Essentials (GSEC)Cybersecurity IntermediateGoogle Cloud Platform - Associate Cloud EngineerCloud computing IntermediateHands-on BGPNetworking BeginnerHands-on HackingCybersecurity BeginnerHands-on Python for Networking ProfessionalsNetworking BeginnerHands-On Web App PentestingCybersecurity ExpertHands-on with Cisco Meraki Wireless Access PointsNetworking BeginnerHands-on with SCCMSystems Administration BeginnerHTML, CSS and BootstrapSoftware Development BeginnerHTML5 Canvas Graphics and AnimationsSoftware Development BeginnerImplementing Microsoft Azure Infrastructure - 70-533Cloud computing ExpertIntro to AngularJSSoftware Development BeginnerIntro to AV/EDR EvasionCybersecurity BeginnerIntro to AWS PentestingCloud computing BeginnerIntro to DockerSoftware Development BeginnerIntro to GitSoftware Development BeginnerIntro to IoT PentestingCybersecurity BeginnerIntro to JavaScriptSoftware Development BeginnerIntro to NodeJSSoftware Development BeginnerIntro to NumPyData & Analytics BeginnerIntro to PHPSoftware Development BeginnerIntro to ReactSoftware Development BeginnerIntro to Ruby on RailsSoftware Development BeginnerIntro to WordPress DevelopmentSoftware Development BeginnerJSA – Certified Associate JavaScript ProgrammerSoftware Development IntermediateJSE – Certified Entry-Level JavaScript ProgrammerSoftware Development BeginnerJuniper Junos OS BasicsNetworking BeginnerKali LinuxCybersecurity IntermediateLean Agile Project ManagementBusiness & Professional Skills BeginnerLean Six Sigma - Green BeltBusiness & Professional Skills IntermediateLean Six Sigma - Yellow BeltBusiness & Professional Skills BeginnerLinux EssentialsSystems Administration BeginnerLinux Security TechniquesCybersecurity BeginnerLinux Shell Scripting - AdvancedSystems Administration ExpertLinux Shell Scripting - BasicsSystems Administration BeginnerLPIC-1 Linux Administrator (101-500)Systems Administration IntermediateLPIC-1 Linux Administrator (102-500)Systems Administration IntermediateLPIC-2 Linux Engineer (201-450)Systems Administration ExpertLPIC-2 Linux Engineer (202-450)Systems Administration ExpertManaging Microsoft Teams (MS-700)Cloud computing BeginnerMastering Microsoft Endpoint Manager and IntuneCloud computing BeginnerMD-102: Endpoint AdministratorCloud computing IntermediateMetasploitCybersecurity IntermediateMicrosoft 365 Fundamentals (MS-900)Cloud computing BeginnerMicrosoft AzureCloud computing BeginnerMicrosoft Azure (AZ-500)Cybersecurity ExpertMicrosoft Azure Administrator Associate (AZ-104)Cloud computing IntermediateMS-102: Microsoft 365 AdministratorCloud computing IntermediateNIST Cybersecurity and Risk Management FrameworksCybersecurity IntermediateObject Oriented JavaSoftware Development IntermediateOWASP Top 10Cybersecurity BeginnerPalo Alto Networks Cybersecurity Fundamentals (PCCSA)Cybersecurity BeginnerPC MaintenanceIT fundamentals BeginnerPCAP – Certified Associate Python ProgrammerSoftware Development IntermediatePCAT – Certified Associate Tester with PythonSoftware Development IntermediatePCED – Certified Entry-Level Data Analyst with PythonData & Analytics BeginnerPCEI – Certified Entry-Level AI Specialist with PythonAI Training BeginnerPCEP – Certified Entry-Level Python ProgrammerSoftware Development BeginnerPCET – Certified Entry-Level Tester with PythonSoftware Development BeginnerPCPP1 – Certified Professional Python Programmer Level 1Software Development ExpertPD101 – Python for Data Analytics 101Data & Analytics BeginnerpfSense 2.4.4: Open Source FirewallCybersecurity BeginnerPowerShell ScriptingSystems Administration IntermediatePowerShell SkillsSystems Administration BeginnerProfessional Scrum MasterBusiness & Professional Skills IntermediatePrompting for AI in Cybersecurity EngineeringAI Training IntermediatePython for SecurityCybersecurity BeginnerReading and Writing FilesSoftware Development BeginnerRed Hat Enterprise Linux 8Systems Administration BeginnerSC-200: Microsoft Security Operations AnalystCloud computing IntermediateSC-300: Microsoft Identity and Access AdministratorCloud computing IntermediateSCS-C02: AWS Certified Security - SpecialtyCloud computing ExpertSecurity FundamentalsCybersecurity BeginnerSplunk Enterprise Administration FundamentalsCybersecurity BeginnerSystems Security Certified PractitionerCybersecurity IntermediateUse the Standard LibrarySoftware Development BeginnerUsing Community CodeSoftware Development BeginnerVMware VCP-DCV (Updated for vSphere 7)Systems Administration ExpertWDA – Certified Associate Web Developer (CSS)Software Development IntermediateWDE – Certified Entry-Level Web Developer (HTML)Software Development BeginnerWindows Admin CenterSystems Administration IntermediateWiresharkNetworking IntermediateWorking with Active DirectorySystems Administration Intermediate
View all coursesesc Close
Course advice

Let’s talk.

Tell us what you’d like to learn.

Checking online enquiries. You can also email info@aitlearning.co.za or call 021 140 6168.

Course finder
01 / 02

What interests you?

Choose a subject.