Master SQL and SQL Server to design, query, and manage databases
A poorly designed database leads to slow queries, inconsistent data, and costly maintenance. SQL and the relational model are the foundations of most information systems, and mastering them radically changes how you interact with data. This training covers the entire cycle: design, creation, updates, retrieval, and advanced concepts, using SQL Server as the practical environment.
Is it for you ?
Developers.
Prerequisites
None.
What You'll Walk Away With
- ✓ Design a solid, normalized relational database
- ✓ Write complex SQL queries to extract and manipulate data efficiently
- ✓ Implement integrity constraints and manage transactions with rigor
Training content
1 Towards relational databases
- Introduction to relational databases
- Data storage
- Ways of organizing data
- Sequential organization
- Direct or random organization
- Indexed sequential organization
- Evolution towards the relational model
- The relational model rules and concepts
- Normalization
2 Introduction to SQL
- Generalities about the language
- A query language
- A standard and normalized language
- A universal language
- The statement categories
3 The Microsoft SQL Server solution
- Introduction to SQL Server
- SQL Server Management Studio
- Creating a new database
- Managing access rights
- The script editor
4 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
5 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
6 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
7 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)
8 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)
9 SQL Server - Configuring the server for shared use
- The problem
- Configuring the Windows firewall
- Enabling named channels in SQL Server
10 Summary lab
- Lecture - Video rental
11 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)
See more
📌 Practical information
100% online training. Accessible anytime from anywhere for one year. If you have any questions about registration, the language of instruction, or the cancellation terms, please consult our FAQ
Trainers
Upcoming information