FreeCoursesOnline Me LYNDA Microsoft SQL Server 2019 Essential Training FCO

1. 01 - Harness the modern and innovative tools in SQL Server 2019.mp414.92MB
2. 02 - What you should know.mp42.79MB
3. 03 - Core concepts.mp425.39MB
4. 04 - SQL Server 2019 editions.mp47.99MB
5. 05 - Install SQL Server Developer Edition.mp421.72MB
6. 06 - Install Management Studio.mp49.22MB
7. 07 - Enable features with Configuration Manager.mp418.26MB
8. 08 - Management Studio first steps.mp49.33MB
9. 09 - Authentication and user permissions.mp46.71MB
10. 10 - Create a new user account.mp49.96MB
11. 11 - Create the first database.mp412.57MB
12. 13 - Table structures.mp412.58MB
13. 14 - Create a simple table.mp413.45MB
14. 15 - Edit a table's structure.mp44.49MB
15. 16 - Enter data into a table using the GUI.mp47.47MB
16. 17 - Import data from CSV files.mp413.14MB
17. 18 - Create tables from flat files.mp46.56MB
18. 19 - Install a sample database.mp49.48MB
19. 20 - Understand data types.mp411.07MB
20. 21 - Table column properties.mp49.43MB
21. 22 - Primary key fields.mp48.45MB
22. 23 - Establish a default value.mp49.2MB
23. 23 - Microsoft SQL Server 2019.mp41.94MB
24. 24 - Check constraints.mp49.52MB
25. 25 - Unique constraints.mp413.36MB
26. 26 - Foreign keys.mp413.03MB
27. 27 - Create a foreign key column.mp47.97MB
28. 28 - Create relationships between tables.mp410.05MB
29. 29 - Understand the role of T-SQL.mp44.8MB
30. 30 - Use the T-SQL editor.mp415.96MB
31. 31 - Create a table with T-SQL.mp411.55MB
32. 32 - Add data to a table.mp48.43MB
33. 33 - Retrieve records with SELECT.mp48.05MB
34. 34 - Filter returned results with WHERE.mp424.45MB
35. 35 - Sort records.mp46.58MB
36. 36 - Delete records from a table.mp48.49MB
37. 37 - Update records in a table.mp46.8MB
38. 38 - Join related tables.mp412.93MB
39. 39 - LEFT JOIN and RIGHT JOIN.mp45.7MB
40. 40 - Remove a table from the database.mp410.14MB
41. 41 - Create a view of the data.mp417.11MB
42. 42 - Data table indexes.mp44.35MB
43. 43 - Create additional indexes on a table.mp46.26MB
44. 44 - Columnstore indexes.mp410.84MB
45. 45 - View execution plans.mp47.59MB
46. 46 - SQL Server's Query Store.mp46.84MB
47. 47 - Rebuild indexes.mp411.37MB
48. 48 - Aggregate functions.mp416.82MB
49. 49 - Use built-in functions.mp47.19MB
50. 50 - Leverage user-defined scalar functions.mp416.38MB
51. 51 - Introduction to stored procedures.mp44.87MB
52. 52 - Create stored procedures.mp411.69MB
53. 53 - Parameterized stored procedures.mp48.64MB
54. 54 - Create a full backup of the database.mp49.5MB
55. 55 - Create a differential backup.mp47.17MB
56. 56 - Restore a backup.mp48.14MB
57. 57 - Automate backups.mp48.77MB
58. 58 - Business continuity solutions.mp45.15MB
59. 59 - User roles and permissions.mp49.61MB
60. 60 - Database schemas.mp415.23MB
61. 61 - Dynamic data masking.mp410.42MB
62. 62 - Always On data encryption.mp413.82MB
63. 63 - Explore the role of system databases.mp44.11MB
64. 64 - Prevent excessive tempdb autogrowth.mp418.02MB
65. 65 - Review the SQL Server error log.mp43.37MB
66. 66 - Dynamic management views.mp46.03MB
67. 67 - Database Console Commands (DBCC).mp464.12MB
68. 68 - Next steps.mp43.72MB