This course is a brief presentation of SQL Server.
We will install SQL Server Express for free, install it, and create a database and table.
We'll also add some data and retrieve it.
We'll then look at all the various programs that you can use:
- SQL Server Management Studio (SSMS, which allows you to learn T-SQL and DBA)
- SQL Server Integration Services (SSIS), which automates the conversion of data.
- SQL Server Analysis Services (SSAS), which allows the creation of cubes, and
- SQL Server Reporting Services (SSRS), which allows for the creation of reports.
We'll also look at some resources for learning these.
No prior knowledge is required - just a willingness to learn.
See you on the course.