Menu
Use Code
Training95
For CPD & QLS
Use Code
Training90
For Opera PMS
Use Code
Training80
For BTEC, NCFE CACHE
Menu

  • No products in the basket.

SQL Server Development

0( 0 REVIEWS )
366 STUDENTS
ACCREDITED BY
Buy Now

Overview:

This excellent SQL Server Development course will teach you many of the SQL functions that allow you to manipulate the data within the database. In addition, this SQL course takes you inside the latest, coolest, and most powerful database software platform, Microsoft’s SQL Server 2005. The modules included on this SQL course focus on key elements in a logical sequence. This amazing SQL course demonstrates how you can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this SQL course is what you need to succeed!

Our learning material is available to students 24/7 anywhere in the world, so it’s extremely convenient. These intensive online courses are open to everyone, as long as you have an interest in the topic! We provide world-class learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date.

What skills will I gain?

  • Get all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code
  • Understand how to use management studio and design relational databases
  • Learn to work with single table queries, merging data joins and unions, and subqueries
  • Understand triggers and audit trails, and transactions, locking and blocking

Meet the instructor:

Paul Nielsen is a hands-on database developer, Microsoft SQL Server MVP, a trainer specializing in data architecture and Microsoft SQL Server technologies, and author of many books including SQL Server 2005 Bible. Paul also serves on the PASS (Professional Association for SQL Server) Board of Directors, and is active in the Colorado area SQL Server user groups.

Course outline:

Section 01 – Introduction to SQL Server 2005

  • Module 01: SQL Server Overview
  • Module 02: Using Management Studio
  • Module 03: Designing Relational Databases

Section 02 – Selecting Data

  • Module 01: Working with Single Table Queries
  • Module 02: Merging Data with Joins & Unions
  • Module 03: Working with Subqueries
  • Module 04: Aggregating Data
  • Module 05: Using Full-Text Search
  • Module 06: Selecting Data through Views
  • Module 07: Distributed Queries
  • Module 08: Modifying Data

Section 03 – Developing Solutions

  • Module 01: T-SQL Stored Procedures
  • Module 02: Triggers & Audit Trails
  • Module 03: User-Defined Functions
  • Module 04: Indexing for Performance
  • Module 05: Transactions, Locking & Blocking
  • Module 06: Introducing to Optimization Theory

What are the requirements?

  • You must be 16 or over
  • You should have a basic understanding of English, Maths and ICT
  • You will need a computer or tablet with internet connection (or access to one)

How will I be assessed?

  • You will have one assignment. Pass mark is 65%.
  • You will only need to pay £19 for assessment.
  • You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days.

What Certification am I going to receive?

Those who successfully pass this course will be awarded a SQL Server Development certificate. Anyone eligible for certification will receive a free e-certificate.

What careers can I get with this qualification?

This excellent SQL Server Development course will qualify you to be a Backend Developer. As a Backend Developer you could work for an existing organisation, or could work on a freelance basis. The average salary of a Backend Developer in the UK is £24,885, and this will go up with experience (payscale.com). With this course you could fulfil any of the following roles:

  • Database Development
  • Database Engineering
  • Database Manager
  • Backend Developer
  • Data Analyst
  • Data Scientist

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 107
SECTION 1 - INTRODUCTION TO SQL SERVER 2005
1: SQL SERVER OVERVIEW
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Addition
4. Creating Sample Databases
2: USING MANAGEMENT STUDIO
1. Arranging the Workspace
2. Registering Servers
3. Explaining Items in the Object Explorer
4. Explaining the Database Properties Dialog
5. Explaining the Columns Properties Dialog
6. Continuing with Object Explorer Items
7. Using the Query Editor
3: DESIGNING RELATIONAL DATABASES
1. Understanding Normalization
2. Discovering Patterns
3. Avoiding Over Complexity
4. Managing Optional Data
5. Creating Physical Keys
6. Using the Database Diagrammer Tool
7. Final Comments
SECTION 2 - SELECTING DATA
1: WORKING WITH SINGLE TABLE QUERIES
1. Understanding Query Flow
2. Filtering Data with the Where Clause
3. Columns, Expressions & Scalar Functions
4. Using Case Expressions
5. Working with Nulls & Coalesce
6. Selecting Environment Functions
7. Working with Dates & Times
8. Parsing Strings
9. Converting Data
10. Sorting Data
11. Topping Off the Query with Predicates
2: MERGING DATA WITH JOINS & UNIONS
1. Working with Inner Joins
2. Using Left Outer Joins
3. Multiplying Data with Cross Joins
4. Referencing Self-Joins
5. Working with Complex Joins
6. Finding the Set Difference
7. Stacking Data with Unions
3: WORKING WITH SUBQUERIES
1. Using Subqueries as Expressions
2. Including Subqueries as Lists
3. Adding Subqueries as Derived Tables
4. Working with Correlated Subqueries
5. Solving for X with Relations Division
4: AGGREGATING DATA
1. Using the New Windowing Functions
2. Using Aggregate Functions
3. Grouping a Data Set
4. Nesting Aggregations
5. Filtering Groups & Adding Grand Totals
6. Generating Cross Tab Tables (Pivot)
7. Calculating Cumulative Sums
5: USING FULL-TEXT SEARCH
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases
6: SELECTING DATA THROUGH VIEWS
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views
7: DISTRIBUTED QUERIES
1. Linking to External Data Sources
2. Executing Distributed Queries
3. Looking at Where the Work Takes Place
4. Using Pass Through Queries
5. Controlling Distributed Transactions
8: MODIFYING DATA
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits
SECTION 3 - DEVELOPING SOLUTIONS
1: T-SQL STORED PROCEDURES
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions
2: TRIGGERS & AUDIT TRAILS
1. Introducing After Triggers
2. Using “Instead of” Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes
3: USER-DEFINED FUNCTIONS
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic
4: INDEXING FOR PERFORMANCE
1. Introducing Indexes
2. Creating Indexes
3. Examining Query Execution Plans, Part – 1
4. Examining Query Execution Plans, Part – 2
5: TRANSACTIONS,LOCKING & BLOCKING
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation
6: INTRODUCING TO OPTIMIZATION THEORY
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credit
WhatsApp chat