The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert

The Ultimate MySQL Bootcamp Go from SQL Beginner to Expert
English | Size: 2.98 GB
Category: CBTS


No Database, SQL, or MySQL experience needed! Complete beginners to MySQL are welcome.
All you need is a working computer for this course; PC, Mac, and Linux users are all welcome.
No previous programming language experience required, but it won’t hurt Smiliey
Description
If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today. [Read more…]

Packt – Learning Python Data Analysis

Packt – Learning Python Data Analysis
English | Size: 1.32 GB
Category: Programming | E-learning | others


Python features numerous numerical and mathematical toolkits such as: Numpy, Scipy, Scikit learn and SciKit, all used for data analysis and machine learning. With the aid of all of these, Python has become the language of choice for data scientists for data analysis, visualization, and machine learning.
This video aims to teach Python developers how to perform data analysis with the language by taking advantage of the core data science libraries in the Python ecosystem. The learning objective for viewers is to understand how to locate, manipulate, and analyse data with Python, with the ability to analyse large and small sets of data using libraries such as Numpy, pandas, IPython and SciPy. [Read more…]

OReilly – Oracle SQL and JSON

OReilly – Oracle SQL and JSON
English | Size: 922.49 MB
Category: CBTs


Introduced as part of Oracle 12, Oracle JSON SQL makes it possible to convert the JSON data world of keys and values into the relational data world of columns and rows. At its core, this course teaches you how to use Oracle JSON SQL.
You’ll learn the key JSON SQL functions that tell you: If the JSON data is valid, if a particular element and/or value exists in the JSON data, how to extract a specific scalar value from JSON data, and how to translate JSON keys and values into relational rows and columns. But this is more than a how-to-use JSON SQL course, it’s a refresher course for those who need a solid understanding of the distinctions between the relational data world and the JSON data world, and how SQL can act as a bridge between the two. [Read more…]

Murach’s SQL Server 2016 for Developers

Murach’s SQL Server 2016 for Developers
English | Size: 104.60 MB
Category: CBTs


If you’re an application developer, or you’re training to be one, this 2016 edition of Murach’s classic SQL Server book is made for you.
To start, it presents the SQL statements that you need to retrieve and update the data in a database. These are the SQL statements that you’ll use every day. Then, it shows you how to design a database, how to implement that design, and how to work with database features like views, scripts, stored procedures, functions, triggers, transactions, security, XML data, BLOB data with FILESTREAM storage, and the CLR integration feature.
[Read more…]

LiveLessons – Data Science Fundamentals Part 1: Learning Basic Concepts, Data Wrangling, and Databases with Python

LiveLessons – Data Science Fundamentals Part 1: Learning Basic Concepts, Data Wrangling, and Databases with Python
English | Size: 2.03 GB
Category: CBTs


The Rough Cuts/Sneak Peek program provides early access to Pearson video products and is exclusively available to Safari subscribers. Content for titles in this program is made available throughout the development cycle, so products may not be complete, edited, or finalized, including video post-production editing. [Read more…]

Linux Academy – Big Data Essentials Tutorial

Linux Academy – Big Data Essentials Tutorial
English | Size: 1.27 GB
Category: CBTs


Big Data Essentials is a comprehensive introduction to the world of Big Data. Starting with the definition of Big Data, we describe the various characteristics of Big Data and its sources. Using real world examples, we highlight the growing importance of Big Data. We discuss architectural requirements and principles of Big Data infrastructures and the intersection of cloud computing with Big Data.
[Read more…]

Pluralsight – Understanding and Applying Numerical Optimization Techniques

Pluralsight – Understanding and Applying Numerical Optimization Techniques
English | Size: 491.90 MB
Category: CBTs


Optimization is all about smart trade-offs given difficult choices. This course focuses on three specific aspects of numerical optimization: correctly setting up optimization problems, linear programming, and integer programming.

Many optimization problems are conceptually similar to software design patterns – they are generally usable techniques that help with commonly recurring problems. In this course, Understanding and Applying Numerical Optimization Techniques, you’ll first learn about framing the optimization problem correctly.
[Read more…]

Pluralsight – PCI DSS – The Big Picture

Pluralsight – PCI DSS – The Big Picture
English | Size: 149.79 MB
Category: CBTs


The Payment Card Industry (PCI) Data Security Standard (DSS) affects every organization that stores, processes, or transmits credit or debit cards. In this course, you’ll learn about the standard and how it is used in card scheme compliance programs.
In an organization that touches payment cards, the information security agenda includes compliance with the Payment Card Industry (PCI) Data Security Standard (DSS). In this course, PCI DSS – The Big Picture, you’ll learn the basic requirements of PCI DSS, the language it uses, and how the standard is structured.
[Read more…]

Packt Publishing – Getting Started with SQL Server 2016 Administration

Packt Publishing – Getting Started with SQL Server 2016 Administration
English | Size: 936.18 MB
Category: CBTs


Configure, administer, and deploy a high-performance, highly available SQL Server.
SQL Server DBAs enable efficient administration of its SQL Server solution to get breakthrough performance and top-notch security. This video will teach you basic as well as advanced administration tasks for handling, managing, and monitoring your SQL Server 2016 efficiently. After setting up and configuring your virtual machine for SQL Server 2016, you will implement various techniques to improve query performance, create indexes, and perform activity monitoring. You will learn how to secure your SQL Server solution by implementing various authentication techniques. Finally, you’ll ensure your database is always available and ready for any catastrophe. [Read more…]

O’Reilly – Learning Path – Delivering Applications with Docker

O’Reilly – Learning Path – Delivering Applications with Docker
English | Size: 2.02 GB
Category: CBTs


Roll up your sleeves and get ready to put Docker to work. In this practical, hands-on Learning Path, you’ll learn how to use Docker to build apps quickly and run them anywhere-no prior container experience necessary. By the end of this course, you’ll have mastered the fundamentals of Docker and moved ahead to more advanced concepts.
[Read more…]