Course Offerings

What you will learn By the end of this course, participants will be able to: Develop a deep understanding of Apache Cassandra’s data model and query language. Design and create tables for optimal data distribution and access patterns. Configure and manage replication for fault tolerance and consistency. Secure Apache Cassandra deployments and implement operational best practices. Integrate Cassandra with DevOps workflows and automation. Explore advanced concepts and features in Apache Cassandra. Beneficial for This course is suitable for: Database Administrators Developers System Architects DevOps Engineers Anyone interested in leveraging Apache Cassandra for scalable and distributed data solutions. Course Pre-requisite Participants should have a basic understanding of: Basic understanding of database concepts. Familiarity with NoSQL databases (beneficial but not mandatory). Enthusiasm for working with distributed and scalable data solutions. Course Outline Module 1: Introduction to Apache Cassandra Overview of NoSQL databases and Apache Cassandra Key features and benefits of using Apache Cassandra Setting up the Apache Cassandra environment Module 2: Cassandra Data Modeling Understanding Cassandra’s data model Designing tables and defining keys in Cassandra Primary keys, clustering columns, and compound keys Module 3: Cassandra Query Language (CQL) Introduction to CQL and its syntax Creating, updating, and querying data in CQL Indexing and performance considerations in CQL Module 4: Data Distribution and Replication in Cassandra Partitioning and distribution of data in Cassandra Configuring replication for fault tolerance Consistency levels and trade-offs in Cassandra Module 5: Cassandra Architecture and Internals Overview of Cassandra’s architecture Understanding the read and write paths in Cassandra Gossip protocol and membership management Module 6: Apache Cassandra Security Securing Apache Cassandra deployments Authentication and authorization in Cassandra Data encryption and best practices for security Module 7: Cassandra Operational Best Practices Monitoring and managing Cassandra clusters Backup and restore strategies in Cassandra Handling maintenance and upgrades in Cassandra Module 8: Apache Cassandra and DevOps Integrating Cassandra with DevOps workflows Automation and scripting for Cassandra administration CI/CD practices for Cassandra deployments Module 9: Advanced Cassandra Concepts Materialized views and secondary indexes in Cassandra Batch processing and lightweight transactions Introduction to Apache Cassandra 4.0 features Module 10: Real-world Use Cases and Best Practices Case studies of real-world Cassandra implementations Best practices for designing scalable solutions with Cassandra Performance optimization and troubleshooting in Cassandra

What you will learn By the end of this course, participants will be able to: Master the Swift programming language for iOS and macOS development. Design and build user interfaces using Swift UI. Implement data persistence, networking, and API integration in Swift. Implement rolling updates and rollbacks in Kubernetes. Understand advanced Swift topics such as concurrency and memory management. Write effective tests and debug Swift applications in Xcode. Successfully deploy and submit applications to the App Store. Beneficial for This course is suitable for: iOS Developers macOS Developers Mobile App Developers Anyone interested in Swift application development for Apple platforms. Course Pre-requisite Participants should have a basic understanding of: Basic understanding of programming concepts. Familiarity with the macOS or iOS environment. Enthusiasm for developing applications for Apple platforms. Course Outline Module 1: Introduction Purpose of Swift  Evolution of Swift  Goals of Swift  Execution Environment  Swift Package Manager  Module 2: Fundamentals Files and Initialization  Statements  Constants and Variables  Type Annotations  Numeric Types  Booleans  Strings and Characters  Tuples  Conditional Statements  Loops  Module 3: Optionals Introduction  Forced Unwrapping  Optional Binding  Optional Chaining  Implicitly Unwrapped Optionals  Module 4: Functions Introduction  External Parameter Names  Default Parameter Values  Variadic Parameters  InOut Parameters  Function Types  Closures  Module 5: Collections Introduction  Arrays  Sets  Dictionaries  Module 6: Object-Oriented Techniques Enumerations  Structures  Classes  Computed Properties  Property Observers  Automatic Reference Counting (ARC)  Inheritance  Type Casting  Initialization  Deinitialization  Protocols  Extensions  Access Control  Module 7: Error Handling Introduction  Representing and Throwing Errors  Handing Errors  Cleanup Actions  Guards  Module 8: Generics Introduction  Generic Functions  Generic Types  Type Constraints  Module 9: Interoperability Introduction  Objective-C Frameworks  C Libraries  Mixed Projects 

