عربي
SQL Server 2019: Database Fundamentals.
Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, beginners will be equipped with the core skills they need to create and manage SQL Server databases. The course begins with the basics, showing how to install SQL Server and log into a local database server. Discussing how to create new databases, design tables, define relationships, write queries, and use stored procedures and built-in functions. Plus, demonstrating how to perform crucial database administration tasks, such as backups and restores, security enhancements, and performance monitoring.
SQL Server 2019: Querying Microsoft SQL Server 2019.
Discover how to query data from SQL Server tables. This course covers how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language. Learn the fundamental structure of a query and see how to manipulate data through the use of built-in functions, operators, filters, and other language features to return a dataset that's formatted to meet a wide variety of needs and perspectives. Upon wrapping up this course, you'll be equipped with the commands and keywords you need to know to effectively analyze your data.
SQL Server 2019: Administration Microsoft SQL Server 2019 Database.
Introduction to SQL Server Database Administration This training introduces SQL Server in general, and the main tools administrators will use, such as Management Studio, SQLCMD and the SQL Server configuration manager. - Installing and Configuring SQL Server - Working with Databases and Storage - Planning and Implementing a Backup Strategy - Restoring SQL Server Databases - Importing and Exporting Data - Monitoring SQL Server - Tracing SQL Server Activity - Managing SQL Server Security - Auditing Data Access and Encrypting Data - Performing Ongoing Database Maintenance - Automating SQL Server Management - Monitoring SQL Server by Using Alerts and Notifications
