The Complete SQL Server 2019 Database Administration Course
The Complete SQL Server 2019 Database Administration Course, available at $54.99, has an average rating of 3.25, with 230 lectures, based on 24 reviews, and has 116 subscribers.
You will learn about Build a robust, reliable, secure, and powerful SQL server. Approach and deepen the BACKUP and RESTORE (2 hours of lessons) Address security and privileges (2 hours of lessons) Detect and resolve corruption on a database (2 hour course). Learn the intricacies and pitfalls to avoid when creating a database (2 hour course) We will see the different isolation modes (READ UNCOMMITED,SNAPSHOT,READ COMMITED…) Learn the constraints on tables (CHECK, UNIQUE, PK, FK, DEFAULT) Learn SEQUENCES and IDENTITY Address the functionalities of the Systems Database (Master, TEMPDB, Msbd, resource) A big chapter on new SQL Server 2016 features. Like RLS, DDM, and temporal data. Let's talk about performance by discussing indexing and its implementation (3 hours of lessons) Improve the performance of your stored procedures Let's tackle TSQL at a slightly more advanced level, through the partitioning functions (ROW_NUMBER etc …) This course is ideal for individuals who are Future Database Administrators (DBAs) or BI consultants working on technologies other than SQL Server (Oracle etc…) or Students who want to start using SQL It is particularly useful for Future Database Administrators (DBAs) or BI consultants working on technologies other than SQL Server (Oracle etc…) or Students who want to start using SQL.
Enroll now: The Complete SQL Server 2019 Database Administration Course
Summary
Title: The Complete SQL Server 2019 Database Administration Course
Price: $54.99
Average Rating: 3.25
Number of Lectures: 230
Number of Published Lectures: 227
Number of Curriculum Items: 230
Number of Published Curriculum Objects: 227
Original Price: €99.99
Quality Status: approved
Status: Live
What You Will Learn
- Build a robust, reliable, secure, and powerful SQL server.
- Approach and deepen the BACKUP and RESTORE (2 hours of lessons)
- Address security and privileges (2 hours of lessons)
- Detect and resolve corruption on a database (2 hour course).
- Learn the intricacies and pitfalls to avoid when creating a database (2 hour course)
- We will see the different isolation modes (READ UNCOMMITED,SNAPSHOT,READ COMMITED…)
- Learn the constraints on tables (CHECK, UNIQUE, PK, FK, DEFAULT)
- Learn SEQUENCES and IDENTITY
- Address the functionalities of the Systems Database (Master, TEMPDB, Msbd, resource)
- A big chapter on new SQL Server 2016 features. Like RLS, DDM, and temporal data.
- Let's talk about performance by discussing indexing and its implementation (3 hours of lessons)
- Improve the performance of your stored procedures
- Let's tackle TSQL at a slightly more advanced level, through the partitioning functions (ROW_NUMBER etc …)
Who Should Attend
- Future Database Administrators (DBAs)
- BI consultants working on technologies other than SQL Server (Oracle etc…)
- Students who want to start using SQL
Target Audiences
- Future Database Administrators (DBAs)
- BI consultants working on technologies other than SQL Server (Oracle etc…)
- Students who want to start using SQL
Learn in this course, how to build a robust, secure and reliable database server!
DBA SQL server is nowadays a full time assured job, it is an extremely sought after job in the working world.
************ This course is broken down into several chapters *****************
-
1st chapter: Let’s talk about performance by discussing indexing and its implementation. (3 hrs of class).
-
2nd chapter: This 2:30 chapter will teach you all the intricacies of BACKUP and RESTORE on SQL Server. (3 hrs of class).
-
3rd chapter: Let’s approach TSQL at a slightly more advanced level, through partitioning functions (ROW_NUMBER etc…).
-
4th chapter: Find out how to easily and automatically detect corruption ,with minimum data loss. (3 hr course).
-
5th chapter : Discover all the subtleties and pitfalls to avoid, when creating and configuring a database. (3 h of class).
-
6th chapter: We will discuss the utility of System DBs, as well as the creation and utility of constraints (PK,FK etc…).
-
7th chapter: We will see the different modes of isolation (READ COMMITED, UNCOMMITED, SERIALIZABLE…) that can be set up on a BDD.
-
8th chapter: Discover triggers, synonyms, the sequences and the IDENTITY on your tables.
-
9th chapter: A big chapter on what’s new in SQL Server 2016. Such as RLS, DDM, and temporal data.
-
10th chapter : Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.
*******And at the end of the course take a virtual interview to prepare for your future interview on SQL *******
-
Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.
-
You go to an interview, you don’t really know what to review beforehand, this is a summary of the most frequently asked questions.
-
For example :What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?
Courses that will arrive during the year 2021
-
10th chapter: Let’s go together on SQL Azure!!!
-
11th chapter: How to improve your performance on your stored procedures.
-
12th chapter: Come and find out how to set up security on a SQL Server. (2 hr course).
Important points about this course:
-
This course covers all SQL Server versions, even SQL Server 2019.
-
This online course is 17 hours 30 minutes of demo and 30 minutes of theory. The theory is in the classes, not in this course 🙂
-
I made sure that the videos, were not too sappy, and that they were no longer than 10 minutes.
-
Taking this course, will help you to stand out technically from your colleagues, or during a job interview.
-
Taking this course will, greatly enable you to pass your Microsoft certifications.Look at the average of my other courses (4.4/5), and you will see that my courses are quality courses 🙂
Course Curriculum
Chapter 1: Let's Set Up our working environment installing Management Studio an
Lecture 1: Small explanation on the subtitles
Lecture 2: Tools for working
Lecture 3: Installation of SQL Server
Lecture 4: Installation of Management Studio
Chapter 2: First Chapter : The complete course on Indexes
Lecture 1: What is a index ?
Lecture 2: Setting up databases
Lecture 3: Démo : Définition and création of a clustered index
Lecture 4: Définition and création of a non clustered index
Lecture 5: Structure of the clustered index with a non clustered index
Lecture 6: Démo : The Table SCAN
Lecture 7: Démo : The table SEEK
Lecture 8: Démo : Do you know the covering Index ?
Lecture 9: Démo : Be careful about the duplicate index !
Lecture 10: Démo : Learn the INCLUDE clause on your index
Lecture 11: Démo : Let's discover the UNIQUE index
Lecture 12: Learn to consolidate your indexes!
Lecture 13: Démo : Indexing and column order
Lecture 14: Démo : Improve performance by deactivating the indexes
Lecture 15: Démo : What is a filtered index ?
Lecture 16: Démo : Filtered indexes and the cache plan
Lecture 17: How to choice your clustered index ?
Lecture 18: Avoid an index clustered on a NEWID column !
Lecture 19: Démo : In search of the perfect index
Lecture 20: Démo : What is the OVER indexing ?
Lecture 21: Démo : The index columnstore
Lecture 22: Démo : Let's a create a indexed view !
Chapter 3: Fragmentation on indexes
Lecture 1: Why is fragmentation important?
Lecture 2: Example of fragmentation
Lecture 3: Démo : Tracking page splits
Lecture 4: Démo: What is the FILLFACTOR ?
Lecture 5: Démo : REBUILD vs REORGANIZE
Lecture 6: Démo : REBUILD INDEX with the option ABORT_AFTER_WAIT
Lecture 7: Conclusion on the Index
Chapter 4: 2nd Chapter : Detecting and Correcting Database Corruption
Lecture 1: Why is this course important?
Lecture 2: What is the first thing to think about corruption ?
Lecture 3: What are the causes of corruption?
Lecture 4: Corruption that disappears?
Lecture 5: Démo :IO/errors
Lecture 6: Démo : TORN PAGE DETECTION and PAGE CHECKSUM
Lecture 7: Démo : DBCC IND and DBCC PAGE
Lecture 8: Verification of data consistency
Lecture 9: Démo : Creation of a job for consistency check
Lecture 10: Explanation on the CHECKDB
Lecture 11: Démo : Options on the CHECKDB
Lecture 12: Survey on the CHECKDB
Lecture 13: Démo : BACKUP WITH CHECKSUM
Chapter 5: How to repair in case of corruption?
Lecture 1: Démo : Let's launch our first REPAIR !
Lecture 2: Démo : Repair of a non-clustered index
Lecture 3: Restore Vs Repair
Lecture 4: Démo : Restore from a corrupted backup
Lecture 5: The different states of a database
Lecture 6: Démo : Corruption with XVI32 editor
Lecture 7: Démo : Recreating a log file by attaching a database
Lecture 8: Démo : The EMERGENCY mode
Lecture 9: Démo : Repairing a database using the HACK ATTACH mode
Lecture 10: Conclusion on the corruption
Chapter 6: 3rd chapter : The complete course about BACKUP and RESTORE
Lecture 1: Démo: Simple BACKUP and RESTORE
Lecture 2: Démo : BACKUP and RESTORE LOGS
Lecture 3: Démo : Differential BACKUP and RESTORE
Lecture 4: Démo : BACKUP WITH INIT
Lecture 5: Démo : BACKUP WITH COPY ONLY
Lecture 6: Démo: RESTORE moving the directory files
Lecture 7: Démo: The different database recovery model in SQL Server
Lecture 8: Démo: What is the Tail log backup ?
Lecture 9: Démo : BACKUP WITH CHECKSUM
Lecture 10: Démo : How to RESTORE just a single page !
Lecture 11: Démo: RESTORE WITH STOPAT
Lecture 12: Démo : RESTORE WITH STANDBY
Lecture 13: Démo : RESTORE from a SNAPSHOT
Lecture 14: Démo : How to RESTORE from a LSN ? (log sequential number)
Lecture 15: Does a COMPRESSION do a CHECKSUM ?
Lecture 16: Démo: Understand what is a CHECKPOINT on your SQL Server engine
Lecture 17: Démo : Consult BACKUP and RESTORE metadata
Chapter 7: How to make SQL Server BACKUPS go faster
Lecture 1: Démo: How to increase performance, with BACKUP on several files !
Lecture 2: Démo: BACKUP WITH COMPRESSION and WITH MIRROR
Lecture 3: Démo : BACKUP WITH BUFFERCOUNT and MAXTRANSFERTSIZE
Chapter 8: How to RESTORE your system database ?
Lecture 1: Never forget to BACKUP yours system database !!!
Lecture 2: Démo : How to RESTORE your MASTER system database ?
Lecture 3: Démo : How to RESTORE ALL systems databases ?
Lecture 4: Conclusion on BACKUP and RESTORE course
Chapter 9: 4th chapter : Configuring and modifying a database on SQL Server
Lecture 1: What are we going to see in this course ?
Lecture 2: Démo : Define the files when creating the DB
Lecture 3: Démo : Définition and création of a filegroup
Lecture 4: Démo : What is the Containment database ?
Lecture 5: Démo : Explanation of the compatibility mode
Lecture 6: Démo : OFF LINE and EMERGENCY on a database
Lecture 7: Démo : SINGLE_USER et RESTRICTED_USER, READ_ONLY
Lecture 8: Create a database by attaching a file
Lecture 9: AUTO options on a database
Lecture 10: What is the TARGET RECOVERY Time?
Lecture 11: But what is CHECKPOINT anyway?
Instructors
-
ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.
Join the masterclass SQL Server course !
Rating Distribution
- 1 stars: 4 votes
- 2 stars: 3 votes
- 3 stars: 6 votes
- 4 stars: 2 votes
- 5 stars: 9 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024