Don't like banners? Log in and we will make sure you see no banners. For free.
[FreeCoursesOnline.Me] [LYNDA] Microsoft SQL Server 2019 Essential Training [FCO]

[FreeCoursesOnline.Me] [LYNDA] Microsoft SQL Server 2019 Essential Training [FCO]

Size
742 MB
Seeders
0
Leechers
1
Files
94
Category
Added
at 12:12pm GMT+1
Infohash
780ab7f46669b944f6a5dcf933b53acbfc35b1a0
Don't like banners? Log in and we will make sure you see no banners. For free.

Description
For More Udemy Free Courses >>> https://freetutorials.us/

For more Lynda and other Courses >>> https://www.freecoursesonline.me/

Forum for discussion >>> https://1hack.us/







Author: Adam Wilbert

Language: English

Released: 5/17/2019

Duration: 4h 24m

Subtitle: Included

Torrent Contains: 143 Files, 1 Folders

Course Source: https://www.lynda.com/SQL-Server-tutorials/Microsoft-SQL-Server-2019-Essential-Training/5010659-2.html



Description:



Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, instructor Adam Wilbert equips beginners with the core skills they need to create and manage SQL Server databases. Adam begins with the basics, showing how to install SQL Server and log into a local database server. He then discusses how to create new databases, design tables, define relationships, write queries, and use stored procedures and built-in functions. Plus, he demonstrates how to perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring.



Topics Include:



• Installing Management Studio

• Enabling features with SQL Server Configuration Monitor

• Creating a database

• Creating tables with Transact-SQL (T-SQL)

• Creating relationships between tables

• Creating views

• Creating user-defined scalar functions

• Backing up and restoring SQL Server

• Monitoring and management

• Security.



Skill Level: Beginner








