Scroll Down to get the courseGet The Course

Mastering Microsoft SQL Server: Comprehensive Hands-On Tutor | Discount Coupon for Udemy Course

IT & Software IT Certifications Microsoft SQL

$14.99 $19.9925% off

Price expires 54 years ago

Master Data Management, Query Optimization, and Server Administration with Microsoft SQL Server & T-SQL | Discount Coupon for Udemy Course

4.15

(37 ratings)

11591 students

Created by:

Vitalii Shumylo

Last updated 4/2023Course Language EnglishCourse Caption English [Auto]Course Length 02:17:40 to be exact 8260 seconds!Number of Lectures 31

This course includes:

2.5 hours hours of on-demand video
Full lifetime access
Access on mobile and TV
Certificate of completion

Unlock the full potential of Microsoft SQL Server with our comprehensive hands-on tutorial series. This course is designed for beginners and professionals alike, offering a deep dive into the world of data management, query optimization, and server administration using SQL Server.Our engaging lectures, demonstrations, and hands-on labs will guide you through the ins and outs of Transact-SQL, SQL Server Management Studio (SSMS), and advanced querying techniques. With a blend of theoretical concepts and practical applications, you'll be well-equipped to take on any challenge in your data-driven career.In the first section, you'll get an in-depth understanding of Transact-SQL, its structure, predicates, and operators. The next section introduces you to the SQL Server Management Studio, its features, and how to work with databases, script files, and projects. By engaging with our sample database, you'll gain a firm grasp of client-server databases and how to execute queries.As you progress through the course, you'll delve into the world of T-SQL and SELECT statements. Learn about functions, variables, and expressions, as well as logical query processing, set theory, and predicate logic in SQL Server. Our expert instructors will provide hands-on demonstrations, reinforcing your learning with real-world examples.Then, you'll focus on writing advanced SELECT queries. Learn how to display columns, use calculations, eliminate duplicates, and effectively use aliases. After completing the course, you'll be well-versed in SQL Server's various functionalities and equipped with the skills to create efficient and powerful queries.With lifetime access to course materials, a community of fellow learners, and support from expert instructors, our Microsoft SQL Server tutorial series will set you on the path to success in the world of data management. Don't miss this opportunity to expand your skill set and take control of your data-driven career. Enroll now!Who this course is for:Database professionalsDatabase administrators

Course Content:

Sections are minimized for better readability, click the section title to view the course content

2 Lectures | 13:12

9 Lectures | 46:43

Relational Databases
05:57
About the Course Sample Database. Client Server Databases. Queries
07:10
SQL Server Versions
02:37
Starting SSMS. Connecting to SQL Server. Working with Object Explorer
05:36
Working with Script Files and Projects
04:53
Executing Queries
02:44
Demonstration: Introducing Microsoft SQL Server
03:13
Lab Tasks: Working with SQL Server Tools
08:20
1. Start SSMS, but do not connect to an instance of SQL Server.
2. Close the Object Explorer and Solution Explorer windows.
3. Using the View menu, show the Object Explorer and Solution Explorer windows in SSMS.

Task 2: Configure the Editor Settings
1. On the Tools menu, choose Options to open the Options window in SSMS and change the
font size to 14 for the text editor.
2. Change several additional settings in the Options window:
o Disable IntelliSense.
o Change the tab size to 6 spaces for T-SQL.
o Enable the option to include column headers when copying the result from the grid.
Look under Query Results, SQL Server, Results to Grid for the check box Include column headers
when copying or saving the results.

The main tasks for exercise 2 are as follows:
1. Create a Project

2. Add an Additional Query File

3. Reopen the Created Project

Task 1: Create a Project
1. Create a new project called MyFirstProject and store it in the folder D:\Labfiles\Lab01\Starter.
2. Add a new query file to the created project and name it MyFirstQueryFile.sql.
3. Save the project and the query file by clicking the Save All option.

Task 2: Add an Additional Query File
1. Add an additional query file called MySecondQueryFile.sql to the created project and save it.
2. Open Windows Explorer, navigate to the project folder, and observe the created files in the
file system.
3. Back in SSMS, using Solution Explorer, remove the query file MySecondQueryFile.sql from the
created project. (Choose the Remove option, not Delete.)
4. Again, look in the file system. Is the file MySecondQueryFile.sql still there?
5. Back in SSMS, remove the file MyFirstQueryFile.sql and choose the Delete option. Observe the
files in Windows Explorer. What is different this time?

Task 3: Reopen the Created Project
1. Save the project, close SSMS, reopen SSMS, and open the project MyFirstProject.
2. Drag the query file MySecondQueryFile.sql from Windows Explorer to the Queries folder
under the project MyFirstProject in Solution Explorer. (Note: If the Solution Explorer window is not
visible, enable it as you did in exercise 1).
3. Save the project.
Lab Answers: Working with SQL Server Tools
06:13

12 Lectures | 55:11

8 Lectures | 22:34

4.15

(37 course ratings)

4/37

2/37

3/37

16/37

12/37

JOIN OUR WHATSAPP GROUP TO GET LATEST COUPON AS SOON AS UPDATED

JOIN WHATSAPP

JOIN OUR TELEGRAM CHANNEL TO GET LATEST COUPON

JOIN TELEGRAM

JOIN OUR FACEBOOK GROUP TO GET LATEST COUPON

JOIN FACEBOOK

Get The Course

If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.