XQZT

Packt – Hands-On Microsoft Access 2019

Packt – Hands-On Microsoft Access 2019-XQZT
English | Size: 1.48 GB
Category: Tutorial

Microsoft Access 2019 is an information management tool that stores information and, arguably, helps manage data more efficiently than other spreadsheet apps. It is an ideal and particularly useful tool for small-to-medium-sized (SME) businesses. This will be a practical, beginner-level course with hands-on, real-world examples you can use as models for your own activities Beginning with a quick introduction to an example Access database, you will cover the core concepts, interface, and terminology you need to get started. You will then master the key components of data query management; forms to help you view, add edit, and even delete data in a controlled environment. Then, you will publish your data with the help of built-in reporting, and move on to work with RDBMS concepts relating to joins and why they re important. You ll find out how to automate your Access database by creating and applying macros and learn about VBA programming and how it s used with Access. By the end of the course, you will be confident in your new skills in Microsoft Access 2019 to improve productivity, and data visualization.

Packt – Understanding Regression Techniques

Packt – Understanding Regression Techniques-XQZT
English | Size: 3.12 GB
Category: Tutorial

Linear and logistic regressions are among the first set of algorithms you ll study to get started on your journey in data science. This course explores three basic regressions linear, logistic, and count model. Starting with linear regressions, you ll first understand the difference between simple and multiple linear regressions and explore different types of variables, including binary categorical, and quadratic. Once you ve got to grips with the fundamentals, you ll apply what you ve learned to solve a case study. As you advance, you ll explore logistic regression models and cover variables, non-linearity tests, prediction, and model fit. Finally, you ll get well-versed with count model regression. By the end of the course, you ll be equipped with the knowledge you need to investigate correlations between multiple variables using regression models.

Linkedin Learning – Advanced SQL Logical Query Processing

Linkedin Learning – Advanced SQL Logical Query Processing-XQZT
English | Size: 283.57 MB
Category: Tutorial

SQL has been the dominant data processing language for the past five decades. This course takes you beyond the syntax fundamentals, and into a new world of understanding how relational database management systems process SQL queries, and how that impacts your coding practices. Learn about logical query processing, and avoid most common pitfalls and processing limitations. Discover advanced JOIN techniques and how to deal with missing data. Understand the subtleties of ternary logic SELECT expression evaluation, grouping logic, and how to implement efficient paging and ordering. By the end of the course, you ll be able to take advantage of the nuances of logical query processing to easily troubleshoot and solve daunting SQL challenges elegantly

Linkedin Learning – Programming Foundations Beyond the Fundamentals

Linkedin Learning – Programming Foundations Beyond the Fundamentals-XQZT
English | Size: 959.92 MB
Category: CBTs

Continue your coding journey as you dive deeper into the foundational concepts, practices, and terminology of programming. In this installment of the Programming Foundations series, instructor Sasha Vodnik goes beyond the basics, using Python to tackle a variety of intermediate and advanced concepts and skills you can add to your programming repertoire. Sasha covers creating and working with collections and loops, combining and manipulating strings, and using external code-all of which are critical concepts, regardless of which programming language you end up working with. He goes over several essential processes, such as choosing a code style and debugging. Plus, he digs into a few more advanced concepts, including memory management and multithreading.

Packt – An Introduction to Stata

Packt – An Introduction to Stata-XQZT
English | Size: 2.02 GB
Category: Tutorial

If you re looking to get started with Stata and manage your data effectively, then this course will help you develop your knowledge.
The course is designed to get you up and running with the basic functionality of Stata and how it can be used to analyze large datasets. You ll even get hands-on experience as you work through two projects. All along, the course follows a step-by-step approach to help you understand the different commands. Although Stata comes with many datasets, this course features the instructor s own datasets to demonstrate the thought process involved in collecting data.