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.

Last updated 3/2018

English

What you'll learn

At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.
Last Update Date : The course was last updated on 03 October 2017

3 sections • 8 lectures • 38m total length

Introduction5:03
Install SQL Server 2012 Express, configure sa login, and explore SSMS with Adventure Works database. Master SQL using select, from, where, order by, joins, unions, subqueries, and group by having.

Pre-requisites & Different Editions of SQL Server6:20
Explore the three principal SQL Server 2012 editions: enterprise, business intelligence, and standard—and learn their features, hardware and software prerequisites, and the developer and express options for hands-on practice.
Learn SQL Server : New location for Adventure Works Database download0:11
Downloading Express Edition & sample database2:49
Download sql server express edition 2012 and the adventure works sample database, choose the appropriate 64-bit or 32-bit installer, and save the files to your desktop.
Installing the downloads & Configuration18:42
Install SQL Server 2012 Express, configure instance named SS2K12EXPRESS, and attach the AdventureWorks sample database using SSMS, covering installation wizard steps, authentication, and data directories.
The sa Login4:02
Explore the sa login, its full administrative rights, and how to manage its password and status in SQL Server Management Studio, including recommended production restrictions.
Wrap up - what we went over !1:12
Review prerequisites for installing SQL Server 2012 Express Edition, compare editions, install the Express Edition with Adventure Works, and outline best practices for managing the sa super user.

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

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

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