Team Treehouse Querying Relational Databases Course

Team Treehouse Querying Relational Databases Course
English | Size: 243.19 MB
Category: CBTs

Building off of previous SQL courses, this course will begin to introduce the student to more complex database concepts. Students will learn to think about data as sets and subsets and practice achieving desired query results via such operations as inner and outer joins, unions and except. They will also be introduced to the concepts of Set Theory and Database Normalization to aid in understanding good query practices. [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…]

Lynda – Querying Microsoft SQL Server 2016 Databases

Lynda – Querying Microsoft SQL Server 2016 Databases
English | Size: 756.69 MB
Category: Tutorial

SQL Server is Microsoft’s de facto relational database software. While you can build a simple database relatively easily straight out of the box, most administrators need to know how to take advantage of more advanced features in the latest release, SQL Server 2016, to give their clients everything they’ve come to expect in an enterprise database. In this course, Adam Wilbert shows experienced SQL Server DBAs how to develop a SQL Server 2016 database. Learn how to create data tables, including temporary tables and tables with variables, and schemas. Find out how to enforce data integrity with constraints and secure your database at the user level. Then discover how to create indexes to optimize performance, work with functions, and make sure your SQL database is as fast and secure as possible. [Read more…]

Pluralsight – Indexing, Querying and Analyzing Text with SQL Server 2012-2014 (2014)

Pluralsight - Indexing, Querying and Analyzing Text with SQL Server 2012-2014 (2014)

Title: Pluralsight – Indexing, Querying and Analyzing Text with SQL Server 2012-2014 (2014)
Video Format: MP4
File Size: 565 MB
More info
[Read more…]

Trainsignal – SQL Server 2012 Querying (70-461)

Trainsignal - SQL Server 2012 Querying (70-461)

Title: Trainsignal – SQL Server 2012 Querying (70-461)
Video Format: MP4
File Size: 443.2 MB
More info
[Read more…]

CBT Nuggets – Exam 70-461: Querying Microsoft SQL Server 2012

CBT Nuggets - Exam 70-461: Querying Microsoft SQL Server 2012

Title: CBT Nuggets – Exam 70-461: Querying Microsoft SQL Server 2012
Video Format: MP4
File Size: 1.22 GB
More info
[Read more…]

M101 : MongoDB for Developers

M101 : MongoDB for Developers

Title: M101 : MongoDB for Developers
Video Format: MP4
File Size: 7.59 GB
More info
[Read more…]