DATABSE DEVELOPMENT AND ADMINISTRATION TUTORIALS
SQL is a standard language for accessing and manipulating databases. Learning SQL can be very rewarding. Once you have a basic understanding of SQL, you can start to develop more advanced databases. This course covers the SQL syntax and its various SQL commands. It assumes a basic knowledge of databases and database design.
Target Audience: Is a Master relational databases. Discover what is happening within SQL Server and learn its awesome capabilities. Raise the performance of their database systems to exceptional levels. Implement the industry's best practices for SQL Server.
Course Objectives: Is for anyone who wishes to learn how to use SQL Server. It assumes a basic understanding of databases and how they work. SQL is a language that enables you to work with a database. A standard programming language aimed at enabling the administration and communication of databases. It is widely used in the Internet (e.g. Microsoft SQL Server, MySQL, etc).
Course Duration: 8 classes, two hours per class, or (Any time which suit you)
Course Fee: €480 per course .
Chapter 1: Introduction
CHAPTER 2: Understanding Core Database Concepts
2.2) Using SQL Server Management Studio (SSMS)
Chapter 3: SQL Data Types and Constraints
Chapter 4: Core Understanding Commands in SQL SERVER
4.2) Understanding Data Definition Language (DDL)
CHAPTER 5: Aggegate Functions in SQL Server
Chapter 6: Joins in SQL SERVER
Chapter 7: SQL Objects Views, Index and Stored Procedures
Chapter Eight: Normalisation and Administration Database