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

Android Development Working With Databases Using Mysql & PHP

Android Development Working With Databases Using Mysql & PHP
English | Size: 905.7 MB
Category: Video Training


Welcome To Android Development: Working With Databases Using Mysql & PHP
[Read more…]

OReilly – Learning Path Oracle Databases

OReilly – Learning Path Oracle Databases
English | Size: 7.62 GB
Category: Tutorial


This learning path offers a solid a foundation in Oracle databases, from the fundamentals of the SQL language and how to build an Oracle database to automating many ETL (extract, transform, load) and analytical tasks and building applications on top of an Oracle database.
[Read more…]

Administering Microsoft SQL Server 2012 Databases – 70-462

Administering Microsoft SQL Server 2012 Databases – 70-462
English | Size: 896 MB
Category: Video Training


Learn how to build and use databases in SQL Server platform
[Read more…]

Lynda – Developing Microsoft SQL Server 2016 Databases

Lynda – Developing Microsoft SQL Server 2016 Databases
English | Size: 542.56 MB
Category: Tutorial


In this course, Adam Wilbert shows experienced SQL Server DBAs how to develop a SQL Server 2016 database with more advanced features. 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. [Read more…]

Udemy – From 0 To 1 – SQL And Databases – Heavy Lifting

Udemy – From 0 To 1 – SQL And Databases – Heavy Lifting
English | Size:4.06 GB
Category:Tutorial


Prerequisites: No prerequisites are needed for the SQL commands and DBMS fundamentals. Basic knowledge of programming in Python would be helpful if you want to run the source code in the course-ending project.
Taught by a Stanford-educated, ex-Googler and an IIT, IIM – educated ex-Flipkart lead analyst. This team has decades of practical experience in quant trading, analytics and e-commerce. [Read more…]

Stanford University – Introduction to Databases

Stanford University – Introduction to Databases
English | Size: 1.27 GB
Category:


This course covers database design and the use of database management systems for applications. It includes extensive coverage of the relational model, relational algebra, and SQL. It also covers XML data including DTDs and XML Schema for validation, and the query and transformation languages XPath, XQuery, and XSLT. The course includes database design in UML, and relational design principles based on dependencies and normal forms. Many additional key database topics from the design and application-building perspective are also covered: indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), and emerging “NoSQL” systems. [Read more…]

From 0 To 1 SQL And Databases – Heavy Lifting

From 0 To 1SQL And Databases – Heavy Lifting

English | Size: 4.06 GB (4,355,723,616 Bytes)
Category: CBTs


Prerequisites: No prerequisites are needed for the SQL commands and DBMS fundamentals. Basic knowledge of programming in Python would be helpful if you want to run the source code in the course-ending project.
[Read more…]

[Pluralsight.com] Amazon Web Services – Databases in Depth

[Pluralsight.com] Amazon Web Services – Databases in Depth

English | Size: 533.01 MB (558,906,390 Bytes)
Category: CBTs


This course will walk you through three major databases from Amazon Web Services. For each database, we will review core use cases, native capabilities, and how to build and configure instances for maximum performance and availability. Students will integrate the databases into a pre-built web application to see a practical example of each service in action. [Read more…]