LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Linkedin Learning – Learning Oracle Database 19c

Leave a Comment

Linkedin Learning – Learning Oracle Database 19c-ZH
English | Size: 225.03 MB
Category: Tutorial


Get up and running with Oracle Database 19c, the latest version of the popular relational database management system (RDBMS), and learn how it can help enhance your database design and deployment process. Throughout this course, instructor Bob Bryla covers the fundamentals of administering Oracle Database 19c. Discover how to install the RDBMS on Linux, manage the database and query tables using the SQLcl command-line tool, and efficiently move data in and out of your database tables using SELECT and DML statements, respectively. Plus, learn how to create, assign, and drop tablespaces, as well as how to create and drop user accounts. [Read more…]

Linkedin Learning – MySQL Advanced Topics-ZH

Leave a Comment

Linkedin Learning – MySQL Advanced Topics-ZH
English | Size: 165.48 MB
Category: Tutorial


Get more out to the world’s most popular RDMS. Learn to take full advantage of some of the more advanced features in MySQL, including views, transactions, triggers, and stored procedures. In this course, Bill Weinman helps you take your MySQL skills to the next level. Discover how to facilitate rapid lookups with indexes, search for data in a result set provided by another select statement with subselects, and put database-intensive operations into stored functions and procedures for faster, more modular, and more efficient programming. Plus, learn how to ensure data integrity with transactions and cross-reference distributed data with foreign key constraints. These techniques allow you to create more performant and stable databases for all your development projects, from web applications to data warehouses. [Read more…]

CBTNuggets – Azure SQL Essentials

Leave a Comment

CBTNuggets – Azure SQL Essentials
English | Size: 579.7 MB
Category: Programming | E-learning | others


This Microsoft training course with Knox Hutchinson teaches you the essentials of the Azure SQL data platform. Throughout this course, you’ll learn about the Azure Data Studio, Azure SQL Data Warehouse, Azure Data Factory, Azure analysis services, and more.
[Read more…]

PluralSight – Combining and Filtering Data with MariaDB

Leave a Comment

PluralSight – Combining and Filtering Data with MariaDB-BOOKWARE-KNiSO
English | Size: 350.75 MB
Category: Tutorial


Release Notes: MariaDB is one of the most sophisticated relational databases in the RDBMS world. It is critical that, in the relational database, multiple columns, fields, and tables work together to provide meaningful results for end users. In this course Combining and Filtering Data with MariaDB, you ll gain the ability to work with complex business logic using various SQL and relational database features of MariaDB. First, you’ll learn how to aggregate results with Group By. Next, you ll learn how to manipulate string and numeric column fields, as well as about Common Table Expressions, Union queries, and Join to combine various results into a single resultset [Read more…]

Linkedin, Learning, Querying, Microsoft, SQL, Server, 2019

Leave a Comment

Linkedin Learning – Querying Microsoft SQL Server 2019-XQZT
English | Size: 394.06 MB
Category: Tutorial


Discover how to query data from SQL Server tables. In this course, Adam Wilbert covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language. Learn the fundamental structure of a query and see how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a dataset that’s formatted to meet a wide variety of needs and perspectives. Upon wrapping up this course, you’ll be equipped with the commands and keywords you need to know to effectively analyze your data. [Read more…]

PluralSight – Capturing Logic with Stored Procedures in T-SQL

Leave a Comment

PluralSight – Capturing Logic with Stored Procedures in T-SQL-BOOKWARE-KNiSO
English | Size: 295.38 MB
Category: Tutorial


Do you have experience writing T-SQL but want to start creating stored procedures? Well, this course is for you! Take your skills to the next level by learning all the in and outs of designing and optimizing stored procedures. [Read more…]

Database Systems Design Implementation and Management 12e

Leave a Comment

Database Systems Design Implementation and Management 12e
English | Size: 485.26 MB
Category: Tutorial


Practical and easy to understand, DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, Tenth Edition, gives readers a solid foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading book provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Renowned for its clear, straightforward writing style, the tenth edition has been thoroughly updated to include hot topics such as green computing/sustainability for modern data centers, the role of redundant relationships, and examples of web-database connectivity and code security. In addition, new review questions, problem sets, and cases have been added throughout the book so that readers have multiple opportunities to test their understanding and develop real and useful design skills. [Read more…]

PluralSight – Querying JSON XML and Temporal Data with T SQL

Leave a Comment

PluralSight – Querying JSON XML and Temporal Data with T SQL
English | Size: 419.82 MB
Category: CBTs


The most common scenario with SQL Server is querying structured data. But many do not know that it also allows storing and querying semi-structured data using XML and JSON; as well as obtaining values from any point in time with temporal tables. [Read more…]

PluralSight – Working with Local Data in Xamarin Forms

Leave a Comment

PluralSight – Working with Local Data in Xamarin Forms-BOOKWARE-KNiSO
English | Size: 203.72 MB
Category: Tutorial


At the core of high quality mobile app development with Xamarin.Forms is an understanding of how to store data locally. In this course, you’ll learn about different local data storage options, and how they can improve your app’s performance. [Read more…]

Packt – Build a Realtime App with React Hooks and GraphQL

Leave a Comment

Packt – Build a Realtime App with React Hooks and GraphQL-XQZT
English | Size: 1.22 GB
Category: CBTs


This course teaches you to build real-time, full-stack React apps from scratch with a GraphQL Server (Apollo Server 2) on the backend, a cloud MongoDB database (Mongo Atlas) with React Hooks to manage our state (replacing Redux!), social authentication (Google OAuth2), real-time data with GraphQL Subscriptions, image uploads with Cloudinary, and much more. [Read more…]