1071 Courses delivered Online

In this course, we will process massive streams of real-time data using Spark Streaming and create Spark applications using the Scala programming language (v2.12). We will also get our hands-on with some real live Twitter data, simulated streams of Apache access logs, and even data used to train machine learning models.

Flash Sale 2024 II Discount II Bundle Course II Free CPD certificates

Let's build sophisticated visualizations and dashboards using Sankey diagrams and geospatial, sunburst, and circular charts and animate your visualizations. We will also cover advanced Tableau topics, such as Tableau parameters and use cases and Level of Detail (LOD) expressions, spatial functions, advanced filters, and table calculations.

Overview In this age of technology, data science and machine learning skills have become highly demanding skill sets. In the UK a skilled data scientist can earn around £62,000 per year. If you are aspiring for a career in the IT industry, secure these skills before you start your journey. The Complete Machine Learning & Data Science Bootcamp 2023 course can help you out. This course will introduce you to the essentials of Python. From the highly informative modules, you will learn about NumPy, Pandas and matplotlib. The course will help you grasp the skills required for using python for data analysis and visualisation. After that, you will receive step-by-step guidance on Python for machine learning. The course will then focus on the concepts of Natural Language Processing.  Upon successful completion of the course, you will receive a certificate of achievement. This certificate will help you elevate your resume. So enrol today! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? Anyone with an interest in learning about data science can enrol in this course. It will help aspiring professionals develop the basic skills to build a promising career. Professionals already working in this can take the course to improve their skill sets. Requirements The students will not require any formal qualifications or previous experience to enrol in this course. Anyone can learn from the course anytime from anywhere through smart devices like laptops, tabs, PC, and smartphones with stable internet connections. They can complete the course according to their preferable pace so, there is no need to rush.   Career Path This course will equip you with valuable knowledge and effective skills in this area. After completing the course, you will be able to explore career opportunities in the fields such as Data Analyst Data Scientist Data Manager Business Analyst Course Curriculum 18 sections • 98 lectures • 23:48:00 total length •Welcome & Course Overview6: 00:07:00 •Set-up the Environment for the Course (lecture 1): 00:09:00 •Set-up the Environment for the Course (lecture 2): 00:25:00 •Two other options to setup environment: 00:04:00 •Python data types Part 1: 00:21:00 •Python Data Types Part 2: 00:15:00 •Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 1): 00:16:00 •Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 2): 00:20:00 •Python Essentials Exercises Overview: 00:02:00 •Python Essentials Exercises Solutions: 00:22:00 •What is Numpy? A brief introduction and installation instructions.: 00:03:00 •NumPy Essentials - NumPy arrays, built-in methods, array methods and attributes.: 00:28:00 •NumPy Essentials - Indexing, slicing, broadcasting & boolean masking: 00:26:00 •NumPy Essentials - Arithmetic Operations & Universal Functions: 00:07:00 •NumPy Essentials Exercises Overview: 00:02:00 •NumPy Essentials Exercises Solutions: 00:25:00 •What is pandas? A brief introduction and installation instructions.: 00:02:00 •Pandas Introduction: 00:02:00 •Pandas Essentials - Pandas Data Structures - Series: 00:20:00 •Pandas Essentials - Pandas Data Structures - DataFrame: 00:30:00 •Pandas Essentials - Handling Missing Data: 00:12:00 •Pandas Essentials - Data Wrangling - Combining, merging, joining: 00:20:00 •Pandas Essentials - Groupby: 00:10:00 •Pandas Essentials - Useful Methods and Operations: 00:26:00 •Pandas Essentials - Project 1 (Overview) Customer Purchases Data: 00:08:00 •Pandas Essentials - Project 1 (Solutions) Customer Purchases Data: 00:31:00 •Pandas Essentials - Project 2 (Overview) Chicago Payroll Data: 00:04:00 •Pandas Essentials - Project 2 (Solutions Part 1) Chicago Payroll Data: 00:18:00 •Matplotlib Essentials (Part 1) - Basic Plotting & Object Oriented Approach: 00:13:00 •Matplotlib Essentials (Part 2) - Basic Plotting & Object Oriented Approach: 00:22:00 •Matplotlib Essentials (Part 3) - Basic Plotting & Object Oriented Approach: 00:22:00 •Matplotlib Essentials - Exercises Overview: 00:06:00 •Matplotlib Essentials - Exercises Solutions: 00:21:00 •Seaborn - Introduction & Installation: 00:04:00 •Seaborn - Distribution Plots: 00:25:00 •Seaborn - Categorical Plots (Part 1): 00:21:00 •Seaborn - Categorical Plots (Part 2): 00:16:00 •Seborn-Axis Grids: 00:25:00 •Seaborn - Matrix Plots: 00:13:00 •Seaborn - Regression Plots: 00:11:00 •Seaborn - Controlling Figure Aesthetics: 00:10:00 •Seaborn - Exercises Overview: 00:04:00 •Seaborn - Exercise Solutions: 00:19:00 •Pandas Built-in Data Visualization: 00:34:00 •Pandas Data Visualization Exercises Overview: 00:03:00 •Panda Data Visualization Exercises Solutions: 00:13:00 •Plotly & Cufflinks - Interactive & Geographical Plotting (Part 1): 00:19:00 •Plotly & Cufflinks - Interactive & Geographical Plotting (Part 2): 00:14:00 •Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Overview): 00:11:00 •Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Solutions): 00:17:00 •Project 1 - Oil vs Banks Stock Price during recession (Overview): 00:15:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 1): 00:18:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 2): 00:18:00 •Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 3): 00:17:00 •Project 2 (Optional) - Emergency Calls from Montgomery County, PA (Overview): 00:03:00 •Introduction to ML - What, Why and Types..: 00:15:00 •Theory Lecture on Linear Regression Model, No Free Lunch, Bias Variance Tradeoff: 00:15:00 •scikit-learn - Linear Regression Model - Hands-on (Part 1): 00:17:00 •scikit-learn - Linear Regression Model Hands-on (Part 2): 00:19:00 •Good to know! How to save and load your trained Machine Learning Model!: 00:01:00 •scikit-learn - Linear Regression Model (Insurance Data Project Overview): 00:08:00 •scikit-learn - Linear Regression Model (Insurance Data Project Solutions): 00:30:00 •Theory: Logistic Regression, conf. mat., TP, TN, Accuracy, Specificityetc.: 00:10:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 1): 00:17:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 2): 00:20:00 •scikit-learn - Logistic Regression Model - Hands-on (Part 3): 00:11:00 •scikit-learn - Logistic Regression Model - Hands-on (Project Overview): 00:05:00 •scikit-learn - Logistic Regression Model - Hands-on (Project Solutions): 00:15:00 •Theory: K Nearest Neighbors, Curse of dimensionality .: 00:08:00 •scikit-learn - K Nearest Neighbors - Hands-on: 00:25:00 •scikt-learn - K Nearest Neighbors (Project Overview): 00:04:00 •scikit-learn - K Nearest Neighbors (Project Solutions): 00:14:00 •Theory: D-Tree & Random Forests, splitting, Entropy, IG, Bootstrap, Bagging.: 00:18:00 •scikit-learn - Decision Tree and Random Forests - Hands-on (Part 1): 00:19:00 •scikit-learn - Decision Tree and Random Forests (Project Overview): 00:05:00 •scikit-learn - Decision Tree and Random Forests (Project Solutions): 00:15:00 •Support Vector Machines (SVMs) - (Theory Lecture): 00:07:00 •scikit-learn - Support Vector Machines - Hands-on (SVMs): 00:30:00 •scikit-learn - Support Vector Machines (Project 1 Overview): 00:07:00 •scikit-learn - Support Vector Machines (Project 1 Solutions): 00:20:00 •scikit-learn - Support Vector Machines (Optional Project 2 - Overview): 00:02:00 •Theory: K Means Clustering, Elbow method.: 00:11:00 •scikit-learn - K Means Clustering - Hands-on: 00:23:00 •scikit-learn - K Means Clustering (Project Overview): 00:07:00 •scikit-learn - K Means Clustering (Project Solutions): 00:22:00 •Theory: Principal Component Analysis (PCA): 00:09:00 •scikit-learn - Principal Component Analysis (PCA) - Hands-on: 00:22:00 •scikit-learn - Principal Component Analysis (PCA) - (Project Overview): 00:02:00 •scikit-learn - Principal Component Analysis (PCA) - (Project Solutions): 00:17:00 •Theory: Recommender Systems their Types and Importance: 00:06:00 •Python for Recommender Systems - Hands-on (Part 1): 00:18:00 •Python for Recommender Systems - - Hands-on (Part 2): 00:19:00 •Natural Language Processing (NLP) - (Theory Lecture): 00:13:00 •NLTK - NLP-Challenges, Data Sources, Data Processing ..: 00:13:00 •NLTK - Feature Engineering and Text Preprocessing in Natural Language Processing: 00:19:00 •NLTK - NLP - Tokenization, Text Normalization, Vectorization, BoW.: 00:19:00 •NLTK - BoW, TF-IDF, Machine Learning, Training & Evaluation, Naive Bayes : 00:13:00 •NLTK - NLP - Pipeline feature to assemble several steps for cross-validation: 00:09:00

