SQL Database Creation  «Prev  Next»

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
  1. Create and alter tables using T-SQL syntax (simple statements)
  2. Create tables without using the built in tools; ALTER; DROP; ALTER COLUMN; CREATE
    Create and alter views (simple statements)
  3. Create indexed views; create views without using the built in tools; CREATE, ALTER, DROP Design views
  4. Ensure code non regression by keeping consistent signature for procedure, views and function (interfaces); security implications
    Create and modify constraints (simple statements)
  5. Create constraints on tables; define constraints; unique constraints; default constraints; primary and foreign key constraints
    Create and alter DML triggers.
  6. 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
  1. Provide the technical skills required to implement a database solution on Microsoft's SQL Server 2005 and
  2. 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:
  1. Describe the overall SQL Server 2010 architecture
  2. Use the tools that come with SQL Server 2016
  3. Define key relational concepts, such as relational integrity, data integrity, and prima, foreign, and unique keys
  4. Create, modify, and delete databases
  5. Create, modify, and delete tables
  6. 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.