Free SQL Tutorial - Microsoft SQL for Beginners (SQL Server and T-SQL) | Udemy
source link: https://www.udemy.com/course/microsoft-sql-for-beginners-sql-server-and-t-sql/?referralCode=5BF44F4B706E71EA039E
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
- 2 小时 长的随选视频
- 1 个可下载资源
- 完整的终生使用权
- 在移动设备和电视上观看
Microsoft SQL for Beginners (SQL Server and T-SQL)
上次更新 4/2020
你将会学到的
- T-SQL
- Microsoft SQL Server
- Basic SQL - Select, Filter, Where and More...
- Advanced SQL - Group By, Having, Temporary Tables
- Joins
- Working with Tables - Insert, Update, Deletes
- Programmability - Stored Procedures and Views
- Basic SQL Syntax and Select06:32
- Select Distinct01:03
- Where Clause02:58
- And, Or, Not03:34
- Order By03:10
- 00:53
- Putting it Together01:52
- Max and Min02:23
- 04:12
- 01:30
- Between02:10
- Count, Avg and Sum02:53
- Nulls01:36
- Group By04:02
- Having02:00
- Nested SQL02:11
- 02:47
- Temporary Tables03:45
- Common Table Expressions02:47
- Date Functions03:06
- Joins01:29
- Inner Join02:29
- Left Join02:06
- Right Join01:17
- Outer Join01:07
- Joining Multiple Tables02:54
- Join Lab08:22
- Union01:22
- Insert Into02:04
- Insert Into Select00:58
- Update01:51
- Delete01:16
- Truncate00:38
- Views04:03
- Stored Procedures05:20
- No prior knowledge of Databases, SQL or SQL Server is needed. We walk you through installation to writing your first lines of code!
- A PC or Mac is required
Are you interesting in learning a skill that can start you in a job between $85,000-$125,000?
In this course you will learn Structured Query Language - SQL and how to use Microsoft SQL Server
Databases are incredibly important in our modern world with many organizations using data to run and drive their business and learning SQL is the staring point to roles in Data Science and Big Data.
This course is meant for absolute beginners who want to learn about Databases and SQL for Microsoft SQL Server
This course covers a series of topics including...
- Setting up and installing SQL Server
- Installing a sample database
- Select Queries
- Where Clauses
- Advanced SQL Queries
- Joins
- Aggregate Functions
- Subqueries
- Stored Procedures and Views
Click the Signup button to sign up for the course!
A PC or Mac is required
No prior knowledge of Databases, SQL or SQL Server is needed.
- Beginner or Brand New Developers looking to learn SQL and SQL Server Basics
- Wanting to get into Data Science or become a data scientist. Learning SQL is a great first step!
- 4.1 讲师评分
- 283 条评论
- 15084 名学生
Director of Business Intelligence and Technology with extensive background as Senior Enterprise Data Architect. Over 15 years of experience in Business Intelligence and Data Warehousing solutions with implementations across Real Estate, Finance, Consumer Goods, Software Products, Pharmaceuticals, Sales and Professional Services, Government and Healthcare industries. Roles on these projects across various horizontals include cloud modernization, user experience architect, data modeler, data architect, solutions developer and business analyst. Knowledge of Business Intelligence tools across the Microsoft BI stack, including: SQL Server, Analysis Services, Integration Services, and Reporting Services as well as Big Data fundamentals.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK