събота, 02. февруари 2019, Tech Tutors, SQL and T-SQL Beginner Level Training in Sofia, Bulgaria | SQL Databases, T-SQL queries, commands, SELECT Statements LIVE, Practical hands-on tutorial style teaching and training with Microsoft SQL Server Databases

от 02. февруари 2019 - 19:00 до 21:00

Tech Tutors

Покажи на картата
0 хора, посещаващи
описание на събитието
This is Remote LIVE Instructor led Online course delivered via Video Conference using Zoom or GoToMeeting which will teach you the basics of Structured Query Language (SQL) and will focus on T-SQL and Microsoft SQL Server based databases.
Get an in-depth introduction to the SQL and T-SQL terminology, concepts, and skills plus, explore T-SQL scripts, database queries, and data types with Microsoft SQL Server databases.

Course Features

16 hours of Practical Hands on SQL Fundamentals and Programming on Microsoft SQL Server
All sessions are recorded and Lifetime access to recordings along with training material, lab exercises, sql scripts used in lab exercises and case studies provided to students
Real World Use cases and Scenarios
Trainers are experts in SQL and also Microsoft Certified SQL instructors


Course Schedule
This course will be taught over 4 weekends starting on February 2, 2019

Dates: February 2,3,9,10,16,17,23,24, 2019

Покажи повече
Saturday, Sunday every weekend
9am-11am  PST (US Pacific Standard Time)


Who can take this course?

Anyone with no background in SQL or databases but this knowledge would help them become more efficient in working with data, tables, or databases.
Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) version of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course.
If you work in: IT, HR, business, Operations, Sales, Marketing, Accounting, Finance, Production, Manufacturing, Healthcare, Financial services, or in any other industry that collects data which has to be manipulated for insights, trends etc.
Someone who wants to start building foundational coding skills which will help them build a 6 figure salary career in the software industry.


Course Prerequisites
You need a Windows 7 or higher computer

Course Outline

History of SQL and T-SQL
Getting Started with SQL and T-SQL - Basic SQL programming knowledge and techniques
Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table
Filter data using the WHERE clause
Sort data using the ORDER BY clause
Complete SQL statements that use aggregate functions
Group data together using the GROUP BY clause
Filter groups of data using the HAVING clause
Learn about data manipulation using Transact-SQL (T-SQL), including INSERT, UPDATE, and DELETE.
Explore wrapper objects, such as views and stored procedures.
Learn about database design and normalization
Using joins, return columns and rows from multiple tables in the same query
Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
SQL Integrity Constraints
Relational and Relational Databases



SQL and T-SQL Beginner Level Training in Sofia, Bulgaria | SQL Databases, T-SQL queries, commands, SELECT Statements LIVE, Practical hands-on tutorial style teaching and training with Microsoft SQL Server Databases, Tech Tutors събитие

jsTalks Bulgaria 2019

jsTalks Bulgaria 2019

събота 23. ноември 2019
1 shares
AffiliateCon: Sofia 2019

AffiliateCon: Sofia 2019

сряда 15. май 2019
1 shares
Дебат за Пастафарианството
четвъртък 31. декември 2020
68 shares
101 Факти и 101 Мнения за Марихуаната
четвъртък 31. декември 2099
37 shares
Дебат за Бежанците
четвъртък 31. декември 2020
17 shares
Masovo luskane na bastuna po ulicite na grad Sofia
петък 21. юни 2019
3 shares
Kłekiller Młode Sztosy 2015- I edycja
понеделник 26. август 2019
25 shares
Certified Passive House Designer/Consultant Exam
събота 23. март 2019
3 shares
Certified Passive House Designer/Consultant Training
понеделник 04. февруари 2019
3 shares
Намери повече интересни събития
Вземете препоръки за събития, базирани на вашия Facebook вкус. Вземи го сега!Покажи ми подходящи събития за менНе сега