Official digital learning platform for standardized technical progression
Track Details
SQL Server Specialist = T-SQL architect who tunes billion-row tables for sub-second reads. Mastery of SSMS, Execution Plans, Indexing (Clustered, Non-Clustered, Columnstore), and Query Store. Expert in HA/DR: Always On Availability Groups, Log Shipping, Replication. Performance tuning via Profiler, XEvents, DMV analysis. Data integrity via ACID, CDC, TDE. 10+ yrs, 99.99% uptime, 40% CPU reduction via refactoring. SSRS/SSIS/SSAS pro. I solve deadlocks before the app team opens a ticket.
Duration
12 weeks
Learning Mode
Online
Batch
Current Cohort
Curriculum modules are not published for this track yet.
No learning objectives are configured yet.
No progression outcomes are configured yet.
Related Tracks
Cloud
Microsoft Azure Core Fundamentals is the on-ramp to the world’s second-largest cloud. In one condensed day you’ll build and break a mini-enterprise: deploy a Ubuntu VM behind a B-series SKU, attach a managed OS disk, snapshot it before a risky upgrade. You’ll create a storage account with hot/cool tiers, lifecycle rules that archive 80 % of blobs to glacier after 30 days, and a SAS token that expires like a mission-impossible tape. You’ll peer two VNets, force-tunnel traffic through an NVA, and watch Network Watcher draw the packet flow in real time. Identity section: invite your Gmail as a guest user, assign Reader role at subscription scope, then add PIM-eligible Contributor that requires ticket-based approval. Governance: apply a “deny naughty SKUs” policy that blocks any VM size starting with “Standard_B” unless tagged “dev-test”. Cost: run the Pricing Calculator, export the estimate to Excel, then set a $50 budget that emails you at 80 % burn.
View DetailsCloud
I’m the glue between product dreams and AWS reality. My day starts reviewing a napkin sketch: “We need global sub-100 ms latency for 8 M concurrent gamers and PCI-DSS compliance.” By stand-up I’ve turned it into a color-coded Lucidchart: CloudFront + WAF front door, Origin Shield in front of S3 static lobby, API Gateway → Lambda@Edge for auth, regional ECS Fargate clusters for game sessions, DynamoDB Global Tables for player state, Kinesis Data Streams + Firehose for 30 TB/day telemetry, and Aurora Serverless v2 for leaderboards that scale to zero at 4 a.m. I write infrastructure as code (TypeScript CDK or Terraform) so every pull-request spins up a full clone stack in 12 minutes; when it’s torn down, the cost is $0.47. Security: IAM boundaries, SCPs, KMS CMKs rotated every 90 days, GuardDuty + Security Hub aggregated across 250 accounts. Cost: I built a FinOps bot that parks 3 200 dev instances nightly, saving $1.1 M/year; reserved Graviton3 capacity cut compute by 42 % while raising TPS 19 %. Observability: CloudWatch metric math, X-Ray sampling, custom Contributor Insights rules that page Slack before users notice.
View DetailsCloud
This is the friendly on-ramp for every future admin, coder, or curious clicker. Morning: we rip open a desktop—identify ATX 24-pin, M.2 NVMe vs. SATA, DDR5 channels, PSU rails, then POST-beep our way to BIOS. Afternoon: boot Ubuntu Live, shrink NTFS, dual-boot, and watch Task Manager while we stress CPU with Prime95 until 90 °C throttle. Networking: cable a Cat6 T568B patch, log into a consumer router, flip 2.4 GHz → 5 GHz, run iperf3 and smile at 940 Mbps. Security: we phish ourselves with a fake LinkedIn e-mail, forward the header to abuse@, and enable 2FA on every account. Databases: import a CSV of 500 movies into SQLite, run SELECT * WHERE genre='Comedy', export to JSON for the web devs. Cloud: spin up a free AWS EC2 micro, SSH in, install nginx, serve “Hello Cloud” in 6 min—then terminate so the bill is $0.00. Software dev: trace the waterfall vs. Agile sticky-note board, write five lines of Python that print Fibonacci, commit to GitHub, open a PR, merge, done. Exam cram: 90-minute mock, 75 multiple-choice, 650 cut-score. We play Kahoot with acronyms—BIOS, USB-C, SSD, VPN, SQL—and finish with a 95 % class average. By 5 p.m. you’ll have replaced a laptop screen, secured Grandma’s Wi-Fi, and earned a digital badge that links straight to LinkedIn. Next stop: A+, Network+, or that coding boot-camp you bookmarked.
View Details