What you will learn By the end of this course, participants will be able to: Have a strong understanding of iOS development using Swift. Be proficient in creating user interfaces and designing interactive iOS applications. Possess the skills to handle data, network requests, and integrate APIs into your apps. Know how to debug and optimize your code for performance Be ready to deploy your own iOS applications to the App Store. Beneficial for This course is suitable for: Aspiring iOS Developers Programmers looking to transition to iOS development Programmers looking to transition to iOS development Anyone wishing to create their own iOS applications Course Pre-requisite Participants should have a basic understanding of: Basic programming knowledge (any language) Familiarity with the macOS environment . A Mac computer running the latest version of macOS Course Outline Module 1: Introduction to iOS Development Overview of the iOS ecosystem  Introduction to Swift programming language  Setting up Xcode, the official IDE for iOS development  Module 2: User Interface Design Interface Builder and Storyboards  Designing responsive and intuitive user interfaces  Connecting UI elements to Swift code  Module 3: Swift Programming Basics Variables, constants, and data types  Control flow and loops  Functions and error handling  Module 4: Building Your First iOS App Creating a simple project from scratch  Implementing basic functionality  Testing and debugging your app  Module 5: Working with Views and View Controllers Understanding the view hierarchy  Customizing views and controllers  Navigation controllers and segues  Module 6: Data Persistence Saving data with UserDefaults  Working with Core Data for more complex data storage  Introduction to Codable for data encoding and decoding  Module 7: Networking and APIs Making network requests with URLSession  Parsing JSON data  Integrating data from web services into your app  Module 8: Advanced Topics Multithreading and Grand Central Dispatch  Implementing animations and gestures  Introduction to SwiftUI  Module 9: Testing and Debugging Writing unit tests  Debugging techniques and tools  Performance optimization  Module 10: Deployment and App Store Submission Creating an App ID and provisioning profiles  Generating certificates for app signing  Preparing and submitting an app to the App Store  Eagerness to learn and passion for creating iOS applications 

What you will learn By the end of this course, participants will be able to: Gain proficiency in Ruby on Rails development. Build and manage databases using ActiveRecord. Implement authentication, authorization, and testing in Rails applications. Develop RESTful APIs and consume external APIs. Integrate JavaScript for dynamic front-end interactions. Deploy and scale Ruby on Rails applications for production. Beneficial for This course is suitable for: Web Developers Full-stack Developers Ruby Developers transitioning to Rails Anyone interested in building web applications with Ruby on Rails. Course Pre-requisite Participants should have a basic understanding of: Basic understanding of programming concepts. Familiarity with web development concepts (HTML, CSS). Enthusiasm for building web applications with Ruby on Rails. Course Outline Module 1: Introduction to Ruby on Rails Overview of Ruby on Rails and its philosophy Setting up the development environment Understanding the Model-View-Controller (MVC) architecture Module 2: Ruby on Rails Basics Ruby language fundamentals for Rails development Creating and managing Rails projects Working with controllers, views, and models in Rails Module 3: ActiveRecord and Database Management Understanding ActiveRecord for database interactions Database migrations and schema management Querying and manipulating data with ActiveRecord Module 4: Rails Routing and RESTful Resources Configuring and understanding routes in Rails Implementing RESTful resources and CRUD operations Nested resources and routing best practices Module 5: Rails Views and Layouts Creating dynamic views with embedded Ruby (ERB) Using layouts and partials for view organization Implementing forms and handling form submissions Module 6: Authentication and Authorization in Rails Implementing user authentication with Devise Managing user roles and permissions Integrating role-based access control Module 7: Testing in Ruby on Rails Introduction to testing frameworks (RSpec, Capybara) Writing unit tests and integration tests TDD (Test-Driven Development) principles in Rails Module 8: Web Services and API Development Building APIs with Rails for data exchange Consuming external APIs in Rails applications Authentication and security in API development Module 9: Front-end Integration with JavaScript and Rails Integrating JavaScript in Rails applications Using AJAX for asynchronous updates Front-end frameworks and tools in Rail Module 10: Deployment and Scaling in Ruby on Rails Preparing Rails applications for deployment Deploying applications to cloud platforms (Heroku, AWS) Scaling strategies and considerations for Rails applications

