Course description
Microsoft SQL Server Development
This course will enable Participants to program a SQL Server database. This includes developing in Transact-SQL. Along with developing databases in the Azure cloud. The course will cover the structure of a SQL Server database. Participants will be able to create stored procedures, triggers, functions and views. The course will cover improving database performance by indexing tables. They will cover the new features in the latest version of SQL Server.
Suitability - Who should attend?
An understanding of basic relational database concepts, including:
- Logical and physical database design
- Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, many-to-many)
- How data is stored in tables (rows and columns)
Who’s it for?
This course is designed for those who are responsible for implementing database objects and programming SQL Server databases by using Transact-SQL.
Outcome / Qualification etc.
- Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.
- Course Completion Certificate will be awarded on successful completion of the course.
Training Course Content
SQL Server Overview
- SQL Server Components and Architecture
- SQL Server Developer Tools
- SQL Server Security Implementation
Language Features
- SQL Server Programming Tools
- Elements of Transact-SQL
- SQL Server Object Names
- Additional Language Elements
- Local Variables
- Operators
- Functions
- Ways to Execute Transact-SQL Statements
- New Transact-SQL (T-SQL) Features
Design a Database
- Define Entities
- Apply Normalisation
- Database Objects
- System Tables
- Defining Databases
- Setting Database Options
- Managing Data and Log File Growth
Implement Tables
- Create Tables
- Adding and Dropping a Column
- Generating Column Values
- Adding Constraints
Access and Modify Data
- Selecting Data
- Using Sub Queries
- Select Queries with Joins
- Modifying Data
- Importing Data to Tables
- Writing and Reading XML
Advanced Query Techniques
- Inner Joins
- Outer Joins
- Self Joins
- Sub Queries
- Creating Pivot Queries
- Working with XML
Implement Views
- Introduction to Views
- Advantages of Views
- Defining Views
- Modifying Data through Views
- Optimizing Performance by Using Views
Implement Functions
- What Is a User-defined Function?
- Defining User-defined Functions
- Types of User-defined Functions
- Scalar
- Inline
- Multi-statement
Implement Triggers
- Introduction to Triggers
- Defining Triggers
- How Triggers Work
- Examples of Triggers
- Performance Considerations
Implementing Stored Procedures
- What Is A Procedure?
- Types of Stored Procedure
- Creating Stored Procedures
- Declaring Parameters
- Set Return Value in a Stored Procedure
Indexing Tables
- Introduction to Indexes
- Index Architecture
- How SQL Server Retrieves Stored Data
- How SQL Server Maintains Index and Heap Structures
- Deciding Which Columns to Index
Managing Transactions and Locks
- Introduction to Transactions and Locks
- Managing Transactions
- SQL Server Locking
- Managing Locks
Design and Administer Security Levels
- Design security plan
- Administer authentication
- Administer authorisation
- Administer permissions
- Administer users, groups and roles
Monitoring and Tuning
- Use SQL Profiler to monitor a database
- Describe how the Index Tuning Wizard works and when to use it
- Define database partitioning
Programming Replication
- Overview of SQL Server Replication
- Replication Programming Interfaces
- Configuring Replication
- Synchronizing Data
Introduction to Integration Services
- Importing and Exporting Data
- Integration Services Tools
- Building a Package
- Troubleshooting a Package
Introduction to Reporting Services
- Understanding Reporting Services
- Configuring Reporting Services
- Building a Simple Report
- Creating, Publishing, and Viewing Reports
- Using and Managing Published Reports
New Features in SQL Server
- Always Encrypted
- Stretch Database
- Real-time Operational Analytics
- PolyBase into SQL Server
- Native JSON Support
- Enhancements to AlwaysOn
- Enhanced In-Memory OLTP
Working with Azure SQL Databases
- Creating an Azure SQL Database
- Connecting to an Azure SQL Server
- Exporting data from an on-premises database
- Querying an Azure SQL Database
Why choose Acudemy Training
100% certified & specialised trainers delivering face-to-face, webinars and on-site courses
5 locations where courses are being delivered, with a concentration on Central London
More than 90% of satisfied individuals and organisations (2000+ students trained so far)
Expenses
Are any Financial Options Provided?
- 0% Interest Free payments available.
Request info
ACUDEMY - MAKING LEARNING SIMPLE
ACUDEMY is a Global training provider of bespoke and accredited courses. Reskill or Upskill for the modern workplace. Outdated competency frameworks are a thing of the past. Upskill or Reskill with popular leading programmes that are focused on Outcome rather...