課程介紹

“One of the best courses I have taken on Udemy. Short and straight to the point. I have been trying to get into DBA job and have been watching long videos and this by far is THE best course to understand DBA jobs before going into more depth.”  — Lo

…[更多細節]

哪些人適合這堂課？

• This course is a 101 level course. Anyone with basics computer skills can take this course.
• This course is not for accidental DBAs or junior level DBAs.
• If you are thinking about a career as a SQL Server DBA or developer then this course is for you.

學習目標

• A the end of this course you’ll know what IT positions are starting roles for SQL Server DBAs
• You’ll learn how to sift through job descriptions specific to your level of expertise.
• You learn what a day in the life of a DBA looks like.

課程介紹

This Microsoft SQL Server 70-461 Exam training course by Infinite Skills teaches you everything you need to know to pass the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server

…[更多細節]

哪些人適合這堂課？

• IT Professionals who wish to gain Microsoft Certification

學習目標

• To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

課程介紹

Please note: Microsoft has withdrawn the 70-462 exam. However, the information in this course is still relevant to DBA.

Do you want to gain practical experience in Database Administration in SQL Server? Welcome.

In this course, learn some of the sk

…[更多細節]

哪些人適合這堂課？

• This course is for you if you want practice experience in SQL Server Database Administration
• No prior experience with T-SQL is required, although the more knowledge you have it, the better.
• In this course we will cover several aspects which used to be tested in Microsoft’s 70-462 exam “Administering Microsoft SQL Server”
• Although the exam specifically says “SQL Server 2012/2014”, all parts of this course are applicable for the 2016 and 2017 versions, and most in the 2008 and 2008R2 versions.
• This course is not for you if you want advanced training on Database Administration.

學習目標

• Create Backups and Restore Databases, understanding the different recovery models
• Manage logins and server roles, and import and export data
• Implement and maintain indexes, and manage and configure databases, including compression and concurrency problems
• Manage SQL Server Agent and audit SQL Server instances
• Collect and analyse troubleshooting data
• Plan and install SQL Server and related services, including implementing a migration strategy

課程介紹

These individual courses will take you step by step in learning what it takes to become a SQL Production Database Administrator and will teach you the skills, roles, tasks, and responsibilities a SQL Production Database Administrator does on a daily

…[更多細節]

哪些人適合這堂課？

• This course is designed for the beginners, developers, business analysts, financial users and anyone interested or has a need to manipulate data

學習目標

• Students will be able to create database, tables, view, stored procedures, filter data, update and delete information and be able to create complex joins of tables

課程介紹

Who Should Join: 

1. Friends, please take the time to review the curriculum carefully before buying so you can see exactly whether this is the right course for you. Please kindly refrain from enrolling until this very important step is complete.

2

…[更多細節]

哪些人適合這堂課？

• This course is for those who appreciate fine levels of detail.
• This course is intended for SQL Server novices
• This course is intended for ASP.NET novices
• This course is intended for Visual Studio novices
• This course is intended for those who are intermediate or above in C#
• This course is NOT for those who want to be entertained.
• This course is NOT for those who want 5 minutes videos.

學習目標

• Learn SQL
• Learn SQL Server
• Learn the Basics of Microsoft Visual Studio 2017 Community
• Learn the Basics of Microsoft ASP.NET with SQL Server
• Learn Enough C# To Connect to Databases
• Learn Enough JQuery to Make Database Controls Interctive (jQuery is used on the bottom of the course)
• Learn the Fundamentals of SQL Server Administration
• Learn how to work with built in functions
• Learn how to write joins
• Learn how to make web pages for collecting and storing information
• Learn how to format data in web pages and tables
• Learn how to represent queries with pictures for easier understanding
• Learn how to use program flow control features like if/else and more
• Learn how to write stored procedures
• Learn how to write user defined functions
• Learn how to write views and triggers
• Learn how to use the SQL Server debugger
• Learn how to create, save, commit and roll back transactions
• Learn how to create users, database roles, logins, and work with securables
• Learn how to backup, restore, attach and detach databases
• Learn how to import data into SQL Server from other programs
• Learn how to bring tables into first, second and third normal form
• Learn how to work with XML in SQL Server and ASP.NET Controls
• Learn how to use and save Table variables
• Learn how to create and use Common Table Expressions
• Learn how to work with string functions like char, and substring
• Learn how to use the Lag/Lead Functions and the Over Clause
• Learn how to work with date functions like Datename, Datepart, getDate and more
• Learn how to build dynamic theme switching with JQuery
• Learn how to build dashboard with C#/CSS/HTML/SQL and JQuery
• Learn how to perform data validation
• Learn how to print to printers, PDF’s, Google Drive, and the Cloud
• Build a web based data entry system with C#/SQL, CSS and VS
• Understand how to use begin/end/go and ;
• Learn how to build a web interface layout that can be dragged, dropped and saved between page loads