What you will learn By the end of this course, participants will be able to: Develop a solid understanding of JavaScript syntax and core concepts. Write and debug JavaScript code for web development. Work with asynchronous operations using Promises and async/await. Manipulate the DOM and handle user interactions effectively. Interact with external APIs and consume data in web applications. Apply best practices and modern features in JavaScript development. Beneficial for This course is suitable for: Web Developers Front-end Developers Full-stack Developers Anyone looking to build a strong foundation in JavaScript. Course Outline Module 1: Introduction to JavaScript Overview of JavaScript and its role in web development Setting up the development environment Basics of HTML and CSS for JavaScript integration Module 2: JavaScript Syntax and Variables Understanding JavaScript syntax rules Declaring and using variables in JavaScript Data types and type coercion in JavaScript Module 3: Control Flow and Looping in JavaScript Implementing conditional statements (if, else, switch) Writing loops (for, while, do-while) for repetitive tasks Breaking and continuing loops in JavaScript Module 4: Functions in JavaScript Declaring and invoking functions Function parameters and return values Scope and closures in JavaScript functions Module 5: Arrays and Objects in JavaScript Creating and manipulating arrays in JavaScript Working with JavaScript objects Iterating through arrays and objects Module 6: DOM Manipulation with JavaScript Understanding the Document Object Model (DOM) Selecting and manipulating HTML elements with JavaScript Handling events and user interactions in the DOM Module 7: Asynchronous JavaScript Introduction to asynchronous programming Callbacks and Promises in JavaScript Handling asynchronous operations with async/awai Module 8: Error Handling in JavaScript Detecting and handling errors in JavaScript Using try/catch blocks for error management Best practices for debugging JavaScript code Module 9: JavaScript and Web APIs Interacting with Web APIs using JavaScript Making HTTP requests with Fetch API Consuming and displaying data from external APIs Module 10: JavaScript Best Practices and Modern Features Writing clean and maintainable JavaScript code ES6 and modern JavaScript features Coding standards and best practices for JavaScript development

What you will learn By the end of this course, participants will be able to: Understand core AWS services essential for developers. Build and deploy serverless applications using AWS Lambda. Containerize applications with Amazon ECS and EKS. Implement effective monitoring, debugging, and security practices. Leverage developer tools and services for CI/CD in AWS Beneficial for This course is suitable for: Developers and Software Engineers DevOps Engineers System Administrators transitioning to development roles Anyone seeking a developer-focused introduction to AWS. Course Pre-requisite Participants should have a basic understanding of: Basic understanding of software development concepts. Familiarity with at least one programming language (e.g., Python, Java). Interest in developing applications using cloud services. Course Outline Module 1: Introduction to Amazon Web Services Summarize the benefits of AWS    Describe differences between on-demand delivery and cloud deployments   Summarize the pay-as-you-go pricing model   Module 2: Compute in the Cloud  Describe the benefits of Amazon Elastic Compute Cloud (Amazon EC2) at a basic level   Identify the different Amazon EC2 instance types   Differentiate between the various billing options for Amazon EC2   Describe the benefits of Amazon EC2 Auto Scaling  Summarize the benefits of Elastic Load Balancing   Give an example of the uses for Elastic Load Balancing   Summarize the differences between Amazon SNS and Amazon SQS Notification Service  Summarize additional AWS compute options   Module 3: Global Infrastructure and Reliability Summarize the benefits of the AWS Global Infrastructure   Describe the basic concept of Availability Zones  Describe the benefits of Amazon CloudFront and Edge locations   Compare different methods for provisioning AWS services   Module 4: Networking Describe the basic concepts of networking   Describe the difference between public and private networking resources   Explain a virtual private gateway using a real life scenario   Explain a virtual private network (VPN) using a real life scenario   Describe the benefit of AWS Direct Connect   Describe the benefit of hybrid deployments  Describe the layers of security used in an IT strategy   Describe which services are used to interact with the AWS global network  Module 5: Storage and Databases Summarize the basic concept of storage and databases Describe benefits of Amazon Elastic Block Store (Amazon EBS)   Describe benefits of Amazon Simple Storage Service (Amazon S3)   Describe the benefits of Amazon Elastic File System (Amazon EFS)   Summarize various storage solutions   Describe the benefits of Amazon Relational Database Service (Amazon RDS)   Describe the benefits of Amazon DynamoDB   Summarize various database services   Module 6: Building a Web Application on AWS Discuss the architecture of the application you are going to build during this course   Explore the AWS services needed to build your web application   Discover how to store, manage, and host your web application   Module 7: Introduction to K8s on cloud Describe how to access AWS services programmatically  List some programmatic patterns  Provide efficiencies within AWS SDKs and AWS CLI  Explain the value of AWS Cloud9  Module 8: Getting Started with Permissions Review AWS Identity and Access Management (IAM) features and components permissions   Demonstrate how to test AWS IAM permissions    Configure your IDEs and SDKs to support a development environment   Demonstrate accessing AWS services using SDKs and AWS Cloud9   Module 9: Getting Started with Storage Describe the basic concepts of Amazon S3   List the options for securing data using Amazon S3   Define SDK dependencies for your code   Explain how to connect to the Amazon S3 service   Describe request and response objects  Module 10: Processing Your Storage Operations Perform key bucket and object operations   Explain how to handle multiple and large objects   Create and configure an Amazon S3 bucket to host a static website   Grant temporary access to your objects   Demonstrate performing Amazon S3 operations using SDKs Module 11: Security Explain the benefits of the shared responsibility model   Describe multi-factor authentication (MFA)   Differentiate between the  AWS Identity and Access Management (IAM) security levels   Describe security policies at a basic level   Explain the benefits of AWS Organizations   Summarize the benefits of compliance with AWS   Explain primary AWS security services at a basic level   Module 12: Monitoring and Analytics Summarize approaches to monitoring your AWS environment   Describe the benefits of Amazon CloudWatch   Describe the benefits of AWS CloudTrail   Describe the benefits of AWS Trusted Advisor  Module 13: Pricing and Support Understand AWS pricing and support models   Describe the AWS Free Tier   Describe key benefits of AWS Organizations and consolidated billing   Explain the benefits of AWS Budgets   Explain the benefits of AWS Cost Explorer   Explain the primary benefits of the AWS Pricing Calculator   Distinguish between the various AWS Support Plans   Describe the benefits of AWS Marketplace   Module 14: Migration and Innovation Understand migration and innovation in the AWS Cloud   Summarize the AWS Cloud Adoption Framework (AWS CAF)    Summarize six key factors of a cloud migration strategy   Describe the benefits of various AWS data migration solutions,  Summarize the broad scope of innovative solutions that AWS offers   Summarize the five pillars of the AWS Well-Architected Framework  