File list
  • [FreeCoursesOnline.Me] [LYNDA] Microsoft SQL Server 2019 Essential Training [FCO]
  • 0. Websites you may like/How you can help Team-FTU.txt 229 B
  • 01 - Harness the modern and innovative tools in SQL Server 2019.en.srt 2.8 KB
  • 01 - Harness the modern and innovative tools in SQL Server 2019.mp4 14.9 MB
  • 02 - What you should know.en.srt 1.5 KB
  • 02 - What you should know.mp4 2.8 MB
  • 03 - Core concepts.en.srt 10.9 KB
  • 03 - Core concepts.mp4 25.4 MB
  • 04 - SQL Server 2019 editions.en.srt 7.6 KB
  • 04 - SQL Server 2019 editions.mp4 8 MB
  • 05 - Install SQL Server Developer Edition.en.srt 15.9 KB
  • 05 - Install SQL Server Developer Edition.mp4 21.7 MB
  • 06 - Install Management Studio.en.srt 7.5 KB
  • 06 - Install Management Studio.mp4 9.2 MB
  • 07 - Enable features with Configuration Manager.en.srt 2.4 KB
  • 07 - Enable features with Configuration Manager.mp4 18.3 MB
  • 08 - Management Studio first steps.en.srt 8.8 KB
  • 08 - Management Studio first steps.mp4 9.3 MB
  • 09 - Authentication and user permissions.en.srt 4.8 KB
  • 09 - Authentication and user permissions.mp4 6.7 MB
  • 10 - Create a new user account.en.srt 6.1 KB
  • 10 - Create a new user account.mp4 10 MB
  • 11 - Create the first database.en.srt 12.5 KB
  • 11 - Create the first database.mp4 12.6 MB
  • 12 - Database configuration options.en.srt 15.2 KB
  • 13 - Table structures.en.srt 6.4 KB
  • 13 - Table structures.mp4 12.6 MB
  • 14 - Create a simple table.en.srt 13.5 KB
  • 14 - Create a simple table.mp4 13.4 MB
  • 15 - Edit a table's structure.en.srt 4.5 KB
  • 15 - Edit a table's structure.mp4 4.5 MB
  • 16 - Enter data into a table using the GUI.en.srt 3.5 KB
  • 16 - Enter data into a table using the GUI.mp4 7.5 MB
  • 17 - Import data from CSV files.en.srt 12.5 KB
  • 17 - Import data from CSV files.mp4 13.1 MB
  • 18 - Create tables from flat files.en.srt 5.9 KB
  • 18 - Create tables from flat files.mp4 6.6 MB
  • 19 - Install a sample database.en.srt 6.2 KB
  • 19 - Install a sample database.mp4 9.5 MB
  • 20 - Understand data types.en.srt 10.7 KB
  • 20 - Understand data types.mp4 11.1 MB
  • 21 - Table column properties.en.srt 9.4 KB
  • 21 - Table column properties.mp4 9.4 MB
  • 22 - Primary key fields.en.srt 4.6 KB
  • 22 - Primary key fields.mp4 8.5 MB
  • 23 - Establish a default value.en.srt 7.5 KB
  • 23 - Establish a default value.mp4 9.2 MB
  • 23 - Microsoft SQL Server 2019.mp4 1.9 MB
  • 24 - Check constraints.en.srt 5.6 KB
  • 24 - Check constraints.mp4 9.5 MB
  • 25 - Unique constraints.en.srt 9.4 KB
  • 25 - Unique constraints.mp4 13.4 MB
  • 26 - Foreign keys.en.srt 8.6 KB
  • 26 - Foreign keys.mp4 13 MB
  • 27 - Create a foreign key column.en.srt 4.8 KB
  • 27 - Create a foreign key column.mp4 8 MB
  • 28 - Create relationships between tables.en.srt 8.4 KB
  • 28 - Create relationships between tables.mp4 10 MB
  • 29 - Understand the role of T-SQL.en.srt 4.3 KB
  • 29 - Understand the role of T-SQL.mp4 4.8 MB
  • 30 - Use the T-SQL editor.en.srt 14 KB
  • 30 - Use the T-SQL editor.mp4 16 MB
  • 31 - Create a table with T-SQL.en.srt 7.9 KB
  • 31 - Create a table with T-SQL.mp4 11.5 MB
  • 32 - Add data to a table.en.srt 5.1 KB
  • 32 - Add data to a table.mp4 8.4 MB
  • 33 - Retrieve records with SELECT.en.srt 4.2 KB
  • 33 - Retrieve records with SELECT.mp4 8.1 MB
  • 34 - Filter returned results with WHERE.en.srt 3.4 KB
  • 34 - Filter returned results with WHERE.mp4 24.5 MB
  • 35 - Sort records.en.srt 5 KB
  • 35 - Sort records.mp4 6.6 MB
  • 36 - Delete records from a table.en.srt 7.9 KB
  • 36 - Delete records from a table.mp4 8.5 MB
  • 37 - Update records in a table.en.srt 5.6 KB
  • 37 - Update records in a table.mp4 6.8 MB
  • 38 - Join related tables.en.srt 5.3 KB
  • 38 - Join related tables.mp4 12.9 MB
  • 39 - LEFT JOIN and RIGHT JOIN.en.srt 4.7 KB
  • 39 - LEFT JOIN and RIGHT JOIN.mp4 5.7 MB
  • 40 - Remove a table from the database.en.srt 8.6 KB
  • 40 - Remove a table from the database.mp4 10.1 MB
  • 41 - Create a view of the data.en.srt 7.9 KB
  • 41 - Create a view of the data.mp4 17.1 MB
  • 42 - Data table indexes.en.srt 6 KB
  • 42 - Data table indexes.mp4 4.3 MB
  • 43 - Create additional indexes on a table.en.srt 5.8 KB
  • 43 - Create additional indexes on a table.mp4 6.3 MB
  • 44 - Columnstore indexes.en.srt 4.5 KB
  • 44 - Columnstore indexes.mp4 10.8 MB
  • 45 - View execution plans.en.srt 4.2 KB
  • 45 - View execution plans.mp4 7.6 MB
  • 46 - SQL Server's Query Store.en.srt 7 KB
  • 46 - SQL Server's Query Store.mp4 6.8 MB
  • 47 - Rebuild indexes.en.srt 8.7 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
1.4 GB11
390 MB11
276 MB10
217 MB00
538 MB01
124 MB02
261 MB00
370 MB01
330 MB01
2.2 GB00
415 MB06
570 MB01
609 MB01
445 MB02
299 MB00