Overview

This is a zero to hero course on Microsoft SQL Databases and Querying. There are no pre-requisites for this course. If you are looking to get acquainted with the concept of Databases and Queries then this is the right course for you.

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.

We will explore best practices in database development using SQL Server Express 2017 and will be building a small school management system database.

All you need is a windows machine and we will walk through setting up an environment, creating a database, creating your first table and writing queries.

At the end of this course, you should be comfortable writing queries for multiple situations and reports.

What will you learn in this course?

• Install SQL server
• Install SQL Management Studio
• Connect to an instance
• Create a database
• Create tables
• Run Queries against tables
• General use of the Management Studio
• Create relationships
• Use aggregate functions to do quick mathematical operations
• Export data to Excel using the Management Studio
• Practical use of SQL
• Creating and managing database views
• Creating and managing custom functions; table triggers and stored procedures
• How to backup and restore databases

Who should take this course?

• This course is for beginners with absolutely no experience in the database.
• This course is for you if you are already comfortable with basic database operations.
• This course is for you if you feel a bit 'rusty' and need to refresh your knowledge.
• This course is for you if you want to understand design principles in database development.
• This course is for you if you are proficient in Microsoft Access and want to learn a new database management system