Sql Server Learn T-Sql In 9 Hours (Its-201, 98-364)
Date: 17 January 2023 | Posted by: voska89
Last updated 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.74 GB | Duration: 9h 20m
For SELECT queries, views, procedures, indexes, backing up databases and more. IT Specialist OD 201 (previously 98-364)
What you'll learn
create tables in a database, normalize the tables, and ALTER columns in the table.
Know what data type to use in various situations.
retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
JOIN two tables together, finding missing data.
INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
Create constraints, views, procedures and triggers
Create backups and restore data, and investigate security
Requirements
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!
There is a 30-day refund policy on this Udemy course - see Udemy's refund policy.
Why not have a look at the curriculum below and see what you can learn?
Description
This course is the foundation for the IT Specialist Certification OD 201 "Databases Fundamentals" (which previously was Microsoft's 98-364 exam), and focuses on Microsoft SQL Server. Learn in just a few hours how to create tables, queries, views, procedures and more.What do people like you say about it?Seme says "Thank you very much for your valuable course . I really enjoyed this course . Packed a lot of information , I found it very interesting and useful . Thank you ."Gasper says "Phillip always does a great job, this is my third course from him. Passionate and informed, I will take as many courses as I can from him."Jonas says "Explaining SQL on a very easyway! Takes you though everything you need to know nice and calm."We start off by installing for free on your Windows desktop or laptop SQL Server, and learning how the six clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.We'll examine how data is stored in tables, and see why normalisation is important for the proper building of tables.We'll then look at constraints, which allows you to set up rules for your data. Following this, how can we insert, update and delete data? We'll also create views, procedures, functions, and have a look at triggers.Finally, we'll investigate how to speed up your queries using indexes, add security, and 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 quizzes to help you remember the information, so you can be sure that you are learning.Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with a bit of practice, you could also go for the official IT Specialist exam - wouldn't that certificate look good on your CV or resume?
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Welcome to Udemy
Lecture 3 The Udemy Interface
Lecture 4 Do you want auto-translated subtitles in more languages?
Lecture 5 Curriculum
Lecture 6 Resources
Section 2: Installing SQL Server and SQL Server Management Studio (SSMS)
Lecture 7 Downloading SQL Server Express 2022 back end
Lecture 8 Which version of SSMS should I use?
Lecture 9 Opening and Exploring SSMS
Section 3: 3.2. Select data - Utilize SELECT queries to extract data from one table
Lecture 10 3.1i, 3.1j. The SELECT clause
Lecture 11 The FROM clause (one table), and how to save and export queries
Lecture 12 Practice Activity Number 1 - SELECT and FROM clauses
Lecture 13 Practice Activity Number 1 - The Solution
Lecture 14 1.1. Entities, rows/records, columns/fields; NULL and NOT NULL
Section 4:[3.2]. Select data - Utilize SELECT queries to extract data - WHERE and GROUP BY
Lecture 15 3.2b-g, 3.2i-n. The WHERE clause - Part 1
Lecture 16 3.2b-g, 3.2i-o. The WHERE clause - Part 2 - using a subquery
Lecture 17 3.2m, 3.2n. The WHERE clause - Part 3 - Text and dates
Lecture 18 3.1h, 3.2h, 3.3a, 3.3c-g. The GROUP BY clause
Lecture 19 Practice Activity Number 2 - WHERE and GROUP BY clauses
Lecture 20 Practice Activity Number 2 - The Solution
Section 5:[3.2]. Select data - Utilize SELECT queries to extract data -HAVING and ORDER BY
Lecture 21 Changing to the msdb database
Lecture 22 3.3b. The HAVING clause
Lecture 23 3.2a. The ORDER BY clause
Lecture 24 Practice Activity Number 3 - The HAVING and ORDER BY clauses
Lecture 25 Practice Activity Number 3 - The Solution
Section 6: Let's explore tables
Lecture 26 1.3. Choose data types - Introduction
Lecture 27 1.3. Numeric Data Types, including Boolean values
Lecture 28 1.3. Date/time Data Types
Lecture 29 1.3. Character Types
Lecture 30 1.3. Other Field Types
Lecture 31 Examining existing tables' fields
Section 7: Creating our own tables
Lecture 32 Creating Database and 2.1a. how to create a table
Lecture 33 2.1ai, 2.1b. Designing the Employee table, determining the right fields to use
Lecture 34 2.1aii, 2.1aiii. Alter and drop tables by using proper ANSI SQL syntax
Lecture 35 Entering data using GUI and T-SQL
Lecture 36 Creating a second table, the Transaction table
Section 8: Joining tables
Lecture 37 The need for relational database management systems (RDBMS)
Lecture 38 How relations are established
Lecture 39 3.1a. JOINing two tables using an INNER JOIN
Lecture 40 3.1b-3.1e. extract data by using joins - other JOINs
Lecture 41 Find missing data using IS NULL
Lecture 42 3.1f. Self joins
Lecture 43 Creating new tables for Practice Activities
Lecture 44 Practice Activity Number 4 - Joining tables
Lecture 45 Practice Activity Number 4 - The Solution
Section 9: 13. Understand normalization
Lecture 46 1.5a. Understand the reasons for normalization
Lecture 47 1.5b. the first three common levels of normalization
Lecture 48 Adding, altering and removing columns
Lecture 49 Practice Activity Number 5 - Adding columns, altering and removing columns
Lecture 50 Practice Activity Number 5 - The Solution
Section 10: 14. Understand primary and composite keys
Lecture 51 1.2a. What are Primary keys? and Creating Primary Keys
Lecture 52 Primary keys shortcut
Lecture 53 1.2b. Select appropriate fields for composite keys, and IDENTITY
Lecture 54 More about IDENTITY
Lecture 55 Practice Activity Number 6 - Primary keys and IDENTITY
Lecture 56 Practice Activity Number 6 - The Solution
Section 11: 14. Understand foreign keys and other constraints
Lecture 57 1.4a. What are Foreign keys? and creating Foreign Keys
Lecture 58 1.4c. understand the relationship between foreign and primary keys
Lecture 59 1.4b. Entity-relationship diagrams (ERDs)
Lecture 60 Practice Activity Number 7 - Foreign keys
Lecture 61 Practice Activity Number 7 - The Solution
Section 12: Data Manipulation language (DML)
Lecture 62 What is DML and its role in databases
Lecture 63 Understand how data is inserted into a database
Lecture 64 4.1b. How to use INSERT statements - VALUES
Lecture 65 4.1a. How to use INSERT statements - from tables and INSERT INTO
Lecture 66 Practice Activity Number 9 - INSERT statements
Lecture 67 Practice Activity Number 9 - The Solution
Section 13: Data Manipulation language (DML) - UPDATE and DELETE
Lecture 68 Understand how data is updated in a database
Lecture 69 4.2. How to write the updated data to the database using UPDATE
Lecture 70 4.2. update by using a table
Lecture 71 4.3. Delete data from single or multiple tables
Lecture 72 Practice Activity Number 10 - UPDATE and DELETE statements
Lecture 73 Practice Activity Number 10 - The Solution
Section 14: 4. Data Definition Language (DDL) - Views
Lecture 74 2.2b. Understand how T-SQL can be used to create database objects
Lecture 75 2.2b. Understand when to use views
Lecture 76 2.2a. How to create a view by using T-SQL or a graphical designer
Lecture 77 2.2aii, 2.2aiii. Alter and drop views by using proper ANSI SQL syntax
Lecture 78 Updating rows using views (or Inserting or Deleting)
Lecture 79 Views WITH CHECK OPTION
Lecture 80 View WITH SCHEMABINDING
Lecture 81 Practice Activity Number 11 - Views
Lecture 82 Practice Activity Number 11 - The Solution
Section 15: Data Definition Language (DDL) - Other Objects
Lecture 83 2.3a, 2.3c. Create stored procedures
Lecture 84 2.3a. Getting an OUTPUT value from Stored Procedures
Lecture 85 2.3b. Scalar Functions
Lecture 86 Practice Activity Number 12 - Procedures, Functions and Triggers
Lecture 87 Practice Activity Number 12 - The Solution
Section 16: Other topics
Lecture 88 3.1g. combine result sets by using UNION, INTERSECT and EXCEPT
Lecture 89 2.4a. Clustered and non-clustered indexes
Lecture 90 Practice Activity Number 13 - Other topics
Lecture 91 Practice Activity Number 13 - The Solution
Section 17: 16. Understand database security concepts
Lecture 92 Understand the need to secure a database
Lecture 93 1.6e. User accounts and roles
Lecture 94 1.6b. What objects can/should be secured?
Lecture 95 1.6. GRANT, WITH GRANT OPTION, REVOKE and principle of least privilege
Lecture 96 1.6aiii. Principle of least privilege
Section 18: Understand database backups and restore
Lecture 97 1.6ai. Importance of backups
Lecture 98 1.6ai. Understand various backup types, such as full and incremental
Lecture 99 1.6aii. How to restore a database
Lecture 100 Practice Activity Number 14
Lecture 101 Practice Activity Number 14 - The Solution
Section 19: Conclusion
Lecture 102 What's next?
Lecture 103 Congratulations
Section 20: Extra videos
Lecture 104 Extra videos
Lecture 105 Other constraints - NOT NULL and DEFAULT
Lecture 106 Other constraints - UNIQUE and CHECK
Lecture 107 Practice Activity Number 8 - Other Constraints
Lecture 108 Practice Activity Number 8 - The Solution
Lecture 109 AFTER Triggers
Lecture 110 INSTEAD OF Triggers
Lecture 111 Insert Snippets
Lecture 112 Practice Activity Number 12b - Triggers
Lecture 113 Practice Activity Number 12b - The Solution
Lecture 114 Normal Forms 4 and 5
Section 21: Bonus Lecture
Lecture 115 Bonus Lecture
This SQL course is meant for you, if you have not used SQL Server much (or at all), and want to learn T-SQL.,This course is also for you if you want a refresher on SQL. However, no prior SQL Server knowledge is required.,By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official 98-364 exam.,Wouldn't the "MTA: Database Fundamentals" certification look good on your CV or resume?
Homepage
https://www.udemy.com/course/98-364-database-fundamentals-microsoft-sql-server/DOWNLOAD LINK
Download from Fikper
https://fikper.com/KgPOESRQf2/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part1.rar[/url].html
https://fikper.com/eiR3RjtFma/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part2.rar[/url].html
https://fikper.com/1hHMEPuZ8z/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part3.rar[/url].html
https://fikper.com/ums5RFXYGm/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part4.rar[/url].html
https://rapidgator.net/file/be53f62a3ee2471171052fc2095c6cd8/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part1.rar.html
https://rapidgator.net/file/900a4792682befb48f7a4369892383b7/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part2.rar.html
https://rapidgator.net/file/0d93d913e117aa21b34337b183d724a4/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part3.rar.html
https://rapidgator.net/file/38d0d6ebb03f3f54a08ba4df2caafdba/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part4.rar.html
https://uploadgig.com/file/download/9Bfb86Ec1776Fe52/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part1.rar
https://uploadgig.com/file/download/28a30B61e021e3b9/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part2.rar
https://uploadgig.com/file/download/D4893A68D74b5f42/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part3.rar
https://uploadgig.com/file/download/Beb1E729dc11844f/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part4.rar
https://nitroflare.com/view/F8F4D2DA8E345D9/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part1.rar
https://nitroflare.com/view/BDBFCA80F6CFAE5/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part2.rar
https://nitroflare.com/view/5C7A8CFADB7D3CD/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part3.rar
https://nitroflare.com/view/D5D792C05E0FEF7/ppnbb.Sql.Server.Learn.TSql.In.9.Hours.Its201.98364.part4.rar
Links are Interchangeable - No Password - Single Extraction
See full article