Learn everything you need to know to start building databases with SQL Server. Course teacher eviews the major features of SQL Server 2014 and shows developers how to architect efficient, high-performance solutions for organizations of any scale. Learn how to install and configure SQL Server, create databases and tables, automate common tasks like backups, and use the SQL query language to retrieve and manipulate data.

Topics include:

• Comparing SQL Server editions
• Installing SQL Server
• Creating a database
• Creating tables and relationships between tables
• Writing SQL statements
• Creating views
• Using stored procedures and functions
• Working with XML
• Backing up and restoring a SQL Server database
• Monitoring SQL Server
• Authenticating users
• Importing and exporting data
• Indexing a database