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 of the OD 201 “Fundamentals of Databases” IT certification (formerly Microsoft 98-364 exam) and focuses on Microsoft SQL Server. Learn how 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 clauses of the SELECT statement – SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We’ll explore how to store data in tables and see why normalization is important to building tables correctly. Then we look at constraints, which allow you to set rules for your data. After this, how can we insert, update and delete data? We’ll also create views, procedures, functions, and take a look at triggers. Finally, we’ll explore how to speed up your requests using profiles, add security, and back up your data. No prior knowledge 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 knowledge of how databases work, and you’ll be able to build your own SELECT statements. And with a little practice, you can also sit for the official IT specialist exam – wouldn’t that certification look good on your CV or resume?
What you will learn in the course SQL Server: Learn T-SQL in 9 hours (ITS-201 98-364)
-
CREATE TABLES IN DATABASE, NORMALIZE TABLES AND ALTER COLUMNS IN TABLE.
-
Know what type of data to use in different situations.
-
Retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
-
Join the two tables and find the missing data.
-
Insert new data, update and delete existing data, and export data to a new table.
-
Create constraints, views, procedures, and triggers
-
Backup and restore data and check security
This course is suitable for people 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, 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 exam.
- Doesn’t the “MTA: Database Fundamentals” certification look good on your CV or resume?
SQL Server course specifications: Learn T-SQL in 9 hours (ITS-201 98-364)
- Publisher: Udemy
- teacher: Phillip Burton, I Do Data Limited
- Training level: beginner to advanced
- Training duration: 9 hours and 20 minutes
- Number of courses: 115
The topics of the SQL Server course: Learn T-SQL in 9 hours (ITS-201 98-364) on 12/2023
SQL Server course prerequisites: Learn T-SQL in 9 hours (ITS-201 98-364)
- You need to know how to use a computer, and hopefully know how to use a spreadsheet.
- No prior knowledge of SQL Server required.
- SSMS cannot be installed on the Mac OS. If you wish to install it on a Mac, you will need either to dual boot into Windows or be running Parallel Desktop.
- You don’t even need SQL Server installed – I’ll show you how to install it on your computer for free!
Course images
Sample video of the course
Installation guide
After Extract, view with your favorite Player.
Subtitle: None
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
3.4 GB
Be the first to comment