Duration 4 Days 24 CPD hours This course is intended for This class is intended for experienced developers who are responsible for managing big data transformations including: Extracting, loading, transforming, cleaning, and validating data. Designing pipelines and architectures for data processing. Creating and maintaining machine learning and statistical models. Querying datasets, visualizing query results and creating reports Overview Design and build data processing systems on Google Cloud Platform. Leverage unstructured data using Spark and ML APIs on Cloud Dataproc. Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow. Derive business insights from extremely large datasets using Google BigQuery. Train, evaluate and predict using machine learning models using TensorFlow and Cloud ML. Enable instant insights from streaming data Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hand-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data. Introduction to Data Engineering Explore the role of a data engineer. Analyze data engineering challenges. Intro to BigQuery. Data Lakes and Data Warehouses. Demo: Federated Queries with BigQuery. Transactional Databases vs Data Warehouses. Website Demo: Finding PII in your dataset with DLP API. Partner effectively with other data teams. Manage data access and governance. Build production-ready pipelines. Review GCP customer case study. Lab: Analyzing Data with BigQuery. Building a Data Lake Introduction to Data Lakes. Data Storage and ETL options on GCP. Building a Data Lake using Cloud Storage. Optional Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions. Securing Cloud Storage. Storing All Sorts of Data Types. Video Demo: Running federated queries on Parquet and ORC files in BigQuery. Cloud SQL as a relational Data Lake. Lab: Loading Taxi Data into Cloud SQL. Building a Data Warehouse The modern data warehouse. Intro to BigQuery. Demo: Query TB+ of data in seconds. Getting Started. Loading Data. Video Demo: Querying Cloud SQL from BigQuery. Lab: Loading Data into BigQuery. Exploring Schemas. Demo: Exploring BigQuery Public Datasets with SQL using INFORMATION_SCHEMA. Schema Design. Nested and Repeated Fields. Demo: Nested and repeated fields in BigQuery. Lab: Working with JSON and Array data in BigQuery. Optimizing with Partitioning and Clustering. Demo: Partitioned and Clustered Tables in BigQuery. Preview: Transforming Batch and Streaming Data. Introduction to Building Batch Data Pipelines EL, ELT, ETL. Quality considerations. How to carry out operations in BigQuery. Demo: ELT to improve data quality in BigQuery. Shortcomings. ETL to solve data quality issues. Executing Spark on Cloud Dataproc The Hadoop ecosystem. Running Hadoop on Cloud Dataproc. GCS instead of HDFS. Optimizing Dataproc. Lab: Running Apache Spark jobs on Cloud Dataproc. Serverless Data Processing with Cloud Dataflow Cloud Dataflow. Why customers value Dataflow. Dataflow Pipelines. Lab: A Simple Dataflow Pipeline (Python/Java). Lab: MapReduce in Dataflow (Python/Java). Lab: Side Inputs (Python/Java). Dataflow Templates. Dataflow SQL. Manage Data Pipelines with Cloud Data Fusion and Cloud Composer Building Batch Data Pipelines visually with Cloud Data Fusion. Components. UI Overview. Building a Pipeline. Exploring Data using Wrangler. Lab: Building and executing a pipeline graph in Cloud Data Fusion. Orchestrating work between GCP services with Cloud Composer. Apache Airflow Environment. DAGs and Operators. Workflow Scheduling. Optional Long Demo: Event-triggered Loading of data with Cloud Composer, Cloud Functions, Cloud Storage, and BigQuery. Monitoring and Logging. Lab: An Introduction to Cloud Composer. Introduction to Processing Streaming Data Processing Streaming Data. Serverless Messaging with Cloud Pub/Sub Cloud Pub/Sub. Lab: Publish Streaming Data into Pub/Sub. Cloud Dataflow Streaming Features Cloud Dataflow Streaming Features. Lab: Streaming Data Pipelines. High-Throughput BigQuery and Bigtable Streaming Features BigQuery Streaming Features. Lab: Streaming Analytics and Dashboards. Cloud Bigtable. Lab: Streaming Data Pipelines into Bigtable. Advanced BigQuery Functionality and Performance Analytic Window Functions. Using With Clauses. GIS Functions. Demo: Mapping Fastest Growing Zip Codes with BigQuery GeoViz. Performance Considerations. Lab: Optimizing your BigQuery Queries for Performance. Optional Lab: Creating Date-Partitioned Tables in BigQuery. Introduction to Analytics and AI What is AI?. From Ad-hoc Data Analysis to Data Driven Decisions. Options for ML models on GCP. Prebuilt ML model APIs for Unstructured Data Unstructured Data is Hard. ML APIs for Enriching Data. Lab: Using the Natural Language API to Classify Unstructured Text. Big Data Analytics with Cloud AI Platform Notebooks What's a Notebook. BigQuery Magic and Ties to Pandas. Lab: BigQuery in Jupyter Labs on AI Platform. Production ML Pipelines with Kubeflow Ways to do ML on GCP. Kubeflow. AI Hub. Lab: Running AI models on Kubeflow. Custom Model building with SQL in BigQuery ML BigQuery ML for Quick Model Building. Demo: Train a model with BigQuery ML to predict NYC taxi fares. Supported Models. Lab Option 1: Predict Bike Trip Duration with a Regression Model in BQML. Lab Option 2: Movie Recommendations in BigQuery ML. Custom Model building with Cloud AutoML Why Auto ML? Auto ML Vision. Auto ML NLP. Auto ML Tables.

