DB-201 : MS SQL Server 2008/2012 Database Programming (Level 1)
- 36Training hours
- 12Lectures
- 7Assistant hours
- 950Egyptian pounds
- 10Students maximum
- Put database programming with MS SQL Server 2008/2012 into practice, and master it
What the training programme covers
- Lesson 1: Overview of Relational Databases
- Lesson 2: Introduction to Microsoft SQL Server 2012
- Introducing Microsoft SQL Server 2012
- Getting Started with SQL Server Management Studio
- Creating Database Objects
- Lab : Working with SQL Server 2012 Tools
- Lesson 3: Introduction to T-SQL Querying
- Introducing T-SQL
- Understanding Sets
- Understanding Predicate Logic
- Understanding the Logical Order of Operations in SELECT statements
- Lab : Introduction to Transact-SQL Querying
- Lesson 4: Writing SELECT Queries
- Writing Simple SELECT Statements
- Eliminating Duplicates with DISTINCT
- Using Column and Table Aliases
- Writing Simple CASE Expressions
- Lab : Writing Basic SELECT Statements
- Lesson 5: Querying Multiple Tables
- Understanding Joins
- Querying with Inner Joins
- Querying with Outer Joins
- Querying with Cross Joins and Self Joins
- Lab : Querying Multiple Tables
- Lesson 6: Sorting and Filtering Data
- Sorting Data
- Filtering Data with a WHERE Clause
- Filtering with the TOP and OFFSET-FETCH Options
- Working with Unknown and Missing Values
- Lab : Sorting and Filtering Data
- Lesson 7: Views and Indexes
- Using Views
- Every Thing About Views
- Indexes
- Lesson 8: Working with SQL Server 2012 Data Types
- Introducing SQL Server 2012 Data Types
- Working with Character Data
- Working with Date and Time Data
- Lab : Working with SQL Server 2012 Data Types
- Lesson 9: Using Built-In Functions
- Writing Queries with Built-In Functions
- Using Conversion Functions
- Using Logical Functions
- Using Functions to Work with NULL
- Lab : Using Built-In Functions
- Lesson 10: Grouping and Aggregating Data
- Using Aggregate Functions
- Using the GROUP BY Clause
- Filtering Groups with HAVING
- Lab : Grouping and Aggregating Data
- Lesson 11: Using Subqueries
- Writing Self-Contained Subqueries
- Writing Correlated Subqueries
- Using the EXISTS Predicate with Subqueries
- Lab : Using Subqueries
- Lesson 12: Using Table Expressions
- Using Derived Tables
- Using Common Table Expressions
- Using Inline Table-Valued Functions
- Lab : Using Table Expressions
- Lesson 13: Using Set Operators
- Writing Queries with the UNION Operator
- Using EXCEPT and INTERSECT
- Using APPLY
- Lab : Using Set Operators
- Lesson 14: Using Window Ranking, Offset and Aggregate Functions
- Creating Windows with OVER
- Exploring Window Functions
- Lab : Using Window Ranking, Offset and Aggregate Functions
- Lesson 15: Pivoting and Grouping Sets
- Writing Queries with PIVOT and UNPIVOT
- Working with Grouping Sets
- Lab : Pivoting and Grouping Sets
- Lesson 16: Querying SQL Server Metadata
- Querying System Catalog Views and Functions
- Executing System Stored Procedures
- Querying Dynamic Management Objects
- Lab : Querying SQL Server Metadata
- Lesson 17: Executing Stored Procedures
- Querying Data with Stored Procedures
- Passing Parameters to Stored Procedures
- Creating Simple Stored Procedures
- Working with Dynamic SQL
- Lab : Executing Stored Procedures
- Lesson 18: Programming with T-SQL
- T-SQL Programming Elements
- Controlling Program Flow
- Lab : Programming with T-SQL
- Lesson 19: Implementing Error Handling
- Using TRY / CATCH Blocks
- Working with Error Information
- Lab : Implementing Error Handling
- Lesson 20: Implementing Transactions
- Transactions and the Database Engine
- Controlling Transactions
- Lab : Implementing Transactions
- Lesson 21: Improving Query Performance
- Factors in Query Performance
- Displaying Query Performance Data
- Lab : Improving Query Performance
- Lesson 22: Working with XML
- XML Data Type
- XML Schema Collections
- Querying XML
- Lesson 23: SQL Services Overview
- Overview of Integration Services
- Overview of Analysis Services
- Overview of Reporting Services
Prerequisites
To take this course you need a good working knowledge of relational databases. Please see the learning paths for more detail.
Who this course is for
- Computer science students.
- Information systems staff and managers.
- Anyone interested in working in software.
Job title
Once you finish this course you can work as an MS SQL Server database programmer
Meet the instructors on this course
Trainer and web developer
Hamada works as a professional web developer across a range of platforms, PHP and MS ASP.NET among them, and is a Microsoft Certified Solutions Developer for web applications, which he took after his university BSc in computer science. He has long hands-on experience building web applications for the commercial market, alongside teaching a good many training courses in the field.
A message for the trainer? Send it from here.
Chief Executive Officer and database developer
Waleed started out in computer science and programming at around the age of eleven, on the old Q-Basic language, and has worked with a long list of technologies across programming, databases and computer systems in general ever since. He is now chief executive of the software house Code-Times, Ltd, specialising in systems analysis, MS SQL Server database development, and building large-scale applications on MS .NET for both the web and Windows. Alongside that, Waleed runs the training departments at 7dash and designs and delivers a range of specialist computer-science programmes on a model of his own: training material as close as possible to the day-to-day reality of a working software company, rather than an academic syllabus with no regard for how the content is actually applied.
A message for the trainer? Send it from here.A message for the trainer? Send it from here.
The questions we are asked most about this training programme
- Can I work as a database programmer as soon as I finish this course?
- Yes. Level 1 does not mean the basics and nothing more: the course starts you at the fundamentals of the database management system and then carries you all the way to a professional level. Its content serves most of the main things most companies need, while the next level goes into more complex subjects that serve particular kinds of role.
- Does this course prepare me for any of Microsoft's specialist certifications?
- Yes, this course prepares you for the MSCTS certification in database development.
Are you following a particular learning path?
Here is where this course sits in every learning path that runs through it
What else comes with this course
-
Sit the course again, free of charge -
Drinks cafeteria -
A comfortable place to study -
Ongoing support -
Private assistance hours
Reserve your seat on this course
Enter your details now and we will call you to fix a date and take you through the booking.
Have a question ?
We are glad to help you get a better grasp of things, so do not hesitate to contact us if you have any questions at all.