Learn Database Design with MySQL

Learn Database Design with MySQL
English | Size: 822.46 MB
Category: CBTs

Database design is one of the most important aspects of web programming. Successful implementation of any system with data storage will always need proper database design. In order to create great database design you will not only have to master database technology but will also have to master database design process and normalization. This course will also teach you SQL and you will be a SQL power user by the end of this course. You will start with a basic introduction to data storage and will follow it up with storage engines and other tools. You will also learn about MySQL installation and database design process. Database design, normalization, structure mapping, keys, and junction tables come next. The next units will teach you SQL and Advance SQL and you will also learn to use PHP with MySQL. This complete database course will help you become a database design guru. [Read more…]

Lynda – Database Clinic: MySQL

Lynda – Database Clinic: MySQL
English | Size: 373.37 MB
Category: Tutorial

The Database Clinic series pits experts and their databases of choice against a series of the same challenges, to highlight the unique capabilities of each database. In this installment of the series, Brad Wheeler demonstrates how MySQL-one of the most widely-used database programs-would rise to meet each task. After going over the strengths and weaknesses of MySQL, Brad shows how to create a database, and quickly load data into MySQL. He also explains how to join data sets; how to search, transform, and perform calculations with your data; and how to use external programming tools to interact with MySQL. [Read more…]

Lynda – Database Clinic – SQLite

Lynda – Database Clinic – SQLite
English | Size: 395.62 MB
Category: Tutorial

SQLite is a powerful embedded database engine that’s a core storage technology in Android and iOS applications. In this installment of the Database Clinic series-in which experts and their databases of choice are pitted against a series of the same challenges- Mark Niemann-Ross demonstrates how to leverage SQLite to solve common database problems.
[Read more…]

Udemy – Database Security for Cyber Professionals

Udemy – Database Security for Cyber Professionals
English | Size: 944.93 MB
Category: Tutorial

The security of the database is related to the use of a wide range of information security control methods in order to protect the database (including data, applications or stored functions, database systems, database servers) against confidentiality, integrity and Accessibility of the database. This includes various types of control techniques such as technical, procedural and physical. Database security is a specialized subject in the field of computer security, information security and risk management. [Read more…]

Packt Publishing – AWS Administration – Database, Networking, and Beyond

Packt Publishing – AWS Administration – Database, Networking, and Beyond
English | Size: 333.67 MB
Category: Tutorial

Learn management tools in AWS with networking, security and database services

This course is packed with clear, practical, instruction-based videos that will enable you to use and implement the latest features of AWS

Amazon Web Services (AWS) is a bundled remote computing service that provides cloud computing infrastructure over the Internet with storage, bandwidth, and customized support for application programming interfaces (API). [Read more…]

Lynda – SQL Server 2016 – Administer a Database Infrastructure

Lynda – SQL Server 2016 – Administer a Database Infrastructure
English | Size: 745.77 MB
Category: Tutorial

SQL Server comes with many features for monitoring, securing, optimizing, and supporting your database infrastructure. Learn how to use these features to administer your SQL Server instances, and prepare for the Microsoft MCSA Administering a SQL Database Infrastructure (70-764) certification exam.
[Read more…]

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…]

Pluralsight – SQL Server: Database Creation, Configuration, and Alteration

Pluralsight - SQL Server: Database Creation, Configuration, and Alteration

Title: Pluralsight – SQL Server: Database Creation, Configuration, and Alteration
Video Format: MP4
File Size: 612 MB
[Read more…]

Treehouse – Database Foundations

Treehouse - Database Foundations

Title: Treehouse – Database Foundations
Video Format: MP4
File Size: 501 MB
[Read more…]