What you will learn By the end of this course, participants will be able to: Develop a foundational understanding of cloud computing and AWS. Gain hands-on experience with key AWS services. Configure and manage security using AWS IAM. Understand storage, database, and networking services in AWS. Implement cost-effective solutions and manage billing in AWS. Explore best practices for designing solutions in AWS. Beneficial for This course is suitable for: System Administrators Developers Business Decision Makers Anyone interested in getting started with AWS. Course Pre-requisite Participants should have a basic understanding of: No specific prerequisites are required. Basic familiarity with IT concepts and an interest in cloud computing is beneficial. Course Outline Module 1: Cloud Concepts Define the AWS Cloud and its value proposition  Identify aspects of AWS Cloud economics  List the different cloud architecture design principles  Module 2: Security and Compliance Define the AWS shared responsibility model  Define AWS Cloud security and compliance concepts  Identify AWS access management capabilities  Identify resources for security support  Module 3: Technology Define methods of deploying and operating in the AWS Cloud  Define the AWS global infrastructure  Identify the core AWS services  Identify resources for technology support  Module 4: Billing and Pricing Compare and contrast the various pricing models for AWS  Recognize the various account structures in relation to AWS billing and pricing Identify resources available for billing support 

What you will learn By the end of this course, participants will be able to: Develop a comprehensive understanding of Microsoft SQL Server. Design and optimize databases using SQL Server’s data modeling tools. Write efficient SQL queries and manage transactions effectively. Implement security measures, access control, and encryption in SQL Server. Create and deploy reports using SQL Server Reporting Services (SSRS). Beneficial for This course is suitable for: Database Administrators Software Developers System Architects Business Intelligence Professionals Course Pre-requisite Participants should have a basic understanding of: Basic understanding of database concepts. Familiarity with SQL and relational databases (beneficial but not mandatory). Interest inworking with Microsoft SQL Server in various applications. Course Outline Module 1: Introduction to Microsoft SQL Server Overview of relational databases and Microsoft SQL Server Key features and benefits of using Microsoft SQL Server Installing and setting up the SQL Server environment Module 2: SQL Server Data Modeling and Table Design Understanding relational data modeling Designing tables and defining relationships Normalization and optimization in SQL Server Module 3: SQL Server Query Language (Transact-SQL) Writing SQL queries using Transact-SQL Query optimization and performance tuning Common table expressions (CTEs) and window functions Module 4: SQL Server Data Manipulation and Transactions Performing CRUD operations in SQL Server Managing transactions and ensuring data consistency Error handling and rollback strategies Module 5: SQL Server Indexing and Optimization Creating and managing indexes in SQL Server Query optimization techniques Execution plans and performance monitoring Module 6: SQL Server Stored Procedures and Functions Designing and implementing stored procedures Creating user-defined functions in SQL Server Parameterization and modularization of code Module 7: SQL Server Security and Access Control Securing SQL Server deployments Authentication and authorization mechanisms Encryption and data protection best practices Module 8: SQL Server Reporting Services (SSRS) Introduction to SQL Server Reporting Services Designing and deploying reports in SSRS Data visualization and interactive reporting Module 9: SQL Server Integration Services (SSIS) Overview of SQL Server Integration Services Building and deploying ETL (Extract, Transform, Load) packages Data migration and automation with SSIS Module 10: SQL Server High Availability and Disaster Recovery Implementing high availability solutions (clustering, Always On) Backup and restore strategies in SQL Server Disaster recovery planning and best practices

