Released: 02/2023
Duration: 4h 43m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 2.41 GB
Level: Beginner | Genre: eLearning | Language: English
The ubiquity of big data means that now, more than ever, there is a burning need to warehouse, access, and understand the contents of massive databases quickly and efficiently. Attaining proficiency in SQL is essential to prepare for our data-driven present and future. It is also crucial to furthering your skills as a data analyst or application developer. In this course, Walter Shields teaches you: the basic structure of databases—what they are, how they work, and how to successfully navigate them; how to use SQL to retrieve and understand data no matter the scale of a database; and how to master the most important SQL query syntax, along with how and when to use it best.

Published 2/2023
Created by Singlestore Education
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 30 Lectures ( 2h 38m ) | Size: 824 MB

Released 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Intermediate | Genre: eLearning | Language: English + srt | Duration: 2h 36m | Size: 388 MB
Data warehouses solve fundamentally different problems than a traditional transactional database, and SQL Server Data Warehouses provide a different model for storing valuable data. In this course, database expert Adam Wilbert guides you through the process of developing data warehouses in SQL Server 2022 to provide a robust, trustworthy platform to serve all your business intelligence reporting and analysis workloads. Explore data warehouse foundations, then get started creating a data warehouse in SQL Server. Learn about columnstore indexes, as well as how to automate the tasks associated with integrating multiple data sources together into a warehouse. Find out how to implement an Azure Synapse Analytics Dedicated SQL Pool and enforce data quality using Data Quality Services. Discover ways to use Master Data Services, plus learn how to consume data from your warehouse with business intelligence applications.

Last updated 01/2023
Duration: 1h 4m | Video: 1280x720 30fps | Audio: AAC, 48 kHz, 2ch | Size:
Genre: eLearning | Language: English
Create PL/SQL Blocks with various components

dbForge Source Control for SQL Server 2.5.27 | 60.5 Mb
dbForge Source Control is a convenient SSMS add-in for SQL Server database change management in all the popular version control systems and servers. The tool can be embedded into the database DevOps to automate SQL changes management.

dbForge Data Pump for SQL Server 1.8.15 | 51 Mb
Data Pump is a SQL Server Management Studio add-in for filling SQL databases with external source data and migrating data between systems. The tool supports import and export from 10+ widely used data formats (Excel, CSV, XML, JSON, Text, MS Access, etc.) and includes a number of advanced options and templates for recurring scenarios.

dbForge Data Generator for SQL Server 4.5.19 | 59.7 Mb
Implement new standards for the population of SQL tables with random data with our visual data generation tool. Data Generator includes 200+ meaningful SQL data generators with sensible configuration options. It provides great flexibility and manual control over the creation of the foreign key data. With the column-intelligent data generation, the data in one column is based on the data of another.

dbForge Data Compare for SQL Server 5.3.20 | 56 Mb
dbForge Data Compare for SQL Server is a powerful SQL comparison tool that easily copes with big data and supports native SQL Server backups. Using dbForge Data Compare for SQL Server, you can arrange a flawless SQL database comparison, quickly analyze SQL data differences, compare static data against a version-controlled database, generate comparison reports, and synchronize SQL Server data by means of the convenient wizard. The tool integrates with SQL Server Management Studio.

Published 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1013.22 MB | Duration: 2h 9m
Learn Microsoft SQL Server

Last updated 01/2023
Duration: 1h 50m | Video: 1280x720 30fps | Audio: AAC, 48 kHz, 2ch | Size: 569 MB
Genre: eLearning | Language: English
Create functions, Stored Procedures and build PL/SQL Program components