Microsoft SQL Server Fundamentals

About Course

Microsoft SQL Server Fundamentals is designed to provide participants with a comprehensive understanding of the fundamental concepts of Microsoft SQL Server. Through a combination of theoretical learning and hands-on practical exercises, students will gain the essential knowledge and skills required to work effectively with SQL Server databases. The course covers key topics such as database design, querying data, managing databases, and implementing security measures. By the end of the training, participants will be equipped to apply their SQL Server expertise in real-world scenarios effectively.

What Will You Learn?

  • Basics of SQL Server architecture
  • Creating and managing databases
  • Writing and executing SQL queries
  • Implementing security features
  • Backup and restore operations
  • Troubleshooting common database issues

Course Content

Microsoft SQL Server Fundamentals

  • Introduction to SQL Server
    02:56
  • Exploring SQL Server Editions
    03:08
  • Introduction to SSMS
    02:19
  • Creating, Attaching, and Detaching Databases
    02:53
  • Creating Tables in SQL Server
    02:48
  • Establishing Relationships
    02:21
  • Entering Data into SQL Server
    02:26
  • Understanding SQL Server Functions
    03:13
  • Stored Procedures in SQL Server
    03:31
  • Working with Triggers
    03:17
  • Business Intelligence and SQL Server
    03:35
  • Basics of SQL Server Functions
    03:03
  • Using String Functions
    03:00
  • Working with Date Functions
    04:01
  • Microsoft SQL Server Fundamentals