What you will learn By the end of this course, participants will be able to: Develop a deep understanding of MongoDB’s data model and query language. Perform CRUD operations, data aggregation, and indexing in MongoDB. Integrate MongoDB with various programming languages and applications Implement security measures, access control, and encryption in MongoDB. Scale MongoDB deployments vertically and horizontally. Configure and manage MongoDB clusters in the cloud using MongoDB Atlas. Beneficial for This course is suitable for: Database Administrators Software Developers System Architects Data Engineers Course Pre-requisite Participants should have a basic understanding of: Basic understanding of database concepts. Familiarity with JSON and basic programming concepts (beneficial but not mandatory). Enthusiasm for working with NoSQL databases and MongoDB. Course Outline Module 1: Introduction to NoSQL. Recognizing the need for NoSQL data stores  Focusing on MongoDB  Interacting with MongoDB  Module 2: Installing MongoDB Surveying Cluster Topology  Dissecting MongoDB Storage Strategies  Storing Large Files with GridFS  Module 3: Exploring the MongoDB Data and Query Model Organizing Data  Querying Documents  Modelling Relationships  Module 4: Configuring Replication and Data Consistency Configuring Read and Write Consistency  Customizing Write Concern and Read Preference  Module 5: Tuning Performance with Indexes Improving access speed with indexes  Considering the cost and benefit of indexing  Taking advantage of indexes  Managing collections with special indexes  Module 6: Utilizing the Aggregation Framework Invoking single-purpose aggregation functions  Performing operations with the Aggregation Pipeline framework  Executing MapReduce on MongoDB 

What you will learn By the end of this course, participants will be able to: Gain a deep understanding of Snowflake’s architecture and features. Load, unload, and manage data in Snowflake for analytics. Perform complex queries and data transformations using Snowflake SQL. Implement security measures and access control in Snowflake. Share and collaborate on data within and outside the organization. Utilize advanced analytics, machine learning, and optimization techniques in Snowflake. Beneficial for This course is suitable for: Data Engineers Data Analysts Data Scientists Database Administrators Course Pre-requisite Participants should have a basic understanding of: Basic understanding of SQL and database concepts. Familiarity with cloud computing concepts (beneficial but not mandatory). Enthusiasm for leveraging cloud-based data platforms for analytics. Course Outline Module 1: Snowflake Architecture and Overview Snowflake Technical Overview  Overview of Three-Tiered Architecture  Module 2: Compute Management Scaling Virtual Warehouses Up & Out  Creating and Managing Virtual Warehouses  Module 3: Snowflake Objects & Commands Built-in Design and Comparison to Traditional SQL Commands  DDL Commands to Work with Dierent Database Objects  Different Functions and Operators Available in Snowflake  Account, Session, & Object Parameters  Module 4: Organizations Managing and Monitoring Multiple Accounts across Lines of Business  Replication between Regions and Cloud Providers and Failover  Module 5: Load Operations & Performance Management Load Operation Performance  Data Unloading  Module 6: DML & Transaction Model Snowflake DML Commands  SQL Statements for Transactions in Snowflake  DML and Clustering Impact on Table Versioning  Module 7: Back-up, Restore & Snapshot Time Travel  Zero-copy cloning  Fail-Safe  Agile Development Use Cases  Module 8: Storage Management Table Design Considerations  DML and Cloning Considerations  Storage Optimization  Module 9: Performance Methodology & Management Query Profile Analysis  Query Best Practices  Caching  Troubleshooting Tools & Tuning Performance Metrics  Data Clustering  Search Optimization Service  Materialized View Module 10: Role-based Access & Design Overview of Data Governance  System Roles & Custom Roles  Role Hierarchy  Best Practices  Column-Level Data Security to Protect Sensitive Data  Module 11: Account & Resource Monitoring Creating Resource Monitors  Monitoring Compute, Storage and Credits  Database Object Types and Storage Considerations  Utility Stored Procedures and Tasks  Module 12: Data Sharing Data Sharing Overview  Secured View  Secured UDF