Relational databases and SQL language with SQL Server

DDL - Table Management

• Introduction
• Creating tables
• SQL Server data types (with exercise)
• Implementing data integrity - Nullity and default value
• Implementing Data Integrity - Primary and Secondary Keys
• Implementing data integrity - Validation constraint (with exercise)
• Visualization of the database schema
• Modifying tables - Columns
• Modification of tables - Constraints
• Implementing referential integrity (with exercise)
• Deleting tables
• Indexing data
• Lesson plan - Creating tables

DML - Updating data

• Introduction
• Some useful elements of Transact SQL (with exercise)
• Inserting data
• Modifying data
• Deleting data (with exercise)
• Transaction management and locks
• Demonstration - Transaction management (with exercise)
• Case Study - Updating a database

Relational algebra

• Introduction to relational algebra
• The principles implemented
• The restriction
• The projection
• The associated calculations
• The Cartesian product
• The join
• Union, intersection, difference and division
• Solving a problem by example: setting up the view
• Solving a problem by example: scheduling operations
• Statement of the practical - Queries in relational algebra

DML - Data extraction

• Introduction
• The basic syntax
• Projection and elementary calculations
• Demonstration - Projection and elementary calculations
• The restriction
• Demonstration - The restriction
• The aggregate calculation
• Demonstration - The aggregate calculation
• The sorting of results
• Relating sets : The cartesian product
• Relating sets : The join
• Demonstration - Relating sets : the join
• Relating sets: The outer join (with exercise)
• Storing intermediate results (with exercise)
• Lesson Plan - SQL Queries (Part 1)

SQL - Advanced Concepts

• Introduction
• Subqueries
• Implementing subqueries : Delete, Update, Insert (with exercise)
• Implementing subqueries : Select (with exercise)
• Using CTE tables (with exercise)
• Implementation of the set operators : UNION, EXCEPT, INTERSECT
• View objects
• Practical Learning Statement - SQL Queries (Part 2)

SQL Server - Configuring the server for shared use

• The problem
• Configuring the Windows firewall
• Enabling named channels in SQL Server

Summary lab

• Lecture - Video rental

SQL Server 2014 - SQL, Transact SQL - Designing and building a database (with practical exercises and answers)

• The relational model
• Implementation of databases
• SQL commands
• Transact SQL: the procedural language
• Distributed data management
• Advanced types
• Common Language Runtime (CLR)