Database Design with Microsoft SQL Server Training Course
Short course
Online
Description
-
Type
Short course
-
Level
Beginner
-
Methodology
Online
-
Class hours
6h
This course is designed for beginners who wish to design and implement database with Microsoft SQL Server. It is a classroom based course that covers relational database fundamentals, database design, Structured Query Language (SQL) and database administration.
This course will prepare you for the Microsoft Technology Associate (MTA) certification exam. It also leads to our Querying Data with SQL and T-SQL, SSIS and SSRS courses.
Following topics are included in this course:
Database Concepts and Introduction of MS SQL Server
Planning and Creating Databases
Constraints and Data Integrity
Structured Query Language (SQL) and T-SQL
Retrieving Data with SQL and T-SQL
Creating Views, Stored Procedures and UDF
T-SQL Programming
Database Normalisation
Understanding Indexes
Migrating, Importing and Exporting
Database security
Backing Up and Restoring
Facilities
Location
Start date
Start date
About this course
Important information: London Academy of IT will offer classroom-based learning when the UK lockdown is over and safe to do so.
Skills Required
No existing knowledge on Microsoft SQL Server is required. You should have basic computing knowledge. Familiarity with relational database concepts is helpful but not required.
If you do not have basic computer and Internet skills then we highly recommend you to attend our Computer Basics for Absolute Beginners course before attending this course.
Certification: Certificate of Completion will be provided after completing the course
Reviews
Subjects
- Database
- Database Design
- SQL
- IT
- Computer
- London
- Stratford
- Skills
- DBMS
- T-SQL
Teachers and trainers (1)
Jayan Karmacharya
Tutor
Jayan is an Experienced Web Developer and IT tutor with over 10 years of experience in Server side programming, front-end development, database design, web server management and, IT instruction. Having Master of Science in Information Technology Degree and Microsoft certified Programming in HTML5 with JavaScript and CSS3
Course programme
- Database Concepts and Introduction of MS SQL Server
- Database and DBMS
- Database Types
- Flat-type databases
- Hierarchical databases
- Relational databases
- Editions of MS SQL Server 2008 and 2012
- Installing and Configuring Microsoft SQL Server
- Introduction to SQL Server Management Studio
- Planning and Creating Databases
- Planning Your Database
- Creating a SQL Server database
- Creating tables
- Data types in SQL Server
- Defining Primary keys and Identity Specification
- Inserting, Updating and Deleting records
- Creating default values
- Constraints and Data Integrity
- Introduction of Database Constraints
- Unique Key Constraint
- Primary and Foreign Key Constraint
- Relationships in a Database
- Composite Primary Keys
- Creating Database Diagram
- Referential Integrity
- Setting Cascade Update and Delete
- Structured Query Language (SQL) and T-SQL
- Introduction of SQL and Transact-SQL (T-SQL)
- Introduction of Data Definition Language (DDL)
- USE Command
- Create Databases using T-SQL
- Drop Databases using T-SQL
- Creating, Altering and Removing Tables using T-SQL
- TRUNCATE TABLE Command to delete data
- Commenting and Saving T-SQL
- Introduction of Data Manipulation Language (DML)
- INSERT statements
- UPDATE statements
- DELETE statements
- Difference between DELETE and TRUNCATE
- Quiz 1
- Retrieving Data with SQL and T-SQL (Part-1)
- Using SELECT statements
- Using WHERE for filtering
- Using the NOT operator
- Using the LIKE operator
- Using IS NULL and IS NOT NULL
- Using ORDER BY for sorting
- Using DISTINCT to find unique values
- Concatenating Columns
- Creating Calculated Field
- Limiting Results by using TOP Clause
- Retrieving Data with SQL and T-SQL (Part-2)
- Using SQL Server Built-in Functions
- Using Scalar Functions
- Using Aggregate functions: AVG, MIN, MAX, SUM and COUNT
- Using GROUP BY clause
- SQL HAVING Clause
- SQL UNION and UNION ALL Operators
- SQL EXCEPT and INTERSECT Operators
- Using Subqueries
- Joining multiple tables together
- Inner Joins
- Outer Joins: LEFT, RIGHT & FULL
- Joining More Than Two Tables
- Creating Views, Stored Procedures and UDF
- Introduction of Views
- Creating Views using T-SQL
- Using View Designer Tools
- Creating User Defined Functions
- Creating Stored Procedures
- Quiz 2
- T-SQL Programming
- Variables
- Control Flow - IF…ELSE
- CASE Statement/Expression
- Database Normalisation
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Understanding Indexes
- Introduction of Indexes
- Clustered Indexes
- Non-clustered Indexes
- Creating Indexes
- Migrating, Importing and Exporting
- Generate SQL Scripts
- Import and Export Wizard
- Import Data into SQL Server
- Exporting Data
- Database security
- Introduction of Database Security
- Authentication Methods
- Creating and Managing Logins
- Creating and Managing Database Users
- Using SQL Server Roles
- Managing Object Permissions
- Backing Up and Restoring
- Introduction of Database Backups
- Types of Database Backup
- Creating backups
- Restoring databases
- Quiz 3
Additional information
Database Design with Microsoft SQL Server Training Course