Description
SQL Server Course: Learn T-SQL in 9 Hours (ITS-201, 98-364). SQL Server Course: Learn T-SQL in 9 Hours (ITS-201 98-364). This course is the foundation for the OD 201 “Database Fundamentals” IT certification (formerly the Microsoft 98-364 exam) and focuses on Microsoft SQL Server. Learn to create tables, queries, views, procedures and more in just a few hours. We start by installing SQL Server for free on a Windows desktop or laptop and learning how to use the six SELECT statements – SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We’ll explore how to store data in tables and see why normalization is important for creating tables correctly. We then look at constraints, which allow you to set rules for your data. How can we then insert, update and delete data? We’ll also create views, procedures, functions and take a look at triggers. Finally, we’ll look at how to speed up your requests using profiles, how to add security and how to back up your data. No prior knowledge is required – I’ll even show you how to install SQL Server on your computer for free! There are regular tests to help you remember the information, so you can be sure you’re learning. By the time you’re done, you’ll have a good basic understanding of how a database works, and you’ll be able to create your own SELECT statements. And with a little practice, you can even sit the official IT Specialist exam – wouldn’t that certification look great on your CV or CV?
What you will learn in the SQL Server course: Learn T-SQL in 9 hours (ITS-201 98-364)
-
Create tables in the database, normalize the tables and alter columns in the tables.
-
Learn which types of data to use in different situations.
-
Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY.
-
Join two tables and find missing data.
-
Insert new data, update and delete existing data, and export data to a new table.
-
Create constraints, views, processes, and triggers
-
Back up and restore data and check security
This course is suitable for those who
- If you haven’t used SQL Server much (or at all) and want to learn T-SQL, this SQL course is for you.
- If you want to refresh your SQL then this course is also for you. However, no prior knowledge of SQL Server is required.
- At the end of this course, you can take (and hopefully pass) Microsoft’s official 98-364 exam after taking the official practice test.
- Does the “MTA: Database Fundamentals” certification not look good on your CV or resume?
SQL Server Course Specifications: Learn T-SQL in 9 Hours (ITS-201 98-364)
SQL Server Course Topics: Learn T-SQL in 9 Hours on 12/2023 (ITS-201 98-364)
SQL Server Course Requirements: Learn T-SQL in 9 Hours (ITS-201 98-364)
- You will need to know how to use a computer, and hopefully know how to use a spreadsheet.
- No prior knowledge of SQL Server is required.
- SSMS cannot be installed on Mac OS. If you want to install it on a Mac, you will either have to dual boot into Windows or run Parallels Desktop.
- You don’t even need to install SQL Server – I’ll show you how to install it on your computer for free!
Course Images
Sample video of the course
installation Guide
After extract, watch with your favorite player.
Subtitles: none
Quality: 720p
download link
File Password: www.downloadly.ir
size
3.4 GB