Description
Microsoft SQL Server Essentials takes you through the journey of learning about the SQL Server database from Microsoft from the ground up. You will become familiar with concepts such as the Structured Query Language (SQL) and Microsoft's version (T-SQL). At the end of the course, you should:- Understand the concept of a relational database- Become familiar with Microsoft SQL Server- Work with Microsoft's IDE: SQL Server Management Studio- Learn how to perform many database tasks using the Graphical User Interface (GUI) - Understand & write T-SQL which is Microsoft's version of SQL- Create databases from the ground up and work with existing database- Create database tables and define relationships between them- Understand the concept of table constraints- Create primary keys, foreign keys etc.- Get comfortable with SQL Server Management Studio- Master DDL - Data Definition Language- Master DML - Data Manipulation Language- Write simple to complex queries- Learn how to use the various built-in functions in SQL Server such as DATE and STRING functions- Learn how to filter queries with various commands- Learn how to aggregate your query results- Work with triggers, views and stored procedure- Learn how to schedule jobs using SQL Server Agent- Learn how to optimize your database queries for optimal executionThis course is ideal if you are getting started with backend development, data analytics or full stack development. You will learn everything you need to know in order to go from beginner to pro in Microsoft SQL Server.
