SQL Server Baby Step: Installation and Configuration

SQL Server Baby Step: Installation and Configuration
An absolute beginner’s tutorial to quickly learn how to setup Microsoft SQL Server practice environment on your machine.
Description

Scope of this course is confined to the following learning objectives ONLY:

  • Start from scratch by installing Microsoft SQL Server Express edition

  • Requirements for installing Microsoft SQL Server

  • Discussion around some of the basic configuration option, including “sa” login

  • Making use of Adventure Works sample database

  • More in depth coverage of relational database in general, and Microsoft SQL Server in particular, in my another course

Who is the target audience?
  • Anyone who is just starting out on their database career.
  • Information workers who work with database.
  • Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant.
  • Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc.
  • Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461
  • Quality Analyst people who need to understand the workings of a database while they do their software testing.
  • Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology.
  • Business Professional
  • Accountants
  • Software Developers
  • Programming Students
  • Financial Analysts

Suggest:

Learn MS SQL Server From Scratch

SQL Server Analysis Services - SSAS, Data Mining & Analytics

Practice advanced SQL queries with MySQL 5.7+

Mastering SQL Server 2016 Integration Services (SSIS)

PHP connections to MySQL

Introduction to MySQL Database