Lesson 1
Introduction to SQL Server Database Creation
MS SQL Server 2016: Creating a Database, the first course in the SQL Server 2016 Database Implementation Certification series. This series is designed to
- Create and alter tables using T-SQL syntax (simple statements)
- Create tables without using the built in tools; ALTER; DROP; ALTER COLUMN; CREATE
Create and alter views (simple statements)
- Create indexed views; create views without using the built in tools; CREATE, ALTER, DROP Design views
- Ensure code non regression by keeping consistent signature for procedure, views and function (interfaces); security implications
Create and modify constraints (simple statements)
- Create constraints on tables; define constraints; unique constraints; default constraints; primary and foreign key constraints
Create and alter DML triggers.
- Inserted and deleted tables; nested triggers; types of triggers; update functions; handle multiple rows in a session; performance implications of triggers
The MCTS certification is designed to recognize an individual's skills in a specific Microsoft technology. Microsoft offers a variety of MCTS certifications,
including two that are of specific interest to SQL Server 2016 DBAs.
There are three that should interest SQL Server 2016 DBAs. The SQL Server 2016 MCTS certification includes these two options:
SQL Server 2016 Business Intelligence Technology Specialist
- Provide the technical skills required to implement a database solution on Microsoft's SQL Server 2005 and
- Help you prepare for the Exam 70-461, Designing and Implementing Databases with Microsoft SQL Server 2016
Course goals
After completing the course, you will be able to:
- Describe the overall SQL Server 2010 architecture
- Use the tools that come with SQL Server 2016
- Define key relational concepts, such as relational integrity, data integrity, and prima, foreign, and unique keys
- Create, modify, and delete databases
- Create, modify, and delete tables
- Use SQL Server constraints and indexes
Learning System
As you probably know, you can interact with SQL Server in two ways: by issuing Transact-SQL commands, and by interacting with its GUI, or Graphical User Interface.
This course uses Slideshow and Tooltips to explain the code syntax used in Transact-SQL commands, and simulations for practicing different elements of the SQL Server GUI.
For additional information on these and other applets, see the Course Orientation .
The series
Creating a Database is the first of three courses in the SQL Server 2016 Database Implementation Certification Series.
In the next lesson, you will learn about prerequisites to this course.