SQL server - from setup to execution
Learn MSSQL using SQL server 2019
4.45 (183 reviews)
19,866
students
4.5 hours
content
May 2020
last update
$49.99
regular price
What you will learn
SQL server setup
SQL queries
SQL server agent
Description
Everything you need to know to use SQL server is here. From setup on windows server, to various queries and stored procedures. And alongside these basics, you will also learn how to establish connections, how to establish them in C#, how to use file tables, how to create jobs and use other more advanced features of SQL server.
Content
Introduction
Introduction
Setup
SQL server setup
SQL server management studio setup
Databases and tables
Basic queries
INSERT
SELECT
UPDATE
DELETE
Filter and sort
Variables
Logic
Basics test
Security
Authentication
Connection strings
Vulnerability assessment
MSSQL and different drivers
Stored procedure
Example: attendee registry
c#
Python
Files
File table
Stored procedures
Insert and retrieve file using C#
General
Functions
Import data
Export data
Jobs
Backup
Database email
Job notifications
Reviews
Niels
February 21, 2020
Het lijkt erop dat de cursusgever af en toe ook niet weet of hij iets wel of niet aan moet zetten bij de installatie
Chetsada
January 5, 2020
this course is ok but don't have some example exercise even test database for practise. is not worth when you buy full price
Jakub
October 22, 2019
Installation options are not described, some settings are enabled just because it's better to enable everything.
Wai-Kit
September 25, 2019
Course was very good and has loads of information broken down into individual sections/categories with the right amount of time per video tutorial. Thank you!
Dirk
September 4, 2019
- Sommige besproken onderwerpen vallen buiten beeld (Te veel ingezoomd)
- Sommige onderdelen zijn lastig zichtbaar en zouden beter ingezoomd kunnen worden weergegeven
- Soms trage voortgang van de cursus doordat er lange laadtijden zijn, kan dit niet worden overgeslagen?
Adam
August 31, 2019
You can tell the instructor is knowledgeable, however he does not explain certain things clearly. In some of the lectures, it feels like there's a certain amount of knowledge of the subject pre-required, which I feel defeats the purpose of an introduction course such as this.
Mihail
April 14, 2019
Appreciate the course information that I received but the information was not clear at all.
When making a tutorial for developers who does not have previous experience with data base systems everything should be shown step by step. Meanwhile I have noticed that the lecturer does not do that. In the beginning of the C# lesson the lecturer have been created Stored procedures and he is working the whole 50 min tutorial with them but never shown how to create them. I have just copied the code but it throws an error and I can clearly see that it's the same on his window and he does not even mention it. Also, cutting your screen and working with the cursor on area that you are not showing is not what a beginner course should be. Thanks.
Néstor
April 4, 2019
No pude disfrutar mucho del curso por terminos de tiempo, y ademas por el idioma era en ingles y pues no esta subtitulado en español entonces por eso hizo que no lo cursara de manera correcta viendo todos los videos. pero lo temas son muy buenos ya hablas de cosas un poco avanzadas y eso me hubiese agradado tenerlo en español.
Coupons
Submit by | Date | Coupon Code | Discount | Emitted/Used | Status |
---|---|---|---|---|---|
- | 5/24/2019 | FBFREE5 | 100% OFF | expired | |
- | 8/27/2019 | FBFREEDAY | 100% OFF | 5000/806 | expired |
- | 9/6/2019 | FBFREEDAY906 | 100% OFF | 3000/21 | expired |
- | 9/16/2019 | SEPTEMBERGIVEAWAY3D | 100% OFF | 8000/405 | expired |
- | 9/21/2019 | SEPTEMBERGIVEAWAY5D | 100% OFF | 10000/25 | expired |
- | 11/17/2019 | NVGIVEAWAY | 100% OFF | expired |
Charts
Price
Rating
Enrollment distribution
Related Topics
2092488
udemy ID
12/17/2018
course created date
4/27/2019
course indexed date
Bot
course submited by