課程介紹

This course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases.  Also, developers, SQL DBAs, IT staff and Network Administration

At the end of this course, the student will have extensive

…[更多細節]

哪些人適合這堂課？

• This course is designed for any student that is interested in learning about how to fine tune their SQL Server and databases. Also, developers, SQL DBAs, IT staff and Network Administration

學習目標

• At the end of this course, the student will have extensive knowledge in the following areas: Types of indexes that can affect performance, ability to read and understand the execution plans, determine the causes of wait stats, views deeply into statistics, comprehend the cause of the fill factor and page splits, view various execution modes and much much more

課程介紹

After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions; and

…[更多細節]

哪些人適合這堂課？

• Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions
• Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions. Students will need Learn T-SQL course created by me to help understand the T-SQL scripts created for each report.

學習目標

• Install SQL Server 2016, Microsoft Visual Studio 2015, create from scratch simple to complex reports that allow the upper management and end users to make important business decisions based on the reports generated

課程介紹

Adding to its data management system Microsoft has come up with a new Server, Microsoft SQL Server 2012 which familiarizes us with the construction and usage of databases in SQL Server platform. This course is the successor of Microsoft SQL Server 20

…[更多細節]

哪些人適合這堂課？

• This exam looks at database professionals who are involved in installation, configuration, and maintenance tasks.
• SQL Server database administrators, business intelligence professionals and system engineers, database developers with two or more years of experience can take up this exam.

學習目標

• Illuminate how to work with variables
• Confer the concepts involved in Implementing a Data Warehouse with SQL Server 2012
• Elucidate the importance of Fact Table
• Categorize the different elements of Control Flow
• Classify the different types of Transforms available in SSIS
• Confer how to deploy and manage packages
• Exhibit how to debug and secure packages
• Find out the uses of Dimensions
• Define data warehouses

課程介紹

安装和配置 SQL Server 2016 课程。通过这一个课程的介绍，学员将掌握 SQL Server 2016 的安装前准备，不同的安装和部署方式，安装后的初始化配置我们的课程，不仅仅只是工具的使用介绍，同时结合讲师十年以上的项目经验，提取大量的企业应用场景和实际问题做为结合，详尽的分析和示例，让您一听就懂，一懂就会，一会就能上手操作，学以致用。

…[更多細節]

哪些人適合這堂課？

• SQL Server 管理人员，运维人员

學習目標

• 掌握 SQL Server 2016 的安装前准备，不同的安装和部署方式，安装后的初始化配置

課程介紹

@常常發生 SQL Server 無法連線的問題？

真實世界有時我們會遇到連線SQL Server問題，明明SQL服務正常、port也沒錯，但client就是無法正常連線SQL Server，

或是連接成功，但卻被非正常中斷連線，一個簡單的Client連接SQL Server過程，底層所涉及的處理其實相當複雜，

造成連線問題的因素很多，如防火牆設定、DNS、別名、協定順序，而且還需考慮SQL Server端相關網路服務設定。

老實說，要解決SQL Server連線問題，除了熟悉Clien

…[更多細節]

哪些人適合這堂課？

• 本課程不適合新手，這是中高階SQL Server管理課程
• 適合中高階DBA。
• 適合中高階開發人員。
• 適合SQL Server愛好者。
• 適合對SQL Server效能調校有興趣者。
• 適合立志朝高階SQL Server DBA、SQL Server Developer或資料庫架構師的專業人員。

學習目標

• 獲取SQL Server三種通訊協定知識
• 獲取SQL Server和Windows Server的TCP相關重要設定
• 獲取SQL Server連線問題除錯方法
• 獲取SQL Server連線問題可能主因