A beginner's level course that will help you learn data engineering techniques for building metadata-driven frameworks with Azure data engineering tools such as Data Factory, Azure SQL, and others. You need not have any prior experience in Azure Data Factory to take up this course.

Learn essential techniques for successful trading & investing through Technical Analysis Masterclass. Explore key indicators, chart patterns, and strategies to decipher market trends effectively.

Overview Mastering data science skills and expertise can open new doors of opportunities for you in a wide range of fields. Learn the fundamentals and develop a solid grasp of Python data science with the comprehensive Data Science with Python course. This course is designed to assist you in securing a valuable skill set and boosting your career. This course will provide you with quality training on the fundamentals of data analysis with Python. From the step-by-step learning process, you will learn the techniques of setting up the system. Then the course will teach you Python data structure and functions. You will receive detailed lessons on NumPy, Matplotlib, and Pandas. Furthermore, you will develop the skills for Algorithm Evaluation Techniques, visualising datasets and much more. After completing the course you will receive a certificate of achievement. This certificate will help you create an impressive resume. So join today! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? This course Data Science with Python course is ideal for beginners in data science. It will help them develop a solid grasp of Python and help them pursue their dream career in the field of data science. Requirements The students will not require any formal qualifications or previous experience to enrol in this course. Anyone can learn from the course anytime from anywhere through smart devices like laptops, tabs, PC, and smartphones with stable internet connections. They can complete the course according to their preferable pace so, there is no need to rush. Career Path This course will equip you with valuable knowledge and effective skills in this area. After completing the course, you will be able to explore career opportunities in the fields such as Data Analyst Data Scientist Data Manager Business Analyst And much more! Course Curriculum 90 sections • 90 lectures • 10:19:00 total length •Course Overview & Table of Contents: 00:09:00 •Introduction to Machine Learning - Part 1 - Concepts , Definitions and Types: 00:05:00 •Introduction to Machine Learning - Part 2 - Classifications and Applications: 00:06:00 •System and Environment preparation - Part 1: 00:04:00 •System and Environment preparation - Part 2: 00:06:00 •Learn Basics of python - Assignment 1: 00:10:00 •Learn Basics of python - Assignment 2: 00:09:00 •Learn Basics of python - Functions: 00:04:00 •Learn Basics of python - Data Structures: 00:12:00 •Learn Basics of NumPy - NumPy Array: 00:06:00 •Learn Basics of NumPy - NumPy Data: 00:08:00 •Learn Basics of NumPy - NumPy Arithmetic: 00:04:00 •Learn Basics of Matplotlib: 00:07:00 •Learn Basics of Pandas - Part 1: 00:06:00 •Learn Basics of Pandas - Part 2: 00:07:00 •Understanding the CSV data file: 00:09:00 •Load and Read CSV data file using Python Standard Library: 00:09:00 •Load and Read CSV data file using NumPy: 00:04:00 •Load and Read CSV data file using Pandas: 00:05:00 •Dataset Summary - Peek, Dimensions and Data Types: 00:09:00 •Dataset Summary - Class Distribution and Data Summary: 00:09:00 •Dataset Summary - Explaining Correlation: 00:11:00 •Dataset Summary - Explaining Skewness - Gaussian and Normal Curve: 00:07:00 •Dataset Visualization - Using Histograms: 00:07:00 •Dataset Visualization - Using Density Plots: 00:06:00 •Dataset Visualization - Box and Whisker Plots: 00:05:00 •Multivariate Dataset Visualization - Correlation Plots: 00:08:00 •Multivariate Dataset Visualization - Scatter Plots: 00:05:00 •Data Preparation (Pre-Processing) - Introduction: 00:09:00 •Data Preparation - Re-scaling Data - Part 1: 00:09:00 •Data Preparation - Re-scaling Data - Part 2: 00:09:00 •Data Preparation - Standardizing Data - Part 1: 00:07:00 •Data Preparation - Standardizing Data - Part 2: 00:04:00 •Data Preparation - Normalizing Data: 00:08:00 •Data Preparation - Binarizing Data: 00:06:00 •Feature Selection - Introduction: 00:07:00 •Feature Selection - Uni-variate Part 1 - Chi-Squared Test: 00:09:00 •Feature Selection - Uni-variate Part 2 - Chi-Squared Test: 00:10:00 •Feature Selection - Recursive Feature Elimination: 00:11:00 •Feature Selection - Principal Component Analysis (PCA): 00:09:00 •Feature Selection - Feature Importance: 00:06:00 •Refresher Session - The Mechanism of Re-sampling, Training and Testing: 00:12:00 •Algorithm Evaluation Techniques - Introduction: 00:07:00 •Algorithm Evaluation Techniques - Train and Test Set: 00:11:00 •Algorithm Evaluation Techniques - K-Fold Cross Validation: 00:09:00 •Algorithm Evaluation Techniques - Leave One Out Cross Validation: 00:05:00 •Algorithm Evaluation Techniques - Repeated Random Test-Train Splits: 00:07:00 •Algorithm Evaluation Metrics - Introduction: 00:09:00 •Algorithm Evaluation Metrics - Classification Accuracy: 00:08:00 •Algorithm Evaluation Metrics - Log Loss: 00:03:00 •Algorithm Evaluation Metrics - Area Under ROC Curve: 00:06:00 •Algorithm Evaluation Metrics - Confusion Matrix: 00:10:00 •Algorithm Evaluation Metrics - Classification Report: 00:04:00 •Algorithm Evaluation Metrics - Mean Absolute Error - Dataset Introduction: 00:06:00 •Algorithm Evaluation Metrics - Mean Absolute Error: 00:07:00 •Algorithm Evaluation Metrics - Mean Square Error: 00:03:00 •Algorithm Evaluation Metrics - R Squared: 00:04:00 •Classification Algorithm Spot Check - Logistic Regression: 00:12:00 •Classification Algorithm Spot Check - Linear Discriminant Analysis: 00:04:00 •Classification Algorithm Spot Check - K-Nearest Neighbors: 00:05:00 •Classification Algorithm Spot Check - Naive Bayes: 00:04:00 •Classification Algorithm Spot Check - CART: 00:04:00 •Classification Algorithm Spot Check - Support Vector Machines: 00:05:00 •Regression Algorithm Spot Check - Linear Regression: 00:08:00 •Regression Algorithm Spot Check - Ridge Regression: 00:03:00 •Regression Algorithm Spot Check - Lasso Linear Regression: 00:03:00 •Regression Algorithm Spot Check - Elastic Net Regression: 00:02:00 •Regression Algorithm Spot Check - K-Nearest Neighbors: 00:06:00 •Regression Algorithm Spot Check - CART: 00:04:00 •Regression Algorithm Spot Check - Support Vector Machines (SVM): 00:04:00 •Compare Algorithms - Part 1 : Choosing the best Machine Learning Model: 00:09:00 •Compare Algorithms - Part 2 : Choosing the best Machine Learning Model: 00:05:00 •Pipelines : Data Preparation and Data Modelling: 00:11:00 •Pipelines : Feature Selection and Data Modelling: 00:10:00 •Performance Improvement: Ensembles - Voting: 00:07:00 •Performance Improvement: Ensembles - Bagging: 00:08:00 •Performance Improvement: Ensembles - Boosting: 00:05:00 •Performance Improvement: Parameter Tuning using Grid Search: 00:08:00 •Performance Improvement: Parameter Tuning using Random Search: 00:06:00 •Export, Save and Load Machine Learning Models : Pickle: 00:10:00 •Export, Save and Load Machine Learning Models : Joblib: 00:06:00 •Finalizing a Model - Introduction and Steps: 00:07:00 •Finalizing a Classification Model - The Pima Indian Diabetes Dataset: 00:07:00 •Quick Session: Imbalanced Data Set - Issue Overview and Steps: 00:09:00 •Iris Dataset : Finalizing Multi-Class Dataset: 00:09:00 •Finalizing a Regression Model - The Boston Housing Price Dataset: 00:08:00 •Real-time Predictions: Using the Pima Indian Diabetes Classification Model: 00:07:00 •Real-time Predictions: Using Iris Flowers Multi-Class Classification Dataset: 00:03:00 •Real-time Predictions: Using the Boston Housing Regression Model: 00:08:00 •Resources - Data Science & Machine Learning with Python: 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Python Programming: Beginner To Expert Overview Unfold the potential within you, and embark on a journey of mastering Python programming - from the fundamental building blocks to the pinnacle of expertise. This comprehensive course, crafted with meticulous care, empowers you to transform from a curious novice to a confident coding maestro, wielding Python's power with finesse. Within these engaging modules, you'll delve into the core principles of Python, meticulously exploring data types, operators, control flow, and functions. As your proficiency blossoms, you'll conquer advanced topics like object-oriented programming, powerful libraries like NumPy and Pandas, and the art of crafting polished scripts. But this journey isn't merely about acquiring technical prowess; it's about unlocking a world of possibilities. By the course's end, you'll be equipped to embark on a rewarding career path, armed with the skills to tackle real-world challenges in diverse domains - from data analysis and web development to scientific computing and automation. Learning Outcomes Gain a solid foundation in Python syntax, data structures, and control flow mechanisms. Master essential functions, user input, and error-handling techniques. Explore advanced data types, object-oriented programming concepts, and popular libraries like NumPy and Pandas. Craft polished, reusable Python scripts for various applications. Confidently navigate the Python ecosystem and continuously expand your knowledge. Why You Should Choose Python Programming: Beginner To Expert Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Python Programming: Beginner To Expert is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Python Programming: Beginner To Expert is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Python Programming: Beginner To Expert Module 01: Introduction to Python Programming from A-Z Intro To Python Section Overview 00:06:00 What is Python Programming? 00:10:00 Who is This Course For? 00:05:00 Python Programming Marketplace 00:06:00 Python Job Opportunities 00:05:00 How To Land a Python Job Without a Degree 00:08:00 Python Programmer Job Roles 00:09:00 Python from A-Z Course Structure 00:04:00 Module 02: Getting Familiar with Python Getting Familiar with Python Section Overview 00:06:00 Installing Python on Windows 00:10:00 Anaconda and Jupyter Notebooks Part 1 00:08:00 Anaconda and Jupyter Notebooks Part 2 00:16:00 Comments 00:05:00 Python Syntax 00:02:00 Line Structure 00:03:00 Line Structure Exercise 00:07:00 Joining Lines 00:05:00 Multiple Statements on a Single Line 00:05:00 Indentation 00:08:00 Module 03: Basic Data Types Basic Data Types Section Overview 00:08:00 String Overview 00:10:00 String Manipulation 00:07:00 String Indexing 00:04:00 String Slicing 00:08:00 Printing 00:10:00 Python Variables 00:08:00 Integers and Floats 00:08:00 Booleans 00:02:00 Mini Project 1 : Letter Counter 00:20:00 Module 04: Python Operators Python Operators Section Overview 00:04:00 Comparison Operators 00:09:00 Arithmetic Operators 00:08:00 Assignment Operators 00:05:00 Logical Operators 00:13:00 Identity Operators 00:05:00 Membership Operators 00:02:00 Bitwise Operators 00:08:00 Module 05: Advanced Data Types Python Advanced Data Types Section Overview 00:11:00 Sets 00:06:00 List Overview 00:05:00 List Slicing and Indexing 00:04:00 Tuples 00:02:00 Dictionaries 00:11:00 When to use each one? 00:05:00 Compound Data Types 00:03:00 Module 06: Control Flow Part 1 Control Flow Part 1 Section Overview 00:15:00 Intro to Control Flow 00:01:00 Basic Conditional Statements 00:14:00 More Conditional Statements 00:05:00 For Loops 00:10:00 While Loops 00:12:00 Module 07: Control Flow Part 2 Control Flow Part 2 Section Overview 00:02:00 Break Statements 00:08:00 Continue Statements 00:05:00 Zip Function 00:07:00 Enumerate Function 00:04:00 List Comprehension 00:04:00 Module 08: Python Functions Python Functions Section Overview 00:03:00 Intro to Functions 00:02:00 Python help Function 00:03:00 Defining Functions 00:09:00 Variable Scope 00:08:00 Doc Strings 00:04:00 Module 09: User Input and Error Handling User Input and Error Handling Section Overview 00:02:00 Introduction to error handling 00:03:00 User Input 00:04:00 Syntax Errors 00:04:00 Exceptions 00:11:00 Handling Exceptions Part 1 00:08:00 Handling Exceptions Part 2 00:08:00 Module 10: Python Advanced Functions Python Advanced Functions Section Overview 00:05:00 Lambda Functions 00:05:00 Functions args and kwargs 00:10:00 Iterators 00:08:00 Generators and Yield 00:12:00 Map Function 00:14:00 Filter Function 00:08:00 Module 11: Python Scripting and Libraries Python Scripting and Libraries Section Overview 00:05:00 What is a script? 00:01:00 What is an IDE? 00:17:00 What is a text editor? 00:12:00 From Jupyter Notebook to VScode Part 1 00:15:00 From Jupyter Notebook to VScode Part 2 00:05:00 Importing Scripts 00:03:00 Standard Libraries 00:04:00 Third Party Libraries 00:06:00 Module 12: NumPy NumPy Section Overview 00:04:00 Why use NumPy? 00:04:00 NumPy Arrays 00:10:00 Reshaping, Accessing, and Modifying 00:07:00 Slicing and Copying 00:06:00 Inserting, Appending, and Deleting 00:10:00 Array Logical Indexing 00:04:00 Broadcasting 00:08:00 Module 13: Pandas Intro to Pandas 00:17:00 Pandas Series 00:17:00 Pandas Series Manipulation 00:17:00 Pandas DataFrame 00:17:00 Pandas DataFrame Manipulation 00:13:00 Dealing with Missing Values 00:10:00 Module 14: Introduction to OOP Functional vs OOP 00:06:00 OOP Key Definitions 00:04:00 Create your First Class 00:12:00 How to Create and Use Objects 00:06:00 How to Modify Attributes 00:12:00 Module 15: Advanced OOP Python Decorators 00:27:00 Property Decorator 00:09:00 Class Method Decorator 00:07:00 Static Methods 00:10:00 Inheritance from A to Z 00:21:00 Module 16: Starting a Career in Python Getting Started with Freelancing 00:09:00 Building A Brand 00:12:00 Personal Branding 00:13:00 Importance of Having Website/Blog 00:04:00 Do's and Don'ts of Networking 00:06:00 Creating A Python Developer Resume 00:06:00