Lynda – Learning SQL Programming

Lynda – Learning SQL Programming
English | Size: 183.82 MB
Category: CBTs

SQL (Structured Query Language) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a server, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.
[Read more…]

Lynda – Advanced SQL for Data Scientists

Lynda – Advanced SQL for Data Scientists
English | Size: 171.34 MB
Category: CBTs

There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common data science tasks, including finding, exploration, and extraction within relational databases.
[Read more…]

Learning Path SQL for Business Users

Learning Path SQL for Business Users
English | Size: 7.38 GB
Category: CBTs

If you’re looking for “just enough” SQL knowledge to wrangle data and do sophisticated analysis, this Learning Path is for you. You’ll get a solid understanding of basic database design principles and normalization. You’ll learn how to pipeline data to other analysis tools (R, Python, even Excel). You’ll be able to prototype a database that suits your business needs, and form accurate queries and database updates in several SQL environments-all without getting bogged down in the deeply technical aspects of SQL that you will never use. [Read more…]

Pluralsight – SQL Server Understanding and Using Azure SQL Database

Pluralsight – SQL Server Understanding and Using Azure SQL Database
English | Size: 314.03 MB
Category: Tutorial

Azure SQL Database is finally on a par with on-premises SQL Server! This course describes and demonstrates using Azure SQL Database and its features as well as migration strategies for migrating existing SQL Server databases to Azure SQL Database.
Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this course, SQL Server: Understanding and Using Azure SQL Database, you’ll learn the fundamentals of Azure SQL Database from a DBA perspective. [Read more…]

Pluralsight – Getting Productive with SQL Developer

Pluralsight – Getting Productive with SQL Developer
English | Size: 685.48 MB
Category: CBTs

Oracle SQL Developer is a very popular free Graphical user interface. This course will teach you about this tool and see how it makes database development and management a breeze, for database developers, DBAs, and analysts.
This IDE is packed with tons of cool features to significantly boost productivity and making executing the day to day tasks for both the database developers and DBAs a breeze. This tool allows you to write complex queries, explore the database and provides a complete development platform for Oracle PL/SQL applications.
[Read more…]

O’Reilly – Developing SQL Databases – Exam 70-762 Certification

O’Reilly – Developing SQL Databases – Exam 70-762 Certification
English | Size: 1.76 GB
Category: CBTs

Microsoft exam 70-762 is one of two exams you must pass to earn a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Development certification. This comprehensive course covers the material included in the 70-762 exam, moving you one step closer to the goal of becoming a true database professional. Taught in a friendly, easy-to-understand style by long time database development expert Mark Long, this course works for those new to the world of SQL databases, as well as those just needing a review.
[Read more…]

O’Reilly – Learning Path SQL Commands, Joins, and Views

O’Reilly – Learning Path SQL Commands, Joins, and Views
English | Size: 329.88 MB
Category: Tutorial

If you need to understand how to query relational databases, this Learning Path will get you up and running quickly. Commands, joins, and views are the most fundamental elements of SQL (Structured Query Language) and with them you can make powerful insights into your data. In the just an hour and a half, you will learn how to use SQL to manage data that is held in relational databases. This Learning Path is designed for beginners who have no previous experience with SQL of any kind. Working files are included, allowing you to follow along with the instructor. [Read more…]

O’Reilly – Oracle SQL and JSON

O’Reilly – Oracle SQL and JSON
English | Size: 765.14 MB
Category: Tutorial

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

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

O’Reilly – Querying Data with Transact-SQL – Exam 70-761 Certification Training

O’Reilly – Querying Data with Transact-SQL – Exam 70-761 Certification Training
English | Size: 1.53 GB
Category: Tutorial

Microsoft’s SQL Server database platform is dominant in the enterprise database marketplace, making those with MS SQL Server skills highly sought after in any job market. Possessing a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Development certificate tells employers worldwide that you have these skills. Earning the certificate requires you to pass two exams: The MS 70-761 and the MS 70-762. This course prepares you to pass MS 70-761. MS 70-761 is all about Transact-SQL, the programming language central to working with MS SQL Server.
[Read more…]