1. Master SQL for Data Analysis
Understand advanced tools and capabilities in SQL. Learn how to combine data from multiple sources, subqueries, data transformation and classification, window functions, views, CTEs, and explore SQL extensively.
- Mode of Training: On-demand videos
- Duration: 3 hours and 54 minutes
- Author: Idan Gabrieli, Senior Solutions Architect with 17 years of industry experience
2. SQL Server Course for Beginners with 100+ examples
Learn to create and modify databases and tables, manipulate records, apply constraints, create indexes, and use operators and functions in SQL. You will gain expertise in querying data, ordering results, and acquiring advanced query capabilities for complex databases and queries.
- Mode of training: On-demand videos
- Duration: 1 hour and 58 minutes
- Author: Amit Diwan, founder of Studyopedia.com and Amit Thinks (YouTube Educational Channel)
3. Job-Ready SQL in an Afternoon
Understand the fundamentals of the relational model, data types, schemas, and table organization. Dive into SQL code, starting with basic operations like creating databases, tables, inserting and selecting data, and filtering. Explore advanced topics including aggregations, subqueries, joins, unions, and window functions, preparing you for technical interviews and real-world SQL applications.
- Mode of training: On-demand videos
- Duration: 6 hours and 14 minutes
- Author: Maximilian Schallwig, Data Engineer and Python Programmer
4. Complete Python Course with 10 Real-World Projects
Get a comprehensive introduction to Python, covering basic to advanced programming techniques. Understand Python basics and progresses to intermediate and advanced concepts, including OOPS, modules, functions, database handling, and building various applications. Become proficient in Python syntax, get the ability to create executable programs independently, and develop a comprehensive understanding of Python.
- Mode of training: On-demand videos
- Duration: 27 hours and 7 minutes
- Author: Ardit Sulce, Python programmer, teacher, and founder of PythonHow
5. Azure Data Factory for Beginners - Build Data Ingestion
Get onboarded onto the Azure Data Factory platform to build your first pipeline. Once you grasp the development pattern, you can easily extend it to other data sources. Learn to build a metadata-driven framework for dynamic ingestion, enable auditing and monitoring for business intelligence. Get equipped to design, implement, and deploy data ingestion solutions in Azure.
- Mode of training: On-demand videos
- Duration: 6 hours and 29 minutes
- Author: David Mngadi, Data Engineering Architect and Consultant with 14 years of data management experience.
6. A Developer's Guide to Building Resilient Cloud Applications with Azure
Learn about migrating old apps to Azure using the Cloud Adoption Framework and building secure and reliable applications. Explore modernizing existing apps with new technologies and approaches, while understanding Azure Container Registry, Azure Container Instances, and Azure Kubernetes Service for developing microservices-based applications. Acquire the skills to perform application migration, select appropriate Azure services, and implement cloud-oriented applications using containers and orchestrators.
- Mode of training: e-Book
- Number of pages: 274
- Author: Hamida Rebai Trabelsi, Senior Cloud Solution Integration Architect, Microsoft MVP Developer Technologies, Microsoft Certified Trainer, and Author
7. Windows Server Automation with PowerShell Cookbook
Learn how to effectively install, configure, and utilize PowerShell 7.2. Understand topics like installation, new features, compatibility solutions, and progresses to fundamental and advanced use cases such as VM creation, Azure VPN setup, networking management, Active Directory, Hyper-V, Azure, WSUS, containers, module handling, and issue diagnosis and resolution on Windows Server. Get be proficient in automating tasks on Windows Server 2022 using PowerShell 7.2, optimizing your Windows environment for enhanced performance.
- Mode of training: e-Book
- Number of pages: 714
- Author: Thomas Lee, Consultant, Trainer, and Writes active in IT industry since the 1960s
8. Azure Machine Learning Engineering
Understand how to train and deploy ML models at scale. Cover topics like training, registering, and productionizing models using Azure Machine Learning service, scoring models in real-time and batch, explaining models for business trust, mitigating model bias, and implementing MLOps. Build and deploy end-to-end ML solutions in Azure for real-time scenarios, enabling you to integrate ML into production systems effectively.
- Mode of training: e-Book
- Number of pages: 362
- Authors: Sina Fakhraee, Ph.D. (Enterprise Data Scientist, and Senior Cloud Solution Architect), Balamurugan Balakreshnan (Principal Cloud Solution Architect at Microsoft Data/AI Architect and Data Science.), and Megan Masanz (Principal Cloud Solution Architect focused on Data, AI, and Data Science)
9. Cloud Auditing Best Practices
Get an introduction to cloud architecture and the importance of cloud control assessments, guiding you to become proficient in cloud auditing. Navigate AWS, Azure, and GCP environments, learn to build cloud IT auditing programs using tools like Terraform, Azure Automation, and AWS Policy Sentry, and gain insights into preparing advanced audits and monitoring cloud environments. Confidently apply and assess security controls for AWS, Azure, and GCP, ensuring compliance in the cloud independently and effectively.
- Mode of training: e-Book
- Number of pages: 268
- Authors: Shinesa Cambric (CCSP, CISSP, CISA, CISM, CDPSE) Cloud Security, Compliance, and Identity Architect and Michael Ratemo (CISSP, CISA, CISM, GCSA, CCSK, CIA) Cybersecurity Leader and Principal Consultant.
10. Apache Spark 3 for Data Engineering and Analytics with Python
Understand key concepts of PySpark, including Spark architecture, transformations, actions, and leveraging Python, Java, and SQL in the Spark ecosystem. Learn how to set up a Python environment for Spark, cover data collection, cleaning, and visualization using Databricks, and explore interacting with DataFrames using SQL. Delve into RDDs and engage in challenges to reinforce your understanding throughout the course.
- Mode of training: On-demand videos
- Duration: 8 hours and 30 minutes
- Author: David Mngadi, Data Engineering Architect and Consultant with 14 years of data management experience