Development Online Course by Udemy, On Sale Here
Learn how to become a future developer, or either a future DBA, or a performance expert on SQL Server 2019!
An excellent training about Database Design & Development
SQL Server – The Complete Guide 2021 (Beginner + Advanced)
If you want to benefit from this course at a price of 10 euros, send me an email to olivtone@yahoo. fr, I will send you the discount coupon within the day Become (really) an expert on SQL Server, through this 12-hour Masterclass course! There will be many new sections added in 2021, of course if you have already purchased this course, these new modules will be free for you. This course will have an estimated duration of between 30 and 40 hours once completed. I challenge you to find another e-learning course, in English, which lasts 12 hours and covers these 2 themes: 1st chapter: Transact SQL for the absolute beginner (7 hours of class): Install SQL Server and management studio on your workstation. The creation and definition of a databaseThe creation and definition of a tableLet’s start playing with data with SELECT, UPDATE, INSERT and DELETEDiscover the column aliases and tackle the specificity and secrets of LIKE. Do you know the usefulness of the TOP? Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and so onCopying a table with the SELECT INTO. Let’s talk about the IN, NOT IN, IS and IS NOT operators, and Sort your data with ORDER BY. Discover aggregate functions with MIN MAX and AVG and the two operators AND, OR. Let’s discover the specificities of COUNT and SUM and how to SELECT a range of data with the BETWEENGroup several results with the GROUP BYA long chapter of one hour and 30 minutes on joints with INNER JOIN, LEFT/RIGHT JOIN FULL OUTER JOIN and so onLet’s discover the specificities of UNION and UNION ALL, and the LEFT and RIGHT function. Have you heard of the CHOOSE, TRIM/LTRIM/RTIM? Let’s go even further with Transact SQL with the IIF, CASEWHEN, OFFSETFETCHNEXTROWS. Let’s look at the conversion functions through CAST and CONVERT, TRY CAST and TRY CONVERT, as well as TRY PARSE and PARSE. The creation and definition of a view. The creation and definition of a Stored Procedure. The creation and definition of a trigger. Creating and defining a function. Here are the sections that will arrive in 2021: A very long chapter on RANKING functions such as ROW NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD etc. Conversion functions with TRY CAST and TRY CONVERT, then TRY PARSE and PARSE. We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don’t understand by the way).How to write a Subquery? Of course there are many exercises and corrections in this course. 2nd chapter: The complete administration of a SQL Server (5 hours of course) : This section brings together two of my courses on the Udemy platform which are: SQL server: Detecting and repairing corruption on a database SQL server: The complete course about BACKUPand RESTORE. The first chapter will talk about BACKUP and RESTORE, we will discuss the: How to make very simply a BACKUP and a RESTORE. Discuss the BACKUP LOGS and DIFFERENTIAL BACKUP, and why it is absolutely necessary to implement them in your BACKUP strategy. Understand the interest of the WITH INIT in a BACKUP, and learn how to make a restoration in time with the WITH STOPAT option. And finally, we will see the different full recovery model on a database(FULL, SIMPLE and BULKEDLOGGUED), and why this is (very) important for our BACKUPs. The performance when doing a BACKUP on several files. Avoiding corruption on BACKUPs with the CHECKSUM, and understanding the importance of BACKUP WITH COPY ONLY, to avoid breaking the BACKUP chain during the day. To discover that you can make a RESTORE of a page, or from a LSN, to avoid losing hours of RESTORE, in case of server crash. Recover unsaved logs, in case of server crash, with the power of the TAIL LOG BACKUP. We will discuss the BACKUP WITH COMPRESSION, to save disk space, which can be significant, and the simultaneous copy of BACKUP with the WITH MIRROR option. We will also see how to restore system databases (Master, MSDB, model, TEMPDB).The RESTORE WITH STANDBY, which allows to examine the data between each RESTORE. And to finish, we will see how to make a RESTORE from a SNAPSHOT, see the necessary rights, to make BACKUP, how to consult BACKUP metadata. The second chapter will talk about corruption on SQLServer: Database corruption happens all the time, all over the world! When it happens in your environment, do you know what to do? This 2-hour course will show you what you need to know to detect and repair most cases of database corruption. The course begins by explaining why early detection of corruption is so important, and then examines the different causes of database corruption. You will learn how to configure SQL Server to automatically detect when I/O errors occur. You’ll learn how to configure SQL Server to automatically detect when I/O errors occur, what consistency checks are, the DBCC commands to use to perform consistency checks, and how to configure SQL Server to perform consistency checks regularly. The training in detail: What are common causes
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.