Join Martin Guidry for an in-depth discussion in this video What you should know before starting, part of SQL Server 2014 Essential Training.
- I'd like to take a minute to talk about what you should know before taking this course. This is our introductory course to SQL Server so therefore, no experience with SQL Server is necessary, however, it might be a good idea to be familiar with databases in general. If you need some help with that we have a course here on lynda.com, Foundations of Programming: Databases, with Simon Allardice. It would also be helpful to have a basic working knowledge of SQL.
A good resource for that is SQL Essential Training for Databases, with Bill Weinman, also here on lynda.com.
Author
Martin Guidry
Released
6/12/2015- Comparing SQL Server editions
- Installing SQL Server 2014
- 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
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome47s
-
-
1. Overview of SQL Server 2014
-
2. Installing SQL Server 2014
-
Installation prerequisites4m 14s
-
Basic installation4m 25s
-
-
3. Post-Install
-
4. Creating and Configuring Databases
-
Creating a database4m 56s
-
Installing sample database2m 51s
-
-
5. Creating Tables in a Database
-
Creating a table using T-SQL2m 30s
-
In memory tables2m 39s
-
6. Working with SQL
-
What is SQL?3m 34s
-
Basic SELECT statement3m 35s
-
INSERT statements4m 24s
-
UPDATE statements3m 12s
-
DELETE statements2m 42s
-
-
7. Creating Views in Databases
-
Creating a view6m 1s
-
-
8. Understanding Programmability
-
Stored procedures3m 13s
-
Built-in functions2m 3s
-
-
9. Working with XML
-
Intro to XML1m 56s
-
Shredding XML5m 20s
-
Working with XML schemas3m 48s
-
Storing XML5m 56s
-
-
10. Backup and Restore
-
Basic backups3m 42s
-
Basic restore2m 16s
-
11. Monitoring SQL Server
-
Auditing logins5m 7s
-
Using Performance Monitor4m 44s
-
Using DBCC4m 38s
-
12. Security
-
Instance-level logins1m 49s
-
Database-level users3m 5s
-
Encrypting data6m 4s
-
13. Importing and Exporting Data
-
Exporting data4m 28s
-
Importing data4m 10s
-
-
14. Performance
-
Basics of indexes4m 4s
-
Creating an index2m 41s
-
Exploring execution plans4m 54s
-
-
Conclusion
-
Next steps51s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: What you should know before starting