In this beginner-level course, you will learn how to install SQLServer Database on both Windows and Linux, and how you can start doing basic tasks in SQLServer, using its free client tools SQLServer ManagementStudio, and Azure Data Studio.

WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

• "Just the kind of introduction I needed for the topic (get into it quickly already with some background on databases)!"

• "Highly interesting topic. The updated version of the course is highly informative and comprehensive."

• "I have enjoyed the updated version of the course. It now contains more elaborate information and new live demonstrations."

• "A useful course for beginners."

THE BENEFITS OF THIS COURSE

By the time you complete this course:

• You will know the basic database principles.

• You will know how to download and perform a basic installation of SQLServer on Windows and Linux.

• You will know the basic SQLServer security concepts such as surface area configuration, logins and authentication modes.

• You will be able to connect and work with SQLServer using SQLServer Management Studio (SSMS)and Azure Data Studio and perform different database operations, such as importing and exporting data.

• You will get a free checklist with the top 10 Tasks aSQLServer DBAmust perform every day in order to maintain a healthy SQLServer instance.

MAJOR LEARNING OBJECTIVES:

Throughout the course, I will first help you refresh your memory on the basic database principles, such as: what are Relational Database Management Systems (RRDMSs), what are Databases, Tables, Queries and Programmability Objects, as well as, we will discuss about the differences between SQL and T-SQL.

After that, we will talk about the SQLServer Data Platform and discuss important topics such as: what can you do with SQLServer, what are the main SQLServer services, which are the Operating Systems supported by SQLServer, as well as, we will be installing SQLServer together on a demo environment, along with discussing about the relevant best practices.

Then, we will talk about SQLServer Management Studio (SSMS), which is a popular free SQLServer client tool provided by Microsoft, and learn how you can perform different tasks in SQLServer using SSMS, such as: create databases and tables, write and run T-SQL scripts, generate T-SQLscripts for various databases operations, as well as, import and export data in SQLServer.

Then, we will discuss about basic SQLServer security concepts, such as: logins and database users, as well as, about the surface area configuration in SQLServer.

After that, we will discuss about Azure Data Studio, and learn how you can perform different database tasks in SQLServer, using this free cross-platform tool, which just like SSMS, is also provided by Microsoft.

Then we will talk about SQLServer on Linux and learn how to install SQLServer on this type of OS, along with its main client tools. Moreover, we will be discussing about the different techniques for importing and exporting data in SQLServer and see many interesting live demonstrations.

Finally, we’ll go over different special topics, via which you will learn how to implement special tasks in SQL Server.

PREREQUISITES:

• No prior knowledge of SQL Server is required.

• It would be helpful to know some basic database-related concepts (i.e. what is a database, a table, etc.) but is not a prerequisite, since we will talk about it as well.

• Willingness and excitement to learn!

THIS COURSE CONTAINS/OFFERS:

• 6.5 hours of high-quality video lectures

• May downloadable resources

• Live demonstrations and guides that illustrate the basic concepts and functions and how to perform different tasks in SQLServer

• Useful quizzes for testing your knowledge on each section

• A practice test in the end of the course

• Ability to ask the instructor questions via the Q&Asection

• Certificate on course completion

  
  

Also: This course is being updated with new material on a regular basis.