|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
[10] Auto-mount the database on project open.mp4
|
MP4
|
5.8 MB
|
|
|
[10] Auto-mount the database on project open.srt
|
SRT
|
3 KB
|
|
|
[11] Auto-populate the data items on project debug.mp4
|
MP4
|
8.1 MB
|
|
|
[11] Auto-populate the data items on project debug.srt
|
SRT
|
3.9 KB
|
|
|
[12] Refactor a database object.mp4
|
MP4
|
8.3 MB
|
|
|
[12] Refactor a database object.srt
|
SRT
|
4 KB
|
|
|
[13] Compare the data project with other databases.mp4
|
MP4
|
3.9 MB
|
|
|
[13] Compare the data project with other databases.srt
|
SRT
|
2.3 KB
|
|
|
[14] Create snapshot DACPAC files.mp4
|
MP4
|
2.8 MB
|
|
|
[14] Create snapshot DACPAC files.srt
|
SRT
|
1.9 KB
|
|
|
[1] Add and remove tables.mp4
|
MP4
|
6 MB
|
|
|
[1] Add and remove tables.srt
|
SRT
|
4.2 KB
|
|
|
[1] Copy database files.mp4
|
MP4
|
3.6 MB
|
|
|
[1] Copy database files.srt
|
SRT
|
3.6 KB
|
|
|
[1] Databases and the project lifecycle.mp4
|
MP4
|
4.2 MB
|
|
|
[1] Databases and the project lifecycle.srt
|
SRT
|
4.2 KB
|
|
|
[1] Next steps.mp4
|
MP4
|
1.8 MB
|
|
|
[1] Next steps.srt
|
SRT
|
1 KB
|
|
|
[1] Prepare to compare databases.mp4
|
MP4
|
3.4 MB
|
|
|
[1] Prepare to compare databases.srt
|
SRT
|
2.3 KB
|
|
|
[1] The SQL Server Express course databases.mp4
|
MP4
|
6.3 MB
|
|
|
[1] The SQL Server Express course databases.srt
|
SRT
|
6.1 KB
|
|
|
[1] Use the query window.mp4
|
MP4
|
6.3 MB
|
|
|
[1] Use the query window.srt
|
SRT
|
4.1 KB
|
|
|
[1] View data in the table data grid.mp4
|
MP4
|
6.9 MB
|
|
|
[1] View data in the table data grid.srt
|
SRT
|
5.1 KB
|
|
|
[1] Why developers need SSDT.mp4
|
MP4
|
16.6 MB
|
|
|
[1] Why developers need SSDT.srt
|
SRT
|
10.9 KB
|
|
|
[1] Work with your SQL Server databases from Visual Studio.mp4
|
MP4
|
3.9 MB
|
|
|
[1] Work with your SQL Server databases from Visual Studio.srt
|
SRT
|
2 KB
|
|
|
[2] Create a Data Compare session.mp4
|
MP4
|
7.5 MB
|
|
|
[2] Create a Data Compare session.srt
|
SRT
|
5.5 KB
|
|
|
[2] DACPAC and BACPAC files.mp4
|
MP4
|
4.6 MB
|
|
|
[2] DACPAC and BACPAC files.srt
|
SRT
|
4.6 KB
|
|
|
[2] PRIMARY KEY and other column settings.mp4
|
MP4
|
7.1 MB
|
|
|
[2] PRIMARY KEY and other column settings.srt
|
SRT
|
3.9 KB
|
|
|
[2] Reconnect the databases.mp4
|
MP4
|
2 MB
|
|
|
[2] Reconnect the databases.srt
|
SRT
|
1 KB
|
|
|
[2] Sort data in the table data grid.mp4
|
MP4
|
3 MB
|
|
|
[2] Sort data in the table data grid.srt
|
SRT
|
2 KB
|
|
|
[2] The Azure SQL course databases.mp4
|
MP4
|
10.4 MB
|
|
|
[2] The Azure SQL course databases.srt
|
SRT
|
7.5 KB
|
|
|
[2] Understand the data project template.mp4
|
MP4
|
2.3 MB
|
|
|
[2] Understand the data project template.srt
|
SRT
|
3.4 KB
|
|
|
[2] What you should know.mp4
|
MP4
|
2.9 MB
|
|
|
[2] What you should know.srt
|
SRT
|
3.3 KB
|
|
|
[2] Write a SELECT query.mp4
|
MP4
|
12 MB
|
|
|
[2] Write a SELECT query.srt
|
SRT
|
6.7 KB
|
|
|
[3] Analyze the Data Compare information.mp4
|
MP4
|
6.8 MB
|
|
|
[3] Analyze the Data Compare information.srt
|
SRT
|
4.9 KB
|
|
|
[3] Create a data project.mp4
|
MP4
|
6.8 MB
|
|
|
[3] Create a data project.srt
|
SRT
|
5.2 KB
|
|
|
[3] FOREIGN keys and tables.mp4
|
MP4
|
5.2 MB
|
|
|
[3] FOREIGN keys and tables.srt
|
SRT
|
3.1 KB
|
|
|
[3] Filter data in the table data grid.mp4
|
MP4
|
6.2 MB
|
|
|
[3] Filter data in the table data grid.srt
|
SRT
|
4.2 KB
|
|
|
[3] Further lessons and examples.mp4
|
MP4
|
812.5 KB
|
|
|
[3] Further lessons and examples.srt
|
SRT
|
1.1 KB
|
|
|
[3] SQL Server Object Explorer (SSOE).mp4
|
MP4
|
3.3 MB
|
|
|
[3] SQL Server Object Explorer (SSOE).srt
|
SRT
|
2.9 KB
|
|
|
[3] SQL Server and Azure Database versions.mp4
|
MP4
|
8.8 MB
|
|
|
[3] SQL Server and Azure Database versions.srt
|
SRT
|
7.8 KB
|
|
|
[3] Tour the Table Designer.mp4
|
MP4
|
10.2 MB
|
|
|
[3] Tour the Table Designer.srt
|
SRT
|
6 KB
|
|
|
[3] Write a CREATE TABLE query.mp4
|
MP4
|
5.2 MB
|
|
|
[3] Write a CREATE TABLE query.srt
|
SRT
|
3 KB
|
|
|
[4] Add CHECK constraints.mp4
|
MP4
|
7.3 MB
|
|
|
[4] Add CHECK constraints.srt
|
SRT
|
4.6 KB
|
|
|
[4] Add a column to a table.mp4
|
MP4
|
4 MB
|
|
|
[4] Add a column to a table.srt
|
SRT
|
2.7 KB
|
|
|
[4] Edit data in the table data grid.mp4
|
MP4
|
7.3 MB
|
|
|
[4] Edit data in the table data grid.srt
|
SRT
|
5.3 KB
|
|
|
[4] Examine the SQL Server object types.mp4
|
MP4
|
6 MB
|
|
|
[4] Examine the SQL Server object types.srt
|
SRT
|
4.1 KB
|
|
|
[4] The LocalDB named instances.mp4
|
MP4
|
7.1 MB
|
|
|
[4] The LocalDB named instances.srt
|
SRT
|
5.9 KB
|
|
|
[4] The programming setup and configuration.mp4
|
MP4
|
4.8 MB
|
|
|
[4] The programming setup and configuration.srt
|
SRT
|
5.6 KB
|
|
|
[4] Update the data in the target database.mp4
|
MP4
|
8.9 MB
|
|
|
[4] Update the data in the target database.srt
|
SRT
|
4.3 KB
|
|
|
[4] Why LocalDB is essential for developers.mp4
|
MP4
|
6.8 MB
|
|
|
[4] Why LocalDB is essential for developers.srt
|
SRT
|
6.8 KB
|
|
|
[4] Work with existing views.mp4
|
MP4
|
11.5 MB
|
|
|
[4] Work with existing views.srt
|
SRT
|
6.6 KB
|
|
|
[5] Add and delete rows in the table data grid.mp4
|
MP4
|
2.8 MB
|
|
|
[5] Add and delete rows in the table data grid.srt
|
SRT
|
1.8 KB
|
|
|
[5] Add items to project.mp4
|
MP4
|
6.7 MB
|
|
|
[5] Add items to project.srt
|
SRT
|
4.8 KB
|
|
|
[5] Connect to network or cloud SQL database.mp4
|
MP4
|
11.3 MB
|
|
|
[5] Connect to network or cloud SQL database.srt
|
SRT
|
7.1 KB
|
|
|
[5] Connected and disconnected workflows with SSDT.mp4
|
MP4
|
8.3 MB
|
|
|
[5] Connected and disconnected workflows with SSDT.srt
|
SRT
|
10.1 KB
|
|
|
[5] Create a Schema Compare session.mp4
|
MP4
|
5.3 MB
|
|
|
[5] Create a Schema Compare session.srt
|
SRT
|
3.6 KB
|
|
|
[5] Create a custom view.mp4
|
MP4
|
6.6 MB
|
|
|
[5] Create a custom view.srt
|
SRT
|
3.8 KB
|
|
|
[5] How to access the sample code on GitHub.mp4
|
MP4
|
6.2 MB
|
|
|
[5] How to access the sample code on GitHub.srt
|
SRT
|
3.5 KB
|
|
|
[5] Update the connected database with table modifications.mp4
|
MP4
|
12.4 MB
|
|
|
[5] Update the connected database with table modifications.srt
|
SRT
|
7.4 KB
|
|
|
[6] Analyze Schema Compare for object definitions changes.mp4
|
MP4
|
2.4 MB
|
|
|
[6] Analyze Schema Compare for object definitions changes.srt
|
SRT
|
1.9 KB
|
|
|
[6] Create Visual Studio data project and use disconnected workflow.mp4
|
MP4
|
13 MB
|
|
|
[6] Create Visual Studio data project and use disconnected workflow.srt
|
SRT
|
7.8 KB
|
|
|
[6] Handling errors in table updates.mp4
|
MP4
|
10.5 MB
|
|
|
[6] Handling errors in table updates.srt
|
SRT
|
6.2 KB
|
|
|
[6] Import schema from a .dacpac file.mp4
|
MP4
|
9 MB
|
|
|
[6] Import schema from a .dacpac file.srt
|
SRT
|
5.2 KB
|
|
|
[6] Install the SQL Server Data Tools (SSDT).mp4
|
MP4
|
8.2 MB
|
|
|
[6] Install the SQL Server Data Tools (SSDT).srt
|
SRT
|
6.6 KB
|
|
|
[6] Work with existing stored procedures.mp4
|
MP4
|
9.9 MB
|
|
|
[6] Work with existing stored procedures.srt
|
SRT
|
7.2 KB
|
|
|
[7] Call a stored procedure with parameters.mp4
|
MP4
|
7.6 MB
|
|
|
[7] Call a stored procedure with parameters.srt
|
SRT
|
4.8 KB
|
|
|
[7] Connect to SQL Server Express in Server Explorer.mp4
|
MP4
|
8.2 MB
|
|
|
[7] Connect to SQL Server Express in Server Explorer.srt
|
SRT
|
5.8 KB
|
|
|
[7] Import schema from a connected database.mp4
|
MP4
|
4.1 MB
|
|
|
[7] Import schema from a connected database.srt
|
SRT
|
3 KB
|
|
|
[7] Understand the Power Buffer.mp4
|
MP4
|
4.9 MB
|
|
|
[7] Understand the Power Buffer.srt
|
SRT
|
3.3 KB
|
|
|
[7] Update the schema in the target database.mp4
|
MP4
|
5 MB
|
|
|
[7] Update the schema in the target database.srt
|
SRT
|
4.2 KB
|
|
|
[8] Change a table or other data item.mp4
|
MP4
|
3.6 MB
|
|
|
[8] Change a table or other data item.srt
|
SRT
|
2.7 KB
|
|
|
[8] Debug a stored procedure.mp4
|
MP4
|
7.4 MB
|
|
|
[8] Debug a stored procedure.srt
|
SRT
|
5.6 KB
|
|
|
[8] Preventing data loss in a schema update.mp4
|
MP4
|
7.2 MB
|
|
|
[8] Preventing data loss in a schema update.srt
|
SRT
|
4.3 KB
|
|
|
[8] Update multiple edits to the connected database.mp4
|
MP4
|
7.3 MB
|
|
|
[8] Update multiple edits to the connected database.srt
|
SRT
|
5.2 KB
|
|
|
[8] Use logical name for readability.mp4
|
MP4
|
5.5 MB
|
|
|
[8] Use logical name for readability.srt
|
SRT
|
3.2 KB
|
|
|
[9] Build the project.mp4
|
MP4
|
7.2 MB
|
|
|
[9] Build the project.srt
|
SRT
|
5.5 KB
|
|
|
[9] Create a custom stored procedure.mp4
|
MP4
|
7 MB
|
|
|
[9] Create a custom stored procedure.srt
|
SRT
|
3.7 KB
|
