Microsoft SQL Server 2012 T-SQL Fundamentals
Microsoft SQL Server 2012 T-SQL Fundamentals is a 18-hour training course by IT Genius Institute. คอร์สสอนการใช้ภาษา SQL ในการถึงข้อมูลจาก database เป็นหลักสูตรที่เน้นการคิวรีข้อมูลจากฐานข้อมูล ไมโครซอฟต์เอสคิวเอล…
Training schedule
No public rounds are open right now — register your interest and we will contact you when the next round opens, or request an in-house session for your team.
Objectives
- This course walks you through your first steps in T-SQL (also known as Transact-SQL), which is the Microsoft SQL Server dialect of the ISO and ANSI standards for SQL. You’ll learn the theory behind T-SQL querying and programming and how to develop T-SQL code to query and modify data, and you’ll get an overview of programmable objects.
- Although this book is intended for beginners, it is not merely a set of procedures for readers to follow. It goes beyond the syntactical elements of T-SQL and explains the logic behind the language and its elements.
Who this course is for
- T-SQL developers, DBAs,
- BI practitioners
- report writers
- analysts
- architects
- SQL Server power users who just started working with SQL Server and need to write queries and develop code using Transact-SQL.
Prerequisites
- พื้นฐานการใช้งานคอมพิวเตอร์, Internet
- พื้นฐานการเขียนโปรแกรม
- พื้นฐานการใช้งานภาษา sql เบื้องต้น
Curriculum
1. Relational Database Basics
1.1 Brief History of SQL
1.2 Relational Databases [may be compressed due to attendee experience]
- Tables
- Rows
- Columns
- Relationships
- Datatypes
- Primary Keys
- Foreign Keys
- Relational Database Management System
1.3 SQL Server Objects
- Valid Object References
1.4 SQL Statements
- Database Manipulation Language (DML)
- Database Definition Language (DDL)
- Database Control Language (DCL)
2. Simple SELECTs with SQL Server
2.1 Introduction to the Northwind Database
2.2 Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
2.3 SELECTing All Columns in All Rows
2.4 Exploring the Tables
2.5 SELECTing Specific Columns
2.6 Sorting Records
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
2.7 The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
2.8 The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
2.9 Checking Multiple Conditions
- AND
- OR
- Order of Evaluation
2.10 Writing SELECTs with Multiple Conditions
3. Advanced SELECTs with SQL Server
3.1 Calculated Fields
- Concatenation
- Mathematical Calculations
- Aliases
3.2 Aggregate Functions and Grouping
- Aggregate Functions
- Grouping Data
3.3 Built-in Data Manipulation Functions
- Common Math Functions
- Common String Functions
- Common Date Functions
4. Subqueries, Joins, and Unions with SQL Server
4.1 Subqueries
4.2 Joins
- Table Aliases
- Multi-table Joins
4.3 Outer Joins
4.4 Unions
- UNION ALL
- UNION Rules
5. Inserting, Updating and Deleting Records with SQL Server
5.1 INSERT
5.2 UPDATE
5.3 DELETE
6. Creating and Modifying Tables with SQL Server
6.1 Creating Tables
6.2 Datatypes
6.3 Altering Tables
- Adding a Column
- Dropping a Column
6.4 Renaming Tables
6.5 Dropping Tables
7. Views and Stored Procedures in SQL Server
7.1 Creating Views
7.2 Dropping Views
7.3 Creating Stored Procedures
- Designing a stored procedure
- Specifying input parameters
- Returning a recordset
- Returning output parameters
7.4 Testing stored procedures
Frequently asked questions
Who is Microsoft SQL Server 2012 T-SQL Fundamentals for, and what background is needed?
Built for T-SQL developers, DBAs, · BI practitioners · report writers Background you should have: พื้นฐานการใช้งานคอมพิวเตอร์, Internet · พื้นฐานการเขียนโปรแกรม Not sure the fit is right? Talk to our team on LINE @itgenius or call 02-570-8449.
How much does Microsoft SQL Server 2012 T-SQL Fundamentals cost and how long does it run?
THB 11,500. The course runs 18 hours. The fee covers course materials, lunch and refreshments throughout. Pay by bank transfer to the company account, confirm it on our payment page, and we can issue the receipt or tax invoice in your company's name.
Do I get a certificate?
Yes. Everyone who completes the course receives a Certificate of Completion from IT Genius Institute. Each certificate carries its own number, and anyone holding that number can verify it online on our certificate page, so you can add it to your portfolio or pass it to HR as evidence of training.
Where does the training take place, and is there an online option?
You can attend onsite at IT Genius Institute or arrange to join online, and we also run it as a private in-house session for your team. Ask about dates and venues on LINE @itgenius or call 02-570-8449.
What if I fall behind or miss a session — can I retake it?
Yes. You may retake the same course free of charge in a later round, under the institute's conditions. Tell our team which course and round you attended, and we will check it and offer you the rounds that still have seats. Ask us on LINE @itgenius or call 02-570-8449.
How do I enrol, or request a quotation for my company?
Enrol online with the registration form on this page. You can register several attendees at once and enter your tax ID and billing address for the tax invoice. Or request a company quotation straight from the quote button. For anything else call 02-570-8449 or reach us on LINE @itgenius.
Instructors
Run this course for your whole team
We run this course in-house, tailored to your stack.
Corporate training quote