English | Size: 386.1 MB
Genre: eLearning
Learn how to consolidate your spreadsheets and other sources into one SQL Server database, create some code to query it for analysis, and how to ask for permission to someone else’s database in this business coding playbook course.
Table of contents
Description
1.Course Overview1m 30s
2.Welcome36s
3.What This Course Is About2m 20s
4.Definitions of Terms4m 34s
5.Big Picture Overview3m 7s
6.SQL Express Introduction5m 40s
7.Visual Studio Community Introduction3m 48s
8.Summary47s
9.Introduction35s
10.Relational Database Comparisons3m 0s
11.Visual Studio Free Editions Comparisons1m 50s
12.Install SQL Server4m 57s
13.Install Visual Studio3m 50s
14.Create an Azure Virtual Machine7m 37s
15.Summary28s
16.Introduction22s
17.Why Consolidate Data59s
18.Acquiring Example Data5m 52s
19.Import from CSV3m 13s
20.Import from Microsoft Excel4m 27s
21.Import from Microsoft Access3m 24s
22.Summary23s
23.Accessing an Organization’s Database1m 46s
24.Access a Database Outside Your Network4m 6s
25.Request Read or Write Permission3m 5s
26.Database Security Settings5m 48s
27.Backup and Restore a Database Overview2m 49s
28.Backup a Database Demonstration2m 55s
29.Restore a Database Demonstration3m 11s
30.Summary46s
31.Introduction25s
32.Connection Strings2m 24s
33.Connect to a Database from Visual Basic Demo4m 23s
34.Connect to a Database from C# Demo4m 9s
35.Protecting Your Credentials1m 23s
36.Encrypting a Connection String Demo3m 12s
37.Connect to a Database from Access Demo2m 10s
38.Connect to a Database from Excel Demo2m 30s
39.Summary25s
40.Introduction22s
41.About T-SQL1m 10s
42.SQL Joins2m 28s
43.Aggregate Functions1m 57s
44.Creating Select Statements Demo3m 22s
45.Preventing SQL Injection Attacks Demo4m 28s
46.Summary27s
47.Introduction to CSV3m 12s
48.Export a CSV File Demo3m 43s
49.Protect Against CSV Injection Demo3m 13s
50.Summary18s
Download Faster with Resume Support with Premium Account
Rapidgator:
https://rapidgator.net/file/5f72c6d7011513a56567042c84f69b6c/PL-Extracting-Database-Information-Business-Coding-Playbook.part1.rar.html
https://rapidgator.net/file/d6d5cac822a0938dc9b4b0c9521af0fd/PL-Extracting-Database-Information-Business-Coding-Playbook.part2.rar.html
NitroFlare:
http://nitroflare.com/view/79BC0D4632871E1/PL-Extracting-Database-Information-Business-Coding-Playbook.part1.rar
http://nitroflare.com/view/596B2C1EB9ACE53/PL-Extracting-Database-Information-Business-Coding-Playbook.part2.rar
If any links die or problem unrar, send request to https://forms.gle/e557HbjJ5vatekDV9
Leave a Reply