Relational Database Design by Hugo Kornelis

Relational Database Design by Hugo Kornelis
English | Size: 904.24 MB
Category: CBTs


In this course, you will learn all the skills required to design good databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the information gathered into a data model, how to normalize the data model so that your database will be free of anomalies, and how to transform the final, normalized data model into a relational database design – ready to be implemented. [Read more…]

Lynda – Designing Database Solutions for SQL Server 2016

Lynda – Designing Database Solutions for SQL Server 2016
English | Size: 383.89 MB
Category: Tutorial


When you’re working with a team to design a SQL Server 2016 database solution for your organization, there are certain advanced concepts you need to know. In this course, Adam Wilbert introduces you to some of the concepts you’ll need to design elegant database solutions that set up your team for success. He covers how to prepare the server for efficient usage, use backup strategies to minimize the impact of a failure, and follow security concepts to ensure users are granted the appropriate permissions for their roles. Plus, Adam covers some of the optimization strategies you can implement in SQL Server to help the system run smoothly in the future. [Read more…]

Udemy – SQL Database MasterClass – Go From Pupil To Master

Udemy – SQL Database MasterClass – Go From Pupil To Master
English | Size: 705.03 MB
Category: Tutorial


Course Description
Do you want to SKY ROCKET your Income?
Do you want to master the skill of SQL.
Do you have an Interview coming up where you know SQL would look amazing on your resume?
Low pay SQL developers make $60,000 per year. In this course you will learn the skills necessary to rock out SQL Statements, Views, Stored Procedures and more. [Read more…]

Pluralsight – Getting Started with HBase The Hadoop Database

Pluralsight – Getting Started with HBase The Hadoop Database
English | Size: 412.45 MB
Category: Tutoria


As the data you store expands in size, traditional relational databases may no longer work. HBase has the ability to deal with billions of rows of data and each record can contains millions of fields. This course will help you get started with HBase.
Billions of records with millions of fields of semi-structured, unformatted data is the reality of the kind of data we are storing today.
[Read more…]

Pluralsight – Azure SQL Database for the SQL Server DBA

Pluralsight – Azure SQL Database for the SQL Server DBA
English | Size: 428.59 MB
Category: Tutorial


Azure SQL Database is Microsoft’s Database as a Service in the cloud. This course, Azure SQL Database for the SQL Server DBA, will show you some of the similarities to SQL Server but also why experienced DBAs will still need to learn some of the key differences. You will get to see the differences in management, high availability, performance, and monitoring of this cloud-first solution. [Read more…]

CBT Nuggets – MySQL 5.0 Database Administrator 1 (Exam 005-002)

CBT Nuggets – MySQL 5.0 Database Administrator 1 (Exam 005-002)
English | Size: 925.10 MB
Category: CBTs


In addition to prepping you for the first of two MySQL Certified Dabase Administrator (CMDBA) exam certification exams, Tim Warner packs this course with real-world practical examples and industry advice that you can apply immediately in your MySQL, Oracle, PostgreSQL or Microsoft SQL Server environments. [Read more…]

O’Reilly – Database Fundamentals for Java Programmers

O’Reilly – Database Fundamentals for Java Programmers
English | Size: 2.35 GB
Category:Java


Database programming and design are core competencies expected of every Java programmer. This code-oriented course moves you toward competency by providing a detailed overview of how to program for the two most common types of database systems used today: The traditional relational RDBMS systems (e.g. Oracle, SQL Server, and PostgreSQL) and the now popular non-relational NoSQL systems (e.g. Mongo DB and Apache Cassandra). [Read more…]

Udemy SQL Database MasterClass – Go From Pupil To Master!

Udemy SQL Database MasterClass – Go From Pupil To Master!
English | Size: 705.03 MB
Category: CBTs


This is a SQL MasterClass that gets you immediate hands on experience with a database. From design to Mastery Class!
Do you want to SKY ROCKET your Income?
Do you want to master the skill of SQL.
Do you have an Interview coming up where you know SQL would look amazing on your resume?
Low pay SQL developers make $60,000 per year. In this course you will learn the skills necessary to rock out SQL Statements, Views, Stored Procedures and more. [Read more…]

CBT Nuggets – Database Fundamentals

CBT Nuggets – Database Fundamentals

English | Size: 1.64 GB (1,764,697,564 Bytes)
Category: CBTs


Databases and the data they contain are crucial to every business and application out there today, which is why IT professionals with data-oriented skills are in constant demand! Whether you’re looking to pick up basic SQL skills for data analysis or begin your journey to becoming a full-blown database engineer, this course is the starting line as it assumes no prior database or query experience, and will prepare you to delve deeper into the world of database platforms and certifications. [Read more…]

Microsoft Database PRO SQL Server 2008 Admin 70-450

Microsoft Database PRO SQL Server 2008 Admin 70-450

English | Size: 532.29 MB (558,142,493 Bytes)
Category: CBTs


SQL Server 2008 for Beginner

20 Lessons

1. Introduction and Overview (4 min)
2. SQL Server 2008 Functional Concepts and Architecture (32 min)
3. SQL Server 2008 Physical Concepts and Architecture (25 min)
4. Planning a SQL Server 2008 Installation (28 min)
5. Installing SQL Server 2008 (18 min) [Read more…]