112 Files  |  13 Folders  |  3.79 GB total space

1. Microsoft SQL Database Server Setup
2. Creating Databases and Tables with SSMS
3. Database Tables Design Properties
4. MS SQL CRUD Operations Database Backup & Restore
5. Some MS SQL (T-SQL Commands)
6. Filtering Data with MS SQL (T-SQL SQL )
7. Sorting Data
8. Extracting data from multiple tables
9. Aggregating Data
10. Database Performance Monitoring
11. Database Security
12. Azure Setup
13. Connect SSMS to Azure SQL Database

            59 Files  |  13 Folders  |  402 MB total space

1. Introduction
2. Backup and Restore
3. Server Security
4. Database Security
5. High Availability
6. Health and Maintenance of the System
7. Conclusion
8. Exercise Files

              94 Files  |  01 Folders  |  523 MB total space

• There are total 46 lessons (46 videos) in this course

            276 Files  |  09 Folders  |  5.87 GB total space

1. Keys Candidate key, Primary key, Super key, Foreign Key
2. Entity – Relationship Model ( ER Model)
3. Functional Dependency (FD)
4. Normalization
5. Structured Query Language ( SQL )
6. SQL Queries for better understanding
7. Relational Algebra (RA) and Relational Calculus (RC)
8. Transactions and Concurrency Control
9. File Organization

          42 Files  |  05 Folders  |  814 MB total space

1. Introduction
2. Files
3. RDBMS Databases
4. NoSQL Databases
5. Real-World ETL Application Samples

            29 Files  |  05 Folders  |  213 MB total space

1. Introduction
2. Database Design Concerns
3. Controlling the Creation of New Data
4. Tables
5. Conclusion
6. Ex_Files_Excel_Setting_Up_a_Database

           352 Files  |  17 Folders  |  9.62 GB total space

1. Course Updates
2. ACID
3. Understanding Database Internals
4. Database Indexing
5. B-Tree vs B+Tree in Production Database Systems
6. Database Partitioning
7. Database Sharding
8. Concurrency Control
9. Database Replication
10. Database System Design
11. Database System Design
12. Database Cursors
13. Database Security
14. Homomorphic Encryption – Performing Database Queries on Encrypted Data
15. Q&A – Answering your Questions
16. Database Discussions
17. Archived Lectures

             128 Files  |  08 Folders  |  2.20 GB total space

1. Introduction
2. What Is Azure SQL Database
3. Connecting and Managing Azure SQL Database
4. Understanding the Service Tiers
5. Recovery in Azure SQL Database
6. Migrating to and from Azure SQL Database
7. Monitoring and Tuning Azure SQL Database
8. Conclusion

          77 Files  |  05 Folders  |  318 MB total space

1. Course Overview
2. Creating Your First Stored Procedure
3. Creating Stored Procedures and Using Parameters
4. Table-valued Parameters and Refactoring
5. Debugging and Troubleshooting Stored Procedures
6. Sql-server-database-programming-stored-procedures

              96 Files  |  01 Folders  |  536 MB total space

• There are total 47 lessons (47 videos) in this course

             20 Files  |  06 Folders  |  595 MB total space

1. Introduction to database
2. MySQL
3. Data managemnet
4. PostgreSQL
5. Database design
6. Bonus audio sections

             1035 Files  |  41 Folders  |  13.9 GB total space

1. Presentation and overview
2. Setting up your environment
3. Part 1 The Transact SQL (10 hours of class)
4. Let’s create our first wonderful database !
5. Let’s create our first fantastic table !
6. Let’s start playing with data with SELECT,UPDATE,INSERT and DELETE
7. Exercise and correction 1 to 5 on SELECT,UPDATE,INSERT,DELETE
8. Let’s go a little further in the SQL transact (DISTINCT,LIKE ..)
9. Exercise and correction 6 to 16 (DISTINCT,LIKE …)
10. Let’s go even further with Transact SQL (AND,OR, MIN,MAX…)
11. Exercise and correction 17 to 25 (AND,OR, MIN,MAX…)
12. Learn to combine data with the power of JOINS
13. Exercise and correction 26 to 33 on the joins
14. Let’s go even further with Transact SQL Part 3
15. Exercise and correction 34 to 41 (SUBSTRING,CHOOSE..)
16. The conversion functions and the different types of columns
17. Let’s discover together the usefulness of views and stored procedure on SQL
18. Exercise and correction 42 to 47 (Stored procedure and view)
19. TSQL Let’s deepen our knowledge of TSQL even more
20. Let’s discover the little known CTE (common table expression) and derived table
21. The Schema, the functions and Temporary tables, variable tables and global table
22. Let’s discover the power of the Ranking functions
23. Another topics on the Transact SQL
24. Chapter 1 Administration on SQL Server the BACKUP and RESTORE course
25. Administration chapter 2 Detecting and Correcting Database Corruption
26. Administration SQL chapter 3 Configuring and modifying a BDD on SQL
27. Administration chapter 4 The different modes of isolation
28. Administration chapter 5 The course on Security and Privilege Management
29. Administration chapter 6 The Trigger,synonym, the sequence, and the constraints
30. Another topics on the Adminstration of your SQL Server
31. Performance Part 1 The complete course on the Index
32. Performance Part 2 Other performance topics
33. Enter the interview room, it’s HERE !!!
34. Questions 1 to 10
35. Answers from 1 to 10
36. Questions from 11 to 20
37. Answers from 11 to 20
38. Questions from 21 to 30
39. Answers from 21 to 30
40. Questions from 31 to 40
41. Answers from 31 to 40