
This is part of the course of Getting Started in SQL Server. This video will go through what you will be learning during the course.
This is part of the course of Getting Started in SQL Server. This video will go through how to download and install SQL Server on the Windows Server environment.
Explore how a table stores information like an Excel spreadsheet, with columns defined by data types and a primary key to uniquely identify, save, and search rows.
Set up a test database and generate data in SQL Server by creating the database, downloading a resource file, opening it in Management Studio, and executing to populate test data.
Learn how to use the select statement with the where clause to filter employees by id or age, and apply the order by clause to sort results by salary.
Explore SQL Server date functions such as dateadd to add or subtract days, months, years; datepart and date name to extract parts and day names; and datediff to compute differences.
Explore what it means to be a SQL Server database administrator, focusing on security, performance, backups and restore, error logs, indexing, and scheduling jobs.
Learn how to link Power BI to SQL Server, import data from the employees table, and create interactive visualizations and reports with filtering and formatting.
Learn the basics of SQL Server Integration Services (SSIS) for importing, transforming, and exporting data from a source to a flat file destination.
Watch a hands-on demo of creating a SQL Server Express database on AWS RDS, selecting the engine, naming the instance, setting a password, and deploying with default settings.
Do you want to learn how to use Microsoft SQL Server?
This SQL Server course is for anybody who has zero knowledge using Microsoft SQL Server.
As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. This course will show you how to start off on the path of learning SQL Server.
After this course, you will be able to
Download and Install SQL Server
Know how to run basic commands in SQL Server
Know the training path you may need in the SQL Server industry